asposecells.api

asposecells.api

Class PivotShowValuesSetting

Represents the settings about showing values as when the ShowDataAs calculation is in use.

Property Getters/Setters Summary
methodgetBaseFieldIndex()
method
setBaseFieldIndex(value)
           Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
methodgetBaseItemIndex()
method
setBaseItemIndex(value)
           Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.
methodgetBaseItemPositionType()
method
setBaseItemPositionType(value)
           Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute. The value of the property is PivotItemPositionType integer constant.
methodgetCalculationType()
method
setCalculationType(value)
           Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFormat integer constant.
 

    • Property Getters/Setters Detail

      • getCalculationType/setCalculationType : int 

        int getCalculationType() / setCalculationType(value)
        Represents how to show values of a data field in the pivot report. The value of the property is PivotFieldDataDisplayFormat integer constant.PivotFieldDataDisplayFormat

      • getBaseFieldIndex/setBaseFieldIndex : int 

        int getBaseFieldIndex() / setBaseFieldIndex(value)
        Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.

      • getBaseItemPositionType/setBaseItemPositionType : int 

        int getBaseItemPositionType() / setBaseItemPositionType(value)
        Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute. The value of the property is PivotItemPositionType integer constant.PivotItemPositionType

      • getBaseItemIndex/setBaseItemIndex : int 

        int getBaseItemIndex() / setBaseItemIndex(value)
        Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.