[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 #9 from Robert Lacroix <muxlab at hotmail.com> ---
I checked the behaviour of Excel today. When all values are selected, the
field's "Select All" checkbox becomes checked (or conversely, selecting every
item causes Select All to become checked automatically), and in this state new
values of the field upon PT refresh are added automatically to the field's
values list, like LO-Calc does, so the PT grows. However when one or more
values are unselected, new values do not become automatically selected upon PT
refresh, in effect opposite to LO-Calc behaviour.

I want to have the Excel behaviour, not for the sake of compatibility, but
because it just makes sense from a use-case POV. If I select only certain
values to be summarized by the PT, I do not want extraneous new values to
pollute my selection list. Growing the table is just undesireable side effect
in this case, one we are prepared to deal with if we want all values selected.

The Select All checkbox in the field is a 3-state checkbox. When there is a mix
of checked and unchecked values, the Select All checkbox shows a filled square.
The field's heading cell also contains a small indicator to say multiple
selections are active (I believe, have not verified).

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