SpreadsheetGear Version 9 Now Available
Version 9 is now available! Please see below for more details on new features you can find in V9:
New Features
SpreadsheetGear for .NET Standard has been renamed SpreadsheetGear Engine for .NET, which will target both .NET Standard 2.0 and .NET 6.
A new SpreadsheetGear for Windows product that targets .NET 6 and provide UI capabilities for WinForms and WPF running on that platform. More details available on the SpreadsheetGear.Windows NuGet package page.
- Support for rendering rich text in cells in Windows Forms WorkbookView (.NET 6+ only).
Support for reading and writing Cell Comments / Form Controls in Open XML file formats (*.xlsx and *.xlsm), which stems from a longstanding limitation discussed in our documentation’s Limitations Page.
- Samples: Cell Comments and various Shapes > Form Controls samples on the main Live API Samples page.
Support for embedded pictures in print headers / footers, which also relates to the above VML limitation.
- Sample: Print Headers and Footers
SpreadsheetGear Engine for .NET (formerly "SpreadsheetGear for .NET Standard") now includes DataTable- and DataSet-related APIs, such as:
- IRange.CopyFromDataTable(...) / GetDataTable(...) / GetDataSet(...)
- IWorkbook.GetDataSet(...)
- Samples:
Document Properties and Custom Properties.
Shape enhancements / better compatibility with Excel, including:
Support for embedding shapes within charts.
- Sample: Embedded Picture In Chart
Support for picture cropping including support for negative picture crop values.
- Sample: Cropped Picture
Better support for Radio button form controls.
- Sample: GroupBox and OptionButtons
Grouping / ungrouping shapes.
"Fine-grained” worksheet protection options (i.e., the checkbox options in Excel's "Protect Sheet…" dialog).
- Sample: Worksheet Protection
DPI property for SpreadsheetGear.Drawing.Image class.
Create chart sheets
- Sample: Create Chart Sheet
Updated new workbook theme to more closely match recent versions of Excel.
Added support for Alt+Down key combination to display the data validation dropdown list control.
Try out Version 9
If you are an active licensed customer, you can access these new versions from the Licensed User Downloads page. If you would like to evaluate SpreadsheetGear free for 30 days, please visit the Evaluation Downloads page.