<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 - Conditional Formatting not maintained after saving and shutting down spreadsheet"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=136470">136470</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Conditional Formatting not maintained after saving and shutting down spreadsheet
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>7.0.0.3 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>surebrec@gmail.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
I have created values to include in conditional formatting for temperature
cells, and they appear like this:

<a href="https://imgur.com/sV0Lchp">https://imgur.com/sV0Lchp</a>

But after saving the spreadsheet and closing it down, upon reopening, the above
formats are losing their inheritance from the "Celcius" bracket, and are being
placed under the "Default Cell Style" bracket.

Furthermore, the cells that I have applied the conditional formatting to, are
having the control shifted from the above "T" values to this:

<a href="https://imgur.com/BYetsyc">https://imgur.com/BYetsyc</a>

This seems to be screwing with the formatting of the cells in question.

Is this a bug, or am I doing something wrong?

OS: W10
LO: 7.0.0.3
File Format: .xlsx

Actual Results:
The cells that I have applied the conditional formatting to, are having the
control shifted from the above "T" values to this:

<a href="https://imgur.com/BYetsyc">https://imgur.com/BYetsyc</a>

This seems to be screwing with the formatting of the cells in question.

Expected Results:
I have created values to include in conditional formatting for temperature
cells, and they appear like this:

<a href="https://imgur.com/sV0Lchp">https://imgur.com/sV0Lchp</a>


Reproducible: Always


User Profile Reset: No



Additional Info:
.</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>