https://bugs.documentfoundation.org/show_bug.cgi?id=170123
Bug ID: 170123
Summary: FILESAVE XLSX with pivot table: desktop MSO does not
open
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, filter:xlsx, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 104839, 112416
Created attachment 204805
--> https://bugs.documentfoundation.org/attachment.cgi?id=204805&action=edit
XLSX
Save attached XLXS with pivot table and reopen in MS.
I could not open in desktop MSO 2021 but could in online.
This is one of many files affected by the following commits.
It used to RT before the first one.
While other commits fixed other files, this one has the above behavior.
There was a bug that some XLSX with pivot tables failed to open in Calc, 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]>
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
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.
