[Libreoffice-bugs] [Bug 130829] XLSX: Pivot Table has two-row headings while in Excel there is only one row, thus causes interoperative issues when formulas are referenced to the pivot table data
https://bugs.documentfoundation.org/show_bug.cgi?id=130829 --- Comment #6 from Simon Dedman --- Bumping this - I just had a sheet shared from a friend and warned him there's an issue in his calcs not lining up; transpired it's from LOCalc mangling it when it works fine in Excel. If this is still not supported, that it what it is, but this is potentially a serious point of cross-platform failure (and thus another stick to beat Linux with). Therefore please could this be prioritised to be fixed if now fixable, or, in the interim (either if not fixable or if fixable with a load of work and thus a load of time), can we have something that alerts the user, rather than silently corrupting the data? Proposals: 1. data & headers in right place but static pasted, not dynamic. Whole pivot section has a comment around it with the generic warning inc pointing to this bug URL. 2. whole pivot section replaced with a block of red background. Each cell or whole section has the same comment per 1. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130829] XLSX: Pivot Table has two-row headings while in Excel there is only one row, thus causes interoperative issues when formulas are referenced to the pivot table data
https://bugs.documentfoundation.org/show_bug.cgi?id=130829 --- Comment #5 from Aron Budea --- This pivot table is in compact form (hinted by the text "Row Labels" in the dropdown), which, as far as I know is not yet supported in Calc. https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130829] XLSX: Pivot Table has two-row headings while in Excel there is only one row, thus causes interoperative issues when formulas are referenced to the pivot table data
https://bugs.documentfoundation.org/show_bug.cgi?id=130829 Kevin Suo changed: What|Removed |Added CC||zolnaitamas2...@gmail.com --- Comment #4 from Kevin Suo --- Tamás Zolnai: I see you have worked on fixing bug 112733. Maybe you are interested in this one? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130829] XLSX: Pivot Table has two-row headings while in Excel there is only one row, thus causes interoperative issues when formulas are referenced to the pivot table data
https://bugs.documentfoundation.org/show_bug.cgi?id=130829 Kevin Suo changed: What|Removed |Added Summary|XLSX: Pivot Table has two |XLSX: Pivot Table has |rows heading instead one|two-row headings while in |row |Excel there is only one ||row, thus causes ||interoperative issues when ||formulas are referenced to ||the pivot table data -- You are receiving this mail because: You are the assignee for the bug.