Hello!
I've been having problems attempting to reach values from my RadSpreadsheet component, which have been entered directly into the spreadsheet.
Retrieving cell values works fine when using a SpreadsheetDocumentProvider or a custom provider, which populates the RadSpreadsheet with sheets, rows and cell values. But only the initially populated cells have accessable values - if any new values were to be added, they would show up as NULL when I would try to reach them.
In the image I attempt to get a cell value (and save a referenced workbook) in a button click event.
Telerik UI for ASP.NET AJAX 2020.2.617
1 Answer, 1 is accepted
Hello Tautvydas,
The data is saved via a callback that calls the SaveWorkbook of the provider. The Sheets property is not populated unless the .DataBind() method is called.
Also, you might find useful the following articles:
- https://www.telerik.com/support/kb/aspnet-ajax/spreadsheet/details/access-the-spreadsheet-workbook-on-the-server
- https://docs.telerik.com/devtools/aspnet-ajax/knowledge-base/spreadsheet-load-via-json-and-save-with-postback
- https://www.telerik.com/support/kb/aspnet-ajax/details/understanding-telerik-ajax-and-document-processing-library-spreadsheet-workbook-and-worksheets
Regards,
Peter Milchev
Progress Telerik