I have a workbook with named styles. Some of the styles have the 'Protection' turned off (this is so I can control which cells can be edited on a 'Protected' worksheet). When I open and save one of these files, all the Styles become protected, preventing all cells from being edited.
I'm using the code below:
// open the workbook
Workbook wb = new Workbook();
Please see attached Console application. Open the Book1.xlsx to see the behavior of the named style. Close the workbook, run the console appliation and open the workbook again. You cannot edit those cells anymore.
Appreciate any feedback.