Hello,
i just discovered the following bug:
When using the “Write Cell” activity with an excel sheet that contains a formula in the same row that is written to, the excel file became unreadable with the “Read Range” activity.
When using the “Write Cell” activity in an excel scope, the file remains readable with the “Read Range” activity.
Testet with UiPath Studio 2020.10.10 and UiPath.Excel.Activities 2.10.4.
Example:
Full sequence:
Files:
Main.xaml (7.3 KB)
Template.xlsx (8.6 KB)
ExcelBugWriteCell.zip (8.7 KB)