ReSize a Pivot Table Row

Aspose.Cells Product Family
1

Hi...fantastic product...love it. I've wrestled with this problem for about 3 hours now trying every possible setting that I can with no luck...

On the fly, I create a Pivot Table and add a Row using:

.AddFieldToArea(PivotFieldType.Row,1)

That field for that row contains company names, and there's almost a handful of company names that are super LONG that makes that first column as wide as the name (sometimes a column width of 150+).

Help with 2 questions please...how do I:

1) In code, set the size of the initial, resulting pivot table column to a fixed width of say 50?

2) In code, set the pivot table to not Autofit column widths on update (that's a setting in XL under "PivotTable Options". Of course, the user could manually adjust it, but then it would keep those settings and not Autofit.

Thanks for ANY help...and keep up the great work! Patrick

2

Hi,

Thank you for considering Aspose.

Well, Aspose.Cells will force MS Excel to autofit the size of the columns. That means, currently we don’t provide the option to disable the autofit option for Pivot Tables. The width of the columns will be autofit by using Aspose.Cells.

Thank You & Best Regards,

3

Any chance that makes it to the “Features to Add” list? If you can, that’d be great. Patrick.