GetNumericFormatAtEx method (Python)

Returns an SpssNumericFormat object from which you can obtain detailed formatting information for a specified data cell, such as the prefix, separator, and suffix for a cell with a custom currency format.

SpssNumericFormat=SpssDataCells.GetNumericFormatAtEx(row,column)

Parameters

row. Row index

column. Column index

The SpssNumericFormat object supports two methods. GetFormatListSize indicates the number of format items available for retrieval--3 if the current cell has a custom currency format, and 1 otherwise. GetFormatStringAt retrieves a specified format item. It takes an integer (zero based) that specifies the index of the format item to retrieve.

GetFormatStringAt(0). If the list size is 3 then the returned value is the prefix of the value in the associated data cell; otherwise the returned value is the same as that returned from the GetNumericFormatAt method.

GetFormatStringAt(1). Returns the separator character of the format for the value in the associated data cell. Only available when the list size is greater than 1.

GetFormatStringAt(2). Returns the suffix of the value in the associated data cell. Only available when the list size is greater than 2.