While reading an excel cell which has a formula error (#div/0), UiPath calculates -2146826281 (a huge negative number), storing the result in the variable meant for the purpose. Check out the screen shots.
I want to understand if there is a logical reason for that? Is there any effective way to avoid that without changing the formula? by using IFERROR formula in an excel we can have it calculate 0 or any other value if there is an error, but is there any other way from UiPath side so it handles formula error smoothly?
Hey Anil, I didn’t quite catch that. Where should I try changing read formatting? I don’t see any option in studio activity properties if that’s what you meant?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.