We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Enabling Classic Pivottable Layout

Hi Aspose Team,


I would like to create a pivot table that have the
"Classic PivotTable Layout (enables dragging of fields in the grid)"
option enabled. (Screenshot attached)

This is in the Pivot table options.
(Right click on pivot table and select "Pivottable options…"

I am using Excel (Microsoft Office Professional Plus 2010)
Could you please help me how to do this in the dotnet code?

Thanks a lot,

Tamas Vandorffy


Hi,


Please try our latest version/fix i.e., Aspose.Cells for .NET v8.2.1.x and use the boolean attribute IsGridDropZones of PivotTable to set it to true for your needs.

Thank you.

Hi,


Yes, thank you, IsGridDropZones=True is working perfectly!

:slight_smile:

Kind regards,

Tamas

Hi,

Good to know that it works for you. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.