Posted 17 February 2021, 4:21 am EST
Hi! 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:
https://www.grapecity.com/spreadjs/docs/v14/online/celllock.html
https://www.grapecity.com/documents-api-excel/docs/online/GrapeCity.Documents.Excel~GrapeCity.Documents.Excel.IProtectionSettings_members.html
Can we expect to have support for the missing ones in Documents for Excel?
Regards.