Released: Jan 5, 2026

v19 中的更新

特性

Spread for WinForms:

• Added support for 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.
• Create pivot tables with customizable fields, layouts, styles, filters, sorting, built-in dialogs, and more.
• 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.
  • Adding custom label formatters for chart labels.
  • Setting label positions and auto-sizing chart labels through the IDataLabels.Position and ITextFrame.AutoSize properties.
  • Vertical writing for data labels and legends using the IDataLabels.TextOrientation property.
  • Showing or hiding individual legend entries with ILegend.Delete().
  • Smoothed line charts, providing visually appealing curved lines similar to Microsoft Excel.
• FormulaTextBox includes support for multi-line display and auto-indentation for long or complex formulas via the AutoIndent, IndentSize, and FormatWidthLimit properties.
• Added support for configurable header highlight styles for selection, hover, and “contains selected” states in the new style system, using the HeaderSelectedStyle, HeaderHoverStyle, and HeaderContainsSelectedStyle properties.
• Pin rows and columns in a worksheet view using the TogglePinnedRows() and TogglePinnedColumns() methods.
• Add “Move Rows” and “Move Columns” as new sheet protection options when protecting worksheets.
• Supports Excel-like arrow key navigation between cells in flat style mode when ExcelCompatibleKeyboardShortcuts is enabled.
• Prevents automatic scrolling when dragging to select a cell range by handling the new SheetAutoScrolling event.
• Customize sheet tab appearance by setting protected color, hover color, and icons for each tab.
• Enables setting the left column and top row of the frozen viewport to values other than zero, using the SetViewportLeftColumn and SetViewportTopRow methods.
• Display and customize RibbonBar items and the ribbon control’s view mode directly in design mode, making form design and configuration easier.
• 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.

Spread for WPF:

• Create pivot tables with customizable fields, layouts, styles, filters, sorting, built-in dialogs, and more.
• Enhanced charts now support vertical writing for data labels and legends using the IDataLabels.TextOrientation property.
• Supports the AllowCellOverflow property, enabling you to control whether cell content can overflow into adjacent empty cells.
• Provides the TabStripEditable property.
• 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.

修补程序

Spread for WinForms:

• 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.