Released: Aug 14, 2025

18.2.0 での更新項目

機能

• Designer Enhancements
  • Theme Support & Customization: SpreadJS Designer now supports two built-in themes and provides theme customization capabilities, enabling support for more modern themes.
  • Transform Command: Implemented a Transform command to apply LAMBDA formulas to a selection, replacing the selected content.
  • Name Manager Enhancements: Added sorting and filtering capabilities to the Name Manager interface.
  • Font Picker Editing: Enabled editing within the font picker component of the designer.
  • Table Enhancements:
    • Added APIs to retrieve table binding sources, convert a regular table to a bound data table, and convert a bound data table back to a regular table.
    • Added support for converting tables to and from bound DataTables through designer UI.
• UI & Styling
  • Checkbox & CheckboxList CellType: Added toggle mode support for Checkbox/CheckboxList cell types, enabling switch-like behavior in cells.
  • Shape Text Direction: Added support for text direction settings in shapes.
  • Paste Special with Lambda Formula: Enabled transformation of clipboard data through Lambda formulas before pasting.
  • Data Validation Search: Enhanced data validation to include search functionality.
  • Comment Fill Color: Comment fill color support now matches Excel 2019+ functionality.
  • Sheet List Search: Added a search feature to the sheet list for quick worksheet navigation.
• Formula & Calculation
  • Asynchronous Function Evaluation: Enabled evaluation of asynchronous functions outside the worksheet.
• PivotTable Improvements
  • PivotTable Data Source: You can now select entire columns (e.g. Sheet1!C:D) as PivotTable sources, resolving dynamic data update issues.
• Collaboration Server Improvements - PREVIEW
  • Real-time Collaboration Status: Added visual indicators for document editing status during collaboration.
  • Batch Operation Processing: Introduced batch operation APIs for submitting multiple changes.
• File Format Compatibility
  • XLSM & XLTM File Format Support (Lossless): Added full support for importing/exporting macro-enabled Excel files with format preservation.
  • XML Source Editing: Added lossless editing of XML source (workbook XML maps).
• Charts & Visualization
  • Added new data chart types:
    • Treemap Chart: Visualizes hierarchical data with nested rectangles.
    • Funnel Chart: Represents process stages with narrowing proportions.
• ReportSheet
  • Hidden Row/Column Visibility: Enabled visibility of hidden rows and columns during design time in Report Sheet templates.
• Framework Support
  • React 19: Added full compatibility with React 19.
  • Next.js 15: Added full compatibility with Next.js 15.
• Improved License Error Messages
  • Enhanced license error messages to help users diagnose issues, including:
    • Invalid/missing keys.
    • Version mismatches.
    • Hostname mismatches.
    • Expired keys.

不具合の修正

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