400+ Formulas & Functions

Excel compatible functions are built-in
Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds.
From basic mathematical functions to complex formulas with statistical and financial functions, Online Spreadsheet includes everything you need to incorporate Excel-inspired data analysis functionality in web app.

Mail Merge

Auto-generate multiple documents at once
Automatically create multiple documents based on a single template and include unique data from a data source. Supported mail merge functions (placeholders):

Pivot Tables, Charts, Sparklines

Summarize and visualize large amounts of data
Supports Excel-like pivot table, shapes, sparklines (Line, Column, Win/Loss), and a wide range of 2D/3D charts:

• Column and Bar Charts
• Pie and Doughnut Charts
• Area and Line Charts
• Scatter, Radar, and Bubble Charts
• Box and Whisker Charts
• Histogram and Pareto Charts
• Treemap and Sunburst Charts
• Waterfall and Funnel Charts
• Stock Charts

Data Editing & Validation

Keep your data clear and accurate.
Online Spreadsheet gives you the total control over cell editing. Excel-inspired Data Validation engine helps reduce data entry errors, improve accuracy and data consistency when modifying worksheet cells. It has the capability to check validation live, when you entered data, this will check the validation for the current change in sheet
Just like Microsoft Excel, Online Spreadsheet includes an AutoFilter - designed to filter data against column values and to display only those rows that meet specific criteria.
Online Spreadsheet supports sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, date and time.

Document Security

Protect your work, prevent unauthorized access
You can password-protect your Excel worksheets/workbooks and prevent unauthorized access. Security options include:

• Restrict Document Modification
• Encrypt a Document with a Password
• Specify a Password to Open or Edit a Document
• Grant User Permissions

Export & Printing

It has ability to export Workbook to Html and Pdf, and Printing capability gives end users to take print of the current worksheet.

Control on Folder & File Permissions

It has the ability to control File and Folder access based on Roles, and users

Programmability & API

Online Spreadsheet provides full customization capabilities using server-side .NET and client-side code using JavaScript

Other Features

• Live Data validation
• Check data validation on Save
• Save document to temporary folder for later working
• Searchable Dropdown for List Data Validation
• Calendar control for Date/Time Validation
• Email Notification on Submission
• Users Management Module
• External Authentication Integration with Azure AD
• Invalid Data Highlighting and Commenting empty required fields
• Required Fields validation (Data Validation Ignore blank)
• Auto fetch & filling cells from another sheet/data source
• Disabled Invalid cell Copy operation
• Disabled cell dragging operation for protected sheet
• Disabled Cell formatting override for protection
• Document Submission and Approval Process
• On Approval/In Progress make the document ReadOnly for end users
• Document Store Integration with SharePoint Online OneDrive
• Online Users Tracking Module
• Administrative View for Document Management
• Clients View for Documents Management
• Role Base Access Control