Bug 123659 - Conditional formatting does not reflect fontseffect and font names
Summary: Conditional formatting does not reflect fontseffect and font names
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2019-02-23 07:35 UTC by thinkedsfoxe
Modified: 2019-03-01 08:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Sample that can not apply font effect in conditional format. (8.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-02-24 08:06 UTC, thinkedsfoxe

Note You need to log in before you can comment on or make changes to this bug.
Description thinkedsfoxe 2019-02-23 07:35:45 UTC
We changed the text color and confirmed.
Changing Automatic and fontcolor is not reflected.

I think that it is the same as or similar to this bug.

How can I reflect the font size and font color in cells that have conditional formatting applied?
Currently we can only deal with not using conditional formatting.

Kubuntu 18.10
Comment 1 Oliver Brinzing 2019-02-23 13:22:42 UTC
Thank you for reporting the bug. 

Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

And please add a detailed description how the bug can be reproduced.

I have set the bug's status to 'NEEDINFO'. 
Please change it back to 'UNCONFIRMED' once the requested info is provided.
Comment 2 thinkedsfoxe 2019-02-24 08:06:19 UTC
Created attachment 149549 [details]
Sample that can not apply font effect in conditional format.
Comment 3 thinkedsfoxe 2019-02-24 08:08:18 UTC
(In reply to Oliver Brinzing from comment #1)
We have created a sample.
Inside of the sample,
1 is a normal cell.
Neither conditional format nor font effect is attached.
2 has an accent of conditional format.
3 is set to conditional format + font size 15.
But 3 shows that the font size is not changed 10.
Comment 4 Oliver Brinzing 2019-02-24 09:17:33 UTC
steps to reproduce:

- open attached spreadsheet
- F8 cell value is 3 and has conditional format "Accent1" 
  (with font size 10pt) applied
- enter 1 into cell F8
  -> font size changes to 15pt (hard formated)

according to 
->"Conditional formatting should not overwrite hard formatting."
this seems to be a bug.