Unplanned
Last Updated: 13 Dec 2021 11:28 by ADMIN
Namysław
Created on: 06 Dec 2021 13:07
Category: Telerik Document Processing
Type: Bug Report
0
Spreadsheet Streaming allows up to 30 (instead od 31) characters of Excel Sheet tab name

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

1 comment
ADMIN
Dimitar
Posted on: 13 Dec 2021 11:28

Hello Namysław,

You are right, I was able to reproduce this issue. I have logged it on our feedback portal. You can track its progress, subscribe to status changes, and add your comment to it here. I have updated your Telerik points as well.

Unfoirtunelly I cannot suggest a workaround. We will do our best to fix this in the next internal build. 

Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.