Help with Macros

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
BorjaGG
Posts: 1
Joined: Wed Oct 12, 2022 2:42 am

Help with Macros

Post by BorjaGG »

Hey, im pretty new using the macros, so i may sound stupid with my question but i dont really know how to do it and thats why i ask, what code i should use to delete a single cell? i saw someones to delete a range but i dont know how to adapt it to delete just one cell.

And if im able to do that, is there any code that can move the content of one cell to another one?

Thanks in advance and sorry if this question was answered before, i just couldnt find it.
Windows 11 and Open Office 4.1
User avatar
Zizi64
Volunteer
Posts: 11361
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Help with Macros

Post by Zizi64 »

https://forum.openoffice.org/en/forum/v ... php?t=2562
https://forum.openoffice.org/en/forum/v ... hp?t=90571
https://forum.openoffice.org/en/forum/v ... 45&t=89079
https://wiki.openoffice.org/wiki/Docume ... s_directly

You must GET the document-sheet-CELL first, and then you can control the Cell object: you can CLEAR the content of the cell.

You can get a cell by its name, by its index and you can get the manually selected one too.
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.
Post Reply