[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 #8 from ady <adylo811517 at gmail.com> ---
(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 so that no
> additional values become automatically selected when the pivot table is
> refreshed and new data values are present in the source range.

Please forgive my ignorance... If you don't want the PT to be automatically
updated, perhaps you could copy the content of the PT to a simple table (not in
the sense of Excel's Table, nor as a Pivot Table). I mean, once you built the
structure of the PT, and the data is acquired in order to fill the PT with
content, can't you just copy the result to a simple table? The result of that
copy should be independent of the original data, breaking the relation to the
PT. Is this a valid workaround?

Is this "locked" Pivot Table request available in other spreadsheet tools?

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