Jspreadsheet Pro 12.0

使用高容量渲染扩展电子表格

Jspreadsheet Pro v12

Released: Dec 9, 2025

Updates in v12

Features

• Extended Viewport: Support for a billion cells with optimized rendering.
• Performance: Range and calculation optimizations for better performance.
• Mobile Navigation: Significant improvements in mobile navigation and better responsiveness.
• Touch Support: Enhanced touch interactions and responsiveness.
• Accessibility: Improved keyboard navigation with IME capabilities.
• Worksheet Tables: Added a new table feature for structured data management.
• Enhanced Copy-Paste: Copy and paste from Excel/Google Sheets with style preservation.
• Web Components: Added support for web-components-based editors.
• Multi-Selection: Added drag and drop support for multiple columns and rows.
• Force as text: Special text string character to force any input to be treated as text.
• Context Menu: New keyboard navigation support.
• Top Menu: New native top menu implementation.
• Selections: Deselect with CTRL+click consistent with other spreadsheet software.
• Behavior and Critical Updates:
  • Column Width: Changing the width of hidden columns/rows does not change the visibility state.
  • Null Handling: undefined/null is treated differently from empty strings for calculations and getData().
  • Empty String Definition: To explicitly define empty strings, use "''".
• Added Extensions:
  • jspreadsheet/extensions: Collection of all extensions.
  • jspreadsheet/format: Extension for custom editors and cell masking.
• Persistence
  • Removed these controls in favor of persistence: function which brings much more flexibility to developers. Additionally, the new autoId property helps to track row ids using guids.
• Columns
  • Column Visibility: Now includes arrow indicators.
  • Multi Column Drag: Drag and drop multiple columns simultaneously.
• Rows
  • Row Visibility: Now includes arrow indicators.
  • Multiple Row Drag: Drag and drop multiple rows simultaneously.
  • Automatic Ids: Automatically allocate guides for new rows.
• Formulas and Calculations
  • Performance optimizations have been introduced, with much better range management, a new type of chain for column and lines and calculations by reference when used together with Formula Pro Version 6.
  • Worksheet Names: Can now accept special characters when used as 'Countries-EU'.
  • Internal Arrays: Array controllers have been updated.
  • Formula Pro: New syntax to accept =100 * .1.
  • onerror: The formula pro includes the event onerror to be triggered when a formula generates errors.
• Removed Functions
  • Custom formulas can be used to restore these functions if needed.
• Clipboard
  • Jspreadsheet automatically includes styles when copying data from Excel, Google Sheets or other external spreadsheets or tables, as long as the content is smaller than 10MB.
  • External Paste: Pasting from external software now brings style information.
• Paste Special: New paste special controls are available in the context menu.
• Validations
  • Custom Validations: New setter jspreadsheet.setValidationHandler(name, handler).
  • Dynamic Lists: Support for type=formula and type=list with dropdown and formulas for dynamic lists.
• Filters
  • Column-Specific Filters: It is no longer possible to activate filters for specific column headers; you can activate at the header level or range level.
  • Range Filters: Better range filtering capabilities.
  • History Integration: Toggle filters are included in history to accept undo/redo operations.
• Editors
  • More accessibility with ARIA, enhanced IME and keyboard and navigation support. Additionally, custom editors can be created as web-components and other features as described below.
• Editor Types
  • Added a new widget for calendar and dropdowns.
• Viewport
  • The highlight of the viewport updates is the improved capability to handle millions of rows. Additionally, several properties have been moved to the spreadsheet level to ensure consistency across different worksheets.
• Shortcuts
  • The new shortcut management system is more flexible and logical, using an object-based declaration to match keyboard events.
• Group Columns/Rows
  • Background color has been removed.
  • History support has been added, allowing users to undo open/close group actions.
  • Improved consistency in group behavior across the spreadsheet.
• Footers
  • Footers have better capabilities, more flexible methods and are updated automatically during formula updates.
• History
  • Cascade Events: The history event onredo or onundo happens only once even when there are cascade events.
  • Performance: Improved history management and performance.