I am having trouble extracting the display value of a cell in excel that is provided by a formula. The cell looks like this -
The formula in that cell is - “=D10-Deposit_Ledger_2[@[Deposit Ledger]]”
When I use the UiPath.Excel.Activities.ReadCell activity I get “1.6370904631912708E-11” which I assume is the real value of the formula.
I’m not sure why it isn’t extracting the expected “0.00” value.
Properties of read cell activity -
I have tried ticking “Preserve Format” but that doesn’t seem to make any difference.