We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

NullReferenceException when opening document with auto-formatted pivot table


I get ‘NullReferenceException’ when opening document with auto-formatted pivot table.

Excel 2010. File format - *.xlsx
Steps to reproduce:
1. Create pivot table with row, column and data field;
2. Set AutoFormat;
3. Set flag PivotTable Options -> Printing -> Set print titles.

I use latest version Aspose.Cells v7.0.3.1.

Thank you,
Alex Shloma


Thanks for reporting and using Aspose.Cells for .NET.

I was able to reproduce the exception using the following code.

We will look into it and fix it asap.

This issue has been logged as CELLSNET-40109.


string path = @“F:\Shak-Data-RW\Downloads\testPivotAutoFormat.xlsx”;

Workbook workbook = new Workbook(path);


Please try the latest fix: Aspose.Cells for .NET v7.0.4.1, we have fixed your issue now.



Yes it’s working.

Thank you,
Alex Shloma

The issues you have found earlier (filed as CELLSNET-40109) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.