https://bugs.documentfoundation.org/show_bug.cgi?id=162417
--- Comment #25 from Robert Lacroix <mux...@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.
