Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
20
No value when reading cell with formula
posted

Hi.

 

I use the attached excel with the fallowing code:

            var wb = Workbook.Load(@"c:\S6.xls");
            var ws = wb.Worksheets[1];         
            var value = ws.Rows[38].Cells[8].Value;

This read the Value out of Cell I39. In this Cell, there is the formula =G39/35 and when I open the xls direct in excel, there is the value 0.97.

When I read it with the code above, I get for the value {#NAME?}. Can someone help me, why this happens? - Thank you.

 

Best Regards, Thomas

S6.zip