Hi,
When I try to read work_sheet.Rows[50].Cells[2].Value, i got null value.(C51), it should be 0.50.
if I clear the C51 contents and reapply the formular, everything is good.
work_sheet.Rows[50].Cells[0].Value and work_sheet.Rows[50].Cells[1].Value shows correct value.
Thanks.
--Shuyang He
Can you post the workbook you are loading that has the problem?