In this article, we will take a detailed look at one of the complex widgets included in the Webix library, which is Spreadsheet.
Complex Webix widgets are full-featured single-page applications with complex logic, but extremely simple integration and customization mechanism.
Spreadsheet is one of the most complex and functional widgets. It allows users to work with data tables in Excel style:
· process table data (sorting, search, filtering, matching, formatting)
· perform calculations
· build graphs
· import / export data
The full list of functions and features will be reviewed later.
Webix Spreadsheet purpose
The main difference between this product and solutions such as Office 365 or Google Docs is the ability to integrate the functionality of Spreadsheet into any web application. This allows you to get a native opportunity to work with data and perform calculations directly on the screens of any business applications. In other words, Webix Spreadsheet is not only an independent application but also a whole platform for creating any Excel-style applications.
The second distinctive feature is the unlimited customization possibilities. Developers can upgrade both the application interface and the functionality itself by developing their computing capabilities and tools based on Webix Spreadsheet.
So, this Spreadsheet is a smart and functional Datatable with the ability to perform calculations, work with graphs, images, and other native Excel features and the ability to integrate these features with the business functionality of any web application.
Webix Spreadsheet allows you to insert images:
· in a separate cell
· in the merged area
· floating image
Search and filters
Webix developers offer a ready-made search with cells highlighting sample. In this method, the data is not filtered but highlighted with a background color.
Custom search filter allows you to filter data, leaving only those lines on the screen that meet the search criteria.
And of course, Spreadsheet offers traditional Filters, but with the ability of setting and customization the search form.
Popups and dialogs
Developers can use all the Webix opportunities to improve and customize the functionality of Spreadsheet.
For example, user-friendly Dialogs help and simplify data entry and validation.
You can use DataTables inside the dialogs themselves.
The form of dialog implementation can be very different, for example, Popup with Form.
Another manifestation of the flexibility of the Webix platform is the ability to create any Custom Views. For example, floating data table.
We have listed only some hidden features of the Webix Spreadsheet application. This solution has unlimited possibilities for customization and creation of computing processors or costume spreadsheet applications.
If you are interested in this solution, you can read more about it in these materials: