Bug 160396 - PIVOTTABLE: Row Field's drop down menus missing when last Row Field set to Compact layout
Summary: PIVOTTABLE: Row Field's drop down menus missing when last Row Field set to Co...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2024-03-27 13:14 UTC by Michael Otto
Modified: 2024-07-22 07:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Pivot Table with 3 Row Fields and 1 Column Field (33.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-27 13:14 UTC, Michael Otto 		Details
screen shot to show how I changed to compact layout (157.67 KB, image/png)
2024-04-12 16:36 UTC, Michael Otto 		Details
Pivot-Spielergebnisse-3Row1Col-CompactSpiel3rd (33.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-04-12 16:50 UTC, Michael Otto 		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 Michael Otto 2024-03-27 13:14:57 UTC 
Created attachment 193344 [details]
Pivot Table with 3 Row Fields and 1 Column Field

PRECONDITION:
a Pivot Table with 3 Row Fields and 1 Column Field
(see attached Pivot-Spielergebnisse-3Row1Col.ods)
Row Fields from left to right: Datum, Spiel, Name
Column Field: Platzierung
all Fields in default settings, i.e. Tabular layout

PROBLEM DESCRITION:
if the 3rd Row Field "Name" is changed to Compact layout, 
this shall not change anything because at that position the layout is not relevant
but: the 3 Row Field's drop down menus for Datum, Spiel, and Name are replaced by a single drop down menu "Row Labels" valid for the Row Field Datum
there are no more Row Field's drop down menus for Spiel and Name


Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (de_DE.UTF-8); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2024-04-12 15:04:23 UTC 
Same question as in bug 160397: how do you "change a field to compact layout"?
Comment 2 Michael Otto 2024-04-12 16:36:57 UTC 
Created attachment 193651 [details]
screen shot to show how I changed to compact layout
Comment 3 Michael Otto 2024-04-12 16:39:16 UTC 
See also bug id 160107 with attached file in Compact Layout (where however the date is shown as a number instead of a calendar date)

attached screen shot to show how I changed to compact layout:
- Data > Pivot Table > Insert or Edit... (dialog Pivot Table Layout)
- double click on Row Field "Name" (dialog Data Field)
- Options... (dialog Data Field Options)
- Display Options Layout: select Compact layout
Comment 4 Michael Otto 2024-04-12 16:50:03 UTC 
Created attachment 193652 [details]
Pivot-Spielergebnisse-3Row1Col-CompactSpiel3rd

Pivot Table with 3 Row + 1 Col Fields, with Col Field "Spiel" in 3rd position set to Compact (and there shall not change the layout)
--> the Header contains only 1 menu "Row Labels" although the layout shall still be Tabular layout
Comment 5 Buovjaga 2024-07-22 07:22:36 UTC 
Confirmed.

As mentioned in bug 160397, compact layout was implemented in 2f8d10b0b9baa03b8a713e9fd1342fe6c8094fb4. Let's assume implementationError.

Arch Linux 64-bit
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 180f0c1ec8e195043b5f4298737a219026a8b944
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: CL threaded
Built on 22 July 2024