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

Free Support Forum - aspose.com

PivotField. Mising AutoShowRange property

Hi,

I can’t find this property in Aspose.Cells.
Could you fix it or show me it, if such property already exists?

Excel Developer Reference
PivotField Object Members
AutoShowRange - Returns xlTop if the top items are shown automatically in the specified PivotTable field; returns xlBottom if the bottom items are shown. Read-only Long.

I use Aspose.Cells v7.0.3.4.

Thank you,
Alex Shloma

Hi,

Thanks for your posting and considering Aspose.Cells for .NET.

Will you please explain the property and in which older version you found it?

Hi,

I mean the following:
Excel 2003.
Field Settings… -> Advanced… -> Top 10 AutoShow -> On -> Show (AutoShowRange.png)

Please also check this link:
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.pivotfield.autoshowrange%28v=office.11%29.aspx

Thank you,
Alex Shloma

Hi,

Please use pivotfield.IsAscendShow property for your need.

Thanks.

Hi,

It’s different properties. ‘IsAscendShow’ - sorting data, ‘AutoShowRange’ - truncating data from top or bottom. I created simple Excel document with samples of using these properties.
Also I attached image with these samples.

Thank you,
Alex Shloma

Hi,


Well, IsAscendSort means to do sorting data and ‘IsAscendShow’ means to select top or bottom data. However, we will look further into your template file and get back to you soon.

Thank you.