Free Republic
Browse · Search
General/Chat
Topics · Post Article

For those who don't know it, LibreOffice is a complete Office Suite (Word Processor, Spreadsheet, Presentations, Drawing, and Database) that is an open source equivalent to Microsoft Office.

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)

1 posted on 02/09/2018 5:34:55 AM PST by markomalley
[ Post Reply | Private Reply | View Replies ]


To: markomalley

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.


2 posted on 02/09/2018 5:40:04 AM PST by sauropod (I am His and He is mine.)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

I use VBA to write stock trading and market analysis algorithms for Excel. Is the Basic language pretty similar to VBA?


3 posted on 02/09/2018 5:42:12 AM PST by RoosterRedux (Onward Christian Soldiers!)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: rdb3; Calvinist_Dark_Lord; JosephW; Only1choice____Freedom; amigatec; Ernest_at_the_Beach; ...

6 posted on 02/09/2018 5:49:42 AM PST by ShadowAce (Linux - The Ultimate Windows Service Pack)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

I use libreoffice for most things.

MS Office is better about label printing.

Fwiw, I despise printers to no end.


11 posted on 02/09/2018 6:50:44 AM PST by wally_bert (I didn't get where I am today by selling ice cream tasting of bookends, pumice stone & West Germany)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

M4L
LibreOffice Basic


15 posted on 02/09/2018 8:06:53 AM PST by Scrambler Bob
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

LibreOffice gives me the only way to convert an Excel file to a PDF programmatically, at least somewhat painlessly.


16 posted on 02/09/2018 8:08:10 AM PST by dfwgator
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

bttt


17 posted on 02/09/2018 8:51:01 PM PST by Unrepentant VN Vet (...against all enemies, foreign or domestic...)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

I use linux day in day out at home and at work. Typing this on linux. It’s my go to platform, my daily driver.

Having said that I recently tried to create a presentation in libreoffice and had to give it up and use ppt/windoze (can access via cloud).

For my personal preference I won’t be using Libreoffice for any more presentations - in fact started another one today using PPT.


21 posted on 02/13/2018 9:57:06 PM PST by 2 Kool 2 Be 4-Gotten
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley
t is free and open source (as opposed to $70-160 for the cheapest version of MS Office)

I got a legit copy of MS Office Professional for $9.95.

Home-User Program.

24 posted on 02/16/2018 1:36:45 PM PST by Lazamataz (Don't even think about it.)
[ Post Reply | Private Reply | To 1 | View Replies ]

To: markomalley

Excel macros won’t open properly in LibreCalc most of the time. Writing a new macro, though not for beginners, will allow you to use the Excel spreadsheet as intended.
I sometimes use google sheets online to help identify what the macro is supposed to accomplish. I refuse to purchase Microsoft products.


25 posted on 02/16/2018 1:50:06 PM PST by whodathunkit
[ Post Reply | Private Reply | To 1 | View Replies ]

Free Republic
Browse · Search
General/Chat
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson