Bug in AutoFit Column Activity of Bala Reva

Dear @balupad14,

I’m using AutoFit colums activity, this activity works fine when the given sheet name exist in excel. But it pops up message box with message ‘Invalid Sheet Name’ when the given sheet name doesn’t exist in the excel. So can you please fix this issue.

BalaReva.Excel.Activities version is 2020.2.1

image

Thanks In Advance :hugs:,
Ahmed

1 Like

Hi @Ahmed_Nizamuddin,
I think you should tag @balupad14 here :wink:

@balupad14,
Hi :slight_smile: Could you assist here?

1 Like

Hi @Ahmed_Nizamuddin,

You didn’t show the properties of the Autofit columns. Check it the sheet is exist or not.

Here I have attached a sample for you.

Before :

After :

Properties :

Sample :

AutofitColumn.zip (29.5 KB)

Thank you @Pablito

Regards
Balamurugan.S

1 Like

@Pablito thank you for helping us to reach out him.

@balupad14, thanks for the quick response,

Here we were performing some negative-test on this activity before using it, we found that it is popping up the message box with above mentioned error.

The error is not our concern, but the message box. Usually whenever some error occurs in any activity, it logs the error message in console and stops the execution of the process.

If we are using this activity, the process won’t end if there is a message box due to any error.

Please Advice.

Thanks :hugs:,
Ahmed

2 Likes

Really I thank you very much @Ahmed_Nizamuddin. Like you, we are getting a boost for component development. It is a very good encouragement for providing feedback about components. I have added the “ContinueOnError” property in all components of this package. When setting it as true, It will not throw the exception. I have updated the package.

Regards
Balamurugan.S

1 Like