SpreadJS 16.2

Mejora la visualización, edición y depuración de fórmulas largas y complejas.
Agosto 17, 2023
Nueva versión

Características

  • 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

Solución completa de hoja de cálculo para aplicaciones JavaScript.

Solicitar presupuesto Comprar ahora

¿Alguna pregunta?

Chatee en vivo ahora mismo con nuestros especialistas en licencias de MESCIUS (formerly GrapeCity).