Posted 8 September 2017, 2:12 pm EST
We just updated to Windows form spread 4.0.3512.2008 (from 4.0.3509.2008)
Now when opening xlsx files where sheet protection is set to true in excel, the user is not able to edit any cells! It locks the whole sheet, and not just the locked cells.
this.bwSpreadWoorkBook.OpenExcel(workBook); //workBook is stream
The same happens if protection is off in excel and in code switches the protection on
-> locks the whole sheet.
bwSpreadWoorkBook.Sheets.Protect = true;
This seems to be the case only for xlsx files and not for xls.
Is there a fix to this issue or work around?
(also cell colors set in excel dosn't seem to update correctly in xlsx -> farpoint)