SheetView name limitations

SheetView name limitations

Posted by: staff.rand on 2 March 2022, 3:58 pm EST

• 

  staff.rand

  • Post Options:
  • Link
    Copy

  Posted 2 March 2022, 3:58 pm EST

  Hello, we recently updated to a new Spreads version and have been hit with a roadblock. There seems to now be validation on what you can call your sheet.

  The exception states "A sheet name must be 31 or fewer characters, not blanks and cannot contain the characters * ? / "

  Is there a way to disable this functionality, we have no intention of exporting to xlsx and if I’m not mistaken, previous version of spreads had no such hard limitation.

  Thanks

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 March 2022, 10:20 pm EST

  Hi,

  This behavior is the same as Microsoft Excel. Currently, there is no way to not disable the validation of SheetView’s name.
  
  We have escalated the case to the development team to get their insights and see if there is a workaround.
  
  [Internal Tracking ID: SPNET-22983]

  Regards
  
  Avnish

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 March 2022, 11:05 pm EST

  Hi,

  As per the development team, you can use the following statement before all your spread logic to disable the sheet name validation.

    GrapeCity.Spreadsheet.WorkbookSet.Compatibility &= ~Compatibility.WorksheetName;
  
  

  Regards
  
  Avnish

• 

  staff.rand

  • Post Options:
  • Link
    Copy

  Posted 3 March 2022, 10:02 am EST - Updated 30 September 2022, 4:09 am EST

  Hi Avnish,

  I’ve tried that above snippet of code prior to all logic and it still does not remove the validation. See a simplified example attached.

  Thanks

• 

  staff.rand

  • Post Options:
  • Link
    Copy

  Posted 3 March 2022, 10:03 am EST - Updated 30 September 2022, 4:14 am EST

  

  2652×1172 146 KB

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 3 March 2022, 6:15 pm EST

  Hi,

  We checked with the development team. The suggested method will only disable the sheet name’s length validation. You cannot use restricted characters because it will cause CalcEngine to malfunction.

  Regards.
  
  Avnish