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




Posts: 43
Joined: 2016-03-01
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: 17361
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?

Regards from Belarus (GMT+3),

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