Can''t operate with ranges from different worksheets

[Christian Staffe]

I get this message when trying to open an Excel file with XlsIO. Is it a restriction ? Should I set an option somewhere ? Any workaround ?

Thanks

Christian

[Melba Winshia]

Hi Christian,

Thanks for your interest in Essential XlsIO.

Could you please provide us the template file in which you are able to reproduce the issue [Can't operate with ranges from different worksheets]? It would help us in investigating this issue further.

Thanks,
Melba

[Christian Staffe]

Here is the file, but it's a large one ! In the zip, you'll find a large file with lots of sheets (where you have cross-worksheet references) and a small file that only contains the first worksheet. The small file loads without problems but we get the error on the large one !

Thanks for your help

>Hi Christian,

Thanks for your interest in Essential XlsIO.

Could you please provide us the template file in which you are able to reproduce the issue [Can't operate with ranges from different worksheets]? It would help us in investigating this issue further.

Thanks,
Melba


berekeningsfile ZE3&4 .zip

[Melba Winshia]

Hi Christian,

Thanks for the files.

I was able to reproduce the issue in version 4.4.0.51. However this issue is fixed in our V5. Here is the video clip for your reference:

Exception_video.zip

A beta version of Essential Studio version 5 is now available. You can get the beta version by sending a email request to our sales team ( [email protected] ). Could you please test this issue in our beta version 5 and let us know if you face any issues?

Thanks,
Melba

[Christian Staffe]

Hi Melba

Thanks for your support. It works fine with version 5 Beta indeed !

[Melba Winshia]

Hi Christian,

Thanks for the update.

Glad to hear that it works fine.

Kindly let me know if you have any other questions.

Regards,
Melba