Bartek Dudek

So maybe let's transform this issue as a general one collecting all non-translated functions? There will be more of them and it might be the easiest to keep the list...

Note: you can obtain this result by modifying the formulas and using `ISBLANK` function. In your example you can replace `SUM(A1+A2) ` with `IF(OR(ISBLANK(A1),ISBLANK(A2)),"",SUM(A1+A2))`. Btw `SUM(A1+A2)` can be replaced with...

Sorry for missing the discussion!

We should also remember, that this would require revision of the main assumptions of the design of HyperFormula. It seems possible, but we should expect a big change in the...

Even simpler example presenting this issue: ``` it('circular dependency when the IF condition is not met', () => { const engine = HyperFormula.buildFromArray([ ['5', '=IF(A1=0,B1,A1)'], ]) expect(engine.getCellValue(adr('B1'))).toEqual(5) }) ``` as...

Yes, this works. But the problem is when the `IF` cell depends on different cells depending on the evaluation of the expression and only one of them leads to the...

@rackuka, indeed, building the graph is the most time-consuming part of processing the data by HyperFormula. We tried to implement it in as effective way as possible, but we are...