Ask Your Question
1

Calc function "=HERE()" [closed]

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

Olivier gravatar image

Hi

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.

Thanks

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

Comments

Do you mean something like this?

DemoHere.gif

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

2 Answers

Sort by » oldest newest most voted
3

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

Comments

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
1

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

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

=SUBSTITUTE(CELL("Address"),"$","")

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

2 followers

Stats

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

Seen: 58 times

Last updated: Aug 28