Posted on 02/09/2018 5:34:55 AM PST by markomalley
I have long promised to write about the scripting language Basic and creating macros in LibreOffice. This article is devoted to the types of data used in LibreOffice Basic, and to a greater extent, descriptions of variables and the rules for using them. I will try to provide enough information for advanced as well as novice users.
(And, I would like to thank everyone who commented on and offered recommendations on the Russian article, especially those who helped answer difficult questions.)
Here are some examples of correct variable names:
Note: In examples that contain square brackets, if you remove the brackets, macros will show a window with an error. As you can see, you can use localized variable names. Whether it makes sense to do so is up to you.
(Excerpt) Read more at opensource.com ...
It is free and open source (as opposed to $70-160 for the cheapest version of MS Office) -- also available for Linux, Windows, and MacOS. For virtually any home user, LibreOffice works perfectly well for home users (and, if everybody in an office used it, for office users as well). If you are contemplating buying an MS Office license, I would highly encourage you to check out LibreOffice first.
This tutorial shows how to write macros to help automate recurring tasks in LibreOffice.
Disclaimer: I use both LibreOffice and MS Office on my computers. One of the primary reasons is that the VBA language used in MS Office is not fully compatible with the Basic language used by LibreOffice. (I also use Calligra Office, but that's another issue altogether)
I used to use GW Basic quite a bit to write utility programs I needed to process experimental data in college. Never did find a good replacement after about Windows 2000.
Can you point me toward something to replace it?
Thx, ‘Pod.
I use VBA to write stock trading and market analysis algorithms for Excel. Is the Basic language pretty similar to VBA?
Have you considered perl or python?
Have you looked at PC Basic? (last updated Jan 2018)
Have you looked at this resource? Converting VBA to OpenOffice Basic.
Also there is a PDF that explains the porting process: Porting Excel/VBA to Calc/Star Basic
Thx much, Mark. Will look into that.
It’s been suggested to me. Haven’t investigated yet.
No but I will!
I use libreoffice for most things.
MS Office is better about label printing.
Fwiw, I despise printers to no end.
Both are Basic, so yes
I am not a programmer but do a lot of Linux scripting. This comparison might help to answer your questions:
Thx much.
M4L
LibreOffice Basic
LibreOffice gives me the only way to convert an Excel file to a PDF programmatically, at least somewhat painlessly.
bttt
I think everyone does.
I defense of paper and printers, I never heard of malware leaping from a printed document and infecting a computer. They can be read when the power is out and don’t disappear when your HD crashes. They are unaffected by EMP. They are not subject to bit rot. The failure modes of paper are well understood as are preventative measures. There really is a lot going for it.
I can think of one type who loves a printer.
The special one who has a printer in their office or cube.
Heaven forbid if there is a problem and they have to walk 20 or 30 feet to a network printer. Some act like their firstborn has died.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.