Release Notes for Version 19.0.20251.0

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:

• Spread now supports enhanced charts with a new rendering engine and model objects, providing higher compatibility with Microsoft Excel, additional chart types, and advanced features for improved data visualization performance and appearance.

• Spread now enables you to create pivot tables with customizable fields, layouts, styles, filters, sorting, built-in dialogs, and more.

• Spread now allows you to insert a DataTable within enhanced charts by using the IChart.DataTable property.

• Enhanced charts now support importing and exporting chart data labels with Excel files.

• Enhanced charts now support adding custom label formatters for chart labels.

• Enhanced charts now support setting label positions and auto-sizing chart labels through the IDataLabels.Position and ITextFrame.AutoSize properties.

• Enhanced charts now support vertical writing for data labels and legends using the IDataLabels.TextOrientation property.

• Enhanced charts now support showing or hiding individual legend entries with ILegend.Delete().

• Enhanced charts now support smoothed line charts, providing visually appealing curved lines similar to Microsoft Excel.

• FormulaTextBox now supports multi-line display and auto-indentation for long or complex formulas via the AutoIndent, IndentSize, and FormatWidthLimit properties.

• Spread now supports configurable header highlight styles for selection, hover, and “contains selected” states in the new style system, using the HeaderSelectedStyle, HeaderHoverStyle, and HeaderContainsSelectedStyle properties.

• Spread now allows you to pin rows and columns in a worksheet view using the TogglePinnedRows() and TogglePinnedColumns() methods.

• Spread now adds “Move Rows” and “Move Columns” as new sheet protection options when protecting worksheets.

• Spread now supports Excel-like arrow key navigation between cells in flat style mode when ExcelCompatibleKeyboardShortcuts is enabled.

• Spread now allows you to prevent automatic scrolling when dragging to select a cell range by handling the new SheetAutoScrolling event.

• Spread now allows you to customize sheet tab appearance by setting protected color, hover color, and icons for each tab.

• Spread now supports setting the left column and top row of the frozen viewport to values other than zero, using the SetViewportLeftColumn and SetViewportTopRow methods.

• Spread now allows you to display and customize RibbonBar items and the ribbon control’s view mode directly in design mode, making form design and configuration easier.

• Spread now supports enhanced and new calculation functions, including better Unicode handling for LEN, MID, SEARCH, FIND, and REPLACE, regex support for XLOOKUP/XMATCH, use of built-in functions as eta-lambdas, and new functions such as TRIMRANGE, REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. You can also set a compatibility version per workbook to control function behavior.

Resolved Issues

The following issues have been resolved since the last release.

• Fixed charts failing to render in Print Preview.

• Resolved selection border not updating when pasting into a sheet with hidden columns.

• Fixed an error occurring on the first attempt to save to XLSX files.

• Resolved incorrect paste and undo behavior when using RichClipboard.

• Fixed header and footer margins not being applied when printing FpSpread via OwnerPrintDraw.

• Resolved enhanced shapes being broken improperly across page breaks during printing.

• Fixed inconsistent page break behavior.

• Resolved missing column headers when opening exported XLSX files in WPS.

• Fixed NegativeFormat.NegativeSignBefore setting not being respected during Excel export.

• Resolved exception thrown after adding then removing the Cell Styles icon from the Quick Access Toolbar.

• Fixed page header not printing when ExcelCompatiblePrinting is enabled.

• Resolved application freeze caused by clicking on column headers.

• Fixed application startup failure caused by printer initialization.

• Resolved intermittent dashed selector appearing in cell values used as function arguments.

• Fixed inability to select a shape on a scaled sheet.

• Resolved application crash when selecting a range in the Formula Wizard.

• Fixed designer error in C1Ribbon triggered by installing GrapeCity.Spread.WinForms.

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 Read Me.