[]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

Release Notes for Version 19.1.0

Enhancements from the Previous Release

Designer Enhancements

  • Templates Configuration & Default Template: Designer can now load a default template during initialization or Reset, which helps teams start new workbooks with predefined styles, settings, and structure instead of rebuilding the same setup each time.

  • Search Added to Formula Dialog: Users can now search by keyword in the Insert Function dialog, making it much faster to find the right function when working with large formula libraries or onboarding less technical spreadsheet authors.

  • SpreadJS XLSX Editor for VS Code Plugin: SpreadJS Designer is now available as a VS Code editor, so developers can open and edit .sjs, .ssjson, .xlsx, .xlsm, .xltm, .xltx, and .csv files directly inside their normal development workflow.

  • DataObject Cell Type in Designer: The DataObject cell type can now be configured from the Designer UI, reducing the need to switch to code when building object-based or JSON-driven cell display scenarios.

  • Apple Silicon Support for Desktop Designer: The macOS Desktop Designer App now supports Apple M-series devices, improving performance and avoiding the poor experience of running older Intel-based builds on modern Macs.

Formulas

  • Custom Functions in Calc Worker: Custom functions can now run inside the Calc Worker, so calculation-heavy applications that rely on custom business logic can keep more work off the UI thread and maintain a smoother editing experience.

  • Value and Array to Text Functions: Added VALUETOTEXT and ARRAYTOTEXT, making it easier to convert scalar values and arrays into text while improving compatibility with newer Excel-based workbook logic.

Conditional Formatting

  • Top/Bottom Percent Rule: Percent-based Top/Bottom conditional formatting now behaves more like Excel, which helps users preserve ranked highlighting logic when importing or rebuilding existing workbooks.

  • Sparkline Rules in Conditional Formatting: Conditional formatting can now drive sparkline-style visuals directly, making it easier to build compact KPI views such as lollipop, gauge, bullet, and variance-style displays without extra formula setup.

Cell Formatting

  • Single and Double Accounting Underline: Added Excel-style accounting underline options, which is especially useful in financial reports where totals and statement formatting need to match familiar spreadsheet conventions.

  • Picture In Cell: Pictures can now behave as cell values instead of floating objects, which makes image-based data easier to sort, filter, search, look up, and include in Excel-compatible workflows.

  • Named Cell Templates: Added named cell templates so users can package styles, validation, conditional formatting, and cell states into reusable workbook-level templates and apply them consistently across multiple ranges.

What-If Analysis

  • Support What-If Analysis Data Table: SpreadJS now supports Excel-style What-If Analysis data tables, allowing users to test one-variable and two-variable scenarios directly in the sheet instead of manually building simulation grids.

  • Support What-If Analysis Goal Seek: Goal Seek has been enhanced with additional options for iteration control and progress handling, making it more practical for planning, forecasting, and target-based calculation workflows.

Import/Export

  • Support XLTX File Formats: SpreadJS now supports importing and exporting .xltx template files, which helps teams reuse Excel-based workbook templates in browser and Designer workflows.

  • Export SparklineEx Types as Images in Excel: Barcode, sparkline, and other SparklineEx results can now be exported as images to Excel, helping visual worksheet content remain intact even when Excel does not natively support the original formula type.

Data Manager

  • Request Header Customization UI: Designer now provides UI support for configuring request headers, which makes it easier to connect workbook-based solutions to secured APIs that require authorization or custom headers.

  • DataSource Panel Enhancements: The Data Manager design-sheet experience has been reorganized with clearer setup and preview flows, helping users bind and validate data sources with less friction.

  • Embedded JSON in Data Manager in SJS Files: DataManager JSON can now be packaged more cleanly inside .sjs files, improving portability and preparing the file format for richer embedded-asset scenarios.

TableSheet

  • Support Multi-column Sorting: TableSheet now supports multi-column sorting with clearer controls and indicators, allowing users to build compound sort orders without losing previously applied sort levels.

  • Apply Column Styles Across Multiple Selected Columns: When multiple TableSheet columns are selected, style changes can now be applied across the full selection, making bulk formatting practical in wide data grids.

  • Blank Value Display in TableSheet: In TableSheet scenarios, custom formatters can now handle null and empty-string values more gracefully, so developers can show placeholders such as N/A, --, or blank output without switching to custom cell types.

PivotTable

Collaboration Server

  • Support TableSheet and Data Manager: Collaboration Server now supports TableSheet and DataManager configuration collaboration, allowing multiple users to coauthor complex data views while keeping structure and settings synchronized.

  • Support Local Data in Data Manager: Collaboration now also supports DataManager local data, helping teams coauthor large local datasets and hierarchical views without depending on remote-source-only models.

DataCharts

  • Support Hierarchical Category in DataCharts: DataCharts now support hierarchical categories on Cartesian charts, making it easier to visualize multi-level business dimensions such as Year to Quarter to Month or Region to Country to City.

  • TreeMap Header Option: TreeMap charts now provide more control over header display, helping teams present hierarchical data with the level of label visibility that best fits the chart.

  • More LineAspect Options for Line, Area, and Radar Charts: Added more LineAspect choices so chart authors can better control how trends and line behavior are displayed across different chart types.

  • Multiple Fields Value Encoding: DataCharts now support value encodings that draw from multiple fields, which is especially useful in financial, range, and multi-metric plotting scenarios.

GanttSheet

  • Improved UX for Building GanttSheet: The GanttSheet design experience has been streamlined so users can map fields, configure hierarchy, and set up timeline behavior more intuitively from a more centralized workflow.

  • Table Theme Support in GanttSheet: GanttSheet now honors TableTheme styling more consistently across table, time scale, and chart regions, which helps teams keep Gantt views visually aligned with the rest of the workbook.

  • Splitter Handle Between Grid and Chart Areas: A new splitter handle makes it easier to resize the table and chart portions of a GanttSheet, improving usability when task metadata and timeline space compete for attention.

  • Show Only the Project Period: Gantt charts can now focus the visible timeline on the actual project period, reducing empty space and making large schedules easier to review and scroll.

UI and UX Enhancements

  • Automatic Scrollbar Visibility: Scrollbars can now hide automatically when content is fully visible and appear only when needed, helping embedded sheets and dashboards feel cleaner without removing discoverable scrolling behavior.

  • Excel-like Checkboxes: SpreadJS now supports a more modern Excel-style checkbox experience, helping imported workbooks preserve their intended interactive boolean UI.

  • Disable Mentions in Threaded Comments: Threaded comments now support disabling @mention behavior, which is useful in deployments where no shared collaborator directory exists and the mention UI would otherwise add noise.

  • Adding Shapes via Drawing Mode: Shapes can now be placed by drawing directly on the sheet, which improves precision and makes the insertion experience feel much closer to Excel.

  • Curved Connector Shapes: Added support for curved connector shapes, giving diagram authors more flexibility when they need cleaner visual paths between related items.

  • Connection Point UI Enhancements: When building flowcharts and connected diagrams, users now get clearer snap-point feedback, better connection-state visuals, and more helpful live routing previews while linking shapes.

Framework Support

  • Angular 21 Support: SpreadJS is now compatible with Angular 21, helping teams upgrade modern Angular applications without changing their spreadsheet integration approach.

  • Next.js 16 Support: SpreadJS is now compatible with Next.js 16, making it easier to keep spreadsheet applications current on the latest Next.js stack.

Additional Enhancements

  • ReportSheet Add/Delete Record Performance: ReportSheet preview performance has been improved for add-record and delete-record workflows, reducing lag in record-heavy templates that previously triggered expensive recalculation.

Resolved Issues

Chart & Shapes

  • Fixed chart rendering cases that behaved differently from Excel.

  • Fixed trend lines displaying beyond the chart area in certain scenarios.

  • Fixed missing charts after importing some Excel files into SpreadJS Designer.

  • Fixed imported Excel charts not preserving per-point data label visibility when labels were manually removed.

  • Fixed Excel export corruption when shapes used formula bindings.

Formula & Calculation

  • Fixed cases where formulas returned #N/A in SpreadJS while working correctly in Excel.

  • Optimized getDependents and getPrecedents to avoid scanning unused ranges, improving performance on large sheets.

  • Fixed row-header formula results not updating after row drag-and-drop operations.

  • Fixed Find and Replace converting formulas to plain text instead of preserving formula behavior.

Conditional Formatting

  • Fixed performance degradation when applying conditional formatting to large data ranges.

  • Fixed incorrect evaluation of the "Between" conditional formatting rule when ExcelCompatibleCalcMode is enabled.

Import/Export & Compatibility

  • Fixed cell background colors changing unexpectedly after importing certain Excel files.

  • Updated TypeScript declaration patterns to avoid future compatibility issues.

TableSheet & Data

  • Fixed Object and Array column types failing to parse JSON string values.

  • Fixed blank-cell handling when reapplying Remove Duplicates on the same selection.

  • Fixed newly added TableSheet rows rendering in the wrong position after hierarchy recalculation when using "Add After".

  • Fixed Table Design tab remaining visible after deleting the last table column until focus changed.

  • Improved iconSize behavior and API consistency for TableSheet row action options.

UI & Interaction

  • Fixed the split-column operation not marking the workbook as modified.

  • Fixed scrollbarShowMax and scrollbarMaxAlign not being honored at certain zoom levels.

  • Fixed incorrect row and column highlight behavior when double-clicking headers with stateRule and header drag enabled.

  • Fixed scrollbar drag behavior regressions in Power BI custom visual scenarios after upgrading to SpreadJS v19.