Bug 165675 - cell background change also changes Font color
Summary: cell background change also changes Font color
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-10 17:00 UTC by damientheo
Modified: 2026-01-26 19:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
file (8.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-03-11 04:04 UTC, damientheo
Details
Font (Automatic) on background colors from Standard palette (304.78 KB, image/png)
2025-03-11 17:30 UTC, nutka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description damientheo 2025-03-10 17:00:59 UTC
Description:
choosing a cell background color changes the Font of that cell to white automatically.
It appears to be only for the base color without a number. For example - yellow, but not yellow 1,2,3,etc. 

Steps to Reproduce:
1.select a cell
2.change background fill to yellow
3.note font color is white, not black (default)

Actual Results:
see above

Expected Results:
font should remain black


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2025-03-11 03:39:38 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 damientheo 2025-03-11 04:04:26 UTC
Created attachment 199728 [details]
file
Comment 3 nutka 2025-03-11 17:27:30 UTC
The automatic font color depends on the selected background (light, dark).
Cell A1 in your sample file has the Font Color set to "Automatic" and the Background Color to "Yellow" from the Standard palette). In my LO the cell text "font" is displayed in black.

Take a look at the attached screenshot (Font Color - Automatic, all background colors from the Standard palette).

-------
Version: 24.8.5.2 (X86_64) / LibreOffice Community
Build ID: fddf2685c70b461e7832239a0162a77216259f22
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: en-US
Calc: threaded
Comment 4 nutka 2025-03-11 17:30:43 UTC
Created attachment 199740 [details]
Font (Automatic) on background colors from Standard palette
Comment 5 damientheo 2025-03-12 00:56:54 UTC
(In reply to nutka from comment #3)
> The automatic font color depends on the selected background (light, dark).
> Cell A1 in your sample file has the Font Color set to "Automatic" and the
> Background Color to "Yellow" from the Standard palette). In my LO the cell
> text "font" is displayed in black.
> 
> Take a look at the attached screenshot (Font Color - Automatic, all
> background colors from the Standard palette).
> 
> -------
> Version: 24.8.5.2 (X86_64) / LibreOffice Community
> Build ID: fddf2685c70b461e7832239a0162a77216259f22
> CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
> Skia/Raster; VCL: win
> Locale: en-US (de_DE); UI: en-US
> Calc: threaded

Automatic should be black. It should never revert to white on a spreadsheet which always has a white background as default.
If input characters in a cell, they are black, but then changing the background (yellow or any as mentioned) changes the font to white.
Comment 6 QA Administrators 2025-11-25 15:25:19 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2025-11-25 15:38:17 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2026-01-26 19:49:53 UTC
damientheo: Please copy and paste here the content of your Help - About by clicking the copy button. This allows us to know more about your system.

Also, do you still see this issue?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.