https://bugs.freedesktop.org/show_bug.cgi?id=69799
Priority: medium Bug ID: 69799 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: In conditional formatting where 2 cells have same sum, they get different color FORMATTING Severity: major Classification: Unclassified OS: Linux (All) Reporter: k...@mail.orbitel.bg Hardware: x86 (IA32) Status: UNCONFIRMED Version: 4.1.1.2 release Component: Spreadsheet Product: LibreOffice Created attachment 86527 --> https://bugs.freedesktop.org/attachment.cgi?id=86527&action=edit Some example and a screen shot where explained behaviour is visible Let us use conditional formatting using following format code: [<1][BLUE]# ##0,00;[>1][RED]# ##0,00;[GREEN]# ##0,00 (I tried [<1][BLUE]# ##0,00;[>1][RED]# ##0,00;[=1][GREEN]# ##0,00 but it was impossible to use such formatting code) Then unfortunately we have 2 sums in the table resulting to 1.00 and one is formatted in RED and other is formatted in GREEN. When I use =round(sum(x..y);2) instead of = sum(x..y) the conditional formatting behaves as expected. I am sending a file - some small example and a screen shot where above explained behaviour is visible. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs