[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 #11 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(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

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