https://bugs.documentfoundation.org/show_bug.cgi?id=167048
Bug ID: 167048
Summary: PIVOTTABLE: display shadow version of changed field
names in layout
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Event: User edits column titles in spreadsheet cells. This changes the field
layout of a pivot table using these titles as field names. The old column
titles no longer appear as fields in the PT layout, so the PT shrinks when it
is refreshed.
Goal: The user wishes to recreate the original PT layout with the new field
names.
Problem: The user may not know/remember/understand which fields go where to
recreate the original PT layout.
Steps to Reproduce:
1. Create a pivot table.
2. Change the title of a column of source data.
3. Refresh the pivot table.
Actual Results:
Pivot table shrinks, losing the dimension of the column that was changed.
Expected Results:
The pivot table does not shrink, and the pivot table field name matches the new
title in the source data.
Reproducible: Always
User Profile Reset: No
Additional Info:
Candidate Solution 1: As suggested by the Summary, display a "shadow version"
of the former PT field names in the layout dialog in theie former location
(filter/row/column/data). The shadow field cannot be moved or removed, but it
will disappear from the layout dialog when the layout is saved, indicating
that the user is satisfied with the modified layout.
Candidate Solution 2: Alternatively, automatically change the PT field names
when the PT is refreshed, substituting new title cell values for old title cell
values. The PT data structure necessarily remembers the source range, so upon
refresh it can replace the field name with the new value.
--
You are receiving this mail because:
You are the assignee for the bug.
