[Libreoffice-bugs] [Bug 103793] FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8).
https://bugs.documentfoundation.org/show_bug.cgi?id=103793 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 103793] FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8).
https://bugs.documentfoundation.org/show_bug.cgi?id=103793 Eike Rathke changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #11 from Eike Rathke --- Rather fix it than document it. While hard > conditional > style is logical also to me (but only implemented for number formats), it seems not to be what is expected. See duplicate of. *** This bug has been marked as a duplicate of bug 117715 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 103793] FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8).
https://bugs.documentfoundation.org/show_bug.cgi?id=103793 Xisco FaulĂ changed: What|Removed |Added CC||stefan_lange...@t-online.de --- Comment #10 from Xisco FaulĂ --- *** Bug 122907 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 103793] FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8).
https://bugs.documentfoundation.org/show_bug.cgi?id=103793 --- Comment #9 from AndyK --- I have a little table where I want positive values lower or equal 10 to be displayed as percentage "#,##0%" and values higher than 10 as normal decimal values with format "#,##0". 1. I made a style "percentage" based off of the standard/default style, changed the number formatting to percentage "#,##0%" and selected the bold font type (to verify). 2. I made a style "number" based off of the standard/default style, changed the number formatting to decimal "#,##0" and selected the italic font style (to verify) 3. I typed in A1 the value 2.5, A2 the value 0.5, A3 the value 125 and in A4 the value 30. 4. I created a conditional formatting with condition 1 "value is below 11" set use style "percentage" and condition 2 "value is equal or greater than 11" use style "number". Range A1:A4 I thought conditional formatting would allow me to do this, but it is not as I can't change number formatting using conditional formatting. If I manually set the style "percentage" or "number" to a cell, the correct number format will be displayed. While writing this and verifying every step along I found a workaround: 1. Enter your values 2. Select the cells you want to have the conditional formatting 3. "Edit" -> "Clear Cells (Backspace)" -> select only "Format" 4. Create styles (if necessary) 5. Create/Apply conditional formatting The step to clear all formats is the key action to have this working. Even though the user has not explicitly applied a format did so implicitly. Imho this information should be included in the help documentary. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 103793] FORMATTING: Conditional formatting doesn't respect category of number-format (Documentation per Comment 8).
https://bugs.documentfoundation.org/show_bug.cgi?id=103793 Timur changed: What|Removed |Added Summary|FORMATTING: Conditional |FORMATTING: Conditional |formatting doesn't respect |formatting doesn't respect |category of number-format. |category of number-format ||(Documentation per Comment ||8). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs