Hi:
I am new to OO Basic and Calc, so forgive me if I ask a very simple question.
What I would like to know is if there is a Method or Property that will give me the address of the current Cell in A1 format. Nothing in the Documentation that I have seen seems to mention any such facility.
Thanks for any help you can afford me.
Regards,
skp49
[Solved] Cell address in A1 format
[Solved] Cell address in A1 format
Last edited by Hagar Delest on Mon Jul 24, 2017 2:40 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Open Office 4.1.3 on Windows 7 Professional 64 bit
Re: Cell address in A1 format
If the current selection is a cell and not something else, like a shape, you can get the address with
Code: Select all
oCurrentSelection = ThisComponent.getCurrentSelection()
sAbsoluteName = oCurrentSelection.AbsoluteName
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Cell address in A1 format
Thank you very much.
Any chance of getting a reference to the documentation that contains stuff like that?
Regards,
skp49
Any chance of getting a reference to the documentation that contains stuff like that?
Regards,
skp49
Open Office 4.1.3 on Windows 7 Professional 64 bit
Re: Cell address in A1 format
All the OpenOffice API documentation is linked off
http://www.openoffice.org/api/
However, it may be sufficient to browse the OpenOffice BASIC documentation, then with a knowledge of BASIC, do some careful searching for existing code.
http://www.openoffice.org/api/
However, it may be sufficient to browse the OpenOffice BASIC documentation, then with a knowledge of BASIC, do some careful searching for existing code.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Cell address in A1 format
The best way to see the properties and methods available in an object is to use an object inspection tool like MRI. There is some information about MRI in this thread.
The code I posted was recorded with MRI.
The code I posted was recorded with MRI.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.