Skip to main content Skip to footer

SpreadJS Releases

SpreadJS v17

SpreadJS V17 has a lot of exciting new features and two new optional addons:

  • NEW! ReportSheet Add-On
  • NEW! GanttSheet Add-On
  • Chart Enhancements
    • Waterfall Charts
    • Smooth Lines Format for Line Charts
    • Inserting Charts with Multi-Selections
    • Shape-based Chart Rendering
  •  Workbook Enhancements
    • Additional Paste Special Options
    • Sheet Tabs Style Support
    • Extending Custom Table Column Style
    • TopRowChanged/LeftColumnChanged Event Enhancement
    • Distributed Horizontal Alignment
    • Preserve Last Excel Sort State
  • Calculation Enhancements
    • IMAGE Function Update
    • Window Functions Enhancements
  • PivotTable Enhancements
    • Table Font Options
    • PivotArea Offset Support
  • TableSheet Enhancements
    • Reference Calculated Fields
    • Trigger Formulas for Columns
  • Lollipop Variance Sparkline
  • Designer Component Enhancement
    • SpreadJS Shortcut Commands
    • Sparkline Enhancement

SpreadJS v16

Release Notes | Release Blog | Releases Page

SpreadJS V16 SP2 is here! This release includes several exciting enhancements and new features, including:

  • GanttSheet Add-On Beta

  • Formula Editor Panel

  • Accessibility

    • Cell.altText Property

  • Calculation Enhancements

    • SUMIFS and xLOOKUP Performance Enhancement

    • Excel Manual Calculation Options

    • Cross-sheet Reference Support in FormulaTextBox

  • Workbook Enhancements

    • Cell defaultValue Property

    • Date and Integer Range Cell Types

    • Excel Styles Copy Optimization

  • TableSheet Enhancement

    • Window Aggregation Function

  • Designer Enhancements

    • Default Active Ribbon Tab

    • Excel Themes, Colors, and Fonts

    • Excel File Password

    • Read-Only Names in Name Manager

  • Angular 16 Support

Read Release NotesRead Release Blog

  • PivotTable Enhancements

    • SubTotal Option for Single Fields

    • GetPivotData functions for PivotTable references

    • PivotTable Sorting

  • TableSheet Enhancements

    • Bind DataManager Views to a Worksheet Table

    • Data Source Spread Transformation

    • Spreadsheet Filters

    • Reordering

    • Header Style Rule

  • Calculation Enhancements

    • Auto Formatting for Formula Results

    • RegEx Functions

    • Quick Typing for Cross Worksheet Formulas

  • Shape Enhancements

    • Sparkline Functions

    • Text Box Shape

    • Z-Order Methods and Designer Support

    • Form Control Enabled Property

  • Chart Enhancements

    • Gauge Charts

    • Invert If Negative

  • Workbook Enhancements

    • Input Mask Style

    • Password-protected Worksheets

    • Resizable Filter Window

    • Word Line-Breaking

    • ComboBox AllowFloat

    • Insert Cut Cells for Tables

    • Display Zero

    • Checkbox CellType Line Break

    • Excel Styles Copy Optimization

    • Preserve WordWrap

    • Column/Row Header Layout Enhancement

    • Style Decoration Icons

    • SetRowCount and SetColumnCount Data Protection

  • Framework Support

    • Next.js Support

    • Nuxt Support

    • Angular 15 Support

  • Designer Component Accessibility

  • Designer Enhancements

    • Resizable Conditional Formatting and Named Range Dialogs

    • Font-Size Drop-Down Enhancement

  • New! File Format
  • TableSheet Enhancements
    • Hierarchy in Data Manager
    • Data Manager Field Name Mapping
  • Designer Enhancements
    • TableSheet Template and Panel Enhancements
    • TableSheet Hierarchy Data
    • Selection-Level Find/Replace
    • Format Pane
  • Calculation Enhancements
    • Invalid Formula Input Behavior and Styles
  • Shape Enhancements
    • Excel-Like Form Controls
    • Resizing Enhancement
    • Shift+Mouse Resize Behavior
  • Workbook Enhancements
    • Copy/Cut Cancel Event
    • Cell Decoration Style
    • Custom Styles for Data Validation
    • Cancel Input in EditEnding and EditEnded Events

SpreadJS v15

  • New! Name Box Component

  • Workbook Enhancements

    • Data Object CellType

    • Slicer Update

    • Table Slicer Multi-Select

    • Selection Navigation Enhancement

    • Support Multiple Hover Styles in Different Ranges

    • InvalidOperation Event Locked Cell Enhancements

  • Picture Shape Enhancements

  • Calculation Enhancements

    • Cross-Workbook Formula Source and Target

    • New! Excel Functions

      • Text Manipulation Functions

      • Array Manipulation Functions

    • Relationship Display Formula

  • TableSheet Enhancements

    • Updating Data without a Page Refresh

    • Getting Changed TableSheet Info

    • Load TableSheet Template without Data

    • ComboBox/MultiColumn List for Lookup Column

  • PivotTable EnableDataValueEditing

  • New! Framework Support

  • New! Cross Workbook Formulas
  • PivotTable Enhancements
    • Timeline Slicer Support
    • Show items with no Data
  • TableSheet Enhancements
    • Multiple Header Support
    • Free Header Support
    • Cross Column Support
    • Create PivotTable from TableSheet name
    • Stacked Mode Vertical Enhancement
  • Designer Enhancement
    • CultureInfo Enhancements
    • Filter Auto Extend Support
    • Vue 3 Support
  • Calculcation Enhancement: “.” Object Operator Support
  • Workbook Enhancements
    • Referenced cell content inside Shapes
    • Non-contiguous Range Sparkline
    • Automatically Update Print Ranges when adding/removing rows/columns
    • Show All Sheets Button
    • GetUsedRange Support
    • Drag-Drop Enhancement
    • VeryHidden Worksheet Support Status
    • SetStyle/SetStyleName Cell Range Support

  • New! TableSheet and Data Manager features
  • PivotTable Enhancement:
    • Slicer
    • GETPIVOTDATA Spill Support
    • Calculated Items
    • Date-to-Date Filter
    • ShowHeaders
    • ToJSON Ignore Style
    • Custom Format Field Settings
    • Filter Dialog Searching
  • Workbook Enhancements:
    • Context Menu Scrolling
    • Center Across Selection
    • InvalidOperation Event for DragFill
    • Color Index Format for Cell Formatting
    • Named Style Apply Flags
    • Header/Footer Options for Different Pages
    • Enhanced Outline Date Display in Filter Box
    • Formula Entry With "+" or “-“
    • Row and Column States
  • New! Calculation Engine Functions
    • LAMBDA
    • ASC
    • DBCS
    • JIS
  • Designer Enhancements
    • Printing
    • Text to Columns
    • Remove Duplicates
    • Change Sheet Tab Position
    • Name Manger Dialog Filter
  • Chart Enhancements
    • Data Point Style Customization
  • Angular 13 Support

SpreadJS v14

  • Designer Enhancements
  • Workbook Enhancements
    • Match Excel Keyboard Shortcuts
    • Status Bar FindControl Method
    • Incremental Loading Sheet Names
    • Workbook Constructor Host ID
  • Getting Current Localization Resources
    • Paste Formatting Enhancement
    • Change Sheet Index API
    • Clone Sheet API
    • Chart Enhancements
  • New Framework Support for Vue 3 and Angular 12

  • Pivot Tables
  • Camera Shape
  • Chart Enhancements
  • Calculation Enhancements
  • Shape Enhancements
  • Workbook Enhancements
  • Introducing the new TableSheet BETA

  • New! v14 Designer
  • Cell Interactions
  • Incremental Loading
  • Accessibility Support
  • Multi-Column Picker
  • Comment Indicator Customization
  • HTML Export
  • getRange API enhancement
  • Copy Images from Excel
  • NumbersFitMode
  • SelectionMode with AutoMerge
  • Table Expand Rows API
  • Pixel Scrolling with Scrollbar
  • Fill Effects and Patterns
  • Calculation Enhancements
  • New! Charts and Enhancements

SpreadJS v13

  • Chart Series Data Label Customization
  • Preserve Chart Import Flags
  • Sorting with Groups
  • Ignore Hidden Rows when Sorting
  • Shape Allow Rotate
  • Shape ShowHandle
  • View Zoom
  • Scrollbar Customization
  • ClearPendingChanges by Range
  • RangeChanged Event isUndo Property

  • Enhanced Hyperlink Support
  • Format Strings
  • Dirty Cell States
  • Custom Sorting
  • Percentage Formatting Enhancements
  • Ellipsis and Tips for Cells
  • Insert Copied/Cut Cells
  • Multi-Select ComboBox
  • Enable/Disable Table Auto Expand
  • Chart Enhancements
  • Miscellaneous SpreadJS Enhancements

  • Cell buttons and drop-downs
  • Text rotation
  • Pixel scrolling
  • Dynamic Arrays and array functions
  • Formula tracing
  • Auto merging
  • Hyperlinks
  • Format string enhancements
  • Dirty cell states
  • Custom sorting

SpreadJS v12

  • Printing Enhancements
  • Drag-Fill Enhancements
  • Wrap-Text Hyphenation
  • Language Packages
  • Custom Localization
  • Chart Symbol Enhancements
  • 3rd Party Library Support Enhancements

  • Double-Click Auto-Fill
  • Data Validation
  • Number and Date Display Enhancement
  • Clipboard Paste
  • Subtotal Function
  • Data Validation Highlighting Style
  • Clipboard Option Enhancements
  • Blank Table Style
  • Status Bar
  • Angular 7 Support

  • Custom shapes
  • Rich text formatting
  • Barcode sparklines
  • Printing enhancements (new event, print preview lines, print info, background watermark images)
  • Language Packages
  • Custom Localization
  • Latest Angular, Vue, and React support with more options

 

SpreadJS v11

  • React and Vue Support
  • NPM Package Support
  • Customize Range Group Interfaces with CSS
  • Sheet Area Offset

  • Undo/Redo Enhancements
  • Filter Dialog UI Enhancements
  • Protection Options Enhancements
  • Custom IconSet
  • Diagonal Line Borders
  • Vertical Text
  • Double Underline

  • Official chart support
  • Support for 462 functions
  • Undo/redo with custom commands
  • Enhancement for the filter dialog UI
  • Vertical text
  • React and Vue support
  • NPM Package
  • Range group interface customization