GetReferredFootnotesAt Method (Python)

Returns an SpssFootnotes object, which allows access to all the footnotes referred to by the specified data cell.

• The footnotes array is a subset of the Footnotes object you can get from the pivot table. You can manipulate the subset using the same properties and methods, but the index of a footnote in this array is in no way related to the index of the same footnote when accessed from the pivot table.

Syntax

SpssFootnotes=SpssDataCells.GetReferredFootnotesAt(row,column)

Parameters

row. Row index

column. Column index

Example

This example gets the footnotes associated with the cell in the first row and first column of the data cell array and sets the text color and text style of the first footnote (index value 0) to red and bold respectively. It assumes that PivotTable is an SpssPivotTable object.

DataCells = PivotTable.DataCellArray()
Footnotes = DataCells.GetReferredFootnotesAt(0,0)
Footnotes.SetTextStyleAt(0,SpssClient.SpssTextStyleTypes.SpssTSBold)
Footnotes.SetTextColorAt(0,255)