Unable to Generate Excel from a template with Pivot & Filters

[potdarpriyanka]

NPOI Version 2.6.2

File Type - [ ] XLSX

Upload the Excel File

Template.xlsx

Please attach your original Excel File to help us reproduce the issue

Reproduce Steps

I have taken all the logic out of this, simple using a template and creating new excel with it doesn't seem to work
code :

MemoryStream outputStream = new MemoryStream();
using (Stream templateStream = assembly.GetManifestResourceStream(resourceName))
{
IWorkbook workbook = new XSSFWorkbook(templateStream);
workbook.Write(outputStream, true);
outputStream.Position = 0;
}
return File(outputStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "GP-Summary.xlsx");

Issue Description

basically similar to #419 but for filters/ slicers

[tonyqus]

#783 #867

[potdarpriyanka]

#783 #867

@tonyqus - is this fixed then?

we've added slicers to filter pivot tables, is that supported? If i remove the slicers, it works but excel is corrupted if i leave them in the template

[tonyqus]

No. These are related PR, which may causes this issue

[potdarpriyanka]

@tonyqus - are we working on this or have plans to add support for slicers?