Bug 160740 - cell styles in protected sheets lose background colours
Summary: cell styles in protected sheets lose background colours
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Cell-Sheet-Protection
  Show dependency tree / graph
 
Reported: 2024-04-20 03:38 UTC by Sam
Modified: 2024-06-02 05:03 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
protected sheet with background colours in cell styles (9.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-04-20 03:38 UTC, Sam 		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 Sam 2024-04-20 03:38:50 UTC 
Created attachment 193764 [details]
protected sheet with background colours in cell styles

Background colours built into cell styles should not be lost when protecting a sheet.

In the attached sample file, Sheet1 is protected.
Go to Tools, then uncheck Protect Sheet …
Background colours built into the cell styles will reoccur.
Comment 1 m_a_riosv 2024-04-20 21:37:14 UTC 
Reproducible, changing sheet protection, shows the issue.
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
and
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c2ed9919d6d9d286d9062b91577d6bb2b7de8aa
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Last working for me
Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: es_ES
Comment 2 raal 2024-04-21 05:12:02 UTC 
This seems to have begun at the below commit in bibisect repository/OS bibisect-50max.

 77020e093586ba51a8752bea2b7638024ab2fb69 is the first bad commit
commit 77020e093586ba51a8752bea2b7638024ab2fb69
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Wed May 27 18:27:56 2015 +0800

    source-hash-7daf15884d980a8b848f3bdf9bdaed498dcb7b55
    
    commit 7daf15884d980a8b848f3bdf9bdaed498dcb7b55
    Author:     Tsutomu Uchino <hanya@apache.org>
    AuthorDate: Tue Jan 27 13:25:47 2015 +0000
    Commit:     Caolán McNamara <caolanm@redhat.com>
    CommitDate: Tue Jan 27 16:50:55 2015 +0000
    
        Resolves: #i85241# store settings about value highlighting in document
    
        (cherry picked from commit d3fb83cbaea17418def1ace6e868d8892d64d85d)
    
        Change-Id: I34b4ee12e4af8300a51d72f0dd36e27c79832eb5