https://bugs.documentfoundation.org/show_bug.cgi?id=162417
Bug ID: 162417
Summary: PIVOTTABLE: Warning does not show range when
overwriting destination range contents
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The destination range is not empty. Overwrite existing contents? [No]/[Yes]
When a pivot table expands into non-empty cells, it is not obvious which pivot
table is generating the warning when multiple pivot tables are in play, and
neither is it obvious whether the warning pertains to cells on the right of
said pivot table or below it, or both, particularly when there are pivot tables
on multiple worksheets and pivot tables are being updated in sequence by a
macro.
I offer 3 levels of solution to this enhancement request. Any level will be
sufficient.
Level 1 solution:
Simply include the address of the offending cell range in the dialog box.
Level 2 solution:
Also indicate whether the offending cell range is right of or below the
existing pivot table.
Level 3 solution:
Include the address of both cells ranges in the dialog box when expansion
pertains to both the vertical and horizontal directions.
--
You are receiving this mail because:
You are the assignee for the bug.
