[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 #10 from Robert Lacroix <muxlab at hotmail.com> ---
(In reply to Heiko Tietze from comment #7)
> (In reply to Robert Lacroix from comment #5)
> > Nope. Tldr; The request is to prevent growth of a pivot table by adding a
> > "locked" attribute to row fields, column fields, and page fields...
> Do you expect this to be applied automatically depending on the surrounding
> cells or is a manual action? How to feed back when content is not appended
> in the pivot table?
> 
> (Adding the topic to the agenda of the design meeting, so we can ponder over
> your ideas next week.)

I was requesting a manual action, but considering how Excel does it I think
that is even better.

As a use case, ponder how management accounting would work. A list of
transactions grows, and you always want a PT to show the current sum of a
subset of the transactions, say for example only "deposit" and "withdrawal" in
the field values, among others. You don't want a new value of the field that
suddenly appears, say "interest", to automatically modify the PT.

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