Bug found in Excel activity "delete row" with custom thousand and decimal separators

Feedback Activities
, , , , ,
1

Hello

I stumbled on this bug by having to delete multiple rows in an .xls file using modern Excel activities.

Under normal conditions, removing multiple rows by inputting “1, 3” for row1 and row3 worked fine, but when I unchecked the “Use system separator” checkbox in Excel Settings (I need to set specific separators for this process) I kept getting an error causing an “Exception from HRESULT: 0x800A03EC”.

image
image822×680 25.5 KB

I solved this issue by separating the “delete row” activity to two different activities, one for each row:

image
image541×649 15.7 KB

Hope this can help.

Bests
Raphael

2

Hi @outofshape

I tried to reproduce the bug but with no luck. I tried with excel activities 2.12.3. and 2.16.0 both working fine.

HRESULT: 0x800A03EC means that you’re trying to access something which can’t be found in excel so I don’t think it might be connected to [Use system separators] option. But that’s an interesting foiunding.

Did it happened once or have you tried running the flow with “1, 3” many times and it always failed?

3

Hello @GT_Ropa and thank you for your answer.

I tried many times last week and it always failed.
I just made another try with “1, 3” just to be sure and it failed as well, then set it back to two separates “delete row” activities and worked just fine.

I am using Excel activities 2.12.3

1 Like
4

Hi @outofshape

Do you maybe have a non-English system locale set?