hyperformula

hyperformula copied to clipboard

Docs: Exclude file `api-ref-readme.html` from search results (previously: `api-template.html`)

1

### Description This file shouldn't be in the search results. It is, in fact, duplicated, because it is displayed as `HyperFormula API reference` in the `API reference` section of the...

sequba

### Description Method `moveColumns` does not change the number of columns in a sheet. But when `maxColumns` limit is set tightly, this operation produces error: ``` Error: Sheet size limit...

sequba

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,...

thilgen

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...

thilgen

Calling `setRowsOrder` twice crashes the application

2

### Description A call to `setRowsOrder` might modify sheet dimensions. It is counterintuitive and unexpected.  ### Demo https://codesandbox.io/s/funny-https-h9go7f?file=/src/hyperformulaConfig.js ### Links https://github.com/handsontable/dev-handsontable/issues/440#issuecomment-1455673440 https://handsoncode.slack.com/archives/C04MC750UJW/p1678191576051399 (internal, private channel)

sequba

### Description As @kirszenbaum pointed out in https://github.com/handsontable/hyperformula/pull/1099#issuecomment-1317499945: > We could use an example that shows integration with a CSV parser library (analogically to the ExcelJS example) ### Links #1099...

sequba

### Description There are 2 ways of defining named expressions: - addNamedExpression() function - the last argument of functions `buildEmpty()`, `buildFromArray()` & `buildFromSheets()` ```js const engine = HyperFormula.buildFromArray( [['=FOO']], {},...

sequba

Make `simpleCellRangeToString` work with column ranges and row ranges (before: Convert or Parse strings "A1:B2", "A:A", and "1:2" to Range objects)

5

### Description Hello, I'm trying to convert (parse could also help) strings to ranges and vice-versa for the following range types: - "A1:B2" - "A:A" - "1:2" https://hyperformula.handsontable.com/guide/cell-references.html#range-references I tried...

impauloalves

### Description - TEXT() has a description in built-in-functions guida - TEXT() limitations are mentioned in the runtime-differences guide Both of the above are not accurate enough about the formats...

sequba

`TEXT()` function should support popular currency formats

4

### Description Our implementation of `TEXT()` supports less formats than Excel. We should expand it. Particularly, format `$#,##0.00` should be supported. Alternatively, we can add a config option `stringifyCurrency` similar...

sequba