[Libreoffice-bugs] [Bug 122907] FORMATTING Style not correctly applied at conditional formatting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122907

--- Comment #4 from Stefan_Lange_KA at T-Online.de <Stefan_Lange_KA at T-Online.de> ---
The subjcect of Bug 122907 corresponds the subjects of Bug 117715 as well as
Bug 103793 and is the opposite of Bug 93300 - seems Bug 122907 and both other
are the result of the solution of Bug 93300, introduced with LO 5.1.3 (Markus
Mohrhard). This build I had also found in my tests as first build with the bug.
If the solution of Bug 93300 is good or not - I don't know. As I see in the
comments to the other bugs there are different views on the problem (e.g. the
proposal "Another option would be to lock or unlock the properties of a style."
in Bug 93300).

According to the hint of m.a.riosv I have deleted in my test document the
direct formatting of column A via "Clear Direct Formatting" (conditional
formatting was deleted too - OK or not?) and after I have re-defined the
conditional formating the styles were applied correctly. On this way I could
solve my problem. 
The only downside is that now the autofilter absolutely can't be used. With the
behavior until LO 5.1.2 the autofilter by date could be used good when cells
had direct formatitng as date and only the cells formatted as yyyy were
displayed in the filter entry list as "not readable" numbers.

But I have made further tests and as result I have found different resp.
inconsistent behavior depending on how conditional formatting is defined:
Seems conditional number formattig is overriden by direct number formatting
only when the condition is defined for an area of cells. When the condition is
defined for a single cell the number format of style applied because of the
condition overrides the direct formatting.

To demonstrate this I have created
"Test_bedingte_Formatierung_Format_Datum_V2.ods" as modified version of
"Test_bedingte_Formatierung_Format_Datum.ods":
- column A: direct formating as date dd.mm.yy, conditinal formatting defined
for area A2:A4 -> date format from direct formatting is used
- column B: direct formating was cleared and conditinal formatting re-defined
for area B2:B4 -> date format from conditional formatting is used
- column C: direct formating as date dd.mm.yy, conditinal formatting defined
for single cells C2, C3 and C4 (with "simple" formulas) -> date format from
conditional formatting is used --> OK or not?
- column D: direct formating as date dd.mm.yy, conditinal formatting defined
for single cells D2, D3 and C4 (with "complicate" formulas) -> date format from
conditional formatting is used --> OK or not?
- column E: no conditional formatting, styles were applied explicitly to show
what I wish to the by the conditional formatting

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190125/e92ca9f9/attachment-0001.html>