# SpreadsheetGetCellFormula

Gets the formula for a for an Excel spreadsheet object cell, or all formulas for the object.

## Method Signature

```
SpreadsheetGetCellFormula(spreadsheetObj=[any], row=[any], column=[any])
```

### Arguments

| Argument         | Type      | Required | Description                                                          | Default |
| ---------------- | --------- | -------- | -------------------------------------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.                                              |         |
| `row`            | `NUMERIC` | `false`  | The row number (1-based). If not specified, returns all formulas.    |         |
| `column`         | `NUMERIC` | `false`  | The column number (1-based). If not specified, returns all formulas. |         |

## Examples

Get a cell formula:

```js
// Retrieve formula from cell
var spreadsheet = SpreadsheetNew();
SpreadsheetSetCellFormula( spreadsheet, 1, 1, "=SUM(A1:A10)" );

var formula = SpreadsheetGetCellFormula( spreadsheet, 1, 1 );
println( formula );  // Output: =SUM(A1:A10)
```

## Related

* [SpreadsheetSetCellFormula()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetcellformula) - Set formula
* [SpreadsheetGetCellValue()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetgetcellvalue) - Get cell value
* [SpreadsheetSetCellValue()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetsetcellvalue) - Set cell value