<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 - The pivot table does not update when renaming a column"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=117853">117853</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>The pivot table does not update when renaming a column
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>unspecified
          </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>shabchi@linagora.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=142342" name="attach_142342" title="test file">attachment 142342</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142342&action=edit" title="test file">[details]</a></span>
test file

Problem description:

When renaming a column in the data sheet, the pivot table that refers to the
data sheet loses the column when we refresh it.

I have performed the test on Excel 2016 and the behavior of calc is similar to
it. the pivot table(s) that refer to it lost the column when we refresh them.

Is this a normal behavior for calc or is it a bug?

Steps to reproduce:

1. Open the attached file "test.ods".
2. Go in sheet "BASE 2017", rename the column "Type" to "Toto".
3. Go in sheet "TCD SUIVI DE MISE EN PLACE" and refresh the table.
4. The column "Type" disappear. 

Operating System: All
Version: 6.1.0.0.alpha0+ Master</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>