CodePlexProject Hosting for Open Source Software
Hi is it possible to get the value for a formula for a range?
workSheet.Cells[1,1].Value returns blank ("") when the cell has a formula i.e. a reference to another cell.
Is it possible to get the value of the formula?
No, there is no calculation engine in EPPlus. You have to open the workbook in Excel to get the value.
Thanks Jan for the reply.
If others have the same question:
Open the workbook. Select the cells. Copy and paste values (not normal paste).
Are you sure you want to delete this post? You will not be able to recover it later.
Are you sure you want to delete this thread? You will not be able to recover it later.