Bug 164300 - PIVOTTABLE: Layout dialog does not show entries for calculations
Summary: PIVOTTABLE: Layout dialog does not show entries for calculations
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2024-12-12 12:51 UTC by Olivier Hallot
Modified: 2024-12-12 15:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Olivier Hallot 2024-12-12 12:51:34 UTC 
The Pivot Table layout dialog on a new pivot table does not show entries in the Data field.

Therefore no calculation is performed and no choice of function is possible.

See image attached.

Steps
1) get data for a pivot table
2) Insert > Pivot Table
3) choose selection
4) PT layout dialog opens

Actual results: Dialog does no show operations in Data Fields box

Expected results: Show at least one operations.
Comment 1 Olivier Hallot 2024-12-12 12:55:04 UTC 
Note: When opening an existing PT for edition, the existing Data fields operations are present.

If you rebuild the PT from scratch, the Data Fields ops are inaccessible.
Comment 2 Buovjaga 2024-12-12 14:26:51 UTC 
I'm not sure I understand, but if I drag from Available Fields to Data Fields, I get the listing like "Sum - Fieldname" and by double-clicking I can change the function.

Can you explain a bit more what you mean?

Arch Linux 64-bit
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
24.8.3-1
Calc: threaded
Comment 3 Buovjaga 2024-12-12 14:28:07 UTC 
Note that there is a catch, you can't use a column named Data before this bug is fixed: bug 154197. Were you by any chance using such a name?
Comment 4 Olivier Hallot 2024-12-12 15:18:49 UTC 
You're right.
Closing as invalid.