[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 #20 from ady <adylo811517 at gmail.com> ---
(In reply to Robert Lacroix from comment #19)

> > FWIW, I am not sure that every use-case or user would agree with such
> > change. There may be other use-cases in which the current behavior would be
> > better suited. In the PT's properties dialog, maybe there should be some
> > option in the "Options" area or in the "Source and Destination" area, since
> > there is already an "Add filter" option.
> 
> Agreed. This is what I was thinking about when proposing a "locked"
> property. However it's clear that Excel does not use one. Users who are
> accustomed to the way LO-Calc works now may prefer it, and users who are
> accustomed to Excel may prefer it the other way. I am in the latter camp. So
> this would be better as a global property or compatibility option. 

No global or compatibility option; definitely not.

First, Excel might change its (default) behavior (in some version or in the
rolling 365 target).

Second, and more important, the same user might need one behavior for one
workbook but the other behavior for another workbook, depending on layouts and
use-cases. Someone might even think that this could be different in different
worksheets of the same workbook, or even a different behavior for different PTs
on the same workbook. And there you have it; the option (if implemented) is for
each PT, not global.

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