PivotField. Incorrect state of the sorting fields. (*.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 state for the sorting in row fields.
RowField - ‘Product’
*.xlsx
IsAscendShow = true
IsAscendSort = false
IsAutoShow = false
IsAutoSort = true
*.xlsb
IsAscendShow = false
IsAscendSort = true
IsAutoShow = true
IsAutoSort = false

PivotFieldCollection pfc = pt.RowFields;
for (int i = 0; i < pfc.Count; i++)
{
PivotField pf = pfc[i];
// my inner printing method
printLine(“IsAscendShow”, pf.IsAscendShow.ToString(), SPACE4);
printLine(“IsAscendSort”, pf.IsAscendSort.ToString(), SPACE4);
printLine(“IsAutoShow”, pf.IsAutoShow.ToString(), SPACE4);
printLine(“IsAutoSort”, pf.IsAutoSort.ToString(), SPACE4);
}

I use Excel 2010 and Aspose.Cells v7.3.5.1.

Thank you,
Alex Shloma
2

Hi,


Thanks for providing us the template files and sample code.

After an initial test and using your code with your template XLSB file, I have managed to reproduce the issue as you have pointed out. I have logged a ticket with an id “CELLSNET-41361” for your issue. We will look into your issue soon.

Thank you.
3

Hi,

Thanks for using Aspose.Cells for .NET.

Please download and try this fix: Aspose.Cells for .NET v7.7.0.4 and let us know your feedback.

4

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

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