Hello,
in my spreadsheet I load the data via a function. I have encountered a problem with extremely long strings (100 000 chars).
When I assign this text into a CellValue, the text is OK (DevExpress.Spreadsheet.CellValue.FromObject(text) ). But when the CellValue is assigned to the cell, the CellValue of the given cell is null.
Thanks for any help.
Hello Petr,
According to Excel specifications, the total number of characters that a cell can contain is limited by 32,767 characters. If a cell contains a greater number of characters, the obtained file will be invalid and incorrectly processed by MS Excel. I guess, it would be better to check this condition in the SpreadsheetControl API as well. So, I've passed this ticket to my team. Our developers will research this issue in detail. We will get back to you once we have any results.
OK, I understand that the size is limited. But Excel displays approximately the first 300 characters. Do you plan to add this functionality into your component or do I have to handle it myself?
Thanks.
Our developers are considering ways of resolving this issue now. We will likely provide optional behavior: a SpreadsheetControl will raise an exception if a cell value exceeds the characters limit or cut the string to an appropriate value.
Since a cell value is changed in code, it would be better to manage this situation in client code and provide custom logic to resolve this case according to your requirements.