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

Free Support Forum - aspose.com

PivotTable. Incorrect ranges. (*.xlsb)


I created a simple document with Pivot Table in *.xlsx and *.xlsb format. It’s the same document converted from *.xlsx to *.xlsb by Excel, but Aspose.Cells returns different ranges for Pivot Tables.

ColumnRange = [3, 1, 3, 6]
RowRange = [3, 0, 16, 0]
DataBodyRange = [4, 1, 16, 6]
ColumnRange = [3, 1, 4, 6]
RowRange = [4, 0, 16, 0]
DataBodyRange = [5, 1, 16, 6]
Workbook wb = new Workbook(fName);
foreach(Worksheet ws in wb.Worksheets)
foreach(PivotTable pt in ws.PivotTables)
try { pt.RefreshData(); }
catch { }
try { pt.CalculateData(); }
catch { }
try { pt.CalculateRange(); }
catch { }

printLine(“ColumnRange”, rangeToStr(pt.ColumnRange), SPACE2); // my inner printing method
printLine(“RowRange”, rangeToStr(pt.RowRange), SPACE2);
printLine(“DataBodyRange”, rangeToStr(pt.DataBodyRange), SPACE2);
I use Excel 2010 and Aspose.Cells v7.3.5.1.


Thanks for your posting and using Aspose.Cells for .NET.

We at Aspose wish you a great 2013 year. Please keep us in your good wishes as well.

We were able to replicate this issue using the latest version:

have logged this issue in our database. We will look into this issue
and fix it. Once the issue is fixed or we have some other update for
you, we will let you know asap.

This issue has been logged as CELLSNET-41332.


Please download and try our latest fix/version: Aspose.Cells for .NET v7.7.0.4

We have fixed your issue now.

Let us know your feedback.

Thank you.

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

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