Summary: | FILEOPEN XLSX Pivot table filter field hides text next to it | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Gabor Kelemen (allotropia) <kelemeng> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | ilmari.lauhakangas, miguelangelrv |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 112416 | ||
Attachments: |
Example file from Excel 2016
The example file in Excel 2016 and Calc master Modified example file without the filter field - looks good in Calc |
Description
Gabor Kelemen (allotropia)
2023-10-30 16:47:30 UTC
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. |