# Release Notes for Version 19.0.20251.0 ## Content 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](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart) 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](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/pivot-table) with customizable fields, layouts, styles, filters, sorting, built-in dialogs, and more. * Spread now allows you to [insert a DataTable](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-elements/data-table) within enhanced charts by using the [IChart.DataTable](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.Charts.IChart.DataTable.html) property. * Enhanced charts now support importing and exporting [chart data labels](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-elements/data-label) 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](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-elements/data-label) through the [IDataLabels.Position](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.Charts.IDataLabels.Position.html) and [ITextFrame.AutoSize](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.Drawing.ITextFrame.AutoSize.html) properties. * Enhanced charts now support [vertical writing for data labels and legends](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-elements/data-label) using the [IDataLabels.TextOrientation](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.Charts.IDataLabels.TextOrientation.html) property. * Enhanced charts now support [showing or hiding individual legend entries](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-elements/legend) with [ILegend.Delete()](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.Charts.ILegend.Delete.html). * Enhanced charts now support [smoothed line charts](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/enhanced-chart/chart-types/basic-charts/smooth-line-chart), providing visually appealing curved lines similar to Microsoft Excel. * FormulaTextBox now supports [multi-line display and auto-indentation](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulabar) for long or complex formulas via the [AutoIndent](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FormulaTextBox.AutoIndent.html), [IndentSize](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FormulaTextBox.IndentSize.html), and [FormatWidthLimit](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FormulaTextBox.FormatWidthLimit.html) properties. * Spread now supports configurable header highlight styles for selection, hover, and “contains selected” states in the new style system, using the [HeaderSelectedStyle](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadSkin.HeaderSelectedStyle.html), [HeaderHoverStyle](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadSkin.HeaderHoverStyle.html), and [HeaderContainsSelectedStyle](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadSkin.HeaderHoverStyle.html) properties. * Spread now allows you to [pin rows and columns](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-freeze) in a worksheet view using the [TogglePinnedRows()](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.IWorksheet.TogglePinnedRows.html) and [TogglePinnedColumns()](https://developer.mescius.com/spreadnet/api/latest/online-win/GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.IWorksheet.TogglePinnedColumns.html) 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](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.IFeatures.ExcelCompatibleKeyboardShortcuts.html) is enabled. * Spread now allows you to prevent automatic scrolling when dragging to select a cell range by handling the new [SheetAutoScrolling](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SheetAutoScrolling.html) event. * Spread now allows you to [customize sheet tab appearance](https://developer.mescius.com/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet/spwin-appearsheetnames) 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](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadView.SetViewportLeftColumn.html)` ` and [SetViewportTopRow](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SpreadView.SetViewportTopRow.html) 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](https://developer.mescius.com/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/trimrange), [REGEXTEST](https://developer.mescius.com/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/regextest), [REGEXEXTRACT](https://developer.mescius.com/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/regexextract), and [REGEXREPLACE](https://developer.mescius.com/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsRtoS/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](https://developer.mescius.com/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellType.NegativeFormat.html) 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](/spreadnet/docs/latest/readme/installedfiles) for the exact location of these files. | **File** | **Version** | | ---- | ------- | | FarPoint.CalcEngine.dll | 19.0.20251.0 | | FarPoint.Excel.dll | 19.0.20251.0 | | FarPoint.PDF.dll | 19.0.20251.0 | | FarPoint.PluginCalendar.WinForms.dll | 19.0.20251.0 | | FarPoint.Win.Chart.Design.dll | 19.0.20251.0 | | FarPoint.Win.Chart.dll | 19.0.20251.0 | | FarPoint.Win.Design.dll | 19.0.20251.0 | | FarPoint.Win.dll | 19.0.20251.0 | | FarPoint.Win.Ink.dll | 19.0.20251.0 | | FarPoint.Win.Spread.Design.dll | 19.0.20251.0 | | FarPoint.SpreadDesigner.exe | 19.0.20251.0 | | FarPoint.Win.Spread.dll | 19.0.20251.0 | | FarPoint.Win.Spread.Html.dll | 19.0.20251.0 | | FarPoint.Win.TextRenderer.dll | 19.0.20251.0 | | GrapeCity.CalcEngine.dll | 19.0.20251.0 | | GrapeCity.Spreadsheet.DataVisualization.dll | 19.0.20251.0 | | GrapeCity.Spreadsheet.dll | 19.0.20251.0 | | GrapeCity.Spreadsheet.Win.dll | 19.0.20251.0 | | GrapeCity.Spreadsheet.WinForms.Ribbon.dll | 19.0.20251.0 | | GrapeCity.Win.PluginInputMan.Design.dll | 19.0.20251.0 | | GrapeCity.Win.PluginInputMan.dll | 19.0.20251.0 | Return to the [Read Me](/spreadnet/docs/latest/readme/readme).