Bug 167052 - Calc Unprotected cells that have the content "cut" from them become protected.
Summary: Calc Unprotected cells that have the content "cut" from them become protected.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.4.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 167336 (view as bug list)
Depends on:
Blocks:
 
Reported: 2025-06-16 20:05 UTC by CSimmons
Modified: 2025-07-02 06:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Protected sheet before cutting content (14.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-06-16 20:11 UTC, CSimmons 		Details
Protecte sheet after cutting content (14.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-06-16 20:11 UTC, CSimmons 		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 CSimmons 2025-06-16 20:05:35 UTC 
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
Comment 1 CSimmons 2025-06-16 20:11:34 UTC 
Created attachment 201314 [details]
Protected sheet before cutting content
Comment 2 CSimmons 2025-06-16 20:11:58 UTC 
Created attachment 201315 [details]
Protecte sheet after cutting content
Comment 3 m_a_riosv 2025-06-16 22:50:22 UTC 
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.
Comment 4 Saburo 2025-07-02 06:39:28 UTC 
*** Bug 167336 has been marked as a duplicate of this bug. ***