New features in SpreadsheetGear 2023 include:
- SpreadsheetGear Engine for .NET replaces SpreadsheetGear for .NET Standard
- Separate SpreadsheetGear.dll assemblies optimized for .NET Standard 2.0 and .NET 6+.
- Runs everywhere .NET Standard 2.0 or .NET 6+ is supported.
- .NET 6+ assembly includes support for .NET intrinsics which improves performance of some operations.
- Both assemblies include DataTable and DataSet APIs which were missing from SpreadsheetGear for .NET Standard.
- New SpreadsheetGear for Windows product
- Optimized for .NET 6+ for Windows.
- Brings the full power of SpreadsheetGear for .NET Framework to .NET 6+ Windows Forms, WPF and ASP.NET Core developers.
- Includes SpreadsheetGear Engine for .NET.
- Full Windows Per-Monitor (V2) high DPI support.
- Added new text layout engine to provide consistent text layout between WPF, Windows Forms and Image Rendering APIs.
- Official support for Excel 2021 and the latest versions of Excel for Microsoft 365.
- Support for embedded pictures in print headers and footers.
- Support for standard and custom document properties.
- Chart enhancements including:
- Support for embedding shapes within charts.
- Support for creating chart sheets.
- Added a number of IChartSheet properties and methods as well as the related IChartSheetWindowInfo and IChartSheetWindowInfos interfaces.
- Shape enhancements for better compatibility with Excel including:
- Arrowheads and other markers on lines.
- Better support for radio button form controls.
- Support for grouping and ungrouping shapes.
- Support for autosizing of cell comments and text objects.
- Support for picture cropping including support for negative picture crop values.
- Support for fine-grained worksheet protection options including:
- Select locked cells
- Select unlocked cells
- Format cells
- Format columns
- Format rows
- Insert columns
- Insert rows
- Insert hyperlinks
- Delete columns
- Delete rows
- Sort
- Use AutoFilter
- Edit objects
- Support for reading and writing cell comments and form controls with Open XML (,.xlsx and .xlsm) workbooks.
- Support for rendering rich text in cells in Windows Forms WorkbookView (.NET 6+ only).
- The SpreadsheetGear.Drawing.Image class supports setting the output DPI.
- 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.