Excel Adapter very slow with pulling cells linked to other sheets

[Chrisshort92]

Description:

Excel Pull component crashes when trying to pull a cell that references a different sheet to the one included "CellContentRequest".

Steps to reproduce:

Create a cell equation that references a cell on a different sheet.

Set up from Wiki can be used to replicate this

Expected behaviour:

I would expect the value to be extracted correctly through to the BHoM Object.

Test file(s):

https://burohappold.sharepoint.com/:f:/r/sites/BHoM/02_Current/12_Scripts/01_Issue/BHoM/Excel_Toolkit/Issue%2094_Crash%20with%20linked%20cells?csf=1&web=1&e=czHiok

Set up from Wiki can be used to replicate this. the project file has been attached, with just testing [Design Check] sheet and range [A12:F12] shows a bug due to the links to another sheet I assume. This may be due to the type of data being pulled. The value may pull correctly but the equation may throw an error.

[adecler]

@Chrisshort92 , I will need clarifications on this one:

• The image you provide doesn't have any error in it
• This image also doesn't match the link you provided (There is no script in that link but The file name and sheet name are not matching)
• I have tried extracting cells [A12:F12] from the Design Check sheet and it works fine for me although it is quite slow:

Also know that you can just use CellValuesRequest instead of CellContentRequest if that is all you need.

[Chrisshort92]

With CellContentRequest I get this crash;

With CellValuesRequest I get the same;

[adecler]

From a conversation with @Chrisshort92 , we confirmed the pull of linked cells doesn't crash but is extremely slow. Most likely taking time because the whole set of spreadsheets has to be evaluated by the library we're using to extract Excel content. This will be investigated next milestone (8.3).