Bug 159295

Summary: Calc cell color menu reverts to default upon entering data anywhere
Product: LibreOffice Reporter: jjgurley
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.5.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Screenshot for update style

Description jjgurley 2024-01-20 02:23:16 UTC
The "default" cell fill color is bright yellow.  If you select a cell and choose a different fill color, the new color becomes the default.  If you select any cell, and enter any data, the default color reverts.  This only started happening within the last few updates.

Trivial to duplicate.
Comment 1 m_a_riosv 2024-01-20 21:47:30 UTC
Created attachment 192076 [details]
Screenshot for update style

Please attach a sample file, and paste the information in Menu/Help/About LibreOffice, there is an icon to copy.

Maybe you have marked the option to automatically update the styles, on the paragraph style.
Comment 2 jjgurley 2024-01-20 22:52:07 UTC
I don't think there's a "paragraph" concept in CALC.  I've build hundreds of spreadsheets with versions of Calc, and this is a relatively new phenomenon (last 3-6 months).  It took me awhile to notice exactly what was resetting the color.
Comment 3 jjgurley 2024-01-20 22:53:36 UTC
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 4 m_a_riosv 2024-01-21 01:57:33 UTC
Sorry for the mistake.

I can't reproduce with
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded

Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 5 jjgurley 2024-01-21 03:30:29 UTC
It was apparently corrected in 7.6.x despite no bug reports.  My bad for not updating before complaining.
Comment 6 m_a_riosv 2024-01-21 15:32:39 UTC
Thanks for the confirmation.