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
I have another issue with the excel.
When I read value for B51, I got 1.02426471. it should be 1.025.
--Shuyang he
I was able to reproduce this issue. It looks like it is not related to the first issue. However, I'm not sure if it can be fixed. It looks like this is caused by a rounding error when calculating another cell's value (B20). When doing multiplication with doubles in the .Net Framework, -1360 * 1.025 results in -1393.9999999999998 instead of -1394, which the ROUNDDOWN function is rounding to -1393. That then causes cell B51 to have the wrong value as well. But it is worth looking into to see if we can mimic Excel's multiplication. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.
Shuyang,
I have submitted this as a development issue. You will receive more information through the support case.
Michael S.