[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 #25 from Robert Lacroix <muxlab at hotmail.com> ---
(In reply to ady from comment #23)
> As for the space that each PT could take (potentially conflicting with each
> other when the size changes in some way), I would suggest either:
> 
> * using other spreadsheets (in the same workbook) to each PT location
> (instead of multiple PTs in one in-common spreadsheet); or,

The issue of a PT overwriting other content when it expands is a pretty big
concern, but not the biggest one. The killer is that formulae referring into PT
data are not adjusted when the shape of the PT changes. Isolating a PT onto one
sheet by itself does not fix this.

> * each PT should span horizontally (so each can grow vertically if needed)
> and never have their layout overlap on (the same) columns; or,
> 
> * each PT should span vertically (so each can grow horizontally if needed)
> and never have their layout overlap on (the same) rows.

Rows, columns, same issue - unexpected growth of the PT invalidates a formula
which refers to data in the PT.

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