I'm working on a .NET 3.0 C# app for a client. I started the project with Aspose.Cells 4.7 and all of my unit tests pass. The client upgraded to 4.8 so I recompiled my app with that version. Now, some of my unit tests are failing.
I've narrowed down the problem to a statement where I'm attempting to compare cell values across Cells objects. With version 4.8, the second part of this statement is generating #REF!.
if (expenseCells[TEMP_FORMULA_CELL].Value.ToString() != invoiceCells[excelInvoiceCellMetadata.GetExpenseTotalCellLocation()].Value.ToString())
Again, this worked fine in 4.7.
While debugging, I tried replacing the value in brackets with a known valid cell ("U20") but still get #REF!.
Why in version 4.8 is a valid cell now considered an invalid reference? Please reply with some ideas on this.