New features in SpreadsheetGear 2008 include:
- Added robust support for reading and writing Excel 2007 Open XML (xlsx) workbooks.
- Added comprehensive charting APIs 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 support for basic chart editing with the new Chart Explorer.
- Added the SpreadsheetGear.Drawing.Image class which provides the ability to easily generate an image of a range of cells or a shape (such as a chart) with one line of code. This image can be displayed on a web page, saved to a file or used in a variety of ways in ASP.NET and Windows Forms applications.
- 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 and IFont.TintAndShade properties.
- Added IInterior.ThemeColor, IInterior.TintAndShade, IInterior.PatternThemeColor and IInterior.PatternTintAndShade properties.
- Added IBorder.ThemeColor, IBorder.TintAndShade, IBorders.ThemeColor and IBorders.TintAndShade properties.
- Added ITab.ThemeColor and ITab.TintAndShade properties.
- Increased unique cell format limit from 4095 to 65535.
- Added 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.
- Added support for dynamic row header width which changes based on the last displayed row.
- Added read, write and API support for IWorkbook.UpdateLinks property.
- Added IWorkbookSet.EndCalculate event for notification of background calculation completion in cases where the WorkbookView control is not being used.