Apache OpenOffice (AOO) Bugzilla – Issue 120004
Feature request: Allow identification of calling cell in (Java) UNO add-in (like Application.Caller in Excel/VBA).
Last modified: 2014-01-09 12:33:25 UTC
It should be possible that a (Java) (UNO) add-in function determines the calling cell (sheet name, row and column) similar to Application.Caller in VBA. Note that there are already build-in spreadsheet functions, which perform such a task (like ROW() and COLUMN()), but afaik there is no method that an add-in function can find out s.th. about the calling cell.
Note: This is also a question on stack overflow, see details there: http://stackoverflow.com/questions/17637601/ooo-libreoffice-uno-java-how-to-get-calling-spreadsheet-cell-of-a-calc-functi