Namespace EasyXLS.PivotTables

Class ExcelCalculatedField

System.Object

EasyXLS.PivotTables.ExcelField

EasyXLS.PivotTables.ExcelCalculatedField

public class ExcelCalculatedField
extends ExcelField

This class stores the formula for a calculated field of pivot table.

Constructor Summary

Constructors

Constructor	Description
ExcelCalculatedField()	Defines an instance of the pivot table field.

Method Summary

Modifier and Type	Method	Description
ExcelCalculatedField	Clone()	Creates and returns a copy of this object.
System.String	getFormula()	Returns the formula of the pivot table field.
void	setFormula(System.String formula)	Sets the formula of the pivot table field.

Methods inherited from class EasyXLS.PivotTables.ExcelField

addSubtotal, getArea, getBaseField, getCustomName, getGroupBy, getGroupEndAt, getGroupInterval, getGroupStartAt, getNumberFormat, getOriginalName, getSortOrder, getSubtotalAt, groupBy, HasNewItemsInFilter, IsGroupAutoEnd, IsGroupAutoStart, IsInsertBlankLine, IsInsertPageBreak, removeSubtotal, setCustomName, setInsertBlankLine, setInsertPageBreak, setNewItemsInFilter, setNumberFormat, setOriginalName, setShowItemLabelsInOutlineForm, setShowItemLabelsInTabularForm, setShowItemsWithNoData, setSortOrder, ShowCompactForm, ShowItemLabelsInOutlineForm, ShowItemLabelsInTabularForm, ShowItemsWithNoData, ShowSubtotalsOnTop, SubtotalCount

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

ExcelCalculatedField

public ExcelCalculatedField()

Defines an instance of the pivot table field.

Method Details

setFormula

public void setFormula(System.String formula)

Sets the formula of the pivot table field. The formula must start with "=" symbol.

Parameters:

formula - the formula of the pivot table field.

See Also:

• getFormula()

getFormula

public System.String getFormula()

Returns the formula of the pivot table field.

Returns:

the formula of the pivot table field

See Also:

• setFormula(System.String)

Clone

public ExcelCalculatedField Clone()

Description copied from class: ExcelField

Creates and returns a copy of this object.

Overrides:

Clone in class ExcelField

Returns:

a clone of this instance.