I want to sum a column from an excel file pasted by the robot in previous activity. I use a write cell activity “=SUM(L:L)” but it is not working due to the cell format in excel (see atached):
The green corner of the cell causes that the sum is 0. If I click manually on the green corner, excel gives me the possibility to convert to number, and it works. But if I convert automatically with the robot the cells to Number, it does not work.
How can I solve this issue?