This set of release notes includes enhancements from the previous release, resolved issues and version details.

Enhancements from the Previous Release

This version of the product has the following enhancements from the previous release:      

• Users can now add a ChartSheet, which refers to a sheet for only a chart.
• Enhancements have been done to apply built-in Excel-like themes and styles to the workbook and customize appearance improve the visual appeal along with essential functionalities.
• Users can now add a shape inside a chart or ChartSheet.
• Users can now create visually appealing headers and footers for columns by wrapping the long text.
• Spread for Winforms now allows you to show chart labels in multiple rows or columns using the MultiLevel property.
• Spread for Winforms now supports the Paste Special option to RichClipboard.
• Users can now save cell data in HTML and XLSX formats.   
• Users can now manage an advanced Excel-like ribbon in Spread to create a simple spreadsheet with a ribbon interface.
  Additionally, you can use the Attach function to use the ribbonBar control with the specified FpSpread control.
• Horizontal scrolling is now supported within the worksheet using the mouse wheel and Ctrl+ Shift keys.
• Create open and closed custom shape that has curved segments using the curve annotation mode.
• Hide the blue border of a spilled dynamic array range by setting the DynamicArrayRenderer and DynamicArrayErrorRenderer properties.
• Users can now check whether a range or cell has a spill range within it or not using the HasSpill property of IRange interface.
• Create and view custom properties of the current workbook.
• Users can now set vertical text orientation for cell comments and shapes using the HorizontalRotatedFarEast property of TextOrientation enumeration.
• Spread for Winforms now allows you to copy sheets with formula references using the IWorksheets.Copy method.
• Spread for Winforms now provides tabstrip buttons to directly jump to the first and last sheet without any manual scrolling.
• Spread for Winforms now allows you to use the InsertPictureInCell or PastePictureInCell members to insert or paste an in-place picture into a cell.
• Users can now determine the last row or column for which data is set in any column or row of a spreadsheet.
• Spread.NET now provides OddAndEvenPagesHeaderFooter and DifferentFirstPageHeaderFooter properties to customize the header/footer for the first page, last page, odd pages, and even pages.
• While printing, Spread.NET now supports the import and export of Excel files with images in the headers and footers. 
  If you have more than one image in the header or footer, only the first image used is exported to Excel in the header or Footer, as Excel supports only one image.
• With Spread.NET, you can now choose the sequence of print pages to make several copies of the same Spread document by using the Collated property.
• Spread.NET now allows you to change the printing behavior of Spread as Excel by setting the ExcelCompatiblePrinting property.
  Currently, enabling of this property may not produce the same print output as Excel; future versions aim to improve print accuracy and consistency.
• Spread for .NET now supports .NET 8.
• New keyboard shortcut keys have been introduced for Spread.NET features.

Changes from the Previous Release

Refer to the Breaking Changes section for a detailed list of changes from previously released version.

Resolved Issues

The following issues have been resolved since the last release.

• Resolved the performance issues while upgrading a project.
• Resolved the performance issues while loading an XML file created in Spread.NET v10 to Spread.NET v16 Designer .
• Resolved the performance issues where auto-sizing all the columns by double-clicking on the header in the Spread Designer.
• Resolved the performance issues while moving a focus with an arrow key in Spread Designer.
• The printing issue is resolved for PrintSheet method.
• No exception error is thrown when open pattern list or custom pattern in GcMask cell of Spread Designer.
• Background of TextCellType is now exported to PDF correctly.
• DisplayZero property is working fine now and displays zero values as empty cells.
• Fixed the performance issues when importing files with a large number of formulas.
• Dynamic array optimization is now working properly when has one column.
• Cell calculation is now working properly when setting formulas via public API.
• Resolved the issue when importing an Excel file that contains spaces in the user-defined format and the NumberFormat of the imported and output Excel file will have "!” unexpectedly.
• No exception error is thrown for various functions when importing excel.
• No exception error is thrown when dragging the Spread.Net from the toolbox.
• Resolved the issue where an ApplicationException is raised by the ColumnChanged event of a DataTable, but the ThreadException event of the Application and the UnhandledException event of the AppDomain are not raised.
• Support for superscripts that set in Spread Deisgner are now maintained properly.
• Cell highlighting is now effective when dragfilling cells with conditional formatting applied.
• Shapes are now printed correctly when the EnhancedShapeEngine property is set to true.
• Resolved the issue where rows and columns are not displayed when DefaultSheetDataModel is inherited and set as the data model for a spreadsheet.
• Resolved the issue where PercentCellType is behaving incorreclty.
• No exception is thrown when executing the GetStyleInfo method of the SheetView class in parallel processing using the Task class.
• Resolved the performance issues for ClipboardPasted and DragFillBlock events of FpSpread class.

File Versions

Spread for WinForms installs the following file versions on your system. See Installed Files for the exact location of these files.

Return to the ReadMe.