Compact Layout for pivot table

Aspose.Cells Product Family
1

Hello.

Which methods or properties are useful to set the different Layouts(like compact,outline and tabular) for Pivot table.

Thanks,

Dmitry.
2
Hi,

Well, to set the layout of the fields in compact, outline or tabular form, please use the following boolean attributes for PivotField.

ShowInOutlineForm --> Indicates whether layout this field in outline form on the Pivot Table view.
If you specify false, it will set in tabular form.
ShowCompact ---> To set in compact form.

You may loop through your desired fields and specify the layouts accordingly.

Thank you.

3
Thank you very much.

But may be you know why "Show in compact form" don't work when PivotTableAutoFormatType is "Classic".
When PivotTableAutoFormatType is "Report6" it is work fine.

Dmitry.
4

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

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

Please add this sample code:

C#


pivotTable.RowFields[i].ShowInOutlineForm = true;


5

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

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