https://bugs.documentfoundation.org/show_bug.cgi?id=162417
--- Comment #16 from ady <adylo811...@gmail.com> --- (In reply to Robert Lacroix from comment #13) > > In LO-CALC: > - The pivot table expands to A1:B5 > - Total Result value in B5 becomes 37.1 > - A new row appears in the pivot table containing "interest". > - The XACTION field dropdown shows the new value "interest" as checked. > > In Excel: > - The pivot table does not change dimensions > - Total Result value in B5 remains 37 > - The XACTION field dropdown shows the new value "interest" as unchecked. That means that the refresh in Calc added the items to the Filter as "checked" (not hidden, not filtered out), whereas Excel adds the items to the Filter as "unchecked" (i.e. filtered out). Please correct me if I'm wrong. > > - LO-Calc's current behaviour when a pivot table's dimensions change is > better than Excel's and should remain as-is, as you describe. So, you currently prefer that newly-added data items in the original data table would be set as "shown" (not hidden) in the filter of the PT when the PT is refreshed, as already done by Calc. No changes here. > > - I want Excel's behaviour for addition of new field values when some field > values are already unchecked before the pivot table is refreshed. This > should apply to row fields and column fields, and also to page fields for > consistency (although new field values do not affect table dimensions). In your example, you added a new row of data, which impacts the Filter (with the differences against Excel as described above, "shown" vs "hidden"). But now you are mentioning other fields of the PT (which is not the same as adding data). I am possibly misunderstanding, and I am also looking for an actual concise reply to the questions I presented in comment 8: * If you want a non-changing resulting table, can't you just copy the content of the PT to another simple table, in order to "disconnect" the (pasted) result from the original data? * How Excel manages (or achieves) the suggested "locked" status? Again, I might be misunderstanding the real goal or the real meaning of this "locked" expression – an expression that is so ambiguous that should be avoided anyway. -- You are receiving this mail because: You are on the CC list for the bug.
