A Spreadsheet Control/Component by SpreadsheetGear LLC

SpreadsheetGear 2008 V4 Beta 1

SpreadsheetGear 2008 is the most significant upgrade from SpreadsheetGear LLC since the release of SpreadsheetGear for .NET 1.0 in 2005. New features include Excel 2007 Open XML (.xlsx) support, chart rendering, chart APIs and more.

New SpreadsheetGear 2008 Features:

• Added robust support for reading and writing Excel 2007 Open XML (.xlsx) workbooks.


• Added comprehensive charting API in the SpreadsheetGear.Charts namespace.


• Added support for chart rendering including the most commonly used chart types and options. Supported chart types include area, bar, column, line, pie, stock and XY scatter. Supported chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, hIgh-low lines, open-close bars, exploded pies, and data point labels. Supported axes options include primary and secondary axes sets, auto and manual scaling, major gridlines and tick marks, reversed axes, and tick label positions. Supported general chart options include chart titles, legends, theme colors, auto colors, number formats and fonts.


• Added the SpreadsheetGear.Drawing.Image class which provides the ability to generate an image of a range of cells or a shape (such as a chart) with one line of code. This makes it very easy to generate an image of a range of cells (including charts) or a single chart which can be displayed on a web page, saved to a file or used in a variety of ways in a Windows Forms application.


• Increased the maximum number of rows and columns from 65,536 rows and 256 columns to 1,048,576 rows and 16,384 columns.


• Added support for the new Excel 2007 color model, including 24 bit colors as well as theme colors with tinting and shading, while maintaining support for the old style 56 color palette and indexed colors.


• Added named cell style support with the IStyles and IStyle interfaces along with IWorkbook.Styles and IRange.Style properties. These APIs provide the ability to add, modify or delete named cell styles as well as the ability to assign a named cell style to a range of cells. Forty nine built-in named cell styles are included in a new workbook and up to 4000+ user defined named cell styles can be added.


• Added support for What If tables with the IRange.Table(IRange rowInput, IRange columnInput) method and added support for Calculation.SemiAutomatic which provides for automatic calculation of all except What If tables.


• Added IFont.ThemeColor, IFont.ThemeFont, IFont.TintAndShade and IFont.TintAndShadeDefined properties.


• Added IInterior.ThemeColor, IInterior.TintAndShade, IInterior.TintAndShadeDefined, IInterior.PatternThemeColor, IInterior.PatternTintAndShand and IInterior.PatternTintAndShadeDefined properties.


• Added IBorder.ThemeColor, IBorder.TintAndShade, IBorders.ThemeColor and IBorders.TintAndShade properties.


• Add ITab.ThemeColor and ITab.TintAndShade properties.


• Increased unique cell format limit from 4095 to 65535.


• Add support for parsing and unparsing DDE references such as “Application|Topic!Item” and reading and writing these DDE references to Excel 97-2007 workbooks.


• Adding hyperlinks to cells now modifies the cells to use the “Hyperlink” named cell style instead of simply setting the font style and color.


• Added SpreadsheetGear.PrintErrors enumeration and IPageSetup.PrintErrors property.


• Added IWorksheet.TransitionFormEntry property.


• Support dynamic row header width which changes based on the last displayed row.

Issues Resolved in SpreadsheetGear 2008

• Installation is now more Windows Vista friendly, with all samples now placed under the application data directory instead of being placed under Program Files.


• SpreadsheetGear 2008 does a better job of working when installed on the same computer as previous versions of SpreadsheetGear for .NET by creating separate “SpreadsheetGear 2008” entries in the Visual Studio Windows Forms Designer Toolbox and in the Windows Start menu.


• Fixed unparsing of data validation list formulas which have embedded double quotes to add extra double quote.


• Fixed a bug which occurred when copying cells with IRange.Copy with skipBlanks set to true which caused incorrect formats to be copied to some cells when blank source cells are encountered.


• Added work around to read workbooks with seemingly invalid country codes in number formats such as “[$-1012C0A]#,##0;\-#,##0”. SQL Reporting Services apparently creates workbooks with number formats such as this.


• Fixed to parse formulas such as "=Sheet1!#REF!,Sheet1!#REF!,Sheet1!#REF!” and "=#REF!,#REF!" as Excel does.


• Fixed a problem which caused a conditional format with a formula such as "=MID(#REF!,1,6)=”"Total”"" to incorrectly evaluate to true.


• Fixed printing of borders to scale border thickness with zoom setting as Excel does.

For more information about this product please visit the