We found a small gap in Telerik's code, while defining name of Excel Sheet tab name (through Telerik Spreadsheet) --> using:
IWorksheetExporter CreateWorksheetExporter(string name);
of:
Telerik.Documents.SpreadsheetStreaming.IWorkbookExporter
When defining name of Excel sheet longer than 31 characters, Telerik code throws ArgumentException "Sheet name should be limited to 31 characters."
This is fine and correct - Excel sheet tab could be set UP TO 31 characters.
When using "shorter" name - like 30 characters, it works.
But when using exactly 31 characters, same Exception is thrown, which shouldn't be the case, as:
- Excel allows UP TO 31 charaters
- also you Exception message is clear that name should be limited TO 31 characters ;)
Best Regards,
Namyslaw Szymaniuk