SpreadJS includes a comprehensive Calculation Engine that supports 450+ built-in functions, custom functions, arrays, dynamic arrays, formula textbox, localized languages function names, and more—helping to create any financial formula.
SpreadJS provides support for 11 chart groups, 30+ chart types, trendlines, and combo charts. Set chart layouts, customize elements, and combine chart types to evaluate financial information, perform stock analysis, present sales revenues, and much more.
Take full control over your spreadsheet's design with the SpreadJS Designer. Create workbooks from scratch or import your own Excel .xlsx files. Edit in an Excel-like WYSIWYG interface to help you create financial apps in no time.
Tables make it easier to manage and analyze related spreadsheet data. SpreadJS supports AutoExpand, conditional formatting, data validation, context menus, fixed headers, table resizing, navigation, a total summary row, and more.
Complete support for importing and exporting your Excel files. Load your most complex Excel (.xlsx) files, make changes, and export back to an Excel file or save to a database.
Sparklines provide a graphical representation of your data embed. These small sparkline charts enable any cell to quickly show trends in your data, such as increases and decreases, minimum and maximum values, stock levels, costs, and more.
Use the built-in Excel-like filter dialog to allow users to automatically filter data. Take advantage of creating custom filters to show and hide relevant data based on your application's needs.
SpreadJS includes various cell types that you can apply to any cell. Define the type of information that can be entered and displayed in any cell or use predefined dropdowns to make it easier for users to select and enter valid data.
Use conditional formatting to highlight important information automatically or spot trends in your data using specific values. SpreadJS supports the importing and exporting of many of Excels' rules.
Similar to filters, Excel-like slicers offer an intuitive, visual way to filter spreadsheet data. Available slicers include table, item, chart, aggregation, and custom slicers such as those used on consumer websites.
Dynamic array support is used to replace the array formula. Formulas with the potential to return multiple results refer to a dynamic array formula. Formulas returning numerous results are referred to as spilled array formulas. Use these to seamlessly build financial models within your spreadsheets.
SpreadJS provides extensive support for formula auditing. This allows users to display relationships between formulas and cells by tracing the precedent and dependent cells in the worksheet.