Created attachment 204805 [details] 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 <tomaz.vajngerl@collabora.co.uk> 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 <tomaz.vajngerl@collabora.co.uk> 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 <tomaz.vajngerl@collabora.co.uk>
Created attachment 204806 [details] XLSX refreshed But, if original file is open in MSO and table refreshed, then I can RT in LO.