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.