[Bug 162417] PIVOTTABLE: Warning does not show range when overwriting destination range contents

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=162417

--- Comment #24 from Robert Lacroix <muxlab at hotmail.com> ---
(In reply to Heiko Tietze from comment #22)
> You can achieve this with the data field options. To stick with my example,
> showing only two items from top keeps the PT height constant.
> 
> Besides the questionable UX, isn't this what you want? If so, can we discuss
> how to make this feature easier to access (I have to add the row to filters,
> click options in data fields, change settings)?

This is a good try at a workaround, but no. "Show Top N items" does constrain
the PT dimensions, but it has a fatal side effect.

"Show Top N items" selects the N field values which have the greatest total of
their associated data. If a new (unexpected column for example) appears because
of the unconditional setting of the new value's checkbox, then "Show Top N
items" makes a choice among the N+1 columns now available for display and the
lowest one is omitted. So when the new field value has a total which is greater
than any of the others, one of the previously displayed columns is omitted from
the PT and the columns are rearranged in alphabetical order. This is bad news
for any formula which refers into the data in the PT.

-- 
You are receiving this mail because:
You are on the CC list for the bug.