<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 Corrupted by Column Insert"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=134767">134767</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Conditional Formatting Corrupted by Column Insert
          </td>
        </tr>

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

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

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

        <tr>
          <th>OS</th>
          <td>Linux (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>mwelinder@gmail.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
The behaviour of insert-column on an area with conditional formatting
depends on conditional formatting present in other parts of the sheet.
Sometimes it updates correctly, sometimes it does not.


localc 6.4.4.2 as supplied in Linux Mint 20 (Ulyana)

Steps to Reproduce:
Load to-be-attached cf1.ods.  The colours in the right-hand block
come from conditional formatting based on the block of values to
the left using relative cell references.

Insert a new column before column C and notice that the coloured
block moves to the right correctly.  This works fine.

Now load cf2.ods.  It's the same file, except that c7:h9 has been copied
to a14:f16.

Insert a new column before column C and notice that this time the conditional
formatting breaks for h7:i9.  This is because the conditional formatting
still refers to c7:d9 instead of d7:e9

Before the column insert, the original and the copy have the same conditional
formatting.  They also do afterwards (ie., one line in the manage-conditional-
formatting dialog) but they need to be different (two lines) because the
relative references need to be updated differently.

Actual Results:
With cf2.ods, the conditional formatting ends up referring to c7:d9.
As a consequence, h7:h9 is displayed wrong.

Expected Results:
With cf2.ods, the conditional formatting should end up referring to d7:e9.
h7:i9 should look like g7:h9 did before the insert.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes</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>