You are right that when I open it in excel it works, however the problem is from within Aspose.Cells when I check the cell value (cells[“C1”].Value) it returns #VALUE!.
I need to have the resulting value by checking the cells[“C1”].Value
I was able to replicate the problem using the code below. Please see the output at the end of this post.
We have logged this issue in our database. We will look into this issue and once the issue is resolved or we have some other update for you, we will let you know asap.
however when trying to use the new update I get a license error:
The subscription included in this license allows free upgrades until 16 Mar 2012, but this version of the product was released on 14 Jun 2012. Please renew the subscription or use a previous version of the product.