Posted 17 February 2021, 4:21 am ESTHi! We have an issue with formulas that have a reference to a protected sheet. If we create a workbook using SpreadJS, add a protected sheet with some values and then create a formula with a reference to the cells of the protected sheet; when we load this workbook on the backend using 'Documents for Excel' and calculate the formulas we get a 0 value. Removing the protection gives the correct value. Calculating the formulas should be done even thought the sheet you are referencing to is protected, like Excel does.
Seems that the protection options supported by SpreadJS are not the same as the ones supported by Documents for Excel:
Can we expect to have support for the missing ones in Documents for Excel?