Open jwilder123 opened 1 month ago
Calling RTD-based async functions with volatile inputs is a problem, and I don't have a good 'default' solution for this yet.
Some options:
It's certainly a problem and needs more thought but is a consequence of the Excel-DNA approach to implementing async functions. Not simple . . .
Thanks so much! And thanks for all your efforts on this project! Any chance you can point me to an example of the second approach?
Steps to reproduce:
The results will not be returned. Furthermore, any calls on new workbooks to '=Test(TODAY())' will immediately return 'Hello' (ie: not recalling the function, simply returning the cached result)
` using ExcelDna.Integration; using ExcelDna.Registration;
namespace DNABug { public class Class1 { public partial class Registration : IExcelAddIn { public void AutoOpen() => ExcelRegistration.GetExcelFunctions().ProcessAsyncRegistrations().RegisterFunctions(); public void AutoClose() { }
} `