Created attachment 190516 [details] Example file from Excel 2016 Attached document contains a pivot table in A8:C14 with a filter field enabled, which is displayed above the table area in A6:B6. There is also some text next to the filter field, and above the table area in C6:C7. This text is visible in Excel, but not in Calc. The same text appears when it's one column to the right of the pivot table area, in D6:D7. 1. Open attached document in Excel and Calc -> In Excel there is some text in the C6:C7 cells, but not in Calc. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7d08767b890e723cd502b1c61d250924f695eb98 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded also back to 4.0, this probably never worked. Turning off the filter field in Excel and saving makes the text in C6:C7 appear.
Created attachment 190517 [details] The example file in Excel 2016 and Calc master
Created attachment 190518 [details] Modified example file without the filter field - looks good in Calc
I think LO doesn't accept any value or cell format on the pivot table area. https://bugs.documentfoundation.org/show_bug.cgi?id=41645 Maybe we can consider this as a duplicate of that one.
(In reply to m.a.riosv from comment #3) > I think LO doesn't accept any value or cell format on the pivot table area. > > https://bugs.documentfoundation.org/show_bug.cgi?id=41645 > > Maybe we can consider this as a duplicate of that one. Gabor: what do you think?
(In reply to Buovjaga from comment #4) > (In reply to m.a.riosv from comment #3) > > I think LO doesn't accept any value or cell format on the pivot table area. > > > > https://bugs.documentfoundation.org/show_bug.cgi?id=41645 > > > > Maybe we can consider this as a duplicate of that one. > > Gabor: what do you think? Hm, that's an interesting bug above, thanks for pointing it out. However, I think this is slightly different. Excel does not consider the C6 cell as "pivot table area" - Calc does (click long on the A6 "Value3" button and it even highlights A6:C6 as one unit!). Since Calc considers C6 belonging to the pivot table, it does not allow pre-existing content or formatting to be imported there. So here I think we should redefine what is considered pivot table area. Adding more filters in Excel makes the pivot area grow upwards, not to the right - so only two columns seem to be needed by the filter.