https://bugs.documentfoundation.org/show_bug.cgi?id=162384
Bug ID: 162384
Summary: EDITING: LibreOffice Calc does not support unprotected
cells in a protected Worksheet
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have Spreadsheet a file with one Worksheet.
The default Spreadsheet protection for my cells is "unprotected".
I specifically protect one cell (A1).
I protect the Worksheet.
Now, trying to edit a value in the worksheet displays the message that the cell
cannot be edited because the Worksheet is protected.
If I open the *same* Spreadsheet file in Microsoft Excel, I can freely edit the
cells, except for the cell A1, which I protected. This is the desired behavior.
This even works in the online version of Microsoft Office.
The file in the ZIP archive was generated with the PhpOffice library. The
following code was used:
$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->getProtection()->setSheet(true);
$spreadsheet->getDefaultStyle()->getProtection()->setLocked(Protection::PROTECTION_UNPROTECTED);
$worksheet->getStyle('A1')->getProtection()->setLocked(Protection::PROTECTION_PROTECTED);
Steps to Reproduce:
1. Open the file
https://drive.google.com/file/d/1UqsXMG2C_RRG2Wk_ZO6pDWlKFame41Io/view?usp=sharing
or run the code from the description
2. Try to input any value anywhere except than A1
Actual Results:
I get a message saying that I can't edit
Expected Results:
I should be able to edit anything other than A1
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
