PivotTable. Incorrect Field List 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 Field List visibility.

*.xlsx
EnableFieldList = true
*.xlsb
EnableFieldList = false

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(“EnableFieldList”, pt.EnableFieldList.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: Aspose.Cells
for .NET v7.3.5.2.

We have logged this issue in our database. We will look into this issue further and resolve the issue. 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-41328.

3

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

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