I have a LO BASIC function which should retrieve data from another cell, where the column is calculated, but the row should be the same as the row of the current cell.
In VBA, this is stored in Application.Caller. Is there an equivalent for LO?
No spreadsheet function looks into “another cell, where the column is calculated, but the row should be the same”. Think of SUM, or LOOKUP, or … . All of them look into cells/ranges passed as arguments. And that’s enough for operation.
The current cell address is not available to the macro-defined spreadsheet function.