PivotTable. Incorrect Grand Total state for row/col. (*.xlsb)

Aspose.Cells Product Family
1

Hi,


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 states for row/col Grand Total.

*.xlsx
ColumnGrand = true
RowGrand = false
*.xlsb
ColumnGrand = false
RowGrand = true

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(“ColumnGrand”, pt.ColumnGrand.ToString(), SPACE2); // my inner printing method
printLine(“RowGrand”, pt.RowGrand.ToString(), SPACE2);
}
}
I use Excel 2010 and Aspose.Cells v7.3.5.1.

Thank you,
Alex Shloma
2

Hi,

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:

We
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-41331.

3
Hi,

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

Your issue should be fixed in it.

Let us know your feedback.

Thank you.
4

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

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