Is there a way to prevent isProtected from clearing the undo stack?

Is there a way to prevent isProtected from clearing the undo stack?

Posted by: james.henke on 22 October 2019, 12:40 pm EST

• 

  james.henke

  • Post Options:
  • Link
    Copy

  Posted 22 October 2019, 12:40 pm EST

  We need to protect and protect the spreadsheet for a number of reasons - this is to stop the user from accidentally changing values.

  We are using:
  
  workbook.getActiveSheet().options.isProtected = true;
  
  When this is executed the undo stack is cleared.

  We want to protect and then un-protect the sheet keeping the undo stack intact.

  Is there a way to prevent the stack from being cleared?

  Thanks,
  
  James

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 23 October 2019, 2:45 am EST

  Hi James,

  We are sorry but with the current API, it is not possible to preserve the undo stack while changing the protection option. Hence we have added an enhancement request on your behalf to support this feature. The internal tracking ID for the case is SJS-2225. We will let you know about any updates regarding the same.

  Regards
  
  Sharad

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 24 February 2020, 5:47 am EST

  Hi,

  This issue is fixed in our latest hotfix build 13.0.5. Please update to the latest build and let us know if the issue persists for you.

  Regards
  
  Sharad