We have updated our Infragistics ASPNET controls to version SR 8.3.20083.2122. Our previous version was 8.3.20083.1009. I found out that the worksheet name validation has been changed a bit. Now it requires that the worksheet name has to be between 1 and 31 characters long. I didn't find any mention in the documents about this change? Has this been changed for the last SR?
Error message:The worksheet name must be between 1 and 31 characters in length.
This was changed for a bug fix: issue 11149. A workbook was being exported with worksheets which contained names longer than 31 characters. Since Microsoft Excel doesn't allow worksheet names longer than 31 character, they were getting truncated. However, in this particular case, the workbook already had another worksheet which had a name matching the truncated name of one of these other worksheets. This caused errors when the file was opened. Since Microsoft Excel doesn't allow more than 31 characters in the name anyway, we decided to throw an exception if a name was set with more than 31 characters.
This is not an issue since it's easy to limit the worksheet name but I get the exception when adding a worksheet with a long name to a workbook like this:
Workbook wb = new Workbook();Worksheet ws = wb.Worksheets.Add("reallylongworksheetnamewillgivemeaniceexception");
I was just wondering this because long worksheet names had been working before and it seems to me that the limit was a new "feature".
There has been a default character length constraint on the DownloadName and WorksheetName properties since their initial threat modeling, in 2003. Where is it that you are seeing this message?