Features | SpreadJS 15

Features

In This Topic

SpreadJS provides support for almost all the major features available in Excel. Refer to the following list of topics while working with SpreadJS.

Topic	Content
Workbook	Describes the basic operations of a workbook. Select Multiple Worksheets Search Data Clipboard Operations Set Widget Border Scrollbar Status Bar Tab Strip Hit Test
Worksheet	Describes the basic operations of a worksheet. Work with Worksheets Protect Worksheet and Lock Cells Sheet Area Offset Background Image Undo and Redo Context Menu Editor Status Tooltips Zoom
Rows and Columns	Describes the basic operations on rows and columns. Work with Rows and Columns Resize Columns and Rows Freeze Columns and Rows Create Multiple Headers Split Resize Columns and Rows Dynamic Column Size Filter Rows
Headers	Describes the basic operations on headers.
Cells	Describes the basic operations on cells. Work with Cells Cell Types Cell Format Cell States Cell Range Get Dirty Status Cell Buttons Cell Dropdowns Cell Comments Hyperlink Auto Merge Cells AutoFit Auto Fill Data Shrink to Fit Cell Overflow Ellipsis or Tips for Cell Overflow Cell Alignment and Indentation Cell Padding and Label Styles Cell Span Cell Tags Styles Cell Colors Borders, Gridlines and Diagonal Lines Quote Prefix Insert Cut or Copied Cells Rotate Text In Cells Vertical Text Direction Text Decoration Rich Text Wrap Text Drag and Drop Drag and Merge Edit Mode Always Watermark IME Mode Pattern Fill and Gradient Fill Paste Options
Data Binding	Describes how to bind data in SpreadJS. Bind Cells SpreadJS Designer Template with Cell Binding
TableSheet	Describes how to use tablesheets. Data Manager TableSheet Components Create TableSheet TableSheet Views Data Operations TableSheet Relationships TableSheet Operations Rules Appearance Calculations Interactive Behavior TableSheet IO
JSON Schema with SpreadJS	Describes how to use JSON schema with SpreadJS. SpreadJS Spread Schema
Data Validation	Describes how to validate or restrict invalid input of data.
Conditional Formatting	Describes how to apply various types of conditional formatting rules. Average Rule Cell Value Rule Data Bar Rule Date Occurring Rule Duplicate Rule Formula Rule Icon Set Rule Scale Rule Specific Text Rule Top 10 Rule Unique Rule
Sort	Describes various sorting operations. Sort Data Custom Sorting Sort with Grouped Data
Group	Describes various grouping operations. Range Groups Customize Range Groups Outline Columns
Formulas	Describes various types of formulas in SpreadJS. Built-In Formulas Allow Users to Enter Formulas Set Formulas Show Cell Formulas Create Custom Names Create Custom Formulas Formula Text Box Use Formula Text Box as a Control Formula Auditing Array Formulas Dynamic Array Formulas Asynchronous Functions Language Package
Serialization	Describes how to implement serialization.
Keyboard Actions	Describes different types of keyboard actions. Input Mapping Keyboard Navigation Shortcuts Precision Selection
Shapes	Describes different types of shapes. Built-In Shapes Connector Shapes Group Shapes Shape Property Formulas Custom Shapes
Floating Objects	Describes floating objects and their customization. Custom Floating Objects Floating Pictures
Barcodes	Describes different types of barcodes. QRCode EAN-13 EAN-8 Codabar Code39 Code93 Code128 GS1_128 Code49 PDF417 DataMatrix
Charts	Describes different types of charts and their elements. Chart Elements Chart Types Add Trendlines To Charts Add Error Bars In Charts Animation in Charts Add Hover Animation and Style Chart Color with Transparency Display Empty Cells in Chart Display #N/A Cells in Chart Hidden Rows or Columns in Chart Preserve Unsupported Charts Pattern Fill in Charts
Sparklines	Describes different types of sparklines. Column, Line, and Winloss Sparklines with Methods Markers and Points Horizontal and Vertical Axes Column, Line, and Winloss Sparklines with Formulas Area Sparkline Pie Sparkline Scatter Sparkline Bullet Sparkline Spread Sparkline Stacked Sparkline Hbar Sparkline Vbar Sparkline Box Plot Sparkline Vari Sparkline Cascade Sparkline Pareto Sparkline Month Sparkline Year Sparkline Custom Sparkline Rangeblock Sparkline
Tables	Describes how to use tables. Create Tables Set Table Styles Bind Tables Resize Tables Auto Expand Tables Structured Reference Formulas
Pivot Table	Describes how to use pivot tables. Pivot Table Components Create Pivot Table Filter Sort Group and Collapse Refresh Data Source Pivot Table Layout Themes and Style Context Menu Pivot Table Settings Pivot View Manager Pivot Table Print
Slicer	Describes how to use slicers. Custom Slicer Item Slicer Table Slicer Table Slicer Styles Table Slicer with the SpreadJS Designer
Print	Describes how to to print a single worksheet or print multiple worksheets with headers, borders, gridlines etc. Print Sheets Configure Page Breaks Display Preview Lines Get Page Information Print Background Image As Watermark
Theme	Describes different themes in SpreadJS. Configure Themes Custom Themes from ThemeRoller Default SpreadJS Theme Excel Theme Bootstrap Theme
Culture	Describes different cultures in SpreadJS. Create Custom Culture

Product Support Forum | Print this page