I have a similar problem, but it is not only forbidden to insert rows and columns, but also to modify fonts and colors (including table background colors). The table I want to export can only edit data.
The table to be exported cannot perform any operations other than editing data. For example, it is forbidden to insert rows and columns, delete rows and columns, modify row height and column width, modify font format and color, size, and background color. Let the exported table only use the format attributes I set to edit the data.
Petar
Telerik team
commented on 09 Nov 2021, 02:07 PM
Hi Xingyu,
Thank you for the additional details.
The Spreadsheet component doesn't support the functionality of restricting the listed by you operations in the exported Excel file. We can control the file editing while it is loaded in the Spreadsheet but when a document is exported, the actions inside it can't be restricted.
Hi Xingyu,
Thank you for the additional details.
The Spreadsheet component doesn't support the functionality of restricting the listed by you operations in the exported Excel file. We can control the file editing while it is loaded in the Spreadsheet but when a document is exported, the actions inside it can't be restricted.