1. Would it therefore be better to convert those UDF's to an add-in? 2. Can I write this add-in in Java? 3. Can you point me in a direction so I can start converting my UDF's to a Java-based add-in? Tx for your help, Ivan If you use Excel and OpenOffice Calc you could take a look at the OpenOffice ...

Just as a side note: The reason why I am interested in this function: The upcomming version of the Excel add-in Obba has the property that if an exception is raised in a Java method, then the cell triggering that exception is printed to the log file. I would like to add this to the OpenOffice port o...

FJCC wrote:The example of ROW() is not relevant, I think, because ROW() requires an argument.

If you use ROW() without argument you get the ROW() of the cell that called the function. Just try it.

There is nothing like Application.caller and the documentation proves my point. But ROW() gets you the row of the calling cell - so there IS an implementation the makes use of some way to get the callers address. Note that I do not need to rely on Basic. It would be sufficient to implement some UNO...

No way. Spreadsheet functions calculate nothing but cell values. http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/AddIn.html I don't see why that implies that I cannot get the callers address. For example, there are functions like ROW() which return the row index of the calling cell. Or...

How do I get the address of the cell which called my (Java) user defined function in a Calc sheet? (So if cell C5 contains the call to MyFunction(..), I would like to get that "C5" inside the Java implementaton of MyFunction. C. PS: In Excel / VBA this can be achived by Application.Caller .