The Worlds' #1 Selling Angular Spreadsheet with Over 450 Excel Functions

• JavaScript Workbook Projects
• Create a basic JS workbook
• Basic JavaScript spreadsheet
• Create an Excel-like tab strip to navigate between worksheets
• Select Multiple Sheets
• Add or hide a horizontal or vertical scrollbar
• Set maximum and minimum on scrollbars
• Customize the background of the spreadsheet
• Repaint a spreadsheet after editing
• Apply events to a workbook
• JSON serialization
• Data source serialization
• Custom item serialization
• Pixel Scrolling
• Split Resize

• Excel-Like Worksheet Functions for JavaScript
• Create a basic JS worksheet
• Add borders and gridlines to worksheets
• Hide or show worksheets
• Zoom into worksheets
• Add headers to JS worksheets
• Add and delete rows and columns
• Dynamic Size
• Freeze rows and columns
• Copy or move data between cells
• Set a formula in code
• Excel-like precision selection
• Use familiar keyboard actions like arrows, delete, and enter
• Configure actions like allowing drag/drop
• Create custom actions for cells
• Protect cells from being edited
• Paint a new sheet
• Set events when user clicks a cell

• Cells
• Allow cell overflow
• Edit cell alignment
• Edit cell padding
• Edit font, font size, font weight, and font style
• Edit fore color and background color
• Edit word wrap in a cell
• Indent a cell
• ShrinkToFit in a cell
• Apply styles to cells and worksheets
• Text Orientation
• Merge cells
• Add labels to cells
• Select single cells or select ranges of cells
• Cell Buttons
• Cell Drop-Down List
• Cell Drop-Down TimePicker
• Cell Drop-Down MonthPicker
• Cell Drop-Down Date Time Picker
• Cell Drop-Down Slider
• Cell Drop-Down Calculator
• Cell Drop-Down ColorPicker
• Cell Drop-Down Workflow List

• Spreadsheet Calculations Using JavaScript
• 450+ built-in functions
• Create Excel-like indirect functions
• Aggregate Function
• Use wildcards in functions
• Evaluate asynchronous values in functions
• Create custom functions in JavaScript
• Basic JS array formulas
• Advanced JS array formulas
• Language Packages
• Dynamic Arrays
• FILTER Function
• RANDARRAY Function
• SEQUENCE Function
• SORT Function
• SORTBY Function
• UNIQUE Function
• "@" Operator

• JS Spreadsheet Data Binding
• Bind an entire sheet to a data source using JavaScript
• Bind a single cell to a data source
• Bind a table to a data source

• Editing Spreadsheet data in JS
• Navigate using keyboard like arrows and TAB
• Identify cells or values that have changed
• Excel-like copy and paste
• Paste an extended range of values
• Enhance copying and pasting
• Store numeric values as a string

• Performance
• Performance Benchmark

• Automerge
• Column Auto Merge
• Range Auto Merge
• Header Auto Merge

• JavaScript Spreadsheet Formatter
• Set or clear basic cell formatting
• Create custom formatting
• Apply accounting formatting
• Format String
• Rich text formatting

• Cell Type
• Configure basic cell types
• Add a button
• Add and configure a check box
• Add a combo box or drop down list
• Add a hyperlink to a cell
• Radio List
• Checkbox List
• Button List
• Create a custom cell type
• Add an image as a cell type
• Edit the cell type of a column or row header
• Range Template

• Cell States
• Introduction
• Cell State Priority

• JavaScript Chart Types
• Add a basic JavaScript chart
• Customize Axis
• Customize Legend
• Customize Chart Area
• Hovering
• Trendline
• Error bars
• JS Column Chart
• JS Line Chart
• JS Pie Chart
• JS Area Chart
• JS Bar Chart
• JS Radar Chart
• XYScatter Chart
• JS Stock Chart
• JS Sunburst Chart
• JS Combo Chart
• JS TreeMap Chart

• Tables in JavaScript
• Add an Excel-like table
• Create a custom JavaScript table
• Table Operator
• Binding Enhancement
• Table Auto Expand
• Table Context Menu
• Table Fixed Scrolling Headers
• Table Resize Handler
• Table Conditional Formatting and Data Validation
• Table Selection
• Table Tab Navigation
• Table Total Row
• Apply styles to JS tables

• Hyperlinks
• Add hyperlinks
• Hyperlink to sheet cells
• Email address hyperlinks
• Standard URL hyperlinks
• Custom Hyperlinks
• HYPERLINK Formula

• Conditional Format
• Apply conditional formatting
• Create conditional rules

• Data Validation
• Apply basic data validation
• Create a custom data validator

• Fill
• Basic drag-fill
• Custom drag-fill a range

• Context Menu
• Add a context menu
• Customize a context menu
• Add elements to a context menu

• Culture
• Localization
• Custom Location
• Globalization

• Filter
• Basic filtering
• Add a filter button
• Add an action to a filter
• Create a custom filter

• Outline
• Group content into outlines
• Customize outlines
• Outline Appearance
• Create an outline to show hierarchical data in a tree view

• Comments
• Add comments to JavaScript spreadsheet
• Edit settings for comments
• Apply actions to comments
• Apply events to comments

• Custom and Built-in Shapes
• Custom shapes and interactions
• Group shapes
• Shapes with formulas
• Basic Excel shapes
• Action shapes
• Badge and star shapes
• Braces
• Connector shapes
• Cloud and balloon shapes
• Flowchart shapes
• Gear shapes
• Math shapes
• Rounded shapes
• Scroll shapes
• Symbol shapes
• 3D shapes

• JavaScript Sparklines
• Basic Sparklines
• Custom Sparklines
• Settings Sparkline
• Cascade Sparkline
• BoxPlot Sparkline
• Bullet Sparkline
• Barcode Sparkline
• HBar and VBar Sparkline
• Pareto Sparkline
• Pie Sparkline
• Area Sparkline
• Scatter Sparkline
• Spread Sparkline
• Stacked Sparkline
• Vari Sparkline
• Compatible Sparkline
• Custom Sparkline
• Month Sparkline
• Year Sparkline

• Search
• Search

• Floating Objects
• Create a floating object
• Customize a floating object
• Edit a picture
• Place a floating object at a fixed position
• Apply actions to a floating object
• Apply an event to a floating object

• Custom Names
• Define a name for a cell range, function, constant, or table

• Slicer
• Add a slicer
• Configure settings for a slicer
• Attach multiple slicers to multiple columns
• Create a slicer for a table
• Create a slicer for an item
• Create a slicer for a chart
• Create a tree slicer for hierarchical data
• Create a data aggregation slicer
• Customize the UI of a slicer with DOM elements

• Formula Text Box with JavaScript
• Formula text box
• Create a function and add a description to it
• Select a range of values and apply a function to it

• Tags
• Store data in tags
• Apply actions to tags
• Search tag strings

• Import and export Excel in JavaScript
• Excel I/O
• Import and export Excel files in JS

• JavaScript PDF Export
• Export to PDF using JavaScript
• Edit settings for JS PDF export
• Register custom fonts for PDF export

• Printing
• Printing
• Customize print settings for ranges of cells, footers, headers, etc.

• Touch
• Basic touch interactions
• Touch Toolstrip

• Theme
• Theme your document
• Apply an external theme
• Apply Spread themes