Provide an event or callback that notifies when the imported Excel file is complete and available in the Spreadsheet. A similar event from the Kendo jQuery widget is render:
https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/events/render
The main advantage of this event/callback will provide the ability to see the data in advance and customize the cells if needed or adjust any other parts of the workbook.
Currently, to achieve the same, a setTimeout needs to be used:
public onExcelImport(ev: SpreadsheetExcelImportEvent) {
setTimeout(() => {
const desc = ev.sender.toJSON();
}, 1000);
}
Setting the rows and columns properties of the Spreadsheet, limits the available cells like:
The same view should be exported to Excel (with hidden rows and columns).
Currently, the exported Excel file generates the rest of the columns and rows and the file looks as by default.
https://stackblitz.com/edit/angular-kns7rm
Hi Team,
I would like to request the toolbar data validation tool like this Kendo UI for jQuery demo to be included in the new Angular component.
Thank you!
Hi,
We are requesting a feature for adding custom options in the Context Menu of the Spreadsheet, just like in jQuery:
https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/methods/cellcontextmenu
Hi, Team!
I would like to request the support of macros in the Kendo UI for Angular Spreadsheet component.
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.
Provide a more descriptive and structured way to present the built-in formulas. The formulas can also be grouped by type and visualized as a list.
Provide built-in border tools for customizing the appearance of the cell borders. A similar feature is already available in the Kendo jQuery Spreadsheet:
Provide the ability to customize the cells' content of the Spreadsheet. SImilar to the custom cell editors of the Kendo jQuery Spreadsheet:
https://demos.telerik.com/kendo-ui/spreadsheet/custom-editors
Allow creating custom toolbar tools in Spreadsheet.
Please provide a built-in option to export the Spreadsheet data into a PDF file.
Allow the developer to customize the built-in Toolbar actions in Spreadsheet. Provide the ability to reorder or show only part of them:
Provide a readonly property to prevent the user from interacting with the data inside.
Consider allowing the user to download the sheet.