[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 #27 from Robert Lacroix <muxlab at hotmail.com> ---
You know, there are many things that LO-Calc does better than Excel when it
comes to Pivot Tables.

I loathe navigating PT options in newer Excel. I'm not used to table options
splashed across all manner of dialogs and ribbons.

Excel sacrifices the Grant Totals column, putting a data column there, if
sideways expansion is cancelled because of impending cell overwrite, yet leaves
the "Grand total column" option active. This looks like a bug. They might call
it a feature.

In LO-Calc the field values list contracts to the minimum set after the PT is
refreshed. But in Excel, typos are persistent in the field values list unless
typos are backed out with Ctrl-Z.

I find that what happens when cancelling PT expansion in LO-Calc could be more
consistent. It depends on the context. If cancellation happens because of
activity in the PT Layout dialog (even changing the source range) everything is
nicely returned to the way it was. But if cancelling because of editing source
data, the values list remains updated. Ctrl-Z will undo the data edit but
leaves the values list untouched until the PT is refreshed. But at least it is
returned to minimum on refresh.

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