SpreadJS 14

添加新的 SpreadJS 设计器组件加载项以及 LET 和 X 函数。
11月 18, 2020 - 16:28


  • New v14 Designer - GrapeCity have created a separate add-on product known as the SpreadJS Designer Component. It is an implementation of a Microsoft Excel-like user interface with SpreadJS features including a ribbon, status bar, formula bar, context menus, and associated dialogs. The SpreadJS v14 Designer includes:
    • Add or remove buttons for tabs in the ribbon.
    • The option to change styling.
    • The ability to change the functionality of different buttons.
    • Custom dialogs.
  • Cell Interactions
    • Incremental loading - Improved performance when working with large amounts of data.
    • Accessibility Support - Included compatibility with screen readers and ADA compliance to better assist customers that need accessibility support in their applications. The supported screen readers are:
      • NVDA for Microsoft Windows.
      • Microsoft Windows Narrator.
      • VoiceOver for Apple OS X.
    • Multi-Column Picker - Added a new drop-down type: the Multi-Column Picker.
    • Comment Indicator Customization - Users can now change the color and size of the indicator.
    • HTML Export - Added the ability to export cell ranges to HTML tables.
    • Improved getRange API - Using the getRange API in previous versions, the row index, column index, row count, and column count were needed to get the specified cell range. SpreadJS v14 uses a more convenient parameter: the range address as a string.
    • Copy Images from Excel - Now supports copying images from Excel and pasting them into sheets. The pasted image will have the same size, border, and background as it did in Excel.
    • NumbersFitMode - You can now set the display strategy for user-defined date and number types with the NumberFitMode option. This option has two enumeration options: mask and overflow.
    • SelectionMode with AutoMerge - Users can now select the automatically merged cells as if they were spanned cells.
    • Table Expand Rows API - SpreadJS v13 included a functionality that automatically expanded rows as data was added in the table. SpreadJS v14 features an API that enables or disables this feature.
    • Pixel Scrolling with Scrollbar - Pixel-scrolling is now affected by scrollbars and not just manually scrolling.
    • Fill Effects and Patterns - Added the ability to use fill effects and patterns for cells, including added support for importing and exporting files that include fill effects and patterns.
  • Calculation Enhancements
    • The OBJECT Function - Added a new OBJECT function. This function lets users define an Object from a set of property names and expressions. Objects can be used for data binding to other cells or as RangeCellType or RANGEBLOCK parameters.
    • The PROPERTY Function - Lets developers parse an object by its properties. Use this function to inspect object properties, or use it in the Multi-Column Picker to parse the returned object into the corresponding property values.
    • The RANGEBLOCK Function - Works with RangeCellTypes. Use this function to implement sparklines within RangeCellTypes. Ideal for implementing dashboards and multi-row scenarios.
    • Cascade Sparkline Total Column - The cascade chart feature is especially useful for charting income statements and balance sheets with totals.
    • Header Formulas and SparklineEx - A column formula or sparkline in the header row is useful for summarizing a dataset in some cases. Lets developers display formulas and sparklines within headers, so they remain visible no matter where the user scrolls.
    • Iterative Calculations - Iterative calculations, also known as circular references, help solve specific calculations by repeatedly using the previous result. Calculate the future value of investments, or provide automatic timestamps to files. Perform what-if analysis with the CalcEngine.goalSeek function, which uses iterative calculations in SpreadJS.
    • X and LET Functions - These new functions include XMATCH, XLOOKUP, and LET, which allow users to create easy to read formulas and make calculations with large datasets.
    • CONVERT Function - Added support for several new units of the CONVERT function. Units include weight and mass, distance, force, pressure, temperature, volume, area, and binary prefixes.
  • New Charts and Enhancements
    • Funnel Chart - Added support for funnel charts Excel chart type. Excel files exported to or imported from Excel that contain funnel charts will load those charts successfully.
    • Axis Cross Points - Now includes an API which adds the ability to choose where the X and Y-axis cross each other.
    • Pattern Fill - Added the ability to add pattern fill to the charts.
    • Bar/Column Chart Gap Width and Overlap - The column and bar charts feature two new properties: gap width and series overlap.
      • gapWidth: sets space between the bar or column clusters as a percentage of the bar or column width (between 0 and 5).
      • overlap: sets bar or column positions (between -1 and 1).
    • Doughnut Chart Hole Size - Lets users customize the size of the hole in their doughnut charts. Display wider slices to better accommodate data labels with long text.
    • Line Break in Charts - Charts now support line breaks for the chart area, including axis labels and legend text, just like Excel.
    • DataLabel Delimiter Options - Chart DataLabels previously only supported commas as a delimiter. Now they support semicolons, periods, and line breaks as well.
LET and X functions


JavaScript 电子表格和数据演示文稿组件。


透过Live Chat与我们的GrapeCity 专家联络!