|
|
-
What a great day this is! I can finally let the cat out of the bag! It’s very exciting to announce that GrapeCity has acquired ComponentOne and is now a Division of GrapeCity. From an evangelism standpoint, I am personally excited to be working directly in the community with developer evangelists Rich Dudley and MVP Kevin Griffin. You will be seeing us at many developer events coming up. It’s also great getting to know many of the folks at ComponentOne here at TechEd this week. It’s a great group of people! If you are running a developer event, please contact one of us for sponsorships at twitter links below. Personally, I am ecstatic about working with the ComponentOne’s Phone 7 controls and a ton of other high quality dev tools. It’s honestly like being a kid in a candy store. Look for a brand new content from RussCamTV! Here is the video that was shown at the announcement party last night…. Also, check out Rich Dudley’s post on the history of GrapeCity and his take on the acquisition. Follow RussCamTV and subscribe to the RussCamTV Daily news with sources from over 300 influentials in the software industry. Follow Kevin Griffin and Rich Dudley on Twitter! See you at TechEd! 
Several were on hand last night to hear the announcement live and cheering at Frank&Steins in Orlando.
|
-
On July 1, 2012, ComponentOne and GrapeCity will join forces to bring you the best tools for Microsoft Visual Studio and beyond. From that date forward, ComponentOne will be a division of GrapeCity.
This document provides questions and answers regarding the merger. The document includes general, subscription, product, support, and sales questions. For more information, contact ComponentOne.
General Q&A
Who is GrapeCity?
Founded in 1980, our corporate headquarters is located in Sendai, Japan, with operations spanning throughout the United States and Asia. GrapeCity is the world's largest component vendor. Our award-winning tools benefit leading corporations, software companies, and independent consultants around the world as a cost-effective solution for building distributed enterprise-wide applications for commercial or in-house use. From the CEO to our newest team member, our goals are the same: to provide you with the innovative tools and support you need to thrive in today's competitive development market.
Our success stems from our use of a proven global delivery model that draws on our extensive software development experience (including development of our own industry-leading products and components for the North American and Asian markets). In addition, we hire only the best and brightest for our global development centers, while maintaining a local footprint to ensure our clients of timely communication and a high level of customer service.
GrapeCity is an award-winning Microsoft Gold Certified Partner, a premier Visual Studio Industry Partner and one of the world’s largest providers of developer components. The company has more than 850 employees and hundreds of thousands of customers worldwide. For more than 30 years, GrapeCity has provided enterprises around the world with state-of-the-art developer tools and components, software services and solutions.
To learn more about GrapeCity, please visit http://www.grapecity.com.
Are you keeping the ComponentOne name?
Yes. We are pleased to announce that the US GrapeCity PowerTools division will be renamed to ComponentOne. The ComponentOne brand name is so strong in the market that the US GrapeCity PowerTools name had proudly been rebranded as ComponentOne. We will also be using the ComponentOne brand in every Asian company outside of Japan. ComponentOne has been a longtime partner of GrapeCity in Japan. In addition, the two companies have been friendly competitors in the US, by doing joint marketing campaigns and sharing technical information. The synergy between the two companies has always been very good, and as a result the transition has been very smooth.
What does this mean to you, as a ComponentOne and/or GrapeCity PowerTools customer?
Everything. GrapeCity has been reselling ComponentOne products in Japan since 1994, and has the incentive and the resources to take ComponentOne products to a new level and do it on an international stage. This combination of resources is a great fit for our customers in terms of complimentary product offerings, sales and support, and our continuing advancement of technology innovation. ComponentOne and Grape City are very serious about being number one in the business of data visualization, business intelligence, and web technologies. It means that no matter what platforms developers use to create applications we will deliver the tools to help them create amazing, beautifully-polished applications in much less time.
I understand that the acquisition will be officially completed with the combined company operating as a single company on July 1, 2012. During the interim period, what impacts (if any) will the acquisition have on me? There will be very little impact on our customers between now and July 1st. Customers will continue to contact sales and support personnel as they have in the past. New messaging and content will begin to appear on the ComponentOne and GrapeCity PowerTools websites. Otherwise, you will see very little change in terms of how to do business with and interact with ComponentOne and GrapeCity PowerTools teams. Starting July 1st, we will begin operating as a single company with merged websites, shopping carts, sales, and support organizations.
Subscription Q&A
Does the acquisition affect my current subscription service? If so, how?
The acquisition will have no impact on your current subscription service. You will continue to receive the same benefits for the coverage period that you had before the acquisition.
Are Spread and/or ActiveReports now included in my current ComponentOne subscription(s)?
No. The Spread and ActiveReports products are licensed separately from the collection of ComponentOne Studio product offerings. Existing ComponentOne customers that have an interest in Spread and/or ActiveReports will need to purchase separate subscriptions for these products.
Are ActiveReports and Spread included in ComponentOne Ultimate? If not, are you planning to offer an “Uber Ultimate” package that includes both?
No. ActiveReports, Spread, and ActiveAnalyis will continue to be sold independently. There are no immediate plans to offer one comprehensive Studio that will include these products; however, we will continue to monitor the situation and will adjust our offerings based on the needs and requests of our customers. For the full list of what’s inside the current ComponentOne Ultimate product, please visit www.componentone.com/SuperProducts/Ultimate/Products+Included/.
Product Q&A
How does the announcement affect the Studio Enterprise 2012 v2 release schedule?
It does not. Our release schedule will remain as it is today. We will still have three releases per year, in the months of March, July, and November.
I’m a Doc-To-Help customer, how will this change affect the product?
It will not. Doc-To-Help is and will continue to be our help authoring solution for all platforms.
How does Spread compare to ComponentOne FlexGrid and True DBGrid? For example, when should I use Spread and when should I use ComponentOne FlexGrid and True DBGrid?
Spread is essentially Microsoft Excel, packaged as a control. It has practically all of Excel's functionality built in, including features such as charting, grouping, formula support, and more. Features unique to Spread include formula calculations using over 300 built-in Excel functions, Excel-like conditional formatting, and full featured import/export of Excel XLS and XLSX documents, including formulas, charts, sparklines, borders, cell formatting, and more.
The FlexGrid and TrueDBGrid controls, on the other hand, are traditional data grid controls. They offer great performance and customizability, both in terms of appearance and behavior.
If you would like to have Excel embedded in your applications, then Spread is the logical choice. If you need traditional data grid functionality, then you should consider FlexGrid or TrueDBGrid.
Support Q&A
Have the customer support hours changed?
No, they have not. Our phone support hours will remain 9am-5pm EST. We will continue to answer support incidents submitted over the web within 2 business days (1 business day for Platinum customers).
How do I get product support on ComponentOne products? On GrapeCity PowerTools products?
ComponentOne support will be unchanged. You can submit a question using the MySupport portal (http://www.componentone.com/Support/default.aspx) or ask your question in our community (http://our.componentone.com/groups/). Platinum support customers can continue to call our phone support number at 412.681.4738 for assistance.
Starting July 1, 2012, GrapeCity PowerTools customers will be able to submit a question using our MySupport portal (http://www.componentone.com/Support/default.aspx) or ask their questions in the community for their respective products (http://www.clubfarpoint.com/Forums/forums/default.aspx for Spread products and http://www.datadynamics.com/Forums/Default.aspx for ActiveReports/ActiveAnalysis).
Are you planning to discontinue/sunset any of the ComponentOne/GrapeCity PowerTools products? If so, how long will they be supported?
We have no immediate plans to discontinue/sunset any of our products. If at some time in the future we decide to do that, then the following applies:
1) We will always provide an upgrade path to existing customers.
2) We will always continue to maintain all products as long as they are being used by our customers. This includes bug fixes and technical support. "Sunsetting" means we will no longer add new features to a product.
3) We have a proven track record in this regard, being the only major component vendor that still sells and supports ActiveX controls.
How are open support tickets being handled?
Nothing changes in the short term. The GrapeCity PowerTools and ComponentOne support teams will continue to provide support to customers worldwide as they have in the past. Open tickets will be handled and responses provided to customers through the normal support channels. Starting July 1, 2012, the GrapeCity PowerTools and ComponentOne support teams will be merged into one support team. Additional information will be shared with our customers as these changes are implemented.
Sales Q&A
How do I purchase ComponentOne and GrapeCity PowerTools products?
Customers wanting to purchase ComponentOne and GrapeCity PowerTools products today can:
Purchase via the ComponentOne or GrapeCity PowerTools online website shopping carts.
Contact either ComponentOne or GrapeCity PowerTools offices by email or phone.
Purchase through the existing networks of worldwide distributors and resellers.
Starting July 1st, customers will be able to purchase all ComponentOne and GrapeCity PowerTools products from a single shopping cart on the ComponentOne website, by calling ComponentOne headquarters in Pittsburgh, PA, or by contacting the combined network of resellers and distributors that will be listed on the ComponentOne website.
How does the acquisition affect product pricing?
There is no change to product pricing. All product prices remain the same as they were prior to the acquisition.
I’m a ComponentOne (or GrapeCity PowerTools) reseller/distributor. What impact will the acquisition have on me? Will I need to sign a new contract?
All existing reseller and distributor agreements will remain intact and unchanged through June 30, 2012. Existing reseller/distributor agreements will need to be reassigned to the new ComponentOne, a Division of GrapeCity company and will become effective July 1, 2012. For additional information, please contact the ComponentOne Channel Sales team in Pittsburgh.
|
-
The new ComponentOne, a division of GrapeCity, Offers an Estimated Ten Million Potential Clients Access to the Largest Collection of UI Controls PITTSBURGH, PA – June 11, 2012 – On the heels of what will be a big year for Microsoft with the release of Windows 8 and Visual Studio 2012, two of the largest enterprise solution providers will be changing the developer tool landscape. While at TechEd North America in Orlando, FL, GrapeCity announced it has acquired ComponentOne, a leader in developer-productivity tools for building enterprise-level applications. “With products available on every known platform including .NET, iPhone, Windows Phone, and JavaScript ComponentOne, as a division of GrapeCity, is now poised to dominate the component market,” said Rick Williamson, General Manager at GrapeCity. ComponentOne and GrapeCity have had a strategic relationship in overseas markets since 1994, with collaborative products being ranked as the top bestselling products in Japan. “The acquisition of ComponentOne by GrapeCity will position the company as the forerunner in the Visual Studio industry,” said Williamson. “Past, current, and new clients will benefit from the company’s ability to deliver the most innovative tools for varying platforms and the best performance and user experience on the market.” For close to 30 years, GrapeCity has provided enterprises around the world with state-of-the-art developer tools and components, software services, and solutions. Beginning July 1, 2012, the addition of the ComponentOne division will elevate GrapeCity to more than 850 employees and hundreds of thousands of customers worldwide, ranging from Fortune 100 companies to entrepreneurs. “This type of strength in the development world is unprecedented,” said Williamson. “Developers will have access to hundreds of UI controls, spanning all Microsoft platforms: Windows Forms, ASP.NET, MVC, Silverlight, WPF, and Windows Phone as well as tools for HTML5 and Windows 8 Metro.” Enterprise clients will appreciate having the support of GrapeCity’s worldwide development team that is committed to continual innovation while being responsive to specific customer requirements. Beyond the development team, Williamson stated that the company’s support system would be strengthened to better service the community. In a blog post by Technical Evangelist, Rich Dudley, he shares what a dynamic group of people work at GrapeCity. “You can take great pride in your work when you know you are providing developers controls that complement Microsoft controls better than any other vendor on the market.” “Our controls are built by developers, for developers, who understand the need for easy and familiar controls, giving one more time to focus on business logic. Nowhere else can you find such powerful reporting tools, amazing Excel-like spreadsheet controls and well-designed business intelligence and data visualization tools,” said Dudley. The company’s website lists their product line up as ComponentOne Ultimate, Studio Enterprise, ActiveReports, Spread .NET, Spread for WPF-Silverlight, ActiveAnalysis, and many more. The extensive product list is available at http://www.componentone.com/SuperProducts/. With legacies like those of GrapeCity and ComponentOne, and strategic partnerships with companies like Microsoft and Esri, developers may rest assured that GrapeCity and its ComponentOne division will continue to provide industry-leading components. A track record of delivering components that evolve with technology trends, while at the same time supporting controls that may be considered legacy, makes ComponentOne, a division of GrapeCity the company developers will turn to. Availability and Resources ComponentOne, a division of GrapeCity offers no-charge, 30-day trials of its software, which may be downloaded at www.componentone.com. The company website offers online tutorials, forums, documentation, and diagrams available as part of the ComponentOne experience. Info-Tech Research Group Report Complete access to the Info-Tech Research Group Report ranking ComponentOne as the leading market champion is available at: http://www.componentone.com/SuperProducts/Ultimate/Application%20Development%20Report/ About GrapeCity Founded in 1980, GrapeCity is an award-winning Microsoft Gold Certified Partner, a premier Visual Studio Industry Partner, and one of the world’s largest providers of developer components. The company has more than 850 employees and hundreds of thousands of customers worldwide. For close to 30 years, GrapeCity has provided enterprises around the world with state-of-the-art developer tools and components, software services and solutions. For more company information, visit http://us.grapecity.com/. Follow on Twitter @componentone or like on Facebook http://www.facebook.com/componentone. ### All product and company names herein may be trademarks of their respective owners. Technorati Tags: vs2012, TechEd, ComponentOne, GrapeCity, windows phone, iPhone, controls, components, tools, developer tools, esri, wijmo
|
-
-
Anyone who has met the Devfish himself, Microsoft Developer Evangelist, Joe Healy, will absolutely love this video. Even if you have not met Joe, it’s vintage Joe, who finally gets his moment in the spotlight on Russ Cam! The opening is definitely a side splitter! Awesome job Joe! It's the final episode from Costa Rica, SQL Saturday 133 at perhaps my favorite! First Russ talks with MS MVP Salamon Henriquez about the big event in Costa Rica. Then, we talk with two speakers from SQL Saturday 133, Solid Quality Mentor’s Javier Loria and SQL Server MVP Jesus Gil. They tell us about their unique role playing session using Tacos. Then (drum roll...) it's the DevFish himself, Joe Healy who is very excited about what he just witnessed in the strong developer and database community in Costa Rica and predictions for an even larger event next year, perhaps 600 people! And Jeff Zwickol is back with his summary of the SQL Saturday. Finally, Wes Dumey makes a return appearance on Russ Cam. Watch until the end for photos and outtakes! In these outtakes, we complete our journey to Jaco Beach with crocodiles along the way and a incredible sunset over the pacific. HAPPY COSAT RICA Day! 
Joe Healy Episode – Vintage Devfish.
Captions available in Spanish! Los títulos disponibles en español!
Raw Link: http://gvtv.gcpowertools.com/#russcam58 
Nice shot of Nizar Lavji, President Vista Technologies , with plane and great sunset. 
My prize photo of a Jaco Beach Sunset! The island mountain on the horizon only is visible with the sun setting directly behind it.
I talk about this sunset as it is happening in this episode. 
Javier Loria and SQL Server MVP Jesus Gil 
RussCamTV, Russ Fustino, with MS MVP Salamon Henriquez holding .NET Gurus Can Cook! More Photos of SQL Saturday 133 Costa Rica More Photos of Costa Rica trip to Jaco Beach Technorati Tags: Jeff Zwickel, SQL Saturday 133, sql saturday, www.sqlsaturday.com, SQL, GrapeCity powertools, sharepoint, idera, Alex Funkhouser, Russ Caaaaaam, Joe Healy, Keith Kabza, Yuri Porras, Eduardo Castro, SQL Server MVP, Jorje Aguilar, Stephen Purkiss, Sherlock Technology Recruiting, Nizar Lavji, Javier Loria, Jesus Gil, Salamon Henriquez
|
-
Russcam has more from SQL Saturday 133 in Costa Rica! First, I chat with Jeff Zwickel about what he's up to plus his thoughts on SQL Saturday Costa Rica! Then, we briefly catch Stephen Purkiss on Russ Cam! He's the Chairman at Sherlock Technology Recruiting. And Nizar Lavji tells us all about the work he does as President of Vista Technologies. Keep watching until the end for all of the outtakes and photos including a trip to Jaco Beach with Joe Healy, Keith Kabza, Alex Funkhouser and more! Find out how Sugar Cain juice is made! CLICK here to watch video! 
Stephen Purkiss and Jeff Zwickel
Captions available in Spanish! Los títulos disponibles en español!
Raw Link: http://gvtv.gcpowertools.com/#russcam57 
Nizar Lavji, President Vista Technologies 
Nazir, Jeff, Alex, Fruit Stand owner, Joe, Wes, Henry, and Russ. The mango was delicious! More Photos of SQL Saturday 133 Costa Rica More Photos of Costa Rica trip to Jaco Beach Technorati Tags: Jeff Zwickel, SQL Saturday 133, sql saturday, www.sqlsaturday.com, SQL, GrapeCity powertools, sharepoint, idera, Alex Funkhouser, Russ Caaaaaam, Joe Healy, Keith Kabza, Yuri Porras, Eduardo Castro, SQL Server MVP, Jorje Aguilar, Stephen Purkiss, Sherlock Technology Recruiting, Nizar Lavji
|
-
Russ Cam is taking you to Costa Rica for SQL Saturday 133! First, we'll talk with Eduardo Castro, SQL Server MVP, keynote speaker and organizer of SQL Saturday 133! Then, Jorge Aguilar tells us about the new Sharepoint solutions at Idera. And wouldn't you know it...Alex Funkhouser makes yet another appearance on Russ Caaaaaam, along with Joe Healy, Keith Kabza and Yuri Porras, representing Microsoft in Costa Rica! Watch until the end for photos and outtakes! CLICK here to watch video! 
Eduardo Castro, Conference organizer
Captions available in Spanish! Los títulos disponibles en español!
Raw Link: http://gvtv.gcpowertools.com/#russcam56 
Jorje Aguilar of Idera 
Yuri Porras, Microsoft DE, was a bit hit! More Photos of SQL Saturday 133 Costa Rica Technorati Tags: SQL Saturday 1333, sql saturday, www.sqlsaturday.com, SQL, GrapeCity powertools, sharepoint, idera, Alex Funkhouser, Russ Caaaaaam, Joe Healy, Keith Kabza, Yuri Porras, Eduardo Castro, SQL Server MVP, Jorje Aguilar
|
-
It’s an exciting time! Spread WPF-Silverlight is now CTP2 with a go live license! Contact sales at PowerSales@GrapeCity.com to purchase your Go Live license today. Click here for a WPF-Silverlight evaluation copy Visit http://www.gcpowertools.com/Products/SpreadWPFSilverlight/Overview for some amazing UI abilities in Silverlight and WPF. Wow! This is the final blog post in a 15 part series on Spread WPF-Silverlight CTP… Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill
Part 13: Edit Mode and Frozen Columns
Part 14: Row Filter 
Spread WPF-Silverlight - Spread is an embedded spreadsheet platform component for application development.
- Spread WPF-Silverlight includes a WPF spreadsheet control and a Silverlight spreadsheet control.
- These controls address use cases best solved using cell-based, free-form, gridded layouts.
- Spread WPF-Silverlight includes rich designer to simplify development and produce quick results.
Features: - AutoFit - Set Row height and Column width to the minimum size needed to include all the text for every cell in the row or column.
- Cell Formatter - Format numeric data in a cell to a specified Excel-style format string.
- CellOverflow - Allow cells data to overflow from a cell into adjacent, empty cells.
- Cell Span - Merge a range of cells into a group that is displayed as a single cell.
- Clipboard - Cut, Copy, Paste, Paste Special.
- Conditional Format - Apply custom styles to cells whose values meet specific conditions or rules.
- Average Rule - compare cell values to the average of a specified range.
- CellValue Rule - compare cell values to another value.
- DateOccuring Rule - compare cell values to a date range.
- Formula Rule - evaluate a formula.
- Scale Rule - compare cell values to scale values of a specified range.
- Top10 Rule - compare the cell value to the top 10 or bottom 10 of a specified range.
- Unique Rule - whether the cell value is unique for a specified range.
- Text & CSV File Import and Export - Load and save Text (txt) and CSV (comma-delimiited) files.
- DataBinding
- DragMove
- Editing Always
- Fill
- Filter
- Freeze Heading & Trailing Rows & Columns
- Grid Line & Border
- Html_Export FeaturePoint
- Input Mapping
- Multiple Header
- Navigation
- SavePDF
- Cell Lock & Worksheet Protection -
- Range Group - Excel style grouping.
- Resize
- Scrolling
- Search
- Selection
- ShrinkToFit
- Sparkline
- StyleInfo
- Table
- TabStrip
- Theme Manager
- UndoRedo
- View port
- Zoom
On a personal note, I would like to wish Robby Powell the best of luck in his new endeavors and many thanks for all of the Spread management, support and love over several years! You will be missed but not forgotten! Best wishes! Technorati Tags: Spread, Excel, Silverlight, CTP, labs@grapecity.com, visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rows, row filter, go live, ctp2
|
-
| Spread CTP - Script 13: Edit Mode and Frozen Columns and Rows If you are interested in downloading the Spread CTP, please email labs@grapecity.com . This is the 13th in a series of Spread CTP Blogs and is a continuation of: Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill
Edit Mode Always
If you are interested in downloading the Spread CTP 2 with a go live license, please email labs@grapecity.com . You can set the cell to always be in edit mode when the user clicks on it. Normally the user types or double-clicks before the cell goes into edit mode. Set the StartCellEditing method in the EnterCell event to cause the cell to go into edit mode as soon as the user clicks on or uses tab or enter to move to the cell.
Frozen Columns and Rows Feature | You can specify whether you want frozen rows or columns or both in a sheet. Frozen columns and rows do not scroll. You can also specify whether to have frozen trailing rows or columns. A line is displayed below frozen rows (or above frozen trailing rows) and to the right of frozen columns (or to the left of frozen trailing columns). Frozen rows stay at the top of the sheet and frozen columns stay on the left of the sheet. Frozen trailing rows stay at the bottom of the sheet and frozen trailing columns stay on the right of the sheet. 
Using Code | CS | | | gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].ColumnCount = 8;
gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;
gcSpreadSheet1.Invalidate(); | | VB.NET |  Copy Code
| | GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).ColumnCount = 8
GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1
GcSpreadSheet1.Invalidate() | Technorati Tags: Spread, Excel, Silverlight, CTP, labs@grapecity.com, visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rowsPart 14 – Row Filter |
|
-
Spread CTP - Script 14: Row Filter If you are interested in downloading the Spread CTP2 with a go live license, please email labs@grapecity.com . This is the 14th in a series of Spread CTP Blogs and is a continuation of: Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill
Part 13: Edit Mode and Frozen Columns You can hide filtered rows. A filter button is displayed in the column header for a column that allows filtering. The user can click on the button and select the item they wish to filter by and they can sort the list of items. The following image displays the filter dialog. 
The user can use the mouse or various keyboard keys to interact with the filter dialog. The ESC key can be used to cancel the dialog. The TAB key can be used to move to different sections and the up and down arrow keys can be used to move in the list of items. The SPACEBAR can be used to change the checked status. The following image shows the list sorted in ascending order. 
Using Code | CS | | | GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1);
GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter; | | VB.NET | | | Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1)
Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
GcSpreadSheet1.Invalidate() | Spread, Excel, Silverlight, CTP, labs@grapecity.com , visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rows, row filter
|
-
Spread CTP - Script 12: Drag and Fill If you are interested in downloading the Spread CTP, please email labs@grapecity.com . This is the 12th in a series of Spread CTP Blogs and is a continuation of: Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move GcSpreadSheet has a drag fill option that allows the user to select cells and fill other cells with the same or different values. The fill type can be set to linear, growth, date, or automatic fill. The fill direction can also be specified. Additional options can be set such as step and stop values. Select a cell or block and move the mouse pointer over the square at the corner of the selection. The mouse pointer changes to a double arrow that can be used to expand the fill range. Click on the plus mark to display a menu with additional fill options as shown in the following image: 
Drag fill is not supported if the destination range contains a spanned cell. Drag fill does not apply to a conditional format or filtered range. The AllowDragFill property is used to specify whether to allow drag fill. The FillAuto Method, FillDate Method, FillGrowth Method, or FillLinear Method can be used to programmatically specify the type of fill. Using Code | CS | | | gcSpreadSheet1.AllowDragFill = true;
gcSpreadSheet1.Sheets[0].SetValue(0, 0, new DateTime(2011, 1, 1));
gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9));
gcSpreadSheet1.Sheets[0].SetValue(0, 2, 5);
gcSpreadSheet1.Sheets[0].SetValue(0, 3, 10);
gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1);
gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e)
{
GrapeCity.Windows.SpreadSheet.Data.CellRange r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1);
gcSpreadSheet1.Sheets[0].FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2);
GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1);
gcSpreadSheet1.Sheets[0].FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, new DateTime(2011, 2, 11).ToOADate());
GrapeCity.Windows.SpreadSheet.Data.CellRange r3 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1);
//gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down);
gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
GrapeCity.Windows.SpreadSheet.Data.CellRange r4 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1);
//gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
//gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2);
gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55);
GrapeCity.Windows.SpreadSheet.Data.CellRange r5 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1);
//gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column);
//gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3);
gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20);
gcSpreadSheet1.Invalidate();
} | | VB.NET | | | GcSpreadSheet1.AllowDragFill = True
GcSpreadSheet1.Sheets(0).SetValue(0, 0, New DateTime(2011, 1, 1))
GcSpreadSheet1.Sheets(0).SetValue(0, 1, New DateTime(2011, 2, 9))
GcSpreadSheet1.Sheets(0).SetValue(0, 2, 5)
GcSpreadSheet1.Sheets(0).SetValue(0, 3, 10)
GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1)
GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1)
GcSpreadSheet1.Sheets(0).FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2)
Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1)
GcSpreadSheet1.Sheets(0).FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, New DateTime(2011, 2, 11).ToOADate())
Dim r3 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1)
'GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down)
GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
Dim r4 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1)
'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2)
GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55)
Dim r5 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1)
'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column)
'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3)
GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20)
GcSpreadSheet1.Invalidate()
End Sub Part 13 : Edit Mode and Frozen Columns and Rows
| Technorati Tags: Spread, Excel, Silverlight, CTP, labs@grapecity.com, visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill
|
-
Spread CTP - Script 11: Drag and Move If you are interested in downloading the Spread CTP, please email labs@grapecity.com . This is the 11th in a series of Spread CTP Blogs and is a continuation of: Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding The user can use the mouse to select a cell or block of cells and move them to a new location. Move the mouse pointer to the edge of a selected column, row, or block of cells and then click and drag the selected range to the new location. The following image displays a selected block of cells with the drag icon: 
Move the block to the new location. 
Release the mouse to display the data in the new location. 
You can select and drag multiple contiguous columns or rows. Using Code | CS | | | gcSpreadSheet1.AllowDragDrop = true; | | VB.NET | | | GcSpreadSheet1.AllowDragDrop = True | Part 12: Drag and fill Technorati Tags: Spread, Excel, Silverlight, CTP, labs@grapecity.com, visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move
|
-
Spread CTP - Script 10: Data Binding If you are interested in downloading the Spread CTP, please email labs@grapecity.com . This is the 10th in a series of Spread CTP Blogs and is a continuation of: Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export GcSpreadSheet supports binding to any object that implements the IEnumerable interface. This includes the Ilist, ObservableCollection, and WCF datasource. The control also supports binding to an RIA datasource. GcSpreadSheet supports one way data binding. Changes to the source automatically update the target but, changes to the target are not propagated back to the source. Specific columns can be bound with the DataField Property. Using Code | CS | | | public class lname
{
public string last { get; set; }
public int val { get; set; }
public lname(string last, int val)
{
this.last = last;
this.val = val;
}
} private void Window_Loaded(object sender, RoutedEventArgs e)
{ lname[] arr = new lname[] { new lname("Smith", 100), new lname("Fender", 3), new lname("Gill", 5) };
gcSpreadSheet1.Sheets[0].DataSource = arr;
gcSpreadSheet1.Invalidate(); | | VB.NET | | | Public Class lname
Public Property last() As String
Get
Return m_last
End Get
Set
m_last = Value
End Set
End Property
Private m_last As String
Public Property val() As Integer
Get
Return m_val
End Get
Set
m_val = Value
End Set
End Property
Private m_val As Integer
Public Sub New(last As String, val As Integer)
Me.last = last
Me.val = val
End Sub
End Class Dim arr As lname() = New lname() {New lname("Smith", 100), New lname("Fender", 3), New lname("Gill", 5)}
gcSpreadSheet1.Sheets(0).DataSource = arr
gcSpreadSheet1.Invalidate() | 
Part 11 : Drag and Move Technorati Tags: Spread, Excel, Silverlight, CTP, labs@grapecity.com, visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding
|
-
This is one of my favorite episodes in large part due to the huge 500 person ‘RussCammmmmmm’ yell (largest to date!)! I talk with Windows Phone MVP, Atley Hunter about his session and a really cool app he's working on! Check out my new cameraman for this interview (hint, he's not the owner of a major pizza franchise)! Then, Microsoft MVP and RD Elijah Manor talks with me about his two sessions about jQuery. Event organizer, Esteban Garcia, takes a few moments away from his busy schedule to be on Russ Cam! And Peter Bromberg from EggHeadCafe shows us the enormous schedule for code camp, and also tells us why he's really into MVC these days. Plus, don't miss the behind the scenes photos and outtakes at the end of the video! 
Raw Link: http://gvtv.gcpowertools.com/#russcam55 
Organizing committee for Orlando Code Camp. 
RD’s Elijah Manor and John Papa More Photos Photos: Orlando CodeCamp
|
-
Russ is catching up with the VP of ONETUG, John Smith! Then, Luis Perez from Neuralnet makes yet another Russ Cam appearance! Alexander Koval talks about his organization, Code Masters International, plus his session at Code Camp. And Jose Chinchilla talks with us about his experience with business intelligence. We wrap it up with an appearance by another Russ Cam veteran, Greg Leonardo. Don't miss the behind the scenes photos and outtakes at the end of this episode!
Raw Link: http://gvtv.gcpowertools.com/#russcam54 
Esteban Garcia and John Smith, key organizers of Orlando Code camp. 
Luis Perez enjoys the session at Orlando Code Camp! More Photos Photos: Orlando CodeCamp
|
|
|
|