使用高容量渲染扩展电子表格
2025年12月12日
Jspreadsheet Pro v12 通过扩展视口渲染优化性能，确保大型电子表格具有响应性和可扩展性。
Jspreadsheet Pro 是一款灵活的基于 JavaScript 的电子表格解决方案，使开发人员能够为 Web 应用程序创建可定制且功能丰富的数据网格。它提供高级公式、数据验证和 API 集成。Jspreadsheet Pro 非常适合财务建模、库存管理和项目跟踪等任务，可帮助企业高效地管理和分析数据。其后端服务器集成支持实时数据处理，从而增强工作流程并提高各行业的生产力。
Jspreadsheet Pro v12 更新通过引入扩展视口和优化的渲染功能，改进了对大型数据集的处理能力。该视口仅处理电子表格的可见部分，从而降低内存占用，保持界面响应速度，即使在处理非常庞大或复杂的数据结构时也能实现流畅的交互。它为开发人员提供了一个更具可扩展性的基础，用于构建需要高性能电子表格功能的应用程序，同时又不影响速度或易用性。
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.
