SpreadsheetGear V9 / 2023 Beta
Version 9 Beta is currently available! See below for more details.
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 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
Arrowheads (and other markers) on lines
- Sample: Arrowheads
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
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.