In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.
However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.
Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍
With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10. With the Spreadsheet control the same example yields (10). How can we get the same behavior as Excel with the Spreadsheet control?