<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 - Auto-Calculate does not work properly after column insert"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=112640">112640</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Auto-Calculate does not work properly after column insert
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>5.3.6.1 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>fred4u@wp.pl
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Steps to reproduce
Enter the following:
A1: 1
B1: 1
C1: SUM(A1:B1)
C1 displays 2 (OK)

Now:
Right-click on C1 header; select "Insert columns on the left".
Blank column C1 appears, the sum moves to D1.
Click on D1, press F2 to edit formula and change B1 to C1 (now formula is
SUM(A1:C1)
Go to C1 and enter "1" for the cell.

Sum in D1 remains unchanged (2 instead of 3), only until force re-calculate D1
using F9 key.

Win7/64. OpenGL enabled.</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>