SpreadJS Releases

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

• NEW! DataCharts Add-On
• Workbook Enhancements
  • Right-to-Left Document Mode and Text Direction
  • Bind Tables to a Data Manager Table
  • Horizontal Scrolling with Shift+Mouse Wheel
  • Search Cell Comments
  • ComboBox CellType Data Source Binding Support
  • New Aggregation Functions (GROUPBY, PIVOTBY, and PERCENTOF)
• PivotTable Add-On
  • Support to Change Data Source
  • Show Subtotal in Single Field
  • Filter Dialog Keyboard Operations Support
• ReportSheet Add-On
  • Chart Support - With NEW DataCharts Add-On
  • Expand/Collapse All cells and dependent cells
• Preview! Collaboration Add-On
• Support for Angular v18
• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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