11,567 questions
EPPlus Value not extracted after calling calculate function
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETZ%3C/text%3E%3C/svg%3E)
T.Zacks
3,996
Reputation points
I have set formula into cell and after setting formula value is showing when opening the excel file but when i try to get value from the cell where formula has been set then i am getting empty value after using Calculate() function.
my formula looks like IF(E4="","",IF(B4=0,"",IF(E4=0,"",IF(B4="","",IF(B4<0,-(E4/B4-1),(E4/B4-1))))))
when i use calculate function
if (ws.Cells[DeltaPercentagePeriod].Formula != "")
{
ws.Cells[DeltaPercentagePeriod].Calculate();
ws.Cells[DeltaPercentagePeriod].Value //getting empty value
}
where i made the mistake for which i am not getting value ? please help me. thanks
Developer technologies C#
{count} votes
-
Viorel 122.5K Reputation points2021-03-06T16:49:21.483+00:00 In your real code, do you have something like ‘x = ws.Cells[DeltaPercentagePeriod].Value;’ to get and check the value of the cell?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Timon Yang-MSFT 9,606 Reputation points2021-03-08T07:29:38.21+00:00 @T.Zacks
There seems to be nothing wrong with the current code. Could you please provide a more complete code for us to test? -
T.Zacks 3,996 Reputation points
2021-03-08T07:35:30.383+00:00 x = ws.Cells[DeltaPercentagePeriod].Value
yes....value was empty. i was generating excel by EPPlus before saving i was trying to get value from cell after evaluating formula.
Sign in to comment
Sign in to answer