Macro to automate insert range names and the corresponding range addresses

[srvnrsprm]

There is Sheet -> Named Range and Expressions -> Insert -> Paste All option in calc that allows the user to paste all the named ranges in one column & the corresponding range addresses in another column. This helps one to quickly refer the named ranges.

But the choice needs multiple selections, which i like to automate using a macro. So, I like to write a macro that inserts the named ranges in a range named as XYZ.

And after the display of the table, the macro should pause indefinitely to allow the user to study the table, and after the ENTER key is pressed by the user the macro should erase the range name table.

I have this requirement put up clearly in front of me but zero clues about the calc api that can assist me in doing this. Any help would be really appreciated.

[karolus]

@srvnrsprm

So, I like to write a macro that inserts the named ranges in a range named as XYZ.

should it mean:
»I am looking for a fool to write this macro for me … «
??

@srvnrsprm

And after the display of the table, the macro should pause indefinitely to allow the user to study the table, and after the ENTER key is pressed by the user the macro should erase the range name table.

»… with all the bells and whistles«

~
»»»
Most people find the concept of programming obvious, but the doing impossible.” — Alan J. Perlis
«««

[Lupp]

@srvnrsprm

I have this requirement put up clearly in front of me …

I dare doubt this.
I didn’t use it for many years, but if I now try the Insert>Paste All feature with formulas (or ranges) containing relative references, I get first shown the content as the string given when the named entry was created, but inserted into cells there are the adaptions to the insertion position based on the reference position that was used at creation time. This without any hint.
I don’t think there are too many users uderstanding and regarding the implications.

@srvnrsprm

… but zero clues about the calc api that can assist me in doing this.

There are the tools XRay and MRI.
Calc documents (for the globally accessible elements) and every sheet (for those only accessible from there) have a collection property .NamedRanges supplying the service descibed here.

[srvnrsprm]

i have asked so many questions in emacs.stackexchange forum, answered many. In fact, i hold > 2000 points in that forum, my rank hovering around 150 of all.

Never ever, the knowledged people there have put such a reply. wondering with such an insolent attitude, how you hacked the system to show you 700 likes…

[JohnSUN]

@srvnrsprm

i have asked so many questions in emacs.stackexchange forum, answered many

Yes, this is really so - 65 asked, 13 answered. But if you have been present on such a resource for nine whole years, you should know that the rules of good manners require that you at least hint in the text of the question “I tried this, and another this…" You know how people feel when they just say, “Hey everyone! I need it, give me…”

@srvnrsprm

but zero clues about the calc api that can assist me in doing this

Just install the MRI extension

[karolus]

@JohnSUN

install the MRI extension

just for the yt-tutorial! by @JohnSUN