hyperformula

hyperformula copied to clipboard

### Description Our user reported that HyperFormula initialization for a complex workbook might take 35 minutes to build and consume a few gigabytes of memory. We need to verify it...

sequba

`#SPILL` error should recalculate on changes to result area (before: "Setting a null value in the ARRAYFORMULA expansion area does not update the NoSpaceForArrayResult error[Bug]")

4

### Description The following code does not run as expected ```// Create an empty HyperFormula instance. const hf = HyperFormula.buildEmpty({ licenseKey: "gpl-v3" }); // Add a new sheet and get...

IMSupperkaka

[Bug]: copy+pasting a formula that includes number in exponential format fails with the error "There is no AST with such key in the cache"

1

### Description Attempting to copy+paste a formula that includes exponential notation (e.g. `"=1.25e+5"`) results in the error: `There is no AST with such key in the cache` code to reproduce:...

Andrew-Bx

Add support for INDIRECT

4

### Description INDIRECT: Return a reference given a string representation of a reference Specifically I need this in order to be able to have references to relatively positioned cells without...

jfstephe

`Value of the formula cell is not computed` when batching setCellContents

1

### Description It seems that replacing cell contents that contain a formula at the same address in the same batch results in a `Value of the formula cell is not...

BrianHung

Error `Value of the formula cell is not computed` after call to `addNamedExpression` and `updateConfig`

3

### Description Needs investigation ```js const hf = HyperFormula.buildFromArray([[1, 2, "=A1+B1"]], { licenseKey: "gpl-v3" }); const sheetName = "Sheet1"; const sheetId = hf.getSheetId(sheetName); hf.addNamedExpression("ABC", "=SUM(Sheet1!$A$1:Sheet1!$C$1)"); hf.updateConfig({ maxRows: 100 }); ```...

sequba

### Description Details to be provided by @krzysztofspilka ### Type of issue - [ ] Missing documentation - [ ] Error in the documentation - [ ] Request for a...

sequba

### Description We should investigate, why it happens and prevent it if possible. ### Links https://github.com/handsontable/handsontable/pull/10326 https://github.com/handsontable/hyperformula/issues/1251

sequba

### Description [Types of values guide](https://hyperformula.handsontable.com/guide/types-of-values.html) should contain a section describing what do the cell value types come from. Users are asking about it. ### Links - https://handsoncode.slack.com/archives/C031GBX62SE/p1669010436735579 (internal discussion)...

sequba

### Description Our users ask about it ### Links https://handsoncode.slack.com/archives/C031GBX62SE/p1668695428147239 (internal discussion) ### Type of issue - [x] Missing documentation - [ ] Error in the documentation - [ ]...

sequba