Excel-DNA / Excel-DNA/ExcelDna
RTD with multiple allow reference args will block caculation
- Dominant language
- C#
- Stars
- 1.5k
- Forks
- 292
- Avg merge
- 20d 12h
- Merged PRs (30d)
- 1
Description
```fsharp
let mutable count = 0
[]
let eval ([] input: obj,[] codeRef: obj) =
async {
do! Async.Sleep(1000)
count <- count + 1
return "Hello" + count.ToString()
} /// Also not worked for `Async.StartAsTask`
```

the `A1` is only caculated once
after change `B1` number
`A1` doesn't change to "Hello2"
This issue doesn't exist when (only one allow reference arg) or running in synchronization mode
Contributor guide
Research direction
Start by reproducing the reported F# sample with two AllowReference arguments in asynchronous mode, then compare it with the one-reference and synchronous cases described in the issue. Trace why changing B1 does not recalculate A1; done means the multiple-reference case recalculates and returns the updated result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, fsharp
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100