<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - opposite result in conditional formatting in LibO Calc"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=111397">111397</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>opposite result in conditional formatting in LibO Calc
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>5.3.4.2 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>gmmellina@inwind.it
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=135169" name="attach_135169" title="ods test">attachment 135169</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135169&action=edit" title="ods test">[details]</a></span>
ods test

As required, this report reopens a previous bug (91070, closed as RESOLVED
NOTABUG).

I've attached a new sample (CALCnewsampletest.ods), extremely simplified and
"crystal clearly" and a new screenshot (CALCnewshot.JPG).

@ Buovjaga and Markus (<a href="show_bug.cgi?id=111397#c36">comment # 36</a> from <a class="bz_bug_link 
          bz_status_RESOLVED  bz_closed"
   title="RESOLVED NOTABUG - opposite result in conditional formatting in LibO Calc"
   href="show_bug.cgi?id=91070">bug 91070</a>):
<span class="quote">> I see a conditional format with if value is between -12 and +12 and that seems</span >
to work just fine"
Sorry, but the condition is "NOT between -12 and +12"!

I personally had already bypassed the problem, you can also scratch this
report, but the problem is obvious and it does not seem right to close the
issue with a "RESOLVED NOTABUG" sentence (do you know Ponzio Pilato?).
In my opinion: 1st) it is not resolved,   2nd) if it is not a bug, what is it?
Greetings.</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>