RowAxisLayout support in Aspose.Cells Pivot tables

Aspose.Cells Product Family
1

There is a way, or is in plan a support in the near future, to create a Pivot Table with RowAxisLayout property set to xlCompactRow excel value ?
We are using Aspose.Cells 4.8.0.0 for creating Excel 2007 PivotTable reports

Thanks in advance,

2

Hi,

Could you create a sample pivot table manually in MS excel with details or screen shots, post the file here to show your requirement, we will check it soon.

Thank you.

3

Thanks for your reply. I’ve solved myself:

for(int i = 0;i<pivotTable.RowFields.Count;i++)
{
PivotField f = pivotTable.RowFields[i];
f.ShowCompact = true;
f.ShowInOutlineForm = true;
}

In Excel there is a PivotTable property (RowAxisLayout) that obtain the same result

Regards