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

Release Notes for Version 18.2.0

Enhancements from the Previous Release

The following features and enhancements have been incorporated into this version of the product.

​​Designer Enhancements​

​​UI & Styling​​

​​Formula & Calculation​

​​PivotTable Improvements​

  • ​​PivotTable Data Source​​: Allows selecting entire columns (e.g., Sheet1!C:D) as PivotTable sources, resolving dynamic data update issues.

Collaboration Server Improvements - PREVIEW

File Format Compatibility​

Charts & Visualization​

​​ReportSheet​​

Framework Support​​

  • React 19: Added full compatibility with React 19.

  • Next.js 15: Added full compatibility with Next.js 15.

Improved License Error Messages​

Resolved Issues

The following issues have been resolved since the last release:

Data Validation & Cell Operations

  • Validation rules no longer fail after cell moves, preserving original validation.

  • New cells created after cut/paste operations now maintain correct absolute references.

Calculation Engine Improvements

  • Fixed calculation discrepancies with Excel when calcOnDemand=true, particularly for SUMIFS functions.

  • LET formula now returns correct values by properly handling operators with CalcArray.

  • BYROW formula now correctly returns results by properly referencing lambda functions.

  • Fixed abnormal formula calculation results that prevented Excel export, especially for image functions with "&" in URL parameters.

Pivot Table & Data Refresh

  • Pivot table fields remain checked after refreshing when data source fields match the current configuration.

  • Fixed incorrect renaming of calculated fields during pivot table refresh.

  • Excel files with pivot tables now import correctly, with all pivot tables available or addable after import.

Chart Rendering & Performance

  • Added support for Binary mode in QR code generation.

  • Significantly improved Treemap chart rendering performance for large datasets by optimizing model update triggers.

  • Chart reference data switching is now faster.

  • Chart and pivot table elements now maintain their state when imported from Excel.

  • Floating objects (like charts) now properly update their positions when row heights change.

UI & Display Fixes

  • First sheet display time is now consistent between ExcelIO and IO during incremental loading.

  • Gantt chart header sizes now correctly revert when switching views.

  • TableSheet custom grouping now displays all data correctly when scrolling.

  • Fixed strange scrollbar layout issues.

  • TabStrip fonts now display correctly on MacOS and iOS devices.

Data Binding & Table Operations

  • Inserting columns in data-bound tables now correctly moves footer values and sheet model data.

  • TableSheet row headers with merged cells now export correctly.

  • MultiColumn list cell type dropdown items are now clickable on mobile devices.

  • Table binding now properly moves all content, including tags, during row insertion.

Import/Export & File Handling

  • Excel file export now properly converts date strings to date formats, even with Chinese resources.

  • SpreadJS now correctly handles Excel files with specific file types (like purl.oclc.org).

  • ReportSheet SUMIF problems fixed by properly fetching data from the ReportSheet's data model.

  • When exporting CSV from ReportSheet, the worksheet index is no longer incorrectly set to -1.

Formula & Calculation Fixes

  • Formula results now match Excel's calculations across various scenarios.

  • Fixed inconsistent expand/collapse behavior for grouped columns.

  • calcOnDemand mode now correctly fetches current values for dynamic array formulas.

  • Invalid formula errors when loading JSON are fixed by properly parsing conditional format references.

Designer & Configuration

  • All data source updates in Designer are now encapsulated as commands.

  • ThemeFont is now properly applied to Title and Heading in Cell Style.

  • TableSheet now supports converting formulas with culture-specific input for panel inputs and column headers.

  • TableSheet now properly handles arrayGroupSeparator set to semi-colon.

  • Table configuration changes no longer occur before clearing ranges, fixing getColumnFormula returning null issues.

  • Conditional format count no longer increases incorrectly during moveTo operations.

  • TableSheet now properly maintains header sizes when switching between views.

Performance Optimizations

  • Significantly improved scrolling performance with auto-merge and fixed rows enabled.

  • Shift+PgDown shortcut performance improved by optimizing status bar calculations.

Localization & Internationalization

  • Filter menu now shows all relevant options with Arabic currency, fixing right-alignment display.

  • Fixed the Chinese culture date strings issues.

Error Handling & Edge Cases

  • Calling calculate() no longer throws errors with invalid sheet name references.

  • Fixed invalid cell style settings by addressing misplacing dropdown attributes and incorrect built-in style names during file import.

  • Formula errors after importing Excel 2016 files are fixed by properly expanding parameters for functions like N.

  • SpreadJS now properly loads specific Excel documents that previously failed due to unsupported file types.

  • An error message no longer appears when modifying cell values after format changes, fixing showZero value handling.

Miscellaneous

  • Clicking hyperlinks is now functional, fixing issues with auto-merged cells and frozen lines.

  • Tags are now correctly copied during row insertion operations to prevent data loss.

  • PatternFill color transfer errors during PDF export in blackAndWhite mode are fixed.

  • When exporting to Excel, date formatting now automatically converts input strings to date formats.

  • Header addition is now consistently applied across all row actions.

  • Fixed setDataSource tag issues.