https://bugs.documentfoundation.org/show_bug.cgi?id=162417
--- Comment #9 from Robert Lacroix <mux...@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.