[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 #12 from Robert Lacroix <muxlab at hotmail.com> ---
(In reply to Heiko Tietze from comment #11)
> (In reply to Robert Lacroix from comment #9)
> > I checked the behaviour of Excel today. When all values are selected...
> Hard to follow for me. Taking the example from comment 4, Excel completely
> rejects the update. The message is "We couldn't complete the action for...
> because there's already a... there. Make space and try again." 
> 
> We ask and let the user decide to overwrite content.
> 
> STR:
> 
> * load the example that contains these data points
> 
> Col_A Col_B Col_C Col_D   Pivot 1
> A     =rnd()  C   =rnd()  =Sheet1.$A:$B
> A             C
> B             D           Pivot 2
> B             D           =Sheet1.$C:$D
> 
> * add something after A5/B5
> * refresh the pivot table
> => clear message with yes/no actions

Sure, in this example all previous field values are selected in the filter
before refreshing, and the PT tries to expand because new values are added
which also become selected in the filter. LO-Calc is better for asking before
overwriting in this case.

However, it's the behaviour where some of the previous field values are not
selected in the filter. Then no new values should become selected despite being
added onto the filter list with the PT refresh. PT expansion is contingent on
new filter values becoming selected. Excel does not select new values in the
filter when at least one of the filter values is unchecked.

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