Programmming Overview > Supported Formula Functions
For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.
| Formula | Description | |
| ADDRESS(row-number,col-number[,[ref-type][,[ A1-ref-style-flag][,sheet-name]]]) | Creates a cell address, given the specified row and column numbers. | |
| CHOOSE(index,argument-list) | Selects the argument in argument-list that corresponds by position to index. | |
| COLUMN([ reference ]) | Finds the number of the column(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula. | |
| COLUMNS(array) | Finds the number of columns corresponding to array. (Limitations: Only supported for cell references and cell reference ranges.) | |
| ROW([ reference ]) | Finds the number of the row(s) corresponding to reference. If reference is omitted, the behavior is as if reference referred to the cell containing the formula. | |
| ROWS(array) | Finds the number of rows corresponding to array (Limitations: Only supported for cell references and cell reference ranges.) |