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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 117854 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
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:

Attachments
test file (137.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-05-28 13:06 UTC, Salim Habchi 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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: 6.1.0.0.alpha0+ 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 6.1.0.0.alpha1+ 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
and
LO 3.6.7.2 (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 
Hello,

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 6.0.4.2 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 6.4.4.2.
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 6.4.4.2.

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.