Chris Thilgen

Wrong result when using `ROW()` function inside a named expression

1

### Description I am seeing unexpected results with Named Expressions. Given an expression ``` const getRowExpression = "=ROW()" ``` And a Named Expression registered on sheet 0 ``` engine.addNamedExpression('GetRowNumber', getRowExpression,...

FORMULATEXT failing when the argument is not a CellReference type

1

### Description This works as expected in Google Sheets and Excel ``` const hyperformulaInstance = HyperFormula.buildEmpty({ licenseKey: 'internal-use-in-handsontable', }); const containerName = 'example' var container = document.getElementById('example') container.hot = new...

Add more info to Building instructions (Node 16 LTS)

1

### Description * After working through https://github.com/handsontable/hyperformula/issues/1166 * I encountered the following error when attempting to `npm run bundle:development` ``` node:internal/crypto/hash:71 this[kHandle] = new _Hash(algorithm, xofLen); ^ Error: error:0308010C:digital envelope...

Add support for HYPERLINK (handsontable)

1

### Context `HYPERLINK` is a formula provided by Google Sheets ([documentation](https://support.google.com/docs/answer/3093313?hl=en)); MS Excel ([documentation](https://support.microsoft.com/en-us/office/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f)); and is included in the Open Document Format for Office Applications ([documentation](http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018226_715980110)) ### For more information...