EPPlus.Core icon indicating copy to clipboard operation
EPPlus.Core copied to clipboard

Worksheet.Cells[3, 2].Value returns #value!

Open Abedilahhassan opened this issue 8 years ago • 0 comments

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()"

Abedilahhassan avatar Oct 22 '17 15:10 Abedilahhassan