Hi there,

is there a way to unlock all cells in a sheet. By default every single cell
is locked.
The problem is, after enabling the sheet protection, you can not delete a
row (even if it is allowed in the worksheet protection settings).

Because cell styles are set only after createCell() was called, i would have
to create a sheet and all cells in it with a "unlockedCellStyle". But this
leads to several other problems (ex. 16'000 cols an 100'000 rows).

I didnt found a way to set a default cell style. Even DefaultColumnStyle
works only for new created cells.

Does anybody now a solution for this.
thank you

Reply via email to