https://bugs.documentfoundation.org/show_bug.cgi?id=169936
Bug ID: 169936
Summary: FILESAVE XLSX: Pivot table wrong grouping
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, filter:xlsx, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 112416
Report is that attached XLSX has wrong grouping when saved and reopened in MSO.
LO does not group by month, rather offers days.
There is opening issue with labels that is similar to bug 122470.
Here is the history of affecting commits.
While this sample was never correct, it seems worse now compared to before the
initial commit. For that I put regression tag but with normal priority.
There was a bug that some XLSX with pivot tables failed to open in Calc (like
sample from bug 122470), since commit c379168711858664baabe7fa482a4c7dd3bc7891
in 24.8:
author Tomaž Vajngerl <[email protected]> Thu Apr 11
16:31:32 2024
pivot: PivotTableFormatOutput to resolve and set PT cell format
Opening in calc was mainly fixed in 26.2. with
https://gerrit.libreoffice.org/c/core/+/193845
commit 5aaedc8c6accb93475c0e83b1fac4cc9bb76c43d
Author: Tomaž Vajngerl <[email protected]>
AuthorDate: Wed Nov 12 18:59:58 2025
Additionally opening in MSO after saving was fixed in 26.2 with
https://gerrit.libreoffice.org/c/core/+/193998:
commit 81d59ec3770b841b9c44f33c91e0d9360e1773e2
sc: fix crash in pivot table with formats and no source data
Author: Tomaž Vajngerl <[email protected]>
Commit: Miklos Vajna <[email protected]>
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX (OOXML) pivot table bugs
--
You are receiving this mail because:
You are the assignee for the bug.
