https://bugs.documentfoundation.org/show_bug.cgi?id=160107
Bug ID: 160107
Summary: FORMATTING: Pivot Row field with Compact layout
supports only Standard Format
Product: LibreOffice
Version: 24.2.0.1 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 193034
--> https://bugs.documentfoundation.org/attachment.cgi?id=193034&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
