mito
mito copied to clipboard
Pivot Table replay edits does not propagate if column headers change
- Create a pivot table
- Add a formula like, LEFT(
value from pivot table column
) - Update the aggregation type of the pivot table
- The formula disappears
This is hard to handle without either adding A, B, C, ... ways of referencing columns or saving the column ids from the original pivot table, re-using them based on index in the pivot table, and saving the formula to use column ids