BHoM / BHoM/Excel_Toolkit

Excel Adapter very slow with pulling cells linked to other sheets

Open
#94 3 comments 0 reactions 2 assignees Claimed by @adecler View on GitHub
type:bug
Dominant language
C#
Stars
0
Forks
3
Avg merge
1d 2h
Merged PRs (30d)
1

Description

#### 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

![Image](https://github.com/user-attachments/assets/3394b121-419e-44f3-910e-7557b042e5ae)

#### 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.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.