Remove a Pivot Field

Aspose.Cells Product Family
1

How to remove a pivot field from the basefield collection?

Something like this, pivottable1.basefields.remove(index) or pivottable1.basefields[index].remove()

We have provision for adding, but couldn't find any properties or methods for deleting it.

Regards,

Pradeep

2

Hi,

I have logged it with an id: CELLSNET-21258. We will soon look into your requested feature and get back to you soon.

Thank you.

3

Hi,

Hopefully your issue would be fixed in the next version of the product.

Thank you.

4

Hi,

<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
<w:UseFELayout/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–><span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”;”>Please try the attached version. We have supported it in the latest v5.1.4.7 (attached).
Sample code:


pivotTable.RemoveField(PivotFieldType.Row, “a”);

pivotTable.CalculateData();



Thank you.


5

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

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

Hi,

We already notified you that we supported your desired feature from v5.1.4.7.
Anyways, <span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”;”>please try our latest version v5.3.1.4.
Sample code:


pivotTable.RemoveField(PivotFieldType.Row, “a”);

pivotTable.CalculateData();



Thank you.