CellText Objects (R)

CellText objects are used to create a dimension category or a cell in a pivot table and are only for use with the BasePivotTable class. The following object types are available:

  • CellText.Number: Used to specify a numeric value.
  • CellText.String: Used to specify a string value.
  • CellText.VarName: Used to specify a variable name. Use of this object means that settings for the display of variable names in pivot tables (names, labels, or both) are honored.
  • CellText.VarValue: Used to specify a variable value. Use of this object means that settings for the display of variable values in pivot tables (values, labels, or both) are honored.