Using LibreOffice to enter a word to a named cell

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
NomNomistan
Posts: 5
Joined: Mon Jun 21, 2021 12:41 pm

Using LibreOffice to enter a word to a named cell

Post by NomNomistan »

Hey im pretty new to Java and stuff and do not know how to make it happen with LibreOffice. I found no informations that would help me. Do I have to use the row and column or do named cell work too?

A little example would be great :)
LibreOffice 7.0.3.1 (x64) on Windows 10 20H2
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Using LibreOffice to enter a word to a named cell

Post by Villeroy »

NomNomistan wrote: A little example would be great
You need a lot more than that.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
NomNomistan
Posts: 5
Joined: Mon Jun 21, 2021 12:41 pm

Re: Using LibreOffice to enter a word to a named cell

Post by NomNomistan »

Villeroy wrote:
NomNomistan wrote: A little example would be great
You need a lot more than that.
Yea maybe but idk really what to do :/
LibreOffice 7.0.3.1 (x64) on Windows 10 20H2
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Using LibreOffice to enter a word to a named cell

Post by RoryOF »

Andrew Pitonyak's OpenOffice.org Macros Explained.odt V4
listing 410 might get you started.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
JeJe
Volunteer
Posts: 2764
Joined: Wed Mar 09, 2016 2:40 pm

Re: Using LibreOffice to enter a word to a named cell

Post by JeJe »

There are some examples with Java here.

https://api.libreoffice.org/examples/ex ... a_examples

You're asking something which would be very easy in Basic and you could easily find an example in that language to learn from - as well as people here who know Basic and can help you. Very little for Java by comparison.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
NomNomistan
Posts: 5
Joined: Mon Jun 21, 2021 12:41 pm

Re: Using LibreOffice to enter a word to a named cell

Post by NomNomistan »

Thanks i will read it all. sadly I cant do it with Basic :/
LibreOffice 7.0.3.1 (x64) on Windows 10 20H2
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Using LibreOffice to enter a word to a named cell

Post by RoryOF »

Nevertheless, the Basic examples will help you with the syntax you need for your Java.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Using LibreOffice to enter a word to a named cell

Post by Villeroy »

New to Java, new to stuff, can't do it in Basic ... never used LibreOffice for more than 10 minutes.
http://fivedots.coe.psu.ac.th/~ad/jlop/ (oh, that might be 3 levels too high. However, this is the minimum level)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Using LibreOffice to enter a word to a named cell

Post by Zizi64 »

Note for NomNomistan:

The functions - what you must use for your task - are totally independent from the Basic and the Java programming languages.
These functions located inside the API. Just call the from Basic or from java. You must study the API functions first. In simple words: only the syntax is different in the different programming languages.

Please read Andrew Pitonyak's free macro programming books - even if they contain Basic related API function callings.

And please install one of the excellent Object Inspection Tools: MRI or XrayTool. Then you will able to list the properties, methods and intrerfaces of the programming objects - without helper documents.
Last edited by Zizi64 on Tue Jun 22, 2021 3:57 pm, edited 3 times in total.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
NomNomistan
Posts: 5
Joined: Mon Jun 21, 2021 12:41 pm

Re: Using LibreOffice to enter a word to a named cell

Post by NomNomistan »

Thanks these links and you all just helped me alot!
LibreOffice 7.0.3.1 (x64) on Windows 10 20H2
Post Reply