<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - opposite result in conditioned format in LibO Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=91070#c29">Comment # 29</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - opposite result in conditioned format in LibO Calc" href="https://bugs.documentfoundation.org/show_bug.cgi?id=91070">bug 91070</a> from <a class="email" href="mailto:gmmellina@inwind.it" title="gmarco <gmmellina@inwind.it>"> gmarco</a> <pre>(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 <a href="show_bug.cgi?id=91070#c15">comment #15</a> 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 <a href="show_bug.cgi?id=91070#c16">comment #16</a>: 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>