Excel-DNA / Excel-DNA/ExcelDna

RTD with multiple allow reference args will block caculation

Open
#221 7 comments 0 reactions 0 assignees View on GitHub
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`

```
![image](https://user-images.githubusercontent.com/25994449/49927794-c1691000-fef9-11e8-8883-ed8bb9b87047.png)

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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.