EPPlus Value not extracted after calling calculate function

T.Zacks 3,986 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].Value  //getting empty value                 


where i made the mistake for which i am not getting value ? please help me. thanks

An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,640 questions
{count} votes