Add built-in support for importing and preserving native Excel tables in the Spreadsheet component.
When an XLSX file contains a table created through Excel’s Insert > Table feature, the Spreadsheet should parse and retain the table definition, including its metadata, style, structured references, automatic expansion, and filter buttons.
When the workbook is exported, the corresponding native Excel table parts should be written back to the XLSX file so the table remains a functional Excel Table.
Provide built-in border tools for customizing the appearance of the cell borders. A similar feature is already available in the Kendo jQuery Spreadsheet:
The status bar is used to represent a summary of the aggregated values of the selected cell.
It would be convenient each formula to have a description underneath. In this case, the user can choose the most suitable one for a certain case, without the need to know all formulas in advance.
It would be great if you would allow loading single sheets instead of all the sheets every time. I receive data per sheet from my server.
Also the Spreadsheet fails to trigger events for:
- row added
- row deleted
- column width changed
- row height changed
- cell style changed
- format changed
- cells merged