Skip to main content Skip to footer

SpreadJS Releases

SpreadJS v18

SpreadJS v18.1 (service pack 1) is available! This release offers several great new enhancements and features to its JavaScript spreadsheet component and optional add-ons including:

SpreadJS v17

Releases Page | Read Release Notes | Read Release Blog

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

  • Formula Performance Enhancements
  • Right-to-Left Text Direction
  • Chart Data Label “Value Of Cell”
  • Custom Table Styles Enhancement
  • Angular 17 & Next 14 Framework Support
  • Custom Slicer Styles Enhancement
  • Protected Sheets Hidden Option
  • Conditional Formatting Rules Manager Performance Enhancement 
  • And Much More!

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