Description: In a protected worksheet, if a range containing protected cells is selected, even though the active cell is unprotected, the error, "Protected cells can not be modified." is shown. Steps to Reproduce: 1. Unprotect some cells 2. Select a range including both protected and unprotected cells 3. Ensure the active cell is unprotected 4. Try to edit Actual Results: The error diagnostic, "Protected cells can not be modified." Expected Results: Calc should accept the edit Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.4.2 (x64) Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL
Reproduced also with Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 86c8c775bbefe333d684e12c99855a3c1de68051 CPU threads: 4; OS: Windows 10.0 Build 21292; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Regression from 6.4.
Please upload a sample spreadsheet with exact steps what to select and edit. m.a.riosv, I'm not seeing this working in older versions, but I don't know if my steps are correct.
Created attachment 169179 [details] Requested test file 1. Created new spreadsheet 2. Right clicked on cell A1 & chose Format cells 3. Went to Cell Protection tab, and deselected 'Protected'. Clicked OK 4. Clicked Tools > Protect Sheet from the menu 5. OK clicked (no password, 'Select protected cells' & 'Select unprotected cells' check boxes selected, all others deselected - i.e. keep the defaults) 6. Selected the range A1:B2, with A1 being the active cell 7. Started typing. The diagnostic 'Protected cells can not be modified.' appears
repro Version: 6.2.0.0.alpha1+
This is Inherited, not regression. Trivial issue. When multiple cells are selected, only upper left one could be edited, as requested by this bug. I don't see a practical value in this, except to emulate MSO behavior.
I have gone back through various historic versions using Windows 10 and the bug occurs in all the version I tested including 7.0.4.2, 6.3.0.0.alpha1+, 5.4.0.0.alpha1 and 4.5.0.0.alpha0.
That would be a very interesting behavior. I'd like to be able to use such a feature like this: - unprotect some cells - protect the sheet - select an area with a mix of protected/unprotected cells - press delete => only unprotected cell's content is deleted That would be really nice and user friendly
(In reply to ornanovitch from comment #7) > - select an area with a mix of protected/unprotected cells > - press delete > => only unprotected cell's content is deleted That is bug 159191.