https://bugs.freedesktop.org/show_bug.cgi?id=69799
Priority: medium
Bug ID: 69799
Assignee: [email protected]
Summary: In conditional formatting where 2 cells have same sum,
they get different color FORMATTING
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
