Questions tagged [libreoffice-basic]
LibreOffice Basic is a procedural, interpreted programming language from the Basic family that can be used to write macros for applications in the LibreOffice Suite.
libreoffice-basic
264
questions
1
vote
2
answers
69
views
Copy values and formats with a BASIC-Script
I want to copy the values, the formats and all conditional formats from an LibreOffice-Calc worksheet-range (A1:H100) to another (new/empty) worksheet of the same workbook.
This is, what I do actually:...
0
votes
1
answer
64
views
How do I turn the first word in a cell into a hyperlink using a macro in LibreOffice Calc
I have a large spreadsheet and want to automate the process of converting the first word of each cell into a hyperlink, but keeping the rest of the text as it is. I.e. linktext appendedtext to be ...
0
votes
0
answers
28
views
Executing LibreOffice Macro from ASP.NET Web App (IIS)
I'm encountering challenges running a LibreOffice macro using soffice from my ASP.NET web application hosted in IIS.
Locally (outside IIS), I could execute the macro with the following command from ...
0
votes
1
answer
25
views
saving a macro that formats cells as text to an extension
I have this calc macro that is working as expected.
It formats the cells as "text" so that I can type February 2024 without any problem.
Is it possible to save this macro as an extension?
...
0
votes
0
answers
33
views
How to query image information in a Libreoffice macro?
I've been looking for some way to obtain information about an image that I read from a file. Image size, etc. After lots of googleing, it seems you can do this using the com.sun.star.graphic....
0
votes
0
answers
161
views
How to select entire row in a Libreoffice Basic macro?
I'm trying to find out how I could select an entire row in a Calc sheet using the Macro language.
Macro recording is of no help, as it doesn't reveal the secret, even if I have recording on while ...
3
votes
1
answer
147
views
A macro to remove the first space
Is it possible to write a macro for the problem explained in this discussion?
https://ask.libreoffice.org/t/can-you-auto-delete-the-space-before-an-auto-corrected-word/101757
If the following sequence ...
0
votes
0
answers
45
views
Get and set local/web hyperlinks in Libre office Impress shape element using basic macro
Using macro written in basic trying to set and get hyperlink in a rectangular shape object. Currently can access selected shaped object, but unable to work with hyperlinks.
Final aim is to set web ...
0
votes
1
answer
94
views
Convert working VBA macro into libre basic
I have a simple VBA macro for word that works fine. I searched the libre forum and also tried to find any documentation regarding the libre object model, I was not able to find anything that would ...
0
votes
2
answers
121
views
Unable to change shape color using macro in LibreOffice Impress presentation mode
I'm trying to use Basic macros to make a shape change its color when clicked during presentation mode. My goal is to create versatile code that works on any slide, regardless of the number of shapes.
...
2
votes
1
answer
71
views
Remove save keyboard shortcut using script
Let's assume I need to remove the Ctrl+S keboard shortcut that is used to save a document in Libreoffice writer.
I can change the function using this code...
<node oor:name="S_MOD1&...
0
votes
1
answer
149
views
Paste formula in Libre Calc using Basic macro
I am trying to replicate an excel macro in Libre Calc using the native Basic.
I've come up against what I feel should be a simple problem/resolution (for someone who has a clue what they are doing).
I ...
0
votes
1
answer
59
views
LibreOffice, Writer, Macros, How to replace a embedded object formula with its string contents
I have a Open Office Writer document with math formulas (com.sun.star.formula.FormulaProperties) and i want to make a macro that replace that formula objects with its string contents.
I am very novice!...
0
votes
1
answer
187
views
Excel Formula to validate valid IP and valid URL in librecalc excel sheet
Excel formulas to validate valid IP and valid URL in librecalc excel sheet.
For Valid IP got one formula as below,
=AND((LEN(A1)-LEN(SUBSTITUTE(A1,".","")))=3,ISNUMBER(SUBSTITUTE(...
2
votes
0
answers
253
views
Writing libreoffice-calc macros in Visual Studio Code
I'd like to write libreoffice-calc macros (libreoffice-basic) in Visual Studio Code instead of the embedded macro editor.
I know xlwings enables such functionality when working with excel, as ...