LibreOffice Basic Programming -- Resources for Learning
Feb 25, 2022 · H Everyone, Does anyone know of any books, pdf files, or courses where one can learn LibreOffice Basic and the ins and outs of macros in LibreOffice? All the best, Shawn …
About VBA-UserForms - English - Ask LibreOffice
Feb 5, 2025 · Hello community people! I came across with a problem, with porting VBA-forms to LibreOffice Basic environment. I have a couple of VBA-forms (MS_Forms) which I’ve exported …
How to retrieve a cell value using LibreOffice Basic
Nov 26, 2017 · In CALC I want to retrieve a cell value, change the cell’s style property (NB: without relying on predefined styles!) depending on that value and write the whole back again …
How to iterate through a range of cells in a Basic macro?
Jun 19, 2023 · Despite the titles of these texts, it remains that Basic itself offers only fundamental functionality of a programming language. The rest are some useful predefined variables, and …
"BASIC runtime error. Argument is not optional" - Ask LibreOffice
Oct 6, 2023 · You could enter this in the spreadsheet document at which you created the BASIC function: =JTMSPLIT2(A1;A2;A3) and fill A1:A3 with meaningful values. Or rather, first enter …
Enable code completion (basic) - English - Ask LibreOffice
Aug 6, 2015 · LibreOffice 4.4.3.2 pl_PL, Calc Hello, I’m trying to enable the code completion in BASIC code editor embded in Calc. I found that option in: Tools → Options (maybe Settings) …
Need LO BASIC Reference for Cell & Sheet Properties
Jun 3, 2013 · It might be that you didn’t swallow completely the most important role of the API in custom programming for LibreOffice. In Excel-VBA nearly (?) every subcomponent (object) …
How to use shell from basic macro (solved) - Ask LibreOffice
Feb 6, 2017 · Having trouble making the SHELL call work from basic macro. I have a bash file hsf.sh that runs gnuplot, to load a control file and plot a data file. It needs no other input or …
BASIC Calc : How to copy a cell range from a row and ... - Ask …
Jun 27, 2020 · You can use the fillAuto() method with FillDirection = 0 (TO_BOTTOM) and nSoureCount = 1: LibreOffice: XCellSeries Interface Reference. (In a case where your source …
BASIC+Calc: How to get address of last cell used with content
Nov 17, 2019 · This code is for all kinds of cell used (including format). Sub GetAddressOfLastCellUsed Dim oSheet, oCursor As Object Dim LastColumn, LastRow As …