Created attachment 193034 [details]
Pivot-Table in Compact layout with a Row field formatted as Date

When in a Pivot-Table with a Row field formatted as Date 
this Row field is changed to Compact layout, 
this Field is always shown as Standard Format. 
In Tabular layout and Outline layout, the Date Format is fine. 

( might be related to:                                            )
( Calc doesn't save pivot table compact layout to ODS file format )
( https://bugs.documentfoundation.org/show_bug.cgi?id=155073      )
( which however works fine with my file.                          ) 

Version: 24.2.0.1 (X86_64) / LibreOffice Community
Build ID: b4d45829793cddfe67b58a53f495528c75738d8a
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Ubuntu 20.04.6 LTS

in attached example (Pivot-Spielergebnisse.ods)
the Field "Datum" (Source in column A, which is formatted as a Date) 
is shown as number values 45325...45374 
instead of 03.02.24...23.03.24 (dates in DE notation)


same behaviour was found with other Formats: 
Time, or Currecy, or Percentage, or Decimal Number,
they are always formatted Standard in the Compact layout.
No matter as well, without Identify categories (if all values are in place).
No matter as well if this Field is not in column A.
No matter as well, if the Pivot-Table Destination is a separate table.