<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING Style not correctly applied at conditional formatting" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122907#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING Style not correctly applied at conditional formatting" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122907">bug 122907</a> from <a class="email" href="mailto:Stefan_Lange_KA@T-Online.de" title="Stefan_Lange_KA@T-Online.de <Stefan_Lange_KA@T-Online.de>"> Stefan_Lange_KA@T-Online.de</a> <pre>The subjcect of <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING Style not correctly applied at conditional formatting" href="show_bug.cgi?id=122907">Bug 122907</a> corresponds the subjects of <a class="bz_bug_link bz_status_NEW " title="NEW - Settings from Conditional formatting shouldn't overwrite direct formatting (only number formatting remained in Comment 4)" href="show_bug.cgi?id=117715">Bug 117715</a> as well as <a class="bz_bug_link bz_status_NEW " title="NEW - FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8)." href="show_bug.cgi?id=103793">Bug 103793</a> and is the opposite of <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Style formatting overrides direct formatting when using conditional formatting" href="show_bug.cgi?id=93300">Bug 93300</a> - seems <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING Style not correctly applied at conditional formatting" href="show_bug.cgi?id=122907">Bug 122907</a> and both other are the result of the solution of <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Style formatting overrides direct formatting when using conditional formatting" href="show_bug.cgi?id=93300">Bug 93300</a>, 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 <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Style formatting overrides direct formatting when using conditional formatting" href="show_bug.cgi?id=93300">Bug 93300</a> 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 <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - Style formatting overrides direct formatting when using conditional formatting" href="show_bug.cgi?id=93300">Bug 93300</a>). 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>