Template Wizard does create SheetNames with more than 30 characters

  • Article

The Template Wizard (Administration/Periodic/Data export/import/Excel spreadsheets/Template Wizard) creates unfortunately SheetNames that might exceed 30 characters, which is not allowed by Excel and results in annoying message boxes that are requesting a new SheetName with less than 31 characters.

The following code change in the method SysDataExcelDef/buildTmpExcelWorksheet will resolve this problem:

    1:          //modifications done for working with long tablenames

    2:          //    str tempSheetName;

    3:          //    str suffixName;

    4:          //    int suffixlength;

    5:          //original code:

    6:          //tmpExcelWorksheet.SheetName = tmpExcelWorksheet.TableName + '_' + int2str(sysExpImpTable.OccurrenceId) + '-1';

    7:          

    8:          tempSheetName = tmpExcelWorksheet.TableName + '_' + int2str(sysExpImpTable.OccurrenceId) + '-1';

    9:   

   10:          if (strlen(tempSheetName) > 30)

   11:          {

   12:              tempSheetName = tmpExcelWorksheet.TableName;

   13:              suffixName =  '_' + int2str(sysExpImpTable.OccurrenceId) + '-1'; //as this is done in the original code

   14:              suffixLength = strlen(suffixName);

   15:              tempSheetName = substr(tempSheetName, 0, 30 - suffixLength);

   16:              //assigning the new name

   17:              tmpExcelWorksheet.SheetName = tempSheetName + suffixName;

   18:          }

   19:          else

   20:          {

   21:              tmpExcelWorksheet.SheetName = tempSheetName;

   22:          }