Only execute formulas with none empty cells

Open julianaiglsdorfer opened this issue 3 years ago • 3 comments

Description

Would be great if you could introduce an option with which you can set that formulas are only calculated if every cell it contains is also filled. So if a cell referenced by the formula is not filled, i.e. empty. The result should also be empty.

Links

https://jsfiddle.net/yj23tf9a/1/

Mar 29 '22 14:03 julianaiglsdorfer

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 A1+A2 ;)

Mar 30 '22 18:03 bardek8

Related discussion: https://github.com/handsontable/hyperformula/discussions/901

Mar 31 '22 09:03 sequba

Sorry for missing the discussion!

Mar 31 '22 09:03 bardek8