hyperformula

hyperformula copied to clipboard

`#REF!` error after adding new sheet

2

### Description The dependency graph needs to be rebuilt sometime between adding new sheet and reading the cell that references it (lazily if possible). The mechanism might be analogous to...

sequba

Using a Named Reference more than once in the same formula throws an "Edge does not exist" error

1

### Description A formula that includes the same Named Reference more than once should work but it actually throws an error of "Edge does not exist". If the ColRow naming...

tommcgrath02

Docs: make it clear that functions accept unlimited number of parameters

2

### Context Internal discussion: https://handsoncode.slack.com/archives/C04MQ954YPL/p1713780506089739 ### Types of changes - [ ] Breaking change (a fix or a feature because of which an existing functionality doesn't work as expected anymore)...

sequba

[Bug]: In a specific combination of adding rows, content, and column amount alteration we get `Uncaught Error` from the `DenseStrategy`

3

### Description In a specific combination of adding rows, content, and column amount alteration we get `Uncaught Error` from the `DenseStrategy`. ### Case 1 - add an empty row below...

AMBudnik

[Bug]: No change event is emitted when the formula changes

14

### Description when i insert/remove row, formula's relative address is change, but no valueUpdateEvent emit, how to listening this event? ```javascript const engine = HyperFormula.buildFromArray([ ['1', '=SUM(A1:A2)'], ['1'], ]) engine.on('valuesUpdated',...

nomind2think

Add unit tests for function `SUM` and operator `^`

1

### Context Unit tests written when analyzing the behavior of function `SUM` and operator `^`. ### How did you test your changes? unit tests pass ### Types of changes -...

sequba

[Bug]: `COLUMN` doesn't work in the array arithmetic mode

2

### Description While trying to use the `ARRAYFORMULA` with `COLUMN` function inside to get the column number based on an if condition it only prints out the first column number...

Azee94

### Description - `returnNumberType` -> `returnType` - `arraySizeMethod` -> `shapeOfResultMethod` - `arrayFunction` -> `enableArrayArithmeticForArguments` **Do not remove the existing props. Mark them as deprecated instead.** ### Links https://github.com/handsontable/hyperformula/blob/master/src/interpreter/plugin/FunctionPlugin.ts

sequba

Add a working example that demonstrates creating a custom function that calls an external API by implementing `GPT()` function - a [GPT API](https://openai.com/product) wrapper. Docs: https://platform.openai.com/docs/introduction Pricing: https://openai.com/pricing Internal discussion...

sequba

[Bug]: Functions do not take null named expressions into account

2

### Description We have found a deviation from Excel where named expressions not set are taken into account in functions. E.g. for the following code: ``` hf.addNamedExpression("a", "=1"); hf.addNamedExpression("b", "=1");...

jboysen