EPPlus.Core
EPPlus.Core copied to clipboard
Worksheet.Cells[3, 2].Value returns #value!
I am using the Worksheet and the workbook and calling the calculate() method for every sheet and for the workbook:
foreach (var worksheet in eppWorlSheets)
{
worksheet.Calculate();
}
this.eppWorkBook.Calculate();
When trying to get the value of some calculated cells that contains double it returns #value! as a string using the below code
Worksheet.Cells[3, 2].Value.ToString());
Even the Text property return #value! and the Value property without "ToString()"