Ask Your Question
0

How can a Calc macro refer to the cell it was called from?

asked 2020-05-23 00:05:37 +0200

jpaugh gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-05-23 07:21:09 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-23 00:05:37 +0200

Seen: 19 times

Last updated: May 23