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.
Created attachment 201738 [details] video demo of problem: column disappears in PT when title changes in source Thanks to https://wiki.debian.org/DebConf/25 DebCamp attendees for making this video.