Skip to content
This repository has been archived by the owner on Jan 25, 2019. It is now read-only.

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

Open
Abedilahhassan opened this issue Oct 22, 2017 · 0 comments
Open

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

Abedilahhassan opened this issue Oct 22, 2017 · 0 comments

Comments

@Abedilahhassan
Copy link

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant