The Read Range activity returns an empty value if the cell contains formulas

When using the Excel.Activities package v 2.16, the Read Range Workbook activity returns empty value if my cells have formulas inside. How can i fix that?

Issue Description

When using the Excel.Activities package v 2.16, the Read Range Workbook activity returns an empty value if the cells have formulas inside.

Resolution

To solve that, downgrade the Uipath.Excel.Activities to 2.12.3 or lower.

This is a known bug affection versions 2.14.0, 2.16.0, 2.16.1 of the Excel.Activities package and it is currently being investigated by UiPath.