Bug 166759 - wrong automatic text color in cells
Summary: wrong automatic text color in cells
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Automatic-Color
  Show dependency treegraph
 
Reported: 2025-05-28 08:29 UTC by fik000
Modified: 2025-09-29 08:07 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
xls table with automatic text color (46.00 KB, application/vnd.ms-excel)
2025-05-28 08:43 UTC, fik000
Details
wrong text colors (60.03 KB, image/png)
2025-05-28 11:34 UTC, fik000
Details
forced text color yellow - ok (192.91 KB, image/png)
2025-05-28 11:49 UTC, fik000
Details
Screencast from my system (651.09 KB, image/gif)
2025-05-28 11:51 UTC, Mike Kaganski
Details
same problem in version 25.2.4.1 (193.69 KB, image/png)
2025-05-28 12:19 UTC, fik000
Details
after reset to factory settings - ok (65.32 KB, image/png)
2025-05-28 12:36 UTC, fik000
Details
error after color scheme changed (82.86 KB, image/png)
2025-05-28 12:42 UTC, fik000
Details

Note You need to log in before you can comment on or make changes to this bug.
Description fik000 2025-05-28 08:29:00 UTC
Description:
with text color set to automatic, when I change the background color to say light green, text is black - ok. But when I set dark green, in some cells text is white, while in some cells text remains black. Even if I set backgroud to black, text in come cells remains black ie invisible. when i force text color to say yellow, all is ok, problem is only with automatic color. i cant reproduce the error with a new document, only with my old one

Actual Results:
cant reproduce with new file, i can provide my file

Expected Results:
when automatic text color is set, then with dark backgroud, text should be white, with light backgroud text shoud be black


Reproducible: Always


User Profile Reset: No

Additional Info:
worked fine before i have upgraded to 25.2.3.2 my last version was from 2022, dont remember exactly, byt it was ok. file is about 9 years old, it is saved as xls
Comment 1 fik000 2025-05-28 08:43:00 UTC
Created attachment 200992 [details]
xls table with automatic text color
Comment 2 Mike Kaganski 2025-05-28 10:00:43 UTC
(In reply to fik000 from comment #1)
> Created attachment 200992 [details]

What are the exact steps to see the problem? Using Version: 25.2.4.1 (X86_64) / LibreOffice Community
Build ID: 09303ce8b49f86f106fccd32b1324662053027cc
CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-GB
Calc: CL threaded

I opened the file, selected all on the sheet displayed by default (TSS20), and applied black background color to all cells. This *seems* to show all text in white (some cells use conditional formatting, and those didn't change the background).

So some specific steps would be nice (like "open sheet X, go to cell Y, make its background to color Z, see A, expected B...")
Comment 3 fik000 2025-05-28 11:34:34 UTC
Created attachment 201001 [details]
wrong text colors

Hello,

it dont work for me...

- go to sheet TSS20
- select all (Ctrl+A)
- in the toolbar click background color
- select some dark color or black
- cells B2, B3, B4 have white text, for example - ok
- cells c2, d3, d4, g3 have black text - error
- n3, n4 etc have red backglound red text - ok (conditions)


see attached file, pls.

? 

Mirek
Comment 4 fik000 2025-05-28 11:49:54 UTC
Created attachment 201002 [details]
forced text color yellow - ok

I have selected all again, and set text color to yellow, all but conditional texts went yellow - ok

when i set text color to automatic, then error occures again



im using dark mode/theme in windows, but when i switch to light mode, error is still present

after instalation i ve switched libre office to light theme (dark is too dark for me)

when i switch the libre office color theme to SYSTEM, error is present for light and dark windows too...
Comment 5 Mike Kaganski 2025-05-28 11:51:25 UTC
Created attachment 201003 [details]
Screencast from my system

(In reply to fik000 from comment #3)

Strange; my screencast doesn't show that error.
What is the full info from Help->About?

And could you please try 25.2.4 RC from pre-releases (at the bottom of the download page)?
Comment 6 fik000 2025-05-28 12:06:28 UTC
for version see my last screenshot, pls
Comment 7 fik000 2025-05-28 12:19:02 UTC
Created attachment 201005 [details]
same problem in version 25.2.4.1

same problem in version 25.2.4.1 RC
Comment 8 fik000 2025-05-28 12:36:14 UTC
Created attachment 201007 [details]
after reset to factory settings - ok

i ve reset the user profile to factory settings (in emergency mode) and the error dissapeared

but libre office went to dark mode, because im using dark mode in windows

but table was ok then
Comment 9 fik000 2025-05-28 12:42:12 UTC
Created attachment 201008 [details]
error after color scheme changed


then i set: Alt+F12 -> appearance -> options - Light, now error is here again!


(even if i set default (dark) mode back) only help is to reset to factory settings now


So I can say the error has something to do with /Light color scheme/ of Libre office in windows set in /Dark mode/