Bug 117853 - The pivot table does not update when renaming a column
Summary: The pivot table does not update when renaming a column
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low enhancement
Assignee: Not Assigned
: 117854 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2018-05-28 13:06 UTC by Salim Habchi
Modified: 2020-07-26 14:07 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:
Regression By:

test file (137.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-05-28 13:06 UTC, Salim Habchi

Note You need to log in before you can comment on or make changes to this bug.
Description Salim Habchi 2018-05-28 13:06:55 UTC
Created attachment 142342 [details]
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: Master
Comment 1 Julien Nabet 2018-05-28 13:16:22 UTC
*** Bug 117854 has been marked as a duplicate of this bug. ***
Comment 2 Jacques Guilleron 2018-05-28 15:24:58 UTC
Hi Salim,
I reproduce with
LO Build ID: 23c5125148a8110d88385b29570bf0b7d4400458
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-05-12_00:15:25
Locale: fr-FR (fr_FR); Calc: CL
LO (Build ID: e183d5b)
so probably inherited from OOo.
Once changed and refreshed, the new name is available, but has to be introduced again into the layout.
Comment 3 Arnaud Versini 2018-05-28 17:53:34 UTC

There is no indication of such behavior in the help, probably a bug.
Comment 4 Michael Meeks 2018-05-28 18:01:52 UTC
Surely this can be improved by adding suitable dependencies on the column titles - but its an enhancement =)
Comment 5 david.vantyghem 2018-05-28 18:41:16 UTC
Same problem with LibreOffice version build 1:6.0.4~rc2-0ubuntu0.16.04.1 under Linux Mint MATE.
I see this as a bug because the goal of a spreadsheet is to automatically update the content of all the cells that are linked to the content of a modified cell.
Comment 6 david.vantyghem 2020-07-16 20:08:04 UTC
Bug still existing in LibreOffice version Version
Comment 7 Arnaud Versini 2020-07-26 14:07:18 UTC
(In reply to david.vantyghem from comment #6)
> Bug still existing in LibreOffice version Version

Thank you David for the confirmation, but the version field is the first with the issue, so we have to keep it to inherited from OOo.