I have an Error when i try to insert a formula in Excel file with WriteCell Activity.
The formula separe the first two characters for a value of a column.
So the steps are, manually speaking, i need to enter this formula in one cel and the rest of the cells from the same columns are autocompleted.
The error is this:
and for a better understand i send a picture how the excel file look:
The formula is: “=LEFT(D4;2)”