validation failure caused by the Excel sheet name limit

[zhouji2013]

The current validation process checks whether the template name (as entered in the spreadsheet) matches the sheet name. In fact, Excel sheet's name is limited to 31 characters while the template names are allowed to be longer. To avoid false alarm, the current checking needs to be loosened to accommodate the case when the sheet name is a truncated template name.

[vdancik]

Would not it be better to enforce 31-character limit for submission name on data entry?

[zhouji2013]

Would not it be better to enforce 31-character limit for submission name on data entry?

I believe that there are many existing submission names longer than this. To implement your suggestion, we would need to change those names retrospectively.

[zhouji2013]

Per Ken's recommendation, we enforce this limit here, but not for the existing submissions.

[zhouji2013]

This is a test case for checking this limit test_51.zip