Use this to automatically rename columns as a pointer data structure. This dialog is activated using the Pointer button on the rename columns dialog. The columns can be named using either numerical suffixes, e.g. A[1], A[2], etc. or using text suffixes where the current column names are included as the labels for the suffixes, e.g. A[‘Y1990’], A[‘Y1991’] etc.
- From the menu select Spread | Column | Rename then click the Pointer button.
Pointer name
Specifies the name that is to be used for the pointer.
Use current column names as text suffixes
When selected, the current column names will be used as the labels for the text suffixes of the pointer.
Numerical indexes
Specifies options when using numerical index for the pointer.
| Start | Specifies the initial number (≥ 0) from which the numerical suffixes start. |
| Increment | Specifies the increment to use for the numerical suffixes. A positive integer (>0) will increase the numerical index by the specified amount. Similarly, a negative integer (<0) will decrease the numerical index by the specified amount. Note that a numerical pointer suffix cannot be negative. |
| Use current names as column descriptions | When selected, the current column names will be used as a column description. |
Columns to rename
Specifies which of the columns will be named using a pointer.
| All | Uses all the columns in the spreadsheet. |
| Selected | Uses the names that are currently selected in the rename columns dialog. Note that names can be selected using the Shift and the up/down arrows or Page Up/Down keys. |
| From current column for | From the name containing the cursor in the rename columns dialog onwards for the number of column names specified in the edit field. |