Description: In Calc, if I have the worksheet locked and content present in unprotected areas of the sheet, when I cut the content from those cells and paste it elsewhere, the source cells become protected. I have to unlock the sheet and unprotect those cells to make them usable again. This bug has been present for at least the last two releases. Steps to Reproduce: 1. Cut the content from an unprotected cell in a protected sheet. 2. Paste the content elsewhere. 3. The source cells from which the content was cut are now protected. Actual Results: The source cells become protected after content is cut from them. Deleting, copying or otherwise modifying the cells does not result is the same change in protected status. Expected Results: Left the source cells unprotected so they can have new content entered into them. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Created attachment 201314 [details] Protected sheet before cutting content
Created attachment 201315 [details] Protecte sheet after cutting content
Because when you cut, the cell format is cleared, and unprotected is part of the cell format. Instead, copy and use delete key without delete the format.
*** Bug 167336 has been marked as a duplicate of this bug. ***
(In reply to m_a_riosv from comment #3) > Because when you cut, the cell format is cleared, and unprotected is part of > the cell format. > > Instead, copy and use delete key without delete the format. Why is the cell formatting cleared when cutting? It felt a bit counterintuitive to me.
(In reply to Shinji Enoki from comment #5) > (In reply to m_a_riosv from comment #3) > > Because when you cut, the cell format is cleared, and unprotected is part of > > the cell format. > > > > Instead, copy and use delete key without delete the format. > > Why is the cell formatting cleared when cutting? It felt a bit > counterintuitive to me. This is how it works in all spreadsheet programs.
reproduced. Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded
(In reply to Hiroyoshi Sudo from comment #7) > reproduced. > > Version: 25.2.4.3 (X86_64) / LibreOffice Community > Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 > CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 > Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP > Calc: threaded You can reproduce it, as I have said in any spreadsheet program, it is how it works, it is not a bug.
Closing as notabug.
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.