SpreadJS 16.2

長く複雑な数式の表示、編集、デバッグを改善
8月 17, 2023
新バージョン

機能

  • Gantt Sheet Add-On (Beta) - This is a full Gantt implementation inside a specialized sheet in SpreadJS. It has its own headers and uses shapes to draw the Gantt tasks. There are multiple options that Gantt Sheet offers including:
    • Zoom and Scroll for the timescale.
    • Styles for taskbars and gridlines.
    • Layout.
    • Task operations.
    • Calendar.
    • Importing and exporting.
  • Formula Editor Panel - Viewing, editing, and debugging long and complex formulas is now even easier with the Formula Editor Panel. This new component provides the following functionality:
    • Syntax highlighting - Formula text will be displayed in different colors according to the type of token. Different syntax elements of a formula (such as the referenced ranges) are highlighted accordingly to enhance readability.
    • Formatting - Formulas that are long and complex can be formatted into separate lines with the appropriate indentation and nesting.
    • Flexible Outline View - Formula outlines can be collapsed and expanded.
    • Auto-Completion Suggestions - Formulas can be entered quickly and correctly with suggested functions, custom names, and enumerated parameters.
    • Tooltip Information - Tooltips with information about a function will show when a user hovers over a function name or types a function.
    • Lint Option - Formula errors such as incorrect parameters and unmatched brackets will be flagged.
    • Theme Customization - You can change the appearance of the Formula Editor by changing the theme CSS, which include properties such as tokens, tooltips, backgrounds and foregrounds.
  • Accessibility
    • Cell.altText Property - This property lets you set specific text that will be read by a screen reader when accessibility is set to true.
  • Calculation Enhancements
    • SUMIFS and XLOOKUP Enhancement - The SUMIFS and XLOOKUP functions have been enhanced in terms of performance.
    • Microsoft Excel Manual Calculation Options - When set, formulas will not automatically calculate; instead, formulas will only calculate when edited or when a new formula is entered.
    • Cross-Sheet Reference Support when Entering Formulas - This release adds the ability to click on a different sheet tab while editing a cell formula to reference cells in other worksheets.
  • Workbook Enhancements
    • Cell defaultValue Property - Added a property that allows you to set the default value for a cell. Normally, a cell will display blank when there is no value in it. With this release, you can set any value or formula as the default value of a cell.
    • Date Time Picker and Slider - Date Time Pickers and Sliders have been enhanced to support users defining a time period or range that includes either a start and end time, or a numerical period from a start number to an end number. This enhancement represents a simple object that can be stored as a cell value, with start and end properties that can either be Dates or Integers.
    • Excel Styles Copy Optimization - Now, SpreadJS will generate named styles for cells and add them on top of the HTML clipboard content instead of adding the same style definition for each cell.
  • TableSheet Enhancement
    • Window Aggregation Function - The WINDOW functions added in this release provide data analysis in a TableSheet. These functions can perform aggregation, ranking, and analytical calculations over a particular window (a set of table rows that are related to the current row) and produce a result for each row. These new functions are as follows:
      • Ranking Functions:
        • CUMEDIST - returns the cumulative distribution value.
        • DENSERANK - returns the rank of the current row within its partition without gaps.
        • ROWNUMBER - returns the number of the current row within the partition.
        • W_PERCENTRANK - returns the percentage of the rank value.
        • W_RANK - returns the rank of the current row within its partition with gaps.
      • Analytic Functions:
        • FIRSTVALUE - returns the value of the argument from the first row of the window frame.
        • LAG - provides access to the value from a row at a given physical offset that leads to the current row.
        • LASTVALUE - returns the value of the argument from the last row of the window frame.
        • LEAD - provides access to the value from a row at a given physical offset that follows the current row.
        • NTHVALUE - returns the value of the argument from the Nth row of the window frame.
        • NTILE - returns the bucket number of the current row within its partition.
  • Designer Enhancements
    • Default Active Ribbon Tab - By setting a default active tab in the configuration, that specific tab will be open upon loading the SpreadJS Designer Component.
    • Excel Themes, Colors, and Fonts - Added Themes, Colors, and Fonts buttons to the Designer, which lets users switch themes or color sets to affect all shapes, charts, and built-in cell styles that reference those theme colors.
    • Excel File Password - SpreadJS supports opening and saving Excel files with passwords, and now that functionality has been added to the SpreadJS Designer.
  • Angular 16 Support - SpreadJS now supports Angular 16 in the Angular wrapper and the Designer Component.
SpreadJS 16.2
Formula auto-completion suggestions example

SpreadJS（英語版）

JavaScriptアプリケーション向けの完全なスプレッドシートソリューション。

見積もりの依頼 購入

ご質問がありますか？

今すぐ MESCIUS (旧社名：GrapeCity) ライセンススペシャリストとライブ チャット。