aspose.cells

Property Getters/Setters Detail

• isHidden/setHidden : boolean 

  function isHidden() / function setHidden(value)
  

  Gets and Sets whether the pivot item is hidden.

• getPosition/setPosition : Number 

  function getPosition() / function setPosition(value)
  

  Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.

• getPositionInSameParentNode/setPositionInSameParentNode : Number 

  function getPositionInSameParentNode() / function setPositionInSameParentNode(value)
  

  Specifying the position index in the PivotItems under the same parent node.

• isHideDetail/setHideDetail : boolean 

  function isHideDetail() / function setHideDetail(value)
  

  Gets and Sets whether the pivot item hides detail.

• isFormula/setFormula : boolean 

  function isFormula() / function setFormula(value)
  

  Indicates whether this pivot item is a calculated formula item.

• isMissing : boolean 

  function isMissing()
  

  Indicates whether the item is removed from the data source.

  True means this value has benn removed from the data source.

• getValue : Object 

  function getValue()
  

  Gets the value of the pivot item

• getName : String 

  function getName()
  

  Gets the name of the pivot item.

• getIndex/setIndex : Number 

  function getIndex() / function setIndex(value)
  

  Gets the index of the pivot item in cache field.

Method Detail

• hide

  function hide(value)

  Sets whether the pivot item is hidden.

  NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Pivot.PivotField.HideItem method. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

• move

  function move(count, isSameParent)

  Moves the item up or down

  Parameters:

  count: Number - The number of moving up or down. Move the item up if this is less than zero; Move the item down if this is greater than zero.

  isSameParent: boolean - Specifying whether moving operation is in the same parent node or not

• getStringValue

  function getStringValue()

  Gets the string value of the pivot item If the value is null, it will return ""

• getDoubleValue

  function getDoubleValue()

  Gets the double value of the pivot item If the value is null or not number ,it will return 0

• getDateTimeValue

  function getDateTimeValue()

  Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue