Libreoffice....Calc Spread sheet..Help: I found on here people recommending the freeware LibreOffice to use instead of Microsoft office. So I have down loaded it and started a spread...

Ugly Hedgehog - Photography Forum

Home Active Topics Newest Pictures Search Login Register ☰

General Chit-Chat (non-photography talk)

Libreoffice....Calc Spread sheet..Help

Aug 21, 2022 11:40:18 #

Lens Cap Loc: The Cold North Coast

I found on here people recommending the freeware LibreOffice to use instead of Microsoft office. So I have down loaded it and started a spread sheet. I have recorded macro's in Excel with no problems. In LibreOffice I have located the check mark that allows me to record macros. I have also set the security for macros as low as it will go. I have saved the macros to the spreadsheet. With all of this done, I can not get the macros to run. I have tried simplistic macros to see if they will run, and they don't. Also I can not get the full menu of "form controls" to appear. I would appreciate any advice from you LibreOffice users that know your way around LibreOffice Calc and have any answers to fix these 2 issues. If the discussion needs to be move to private messaging so be it. Thanks in advance

Phil

Aug 21, 2022 18:12:53 #

Lens Cap Loc: The Cold North Coast

So, update. I rebooted the computer....Macros now work! Yay....still no solution for the "Form Controls" menu

Aug 21, 2022 18:39:23 #

Lens Cap Loc: The Cold North Coast

UP date #2...."Form Controls" menu fully activated.

Aug 21, 2022 19:47:14 #

DirtFarmer Loc: Escaped from the NYC area, back to MA

Persistence Prevails.

Aug 21, 2022 20:14:21 #

Lens Cap Loc: The Cold North Coast

Like they say never give up......

DirtFarmer wrote:

Persistence Prevails.

Aug 21, 2022 22:20:28 #

insulator Loc: JASPER, ALABAMA

I use Libreoffice daily it has served me well.

Aug 22, 2022 06:18:20 #

Red6

Lens Cap wrote:

I found on here people recommending the freeware L... (show quote)

I also use Libre and have been very happy with it. However, I mostly use Writer and not Calc the spreadsheet program. But, even with Writer, I often run into issues that take some study and persistence to get through.

I did find that there are some good documentation/manuals for all the Libre programs on the libre.org website. They are not included when you download the programs and have to be downloaded separately.

Aug 22, 2022 08:31:48 #

Lens Cap Loc: The Cold North Coast

Thanks I'll use this the next issue I have.

Red6 wrote:

Aug 22, 2022 08:42:46 #

kubota king Loc: NW , Pa.

I have used calc in Libre in my windows 10 and now in 11 for a while now and it comes with Linux Mint I have on one desk top and one lap top . I only use the straight out spreed sheet for my side jobs I do . Nothing fancy like you do . Glad you got all the special things it can do figured out .Tommy

Aug 26, 2022 17:55:30 #

JerryOSF Loc: Bristol, VA

https://documentation.libreoffice.org/en/english-documentation/

Sep 8, 2022 15:04:33 #

BrianFlaherty Loc: Wilseyville, CA

Lens Cap:
After 25 years fighting with Bill Gates and Windows, I DID learn one thing: If something doesn't work: Re-boot!
PS. . .I had a similar problem with LibreOffice last night. . .Lost a spread sheet that had been an hour or so in the making. . .A quick re-boot! And, all was well again in Computer Land! Even works on my iMac! <smile>

PS: the neat thing about it. . I have no idea why it went haywire; or, how it got fixed! And, I don't care! As long as it works 99% of the time. . .the other 1% hasn't happened yet. However, I KNOW that there are NO absolutes in the world! 1% is probably just waiting around the corner??? Have a good day!

If you want to reply, then register here. Registration is free and your account is created instantly, so you can post right away.

General Chit-Chat (non-photography talk)

Home | Latest Digest | Back to Top | All Sections

UglyHedgehog.com - Forum