Posted 14 June 2021, 4:54 pm EST - Updated 29 September 2022, 6:33 am EST
Hi,
We found that under some circumstances, the cell value cannot be fetched correctly. Please refer attachment for reproduction(See CalcResult.xlsm).
We have a workbook with following names defined.
_F0101: =Sheet1!$B$2:$C$2
_F0102: =Sheet1!$B$3:$C$3
CalcResult: =EVALUATE(Sheet1!$A$1)
The formula in Sheet!$A$1 is [_F0101*_F0102].
At cell G1 and H1, we are referencing the result of name [CalcResult] using the following formula.
=IFERROR(INDEX(CalcResult,1,1),0)
When workbook is opened in Excel, we can see that G1 and H1 has the correct value 20000 and 120000. But when we try to get the G1 and H1 value using the library, we can only get 0 and 0 due to IFERROR. We are using the latest version V4.1.1 by the way.
We hope that the value should be the same as Excel.
Please help to investigate this issue. Thank you.
Regards