Questions tagged [libreoffice-macros]

questions pertaining to the writing and usage of macros in Libreoffice

A macro is a rule or pattern that specifies how a certain input sequence (often a sequence of characters) should be mapped to an output sequence, which may be a sequence of characters, or to manipulate and process a string or data set, according to a defined procedure.

5 questions
2
votes
1 answer

How to change the font?

I want to change the font and set its style to bold. I have two problems: changing CharWeight works but not CharFontName it applies "bold" to the whole paragraph, not only to the selection Here's my code: sub AddAnimation xTextCursor =…
Olivier Pons
  • 15,363
  • 26
  • 117
  • 213
1
vote
2 answers

Python 3 class returns null when using contructor

I started Libre-Office Calc with the following command: $ libreoffice --calc --accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager" import uno # Class so I don't have to do this crap over and over again... class UnoStruct(): …
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

libreoffice - how to store database inside odt document

I'm using libreoffice and I have a problem to create a list of data inside an odt document to use for a macro. I see odt documents can store a database with keys and values, so I want to make a database to store inside the document. The problem I…
user21502496
0
votes
1 answer

Libreoffice calc: function that deletes rows

I am new to Libreoffice Calc. My if/else function populates cells in a new sheet. The function generates a lot of empty rows in the new sheet. Is it possible to delete those empty rows with a function? Something…
Els den Iep
  • 302
  • 2
  • 15
0
votes
2 answers

How to select the current row?

How to select current row in calc of Libreoffice? use macro. The effect I want to achieve is: If the current row is an odd line, Change the current row background color to blue. If currentAddress.Row mod 2 = 1 Then dim document as object …