SpreadJS 15.1

통합 문서 간 수식에 대한 지원과 타임라인 슬라이서에 대한 지원을 추가합니다.
5월 25, 2022
신규 버전

기능

  • Cross Workbook Formulas - This new feature allows your users to enter formulas that contain references to data in other SpreadJS workbooks.
  • PivotTable Enhancements
    • Timeline Slicer Support - SpreadJS PivotTables now support timeline slicers, which give your users the ability to slice data by specific dates.
    • Show Items with no Data - By default, PivotTables will only display items containing data. With the new 'Show items with no data' option, you can enable the PivotTable to show these blank values even though they don’t have any data.
  • TableSheet Enhancements
    • Multiple Header Support - TableSheet now supports displaying multiple rows in column headers, allowing you to visually group columns together in hierarchies of related fields.
    • Free Header Area Support - This lets you create a dynamic header area above the TableSheet view that includes full support for formulas, formatting and more, making it ideal for providing supporting summary data at a glance.
    • Cross Column Support - Cross columns allow you to present (pivot or transpose) fields from multiple related tables or records in a single row view.
    • Create PivotTable from TableSheet name - You can now reference TableSheet data when creating PivotTables.
    • Stacked Mode Vertical Enhancement - In many cases, columns in a TableSheet will contain header text that is longer than the column's width. This column header StackedMode API enhancement allows you to display the full text without increasing the column width.
  • Designer Enhancements
    • CultureInfo Enhancements
      • Exposing properties (id, name, predefinedFormats) in the CultureInfo type.
      • Support for customization of culture-related features in the number format dialog.
      • A new culture information package project published on GitHub.
    • Filter Auto Extend Support - When a filter is applied on a single cell, it is automatically extended to adjacent cells that have data in them.
    • Vue 3 Support - This release adds Vue 3 support to the Designer Component.
  • Calculation Enhancement
    • '.' Object Operator Support - The calculation engine now supports using '.' as an operator to retrieve the properties of an object.
  • Workbook Enhancements
    • Referenced cell content inside Shapes - This release includes the ability to add cell references as the content in shapes.
    • Non-contiguous Range Sparkline - Create sparklines from data in non-contiguous ranges of cells.
    • Automatically Update Print Ranges when adding/removing rows/columns - Print ranges now update when rows or columns are added or removed.
    • Show All Sheets Button - To make multiple sheets easy to navigate in SpreadJS, this release added an 'All Sheets' button in the sheet tab bar, which shows a drop-down of all of the sheets in the workbook to make them easier to select.
    • GetUsedRange Support - SpreadJS now supports the 'GetUsedRange' API, which essentially returns the range of cells with data.
    • Drag-Drop Enhancement - The drag-drop functionality in SpreadJS has been enhanced to insert rows rather than overwriting existing rows.
    • VeryHidden Worksheet Support Status - This behaves the same as the standard 'Hidden' status, except that hide and unhide operations cannot be performed through the UI.
    • SetStyle/SetStyleName Cell Range Support - In the previous release of SpreadJS, setting style and style names would have to be done cell-by-cell using a loop. This release has eliminated the need for a loop by providing the setStyle and setStyleName API on entire cell ranges.
SpreadJS 15.1
Timeline Slicer support

SpreadJS

JavaScript 애플리케이션을 위한 완벽한 스프레드시트 솔루션.

견적 요청 지금 구입하기

궁금한 점이 있으세요?

MESCIUS (formerly GrapeCity) 사 제품 라이선스 담당자와 라이브 채팅