Bug 154197 - Pivot Table with column named "Data" does not show in Data Fields pane -EDITING
Summary: Pivot Table with column named "Data" does not show in Data Fields pane -EDITING
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/countin...
Keywords: implementationError
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2023-03-15 07:22 UTC by Alistair Saywell
Modified: 2023-03-17 00:04 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Spreadsheet including image comparing Properties of pivot table for and (42.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-15 07:22 UTC, Alistair Saywell

Note You need to log in before you can comment on or make changes to this bug.
Description Alistair Saywell 2023-03-15 07:22:11 UTC
Created attachment 185967 [details]
Spreadsheet including image comparing Properties of pivot table for and

A pivot table created from a range including column named "Data" shows nothing in  the Data Fields pane which should show Count - Data2. The pivot table displays the data and will update with Refresh but if Properties opened nothing can be seen in Data Fields. When OK pressed then the pivot table will update to show empty column.

The example pivot table shows Data fields when opened in LibreOffice but not in nor so probably related to Bug 118117. 

Pivot table created in German version of LibreOffice but issue showing in English-UK language version so possible related to Bug 64441

Issue appeared in https://ask.libreoffice.org/t/counting-valid-or-missing-cell-data-based-on-other-column/89239/4
Comment 1 Stéphane Guillou (stragu) 2023-03-15 14:19:29 UTC
I can see the issue in the attachment:

1. Right-click on existing pivot table > Properties...

Result: nothing in "Column Fields" nor in "Data Fields".
However, if you right-click > Refresh the pivot table, the values update and are calculated properly!

If I recreate the pivot table in with:

1. Select 3 columns
2. Data > Pivot table > Insert of edit... > OK
3. Drag "Continent" into "Row Fields"
4. Drag "Data2" into "Data Fields", double-click it to change to "count"
5. Click OK
6. Right-click on new pivot table > Properties...

Result: the properties are still there, works as expected.

Tested in:

Version: / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

So the issue is that pivot tables created in a version prior to the fix for bug 118117 result in *functioning* properties that are not displayed in the dialog in later versions.

Justin, what do you think?
Comment 2 Alistair Saywell 2023-03-15 20:43:17 UTC
Original spreadsheet from Meta.xml was created in LibreOffice/$Linux_ARM_EABI LibreOffice_project
I modified it in just to add image so neither is earlier version.

It was created in German language version so the word displayed in Data fields was "Daten" not "Date". Apparently, it still displays "Daten" in German version, de.DE.

Maybe better to have an error dialogue on creation of pivot table based on a range with a heading using reserved words so the issue could be corrected before the pivot table is created.
Comment 3 Justin L 2023-03-17 00:04:36 UTC
Here is a patch that fixes it: https://gerrit.libreoffice.org/c/core/+/149013

However I am a little reluctant to get involved in this again, since I don't know anything about pivot tables, and they obviously need a lot of work.