Bug 168800 - Can't give names/aliases to PivotTable data fields / data series
Summary: Can't give names/aliases to PivotTable data fields / data series
Status: RESOLVED DUPLICATE of bug 129088
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2025-10-10 20:16 UTC by Eyal Rozenberg
Modified: 2025-10-11 17:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Some data for creating a PivotTable (10.75 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-10-10 20:16 UTC, Eyal Rozenberg
Details
Screen recording. (1.32 MB, video/mp4)
2025-10-11 17:25 UTC, m_a_riosv
Details
Creating a PivotTable in Calc 26.2 nightly and trying to rename the data series/field (499.44 KB, video/x-matroska)
2025-10-11 17:35 UTC, Eyal Rozenberg
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2025-10-10 20:16:04 UTC
Created attachment 203253 [details]
Some data for creating a PivotTable

Reproduction instructions:

1. Type in some tabular data, at least two columns and two rows (or open the attached file).
2. Select your data.
3. On the menus, choose Insert > Pivot Table...
4. Choose one column and drag it into the "Data Fields" section of the Pivot Table Layout dialog
5. Choose some aggregation function for the new field
6. Try to set the new field's name

Expected results:
There should be some way to set the field name

Actual results:
There is no way to set the field's name. If one double-clicks the data field, a pop-up "Data Field" dialog opens, which shows the field name as a uneditable label.
Comment 1 m_a_riosv 2025-10-10 23:17:13 UTC
https://help.libreoffice.org/6.3/en-US/text/scalc/guide/datapilot_edittable.html?DbPAR=CALC#bm_id3148663

Please take a look at the last paragraph.

I have just tested with
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 11c3d7bb03ab1daa8f14fff076987f65b7e36700
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 Eyal Rozenberg 2025-10-11 07:13:27 UTC
(In reply to m_a_riosv from comment #1)
> Please take a look at the last paragraph.

Looked at that.

When I try to rename by typing over the name, this is reverted, and I get a dialog saying: "You cannot change this part of the PivotTable".
Comment 3 m_a_riosv 2025-10-11 17:25:43 UTC
Created attachment 203276 [details]
Screen recording.

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 11c3d7bb03ab1daa8f14fff076987f65b7e36700
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Maybe you need a refresh of the pt, to get it working.
Comment 4 Eyal Rozenberg 2025-10-11 17:31:52 UTC
(In reply to m_a_riosv from comment #3)
> Maybe you need a refresh of the pt, to get it working.

Refershed, and got the same result. I'll make my own recording. You seem to have been using a different PT than the one I had created in the attached document, maybe that has something to do with it.
Comment 5 Eyal Rozenberg 2025-10-11 17:35:00 UTC
Created attachment 203277 [details]
Creating a PivotTable in Calc 26.2 nightly and trying to rename the data series/field

You will notice there is no possibility to choose a name in the field / data series creation sub-dialog; and that when I try to edit the series name - that's not allowed.

Miguel seems to have renamed a row field, while I want to be able to name data fields (which is at least, if not more, important to be able to rename).
Comment 6 m_a_riosv 2025-10-11 17:37:26 UTC
No possible to select the cell with mouse, go to it with keys.
Comment 7 Eyal Rozenberg 2025-10-11 17:48:11 UTC
(In reply to m_a_riosv from comment #6)
> No possible to select the cell with mouse, go to it with keys.

I'm not sure I understand this sentence... I had no problem selecting any of the cells with the mouse, as you can see in my screen recording.
Comment 8 m_a_riosv 2025-10-11 17:54:54 UTC
Duplicate of TDF#129088, where you have a comment.

*** This bug has been marked as a duplicate of bug 129088 ***
Comment 9 Eyal Rozenberg 2025-10-11 17:58:51 UTC
(In reply to m_a_riosv from comment #8)
> Duplicate of TDF#129088, where you have a comment.

But that field is only about the creation dialog, this is about the fact that you can _never_ rename.

So, we need to either:

* expand that bug or
* make this bug only about renaming by editing label after creation

which do you think is more appropriate?