Extracting Cell Value

I am having trouble extracting the display value of a cell in excel that is provided by a formula. The cell looks like this -

image

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 -

image

I have tried ticking “Preserve Format” but that doesn’t seem to make any difference.

Resolved by using new activities

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.