Bug 169374 - Calc sheet protection at 25.8.2 blocks ability to move columns of cells back into protected area
Summary: Calc sheet protection at 25.8.2 blocks ability to move columns of cells back ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 169546 (view as bug list)
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency tree / graph
 
Reported: 2025-11-10 17:34 UTC by Gilbert Mousty
Modified: 2025-11-21 11:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Gilbert Mousty 2025-11-10 17:34:51 UTC 
Description:
In Libre Office Calc last version 25.8.2
When a sheet is protected, data offsets no longer work correctly

Actual Results:
When a sheet is protected, it is impossible to move certain data

Expected Results:
Same behavior as in the abscence of protection


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Nothing
Comment 1 m_a_riosv 2025-11-11 00:38:12 UTC 
Please attach a sample file, reduce the size as much as possible without private information,
and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 V Stuart Foote 2025-11-19 19:39:56 UTC 
*** Bug 169546 has been marked as a duplicate of this bug. ***
Comment 3 V Stuart Foote 2025-11-19 19:41:42 UTC 
OP replied in dupe:

Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI renderer: Skia/Vulkan; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL threaded

Following bug 169374
It is not necessary to provide an example file. The bug is consistently reproducible on any Calc file. You start with a blank file. You select all the cells that are useful but not protected. You protect the spreadsheet with full permissions. You enter a column of values ​​of any size. You move the values ​​to the right. You can no longer move them to the left because the cells are now protected without your permission.

Actual Results: Cells are now protected without your permission.

Expected Results: Properly manage protected cells.
Comment 4 nobu 2025-11-19 21:44:16 UTC 
While the reported details differ, I believe this is essentially the same issue as the following bug report.
https://bugs.documentfoundation.org/show_bug.cgi?id=167052

I noticed this specification change in the following Japanese ASK.
https://ask.libreoffice.org/t/topic/123908