Pivot table changes when you paste data elsewhere

[vladimirrb]

Read and complete the full issue template

Do not randomly delete sections. They are here for a reason.

Do you want to request a feature or report a bug?

• Bug
• Feature
• Question

Did you test against the latest CI build?

• Yes
• No

If you answered No, please test with the latest development build first.

Version of ClosedXML

e.g. 0.102.2

What is the current behavior?

The workbook contains a pivot table. When I insert data into any cell of any sheet of this workbook, the name of the first column of the pivot table changes, and the filter buttons for the remaining columns disappear.

What is the expected behavior or new feature?

A pivot table should not change when data is not inserted into the data source range of that pivot table

Is this a regression from the previous version?

No

Reproducibility

This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.

Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.

Code to reproduce problem:

public void Main()
{
            string templatePath = @"PivotTest.xlsx";
            string destPath = @"PivotTestChanged.xltx";

            var wb = new XLWorkbook(templatePath);
            var ws = wb.Worksheet("sheet3");            
            ws.Cell(2, 9).Value = "TEST!!";

            wb.SaveAs(destPath);
            Process.Start(destPath);      
}

• I attached a sample spreadsheet. (You can drag files on to this issue)
  
  PivotTest.xlsx
  PivotTestChanged.xlsx