Spread.NET Versions

Spread Windows Forms and Spread WPF:

• New Pivot Table Style Options - Take greater control over how your PivotTables look and feel. With new style options, you can now customize header appearances and apply banded row and column formatting. The result is cleaner, more readable PivotTables that make complex data easier to interpret at a glance.
• Group Dialog for Pivot Fields - Grouping data is now more intuitive than ever. In addition to existing API-based grouping for numbers and dates, V19.1 introduces a designer-based dialog that supports grouping for numbers, dates, and now text. This enhancement simplifies data organization directly within your workflow.
• Active Cell Focus Highlighting - Navigating large datasets just got easier. With the new FocusCellMode property, you can highlight the active cell's row, column, or both - making it simple for users to track their position and reduce errors during data entry or analysis.
• Support for .NET 10 and Visual Studio 2026 - Stay up to date with the latest development platforms. Spread for Windows Forms and Spread WPF v19.1 fully supports .NET 10 and Visual Studio 2026, ensuring compatibility with modern development environments and future-ready applications.

Spread Windows Forms:

• New PivotTable Protection Option - Enable secure interaction with PivotTables even on protected worksheets. The new 'Use PivotTable' option allows users to work with PivotTables without removing sheet protection. Configure it easily through the Designer or programmatically via the AllowUsingPivotTables property.
• Paste Data Beyond Sheet Boundaries - Handling large data imports is now more flexible. The new PastingExceededValues option lets you control how pasted data behaves when it exceeds worksheet limits. Combined with the new ClipboardPastingEventArgs event, you gain fine-grained control over row and column expansion during paste operations.
• Seamless Hierarchical Scrolling Transition - Working with hierarchical (parent-child) data views is smoother than ever. Spread Windows Forms now supports seamless scrolling transitions between child and parent views, improving navigation and delivering a more natural user experience.

Spread WPF:

• Drag Fill Support - Boost productivity with built-in drag fill functionality. Users can quickly populate cells by dragging across rows or columns - mirroring the familiar auto-fill experience found in spreadsheets like Excel.
• Data Visualization Functions - Bring your data to life directly within cells. Spread WPF now supports data visualization functions, enabling you to create custom-rendered visuals such as sparklines and other graphical indicators. These functions combine calculation logic with rendering capabilities, opening the door to highly interactive and insightful spreadsheet designs.

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.