Asformula receiving #VALUE! error when column is blank

[AllanGMorris]

Hi,

I am receiving an #Value response to a formula when one of the cells is blank.


Book.Sheets[0].asformula[1,1] := 'D1+E1';
sRatePrice := Book.Sheets[0].Calculate(1, i);


When either D1 or E1 is blank I get the error via sRatePrice, if both are valid numerics then the formula calculates as expected.

Thanks
Allan

[larsa]

Hello

I can't reproduce this. Do you have the latest update installed?

[AllanGMorris]

Hi Lars,

I upgraded to the latest version and it all works fine.

Thanks
Allan