[Libreoffice-bugs] [Bug 91070] opposite result in conditioned format in LibO Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #29 from gmarco <gmmellina at inwind.it> ---
(In reply to Julien Nabet & Tommaso)
I too do not understand but so it is! However, without the need to uninstall
the current one, I installed 5.3.3.2 and tried the bug, but absolutely nothing
has changed (see the new attachments): as from my comment #15 cells
F53-54-66-67 have a conditioned format resulting the opposite of what should
be. All those cells are conditioned "if not between -12/+12" but for example,
cell F54 (containing the value -7) is "red" while it should not be; changing
the condition the problem remains: set the condition "if = -7" and check the
result, it would become "not red" instead remains "red"; if you want that cell 
correctly "red" highlighted, you have to set "if not=". 
I also tried to save the XLS file as ODS and reopen it: it does not change
anything.

I also do not understand why, after two years, the bug is still UNCONFIRMED,
maybe someone gets a different result from mine?
The file (XX-mysampletest.bin) is at your disposal since 2015-05-11 (see my
comment #16: The .bin here attached ..... Renaming it as .xls you get the
original sheet like that I have on my harddisk), just download it, rename it,
open it ... and check it out.

-- 
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/20170515/4b9074cb/attachment-0001.html>