Bug 129945 - Saved files always have protected cell from BM column
Summary: Saved files always have protected cell from BM column
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-01-11 18:21 UTC by Marco
Modified: 2021-09-06 10:32 UTC (History)
1 user (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 Marco 2020-01-11 18:21:56 UTC 
Description:
Select all in a spreadsheet (from A1 to AMJ1048576), select "Format Cells" - "Cell Protection", deselect "Protected" and click "Ok".
Good. Now all cells are unprotected cell, and you can verify it using the previous menu.
But, if you save your file, close and reopen it, all cells from AM1 to AMJ1048576 are again protected cells.
So, if the spreadsheet is protected, you and not select (or modify) a whole line, because it contain some protected cells.
All column to the right of AL ignore the saved setting (unprotected cell)

Steps to Reproduce:
1. Unprotect AM1 cell
2. Now AM1 is unprotected cell
3. Save your file
4. Close your file
5. Open saved file

Actual Results:
AM1 is again protected cell

Expected Results:
AM1 must be unprotected cell


Reproducible: Always


User Profile Reset: No



Additional Info:
I tried 6.3.4 version too, and the result is the same.
Fedora 31 operating system
Comment 1 m_a_riosv 2020-01-12 00:18:35 UTC 
Please what file format do you use to save?
Comment 2 Marco 2020-01-12 06:10:01 UTC 
I save as ods. I tried the xlsx format, and it doesn't seem affected by this bug. It is an ods problem.
Note: I tried with a new user, and the bug is still there: then, is not a profile problem.
Note: If I dowgrade Libreoffice to 6.2.8, opening the saved file all the cells are unprotected, how it should be. It appears to be a problem in opening the file, not saving it.
Comment 3 Marco 2020-01-12 06:11:46 UTC 
Errata-corrige of first message:

"But, if you save your file, close and reopen it, all cells from AM1 to AMJ1048576 are again protected cells." -> "But, if you save your file, close and reopen it, all cells from BM1 to AMJ1048576 are again protected cells."
BM1, not AM1!
Comment 4 QA Administrators 2020-01-13 03:35:38 UTC Comment hidden (obsolete)
Comment 5 Marco 2020-01-13 07:46:46 UTC 
Yesterday I tried a Windows version of LibreOffice Calc, and the bug is also there.
Also, I noticed that the BL column (the last one not affected by the bug) is, in hexadecimal, the 0x40 column. Instead, the AMJ column (the last column of the spreadsheet) is the 0x400 column. Have you forgotten a zero?
Comment 6 Marco 2020-04-12 08:09:56 UTC 
It is anyone working on this bug? Everything is silent, and the bug is still there.
Comment 7 Timur 2021-09-06 09:39:10 UTC 
(In reply to Marco from comment #6)
> It is anyone working on this bug? Everything is silent, and the bug is still
> there.

Question is "no-value". LO is volunteer driven, so you can fix it yourself, find or pay someone do it, or just wait, days or decades, like others in bug 107450. 

This bug was wrongly confirmed by reporter. I don't reproduce.
I set Needinfo for sample ODS.
Comment 8 Marco 2021-09-06 09:44:17 UTC 
Version 7 of LibreOffice is not affected by this bug.
Comment 9 Timur 2021-09-06 10:32:55 UTC 
Thanks for recheck. 
When bug used to be reproducible and not anymore we set WorksForMe.
But here nobody except reporter confirmed and no sample, so I close with InsuficcientData.