New features in SpreadsheetGear 2009 include:
- Support for the 93 functions which are in the Excel 2003 Analysis Toolpak as well as the undocumented DATEDIF function bringing the total number of supported functions to 331.
- CSV and tab separated text support (read and write).
- Drag Fill / Auto Fill API & UI including support for numbers, dates, times, month names, day names and certain text patterns.
- Data Series API & UI including support for automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.
- Single variable and single target goal seeking API & UI.
- Chart axis title rendering.
- Bubble chart rendering.
- Rotated text support in charts and cells.
- Enhanced fill option support including gradient API & UI.
- Many Range Explorer, Chart Explorer and Shape Explorer enhancements.
- Added WorkbookView.BeginEdit(), WorkbookView.CancelEdit() and WorkbookView.EndEdit() methods as well as a WorkbookView.IsEditing property.
- Added support for hidden chart series when linked to hidden rows or columns when the PlotVisibleOnly option is enabled.
- Added support for font names and font sizes in print headers and print footers.
- Added SpreadsheetGear.CustomFunctions.IArguments.GetArrayFormulaInfo(ref int row1, ref int col1, ref int row2, ref int col2) method to return information about the array formula currently being evaluated, if any.
- Added SpreadsheetGear.SetDataFlags.WrapToNewWorksheet64K to provide support for wrapping at the Excel 97-2003 64K row limit.
- Added more samples to the SpreadsheetGear Explorer Sample Solutions for C# and VB.
- Added enhanced printing API and UI including support for printing multiple worksheets, ranges and charts in a single print job as well as providing a public WorkbookPrintDocument class and several new printing samples in the SpreadsheetGear Explorer sample solutions (5.1.1.102).
- Added UI support for setting and displaying hyperlink screen tips (5.1.1.104).
- Added MarkerBackgroundColor and MarkerForegroundColor properties to the ISeries and IPoint interfaces (5.1.1.118).
- Added support for x86 and x64 versions of Windows 7 and Windows Server 2008 R2 (5.1.1.154).