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 was able to reproduce the issue with a test project. A bug work item has been created so the team can take a look into the issue (#76587).
Torrey
Hi
Thanks a lot for quick response! By clear the contents and reapply formula, I can get the correct value. But it's very difficult to ask user to have this workaround. They would prefer to avoid this issue when they first create xsl file? Do u have any suggestion?
--Shuyang he