Bug 160396

Summary:	PIVOTTABLE: Row Field's drop down menus missing when last Row Field set to Compact layout
Product:	LibreOffice	Reporter:	Michael Otto <Micha.Otto.de>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal	CC:	stephane.guillou
Priority:	medium
Version:	24.2.1.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=160397 https://bugs.documentfoundation.org/show_bug.cgi?id=160107
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103381
Attachments:	Pivot Table with 3 Row Fields and 1 Column Field screen shot to show how I changed to compact layout Pivot-Spielergebnisse-3Row1Col-CompactSpiel3rd

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