JavaScript Spreadsheet Optional Add-Ons
Transform Your JavaScript Development and User Experience
Empower your user and development projects with SpreadJS' versatile optional add-on components - PivotTable, ReportSheet, and GanttSheet. Dive into data-driven insights using PivotTable, a robust tool for quick organization and analysis, enhancing business intelligence with customizable features. Design detailed reports effortlessly with ReportSheet, offering data entry, filtering, sorting, and styling options, all within the familiar SpreadJS environment. Elevate project and resource management with GanttSheet, seamlessly integrating Gantt chart capabilities into your spreadsheets. Developers gain unparalleled flexibility, while users benefit from intuitive interfaces, customizable reports, and streamlined project workflows, ultimately enhancing productivity and decision-making processes. Additionally, enhance your users spreadsheet design experience further with our Designer Ribbon Component Add-on.
JavaScript Pivot Table Component
A JavaScript Pivot Table is a powerful data summarizing and reporting tool that allows you to organize, extract and analyze large amounts of data quickly. Improve your business intelligence by visualizing complex data, discover trends, and uncover data information that otherwise may be very difficult to answer by looking at the data itself.
SpreadJS provides an optional JavaScript PivotTable add-on to allow your users to analyze data in their JavaScript spreadsheets quickly. Work with the field and panel features to generate fast, easy-to-read reports in seconds. SpreadJS PivotTables utilize a familiar UI that users recognize, allowing you to organize and summarize data using the built-in aggregations, pivot table field lists, and calculated fields. Fully customize your application's needs and let SpreadJS PivotTables perform the complex interactive analysis for your applications.
Full PivotTable Layout Customization
Supports many different options to customize the appearance and functionality of the JavaScript PivotTable per your application's needs, including control filters, rows, columns, headers, themes, Pivot Panels, and more.
Report Layout Options
Choose from three PivotTable report layouts to change how data is displayed in the PivotTable: Compact Form, Outline Form and Tabular Form.
PivotTable Panel
Utilize the JavaScript PivotTable Panel to choose from various fields from a data source and sort/filter them as needed.
Pivot View Manager
Create, manage, and save different views for the PivotTable with the View Manager, allows users to quickly access any saved view of the pivot table at a certain point in time.
Pivot Slicers
SpreadJS's PivotTable supports slicers, which are a convenient graphical interface for the label filter. PivotTable supports the following slicers types: Pivot Table Item slicer, Pivot Table Timeline slicer
Pivot Conditional Rules
Apply, get, and remove conditional formatting rules within the PivotTable area. The conditional rules work as expected irrespective of the changes to PivotTable layout.
JavaScript Gantt Chart Sheet Component
Provide JavaScript Gantt Chart behavior in a spreadsheet user interface. This includes standard JavaScript Gantt functionality, including Timescales, Taskbars, Tasks, and Calendar capabilities just to name a few. With this being implemented within SpreadJS, GanttSheets can be added just like a normal worksheet, and as such supports standard spreadsheet functionality like sorting and Import/Export.
You can use GanttSheet for things like:
- Project Scheduling/Management
- Staff/Resource Scheduling
- Warehouse Shipment Scheduling
- Flight Lists
- Production Schedules
Binds Data to the GanttSheet
Use the existing DataManager from TableSheet to create tables that can be easily connected to a GanttSheet. The Data Manager is a powerful local data engine that sends requests to the server side, then binds the data to the GanttSheet when the data is ready.
Import and Export GanttSheet Capabilities
Supports importing SSJSON and SJS files and exporting the data to various formats, including SSJSON, SJS, and Excel (.xlsx).This facilitates interoperability with different systems, supporting the diverse tools often found in enterprise environments.
Timescales in Gantt Chart
The timescale is the column header of the gantt chart in a GanttSheet, it allows you to show smaller or greater time units. The GanttSheet chart area can be zoomed in or out, and scrolled to show more or less of the chart.
JavaScript ReportSheet Component
A new sheet type that allows your users to easily design reports, including support for data entry, pagination, data filtering, sorting, and conditional formatting. The ReportSheet add-on has two parts: ReportSheet and TemplateSheet, with the later containing various report-related settings. The data for the sheet is also connected to the DataManager implementation, and the ReportSheet has data entry APIs to interact with it. You can design reports directly in the SpreadJS Designer with full control over the report UI, which you can then export and load into a SpreadJS instance in your application.
ReportSheet Template Cell Types
Template cell type is the most important option of the template cell. this option can control how to organize data. If you want to make row based report you can use the ‘List' cell type, or if you want to make a sales summary report, you need to use the ‘Group’ and 'Summary’ cell type.
Data Entry
ReportSheet supports data entry through the DataManager. You need to configure the remote info of the table in the DataManager. You also need to configure the cell that is written back to a column of a table in the data entry setting of the template sheet.
Set Pagination in Reports
Pagination feature are available in the ReportSheet add-on. Allowing customization of pagination settings in the TemplateSheet to meet diverse report layout requirements.
Group, Filter, and Sort Data
Group, Filter, and Sort data, in addition to adding calculated columns and dynamic parameters to regenerate data instead of using static values.
Support for Formula Functions
ReportSheet uses Context when evaluating formula cells. If a formula cell has a specific context in preview mode, the formula calculation will use that context. This indicates that the same formula can produce different results depending on the context. Utilizes the full SpreadJS calculation engine.
Import, Export and Printing Capabilities
Print, Import and Export the SpreadJS ReportSheet to JSON, SJS, and Excel.
What's New in SpreadJS v17.1
SpreadJS v17 SP1 is available! This release offers several great new enhancements and features including:
- Formula Performance Enhancements
- Right-to-Left Text Direction
- Chart Data Label “Value Of Cell”
- Custom Table Styles Enhancement
- Angular 17 & Next 14 Framework Support
- Custom Slicer Styles Enhancement
- Protected Sheets Hidden Option for Formulas
- Conditional Formatting Rules Manager Performance Enhancement
- And Much More!
SpreadJS Media and Content
Award-Winning Products and First-Class Support
"I have been using a various form of Spread back to the COM days. Spread is the most reliable spreadsheet that retrieves and stores data, whether interacting with a database or simply an Excel file. Try it out, and you will not go back to any other control"
TRUSTED CUSTOMER
"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"
TRUSTED CUSTOMER
"Excellent Products. I have been using their products for around 15 years. Always there to help."
TRUSTED CUSTOMER
 |
 |
MESCIUS Spread is Trusted by the World's Leading Companies
