Aspose.Cells produces corrupted pivot table with report filter when saved to XLSB

Aspose.Cells Product Family
1

Please see the attached file (which a simple pivot table with a report filter). The script provides a corrupted XLSB:

var wb = new Workbook(GetFullPath(“sample.xlsx”));
wb.Save(GetFullPath(“result.xlsb”), SaveFormat.Xlsb);

Opened in Excel the report filter does not work and filter icon is shift by one row down (see the attached screenshot).

The issue isn’t observed when saved in XLSX .

Thanks
2

Hi Dmitry,


Thank you for the samples.

We have raised the said issue as CELLSNET-45143 in our bug tracking system for further investigation and correction. Please spare us little time to properly analyze the case and revert back with updates in this regard.
3

Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.02.2 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.02.2 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.

4

The issues you have found earlier (filed as CELLSNET-45143) have been fixed in Aspose.Cells for .NET 17.3.0.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.