When adding multpile DataFields based on the same Field, but different Functions to the PivotTable it causes the Excel to crash after opening the file generated in that way.
Smple code:
public void PT()
{
FileInfo fi = new FileInfo(@".\test.xlsx");
ExcelPackage pck = new ExcelPackage(fi);
var ws = pck.Workbook.Worksheets.Add("Data");
var pv = pck.Workbook.Worksheets.Add("Pivot");
ws.Cells["A1"].Value = "Data1";
ws.Cells["B1"].Value = "Data2";
ws.Cells["A2"].Value = "1";
ws.Cells["B2"].Value = "2";
ws.Cells["A3"].Value = "3";
ws.Cells["B3"].Value = "4";
ws.Select("A1:B3");
var pt = pv.PivotTables.Add(pv.SelectedRange, ws.SelectedRange, "Pivot");
pt.RowFields.Add(pt.Fields["Data2"]);
var df=pt.DataFields.Add(pt.Fields["Data1"]);
df.Function = DataFieldFunctions.Count;
df=pt.DataFields.Add(pt.Fields["Data2"]);
df.Function = DataFieldFunctions.Sum;
pck.Save();
}