PivotField. ShowCompact. Incorrect property value in *.xls format

Aspose.Cells Product Family
1
Hi,

I've created simple documents with Pivot Table in *.xls and *.xlsx formats. The value of property ShowCompact (RowFields -> 'Product') is equals to 'true' in both documents, but Aspose.Cells returns 'false' for the document in *.xls format.

PivotFieldCollection pfc = pt.RowFields;
for (int i = 0; i < pfc.Count; i++)
{
PivotField pf = pfc[i];
printLine("ShowCompact", pf.ShowCompact.ToString(), SPACE4); // my inner printing method
}

I am using Excel 2010 and Aspose.Cells 7.0.4.1.

Thank you,
Alex Shloma

2
Hi Alex,

I can find the issue as you mentioned by you template XLS file using your code, the property gives False instead of True, it works fine with the similar XLSX file though.
Workbook workbook = new Workbook(@"e:\test2\AsposeShowCompact.xls");
PivotTable pt = workbook.Worksheets[1].PivotTables[0];
PivotFieldCollection pfc = pt.RowFields;
for (int i = 0; i < pfc.Count; i++)
{
PivotField pf = pfc[i];
MessageBox.Show("ShowCompact " + pf.ShowCompact.ToString()); // false
}

I have logged a ticket with an id: CELLSNET-40213. We will look into it soon.

Thank you.
3

Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v7.0.4.3

4

Thank you!!! All works as expected.


Thank you,
Alex Shloma
5

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.