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:          }