https://bugs.documentfoundation.org/show_bug.cgi?id=157989
Gabor Kelemen (allotropia) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #5 from Gabor Kelemen (allotropia) <[email protected]> --- (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. -- You are receiving this mail because: You are the assignee for the bug.
