Go to next empty line with Excel

[anjuna]

Hello,

I have some issue using the action Go to next empty line.
I have one line with "0" as value and Blue Prism gives as a result this cell instead of the next cell with blank value.
I only have this issue with one Excel file. It works properly with other Excel files.

Anyone knows what might be the reason ?

Thank you

 

[Pete_L]

Does the cell in question contain a formula? If so, does the formula reference an empty cell? For example, if the formula in A1 is "=B1" (without the double quotes, of course), and if B1 is blank, A1 will show a 0.