[Dropped] Easy and simple code? for beginner

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Locked
User avatar
Ricardomx
Banned
Posts: 2
Joined: Wed Jan 27, 2021 6:04 pm

[Dropped] Easy and simple code? for beginner

Post by Ricardomx »

Hi all
i have to say that I am and old programmer.
But I am trying to learn how to program macros with Calc.
So, the first thing I faced was the complicated commands to do simple things.
To undestand commands, i tried first using the macro recorder. Very complicated.

At the end, I learned how to storage a cell content in a variable, with simple and clear instructions:

' Dim oHoja2 As Object
' oHoja2 = oDoc.getSheets.getByName("RECONTEO")
' txt = oHoja.getCellRangeByName("D8").getString()
' Msgbox TXT

Now the issue is this. I dont understand how to write, storage, put, paste (or whatever it is called) that value in another cell.

I have searched for an answer but all of them are not clear, not well explained, or terrible confused.

Please help!!!
How can I wirte or paste the variable content in a cell with simple and clear instructions?.

Best Regards
openoffice 4.1.7
windows 10
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: easy and simple code? for begginer

Post by RoryOF »

Download Andrew Pitonyak's book from https://www.pitonyak.org/oo.php
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Ricardomx
Banned
Posts: 2
Joined: Wed Jan 27, 2021 6:04 pm

Re: easy and simple code? for begginer

Post by Ricardomx »

ok, thanks for nothing.
Administrator, please remove my account.
 Edit: Topic locked to prevent tampering by the OP. I see no good reason to remove your account or this topic. Just ignore it and never return if you don't like the free advice you received about the free software you downloaded.
-- MrProgrammer, forum moderator 
 Edit: Now I've banned you, at your request, so you cannot post again.
-- MrProgrammer, forum moderator 
openoffice 4.1.7
windows 10
Locked