← Back to all blogs

Featured Posts

Posts tagged with 'spreadsheet'

Spread Studio 8 Released!

I am very happy to announce the release of Spread Studio 8!  We've added a lot of new features and made an array of enhancements. With this release Spread for ASP.NET now fully supports Chrome, and Firefox, and also it also runs on iPad. Spread for WinForms provides a Table feature which includes built-in styles and also supports structured reference. Our MultiRow for WinForms control received some nice enhancements as well. Spread XAML (WPF/Silverlight/WinRT), now offers printing (Spread WPF provides print preview), and structured references. Moreover, for all platforms the Spread controls have nice new appearances.

ComponentOne Spread with jQuery Calendar

ComponentOne Spread for ASP.Net provides several ways to show data for Date format. You may either use the built in DateTimeCellType which allows editing the date or you may use the Ajax Calendar Control inside ComponentOne Spread's cell. Recently a customer came up with an interesting question about using a jQuery control inside a cell replacing the Ajax calendar control. In this blog I am going to talk about replacing the Ajax calendar control with the jQuery date picker step by step:

Best Way to Manage State When Spread has Large Data - Part I

State management has been a very important aspect of ASP.NET application development. Being an ASP.NET control ComponentOne Spread for ASP.NET also supports different processes of managing state. With Spread, we can primarily manage state with the following processes:

Auto-size ComboBoxCellType Columns in Spread for WinForms

The AutoSize feature of TextCellType and GeneralCellType Columns in Spread for WinForms can be implemented using GetPreferredColumnWidth method of the SheetView class. This method basically gets the width of the widest text string in the specified column on the sheet. However, this feature is not available for the ComboBoxCellType columns.

Data Visualization with Spread

Seeing the current trends and user demands, ComponentOne has recently added a Chart control in Spread for Silverlight and WPF. This feature was in great demand because the Spread control has always been a replica of Microsoft Excel and Microsoft Excel has always had charts.

ComponentOne Receives 12-Time All-Star Award from the Editors of SD Times

PITTSBURGH, PA  - June 4, 2014 - ComponentOne, a division of GrapeCity and the largest component solution provider in the Microsoft Visual Studio Partner Ecosystem, was recognized in the June 2014 issue of BZ Media’s SD Times as a 12-Time-All Star for the SD Times 100 awards. The SD Times 100 (http://sdt.bz/71295) is an annual awards program that represents the leaders of the software development industry.

Grouping and UnGrouping Spread at Runtime

When we talk about Grids in general there are few common features that come to mind, like Filtering , Sorting, Grouping, etc.

Use custom function to implement INDIRECT in Spread

INDIRECT is an useful function, it returns the reference specified by a text string, and the references are immediately evaluated to display their contents. Currently Spread doesn't support INDIRECT yet, but Spread provides powerful customization ability, you may use custom function to implement a simple INDIRECT function. Here is a sample shows how to do it.

ComponentOne 2014 Roadmap

As we enter into the new fiscal year here at ComponentOne, it is once again time to summarize what’s new and what’s coming in our products. This is the perfect opportunity for you to check out what we have planned and to make suggestions. Your input will help direct our future efforts. Thank you in advance for your feedback.