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: UNCONFIRMED
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:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2024-03-27 13:14 UTC by Michael Otto
Modified: 2024-04-12 17:07 UTC (History)
1 user (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

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