I'm using Aspose.Cells 18.104.22.168.
I have an excel file with a reference problem in one cell. It contains #REF! inside the formula and is evaluated by Excel as #REF! (see attached file excel_error_displayed.png)
I thought the IsErrorValue of Aspose.Cells will help me to detect such kind of problems before reading the celle value.
But the IsErrorValue is false and the StringValue of the cell is "6". (see attached file error_eval_formula.png)
Can you explain if it is normal ?