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 <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> Commit: Miklos Vajna <vmiklos@collabora.com>
Created attachment 204575 [details] XLSX
Created attachment 204576 [details] XLSX compared Left shown fileopen in LO 24.8 before 1st commit and RT in MSO. Right shown how original looks in MSO and RT file in MSO with 26.2+. (labels are separate issue, rows seeming grouped is this issue).
Created attachment 204578 [details] TEST LBO 26.2 vs MSO 365 LO 26.2.0.0-b1 vs MSO 365 seems the grouping vertical is ok but not in horizontal
The connected XLSX was incorrectly grouped when it was saved and reopened in MSO. Instead of grouping by month, LO offers days. https://soflowheelie-life.io