[Bug 29350] Editable Ranges in Protected Sheets

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 29350] Editable Ranges in Protected Sheets

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=29350

--- Comment #5 from Ricardo Mano <[hidden email]> ---
Found a workaround using CellStyles

CellStyle cellStyle = wb.createCellStyle();
cellStyle.setLocked(false);

Cell cell = sheet.createRow(0).createCell(0);
cell.setCellValue("Value");
cell.setCellStyle(cellStyle);

sheet.protectSheet("pass");

I Hope this helps someone else.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]