Ask Your Question

Calc function "=HERE()" [closed]

asked 2020-08-28 18:59:18 +0200

Olivier gravatar image


I'm looking to write a function named "=HERE()", where when I insert =HERE() in cell B3 I get "B3" as result.

Looks easy for formulate, no to easy to get into the API.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by igorlius
close date 2020-09-08 10:16:30.718087


Do you mean something like this?


JohnSUN gravatar imageJohnSUN ( 2020-08-28 19:14:41 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-08-28 19:05:35 +0200

erAck gravatar image

Use =CELL("address") in B3 => result "$B$3".

Though I didn't get what you mean with "to get into the API".

edit flag offensive delete link more


Oh... That easy! I was looking to get the address from the API such as ThisComponent.Sheet(0).address_where_the_formula_is_and_return_it

Olivier gravatar imageOlivier ( 2020-08-28 19:32:48 +0200 )edit

answered 2020-08-28 21:14:08 +0200

igorlius gravatar image

To only get the requested location (e.g. B3) without the $ one can combine the CELL function with the SUBSTITUTE function like this:


Though this would be good to add here.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

Have a nice day and let's (continue to) "Be excellent to each other!"

edit flag offensive delete link more

Question Tools



Asked: 2020-08-28 18:59:18 +0200

Seen: 91 times

Last updated: Aug 28 '20