PivotTable. Incorrect 'Show the Values row' state. (*.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 ‘Show the Values row’.

*.xlsx
ShowValuesRow = false
*.xlsb
ShowValuesRow = 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(“ShowValuesRow”, pt.ShowValuesRow.ToString(), SPACE2); // my inner printing method
}
}

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 were able to replicate this issue using the latest version:

We have logged this issue in our database. 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-41329.

3
Hi,

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..
4

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

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