Bug 157785 - The font colour of the text in cells is not changed in the editing mode
Summary: The font colour of the text in cells is not changed in the editing mode
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All All
: medium normal
Assignee: Oleksa Stasevych
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: User-Profile-Upgrade
  Show dependency treegraph
 
Reported: 2023-10-15 10:30 UTC by Oleksa Stasevych
Modified: 2024-04-18 16:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Register xcu file with the bad behavior. (1.47 MB, application/xml)
2023-10-17 21:04 UTC, m_a_riosv
Details
File with bad behaviour (2.88 MB, application/xml)
2023-11-02 14:03 UTC, Oleksa Stasevych
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oleksa Stasevych 2023-10-15 10:30:10 UTC
Description:
When I try to change the colour of the text in a cell which I am editing in the LibreOffice Calc it is not changed in the editing mode. However, it is changed when viewing the final spreadsheet document or printing, which confuses some.
This started to happed after the upgrade from 7.5.x to 7.6.x version.

Steps to Reproduce:
1. Create some spreadsheet document
2. Go to any cell and place some text or numbers there
3. Change the font colour to any other
4. Observe that it is not changed in the editing mode
5. Switch to the preview mode and see that it is changed

Actual Results:
The colour of the text in cells is not changed in the editing mode.

Expected Results:
When I change the colour colour of the text in cells it should be changed  in the editing mode according to the wysiwyg concept.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2023-10-15 16:10:22 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 2 Stéphane Guillou (stragu) 2023-10-16 10:15:39 UTC
Could not reproduce in:

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

If there is a regression, wondering if it has something to do with the fix for bug 107965.
Comment 3 m_a_riosv 2023-10-16 20:47:03 UTC
Please, @Stephane, test in Safe Mode.

I'm able to reproduce with 7.5.8 with a clean profile.
In this case if I delete in the options the Light Theme then it works.
Comment 4 Stéphane Guillou (stragu) 2023-10-17 15:51:04 UTC
(In reply to m.a.riosv from comment #3)
> I'm able to reproduce with 7.5.8 with a clean profile.
> In this case if I delete in the options the Light Theme then it works.

Couldn't reproduce with user profile deleted, nor in safe mode.
Which OS, m.a.riosv?
And what do you mean "delete the Light Theme"?
Comment 5 m_a_riosv 2023-10-17 21:04:25 UTC
Created attachment 190271 [details]
Register xcu file with the bad behavior.

This is getting me a bit crazy.

With the attached registrymodifications.xcu, the issue happens for me with
Version: 7.5.8.1 (X86_64) / LibreOffice Community
Build ID: a3cc32c5bcaabeae7ab60e12c44c40a7d8d36345
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
and with the same xcu file happens with:
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: e9374f74385d7dfe77d1902d3d82af20143bc775
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

But I'm not able now to solve it, deleting the scheme in:
Menu/Tools/Options/LibreOffice/Application colors/Color Scheme.
Comment 6 Oleksa Stasevych 2023-11-02 13:35:23 UTC
(In reply to m.a.riosv from comment #1)
> Please test in safe mode, Menu/Help/Restart in Safe Mode

It's fine in Safe Mode.
Comment 7 Oleksa Stasevych 2023-11-02 13:52:24 UTC
(In reply to m.a.riosv from comment #3)
> Please, @Stephane, test in Safe Mode.
> 
> I'm able to reproduce with 7.5.8 with a clean profile.
> In this case if I delete in the options the Light Theme then it works.

Please, explain, how to delete Light Theme in the options? Where to find that parameter?
Comment 8 Oleksa Stasevych 2023-11-02 13:57:17 UTC
(In reply to m.a.riosv from comment #5)
> Created attachment 190271 [details]
> Register xcu file with the bad behavior.
> 
> This is getting me a bit crazy.
> 
> With the attached registrymodifications.xcu, the issue happens for me with
> Version: 7.5.8.1 (X86_64) / LibreOffice Community
> Build ID: a3cc32c5bcaabeae7ab60e12c44c40a7d8d36345
> CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL:
> win
> Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
> and with the same xcu file happens with:
> Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: e9374f74385d7dfe77d1902d3d82af20143bc775
> CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL:
> win
> Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
> 
> But I'm not able now to solve it, deleting the scheme in:
> Menu/Tools/Options/LibreOffice/Application colors/Color Scheme.

In the Colour Scheme I see only one "Automatic".
Comment 9 Oleksa Stasevych 2023-11-02 14:03:52 UTC
Created attachment 190615 [details]
File with bad behaviour
Comment 10 QA Administrators 2023-11-03 03:15:53 UTC Comment hidden (obsolete)
Comment 11 Buovjaga 2023-11-13 17:34:32 UTC
I can reproduce with the xcu, attachment 190271 [details], on Windows. Should ask about this in the dev chat, though.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 50add2043752c7b07beccef9a509bea6c09619f8
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 12 Armondo Lopez 2024-04-13 22:11:07 UTC
I was unable to reproduce the same behavior in

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

or

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 13 Stéphane Guillou (stragu) 2024-04-18 16:31:16 UTC
(In reply to Buovjaga from comment #11)
> I can reproduce with the xcu, attachment 190271 [details], on Windows.
Also on Linux:
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bdf3b5ce49b0e4ee1b4525d344cfb037ef473059
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

... but not changing the OS, as the profile might only get corrupted on Windows in the first place.
Wondering if it could have to do with the fix for bug 152184, which caused 160513 (because I see that m_a_riosv's profile similarly has not active Application Color scheme).

Setting to new because two users reproduced.