Bug 167336 - Unprotected cells cannot be edited
Summary: Unprotected cells cannot be edited
Status: RESOLVED DUPLICATE of bug 167052
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/topic/1...
Whiteboard:
Keywords: bibisected, bisected
Depends on:
Blocks:
 
Reported: 2025-07-02 05:14 UTC by Saburo
Modified: 2025-07-02 06:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
test cellprotect (7.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-07-02 05:17 UTC, Saburo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2025-07-02 05:14:18 UTC 
Description:
If a sheet is protected, dragging, cutting and pasting, or deleting all unprotected cells will prevent the original cells from being edited.

Steps to Reproduce:
1.Uncheck "protected" in "Cell protection". (A1:B1)
2.Protect the sheet.
3.Press 'Back Space' key in A1. (Delete all)
4.Enter text in A1.

Actual Results:
"Protected cells can not be modified."

Expected Results:
Cell A1 is editable


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.8.0.0.beta1 (X86_64) / LibreOffice Community
Build ID: 1b25e37a63c5a6f16bdcb365ed3da80ac419e6e4
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
Comment 1 Saburo 2025-07-02 05:17:52 UTC 
Created attachment 201599 [details]
test cellprotect

bibisected with win64-25.2
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6ca76f3e6fbb19ef4982b0c178879645e7f72c00

author	Balazs Varga
commit 6ca76f3e6fbb19ef4982b0c178879645e7f72c00

Related: tdf#160536 - ooxml import export correctly cell protection
property for Pivot tables cells.
Comment 2 Saburo 2025-07-02 05:21:02 UTC 
adding to CC:Balazs Varga

Please, take a look?
Comment 3 Saburo 2025-07-02 06:39:28 UTC 

*** This bug has been marked as a duplicate of bug 167052 ***