HyperFormula Calculation Discrepancies

HyperFormula
1

Hi Team,

We identified two differences between HyperFormula and Microsoft Excel:

  1. COUNT(“”) returns 0 in Excel but 1 in HyperFormula.
  2. HyperFormula evaluates an empty string (“”) as 0 in mathematical operations, whereas Excel returns an error.

Formula:

=IF(IF(SUM(Q_1,Q_2)>0,SUM(Q_1,Q_2),“”)>0, (IF(SUM(Q_3,Q_4)>0,SUM(Q_3,Q_4),“”)/1000000)/ IF(SUM(Q_1,Q_2)>0,SUM(Q_1,Q_2),“”), “”)

Test values: Q_1 = 100, Q_2 = 200, and Q_3 and Q_4 are blank.
Output: Excel throws Error but Hyperformula returns 0

Could you please investigate and confirm whether these are known issues or intended differences? If they are bugs, please consider addressing them in a future release.

2

Hi @aleksandra_budnik here’s Aleksandra from the Support. I replied to your message on the emails, so I will close this thread.