How to get callee cell value in XLL UDF

Add-in Express™ Support Service
That's what is more important than anything else

How to get callee cell value in XLL UDF
 
Ashim Mishra


Guest


Hi Team,

I want to get the current caller cell value in my XLL UDF.

I have tried with 


=GetData(p1, p2, p3) {
var callingRange = Module.CallWorksheetFunction(ADXExcelWorksheetFunction.Caller) as ADXExcelRef;
var value = callingRangel.GetValue()

// value is always null

}


But the value is always null, is there any other CallWorkSheetFunction API i can use to get the callee cell value.

Please note that i don't want to use the interop object to get the range using the address in XLL.
Posted 16 Sep, 2020 10:01:53 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Ashim,

You can't get the value of the caller cell as it is being calculated right while your function is called as part of that cell's formula.

You could cache values your function returns to a given cell.

But why would you need this?


Andrei Smolin
Add-in Express Team Leader
Posted 16 Sep, 2020 10:23:34 Top