Setting LibreOffice/OpenOffice To Act Like Microsoft Office

[@angusorvid8840]

Good lesson. I prefer Libre to MS Office. Not only is it free but I think it's also easier to use. Like Word, it's not more bells and whistles than I'd ever need to use, but it's nice to know they are there if you need them. Libre is also a lot punchier, far more stable, than Office. Writer is the main Libre application I use and it's fantastic.

[@4Keystone]

Angus...Thanks so much for your input! We probably have 500+ customers using Libre and we never hear any complaints. ~John

[@Juliodax]

Writer is excellent!!!. But a very small feature I wish this has: thumbnails, like Impress or Draw. But it is a minor thing.

[@tonypmedia]

THANK YOU!!!!!! no nonsense and straight to the point and the instruction actually works! I was tired of saving as another and reopening and all that jazz.

[@4Keystone]

So glad this helped you! Thanks for letting me know. ~John

[@taslad5157]

Thank you so much, you made it so easy to follow and everything now works!!

[@4Keystone]

Glad it helped! Thanks for letting me know! ~John

[@basavarajchougala3384]

Dear Sir, Thank you for valuable Video! I learned new thing from you. I am always thankful to you! Basavaraj, From India.

[@4Keystone]

Thank you so much for your comment. Made my day! ~John

[@caitlinl3734]

I'm making these changes to mine now. Thanks as always for the helpful info!

[@4Keystone]

Glad to help! ~John

[@soulaesthete8563]

Thank you for this very helpful tutorial. It should be noted that you must click the "Apply" button after each app change. Also, I would recommend unchecking "Warn when not saving in ODF or default format." It's right below "Always save as."

[@4Keystone]

Thanks for your comment. However, it is not necessary to click "Apple" after each app change. In fact, you don't have to click "Apply" at all. As I did in the video, all you have to do is make the changes and then click "Ok." Clicking "OK" automatically applies the changes. As for the warning, I prefer that to stay just in case one of my customers accidentally changes the extension when saving. Again, I appreciate you taking the time to comment. ~John

[@asd67lkj]

This is just what I was looking for. I'm so glad I saw this video.

[@gerry5249]

Simple, no nonsense...and it works. Thank you.

[@4Keystone]

Appreciate your comment. ~John

[@badpiggies988]

I mainly use writer, it can seamlessly open and create DOCX files which makes it great for college- as well as the fact that unlike Excel, Calc can produce ANOVA charts which is paywalled in excel.

[@4Keystone]

That makes perfectly good sense to me. Thanks for sharing! ~John

[@crimson3356]

This is just what I was looking for!! I'm so glad I saw this video!! Thanks!!

[@4Keystone]

You're so welcome! Thanks for letting me know! ~John

[@ChicagoDreamer5]

Great info, presented very understandably. Good to know. Thanks very much.

[@4Keystone]

Thanks for watching! And thanks for your comment. ~John

[@werhold]

that was quick and painless - many thanks

[@4Keystone]

You're welcome! Glad it could help. ~John

[@larryglatt2548]

Thank you thank you for speaking plain English, you solved my need.

[@4Keystone]

So glad my video helped you! Thanks for letting me kow. ~John

[@sharp_focus]

Quick, simple, and efficient! Thanks

[@4Keystone]

You're welcome! ~John

[@Caesar7118]

Good evening , I followed your instructions, but when i hit load/save it could not give me the ms word to click on or use. What do I do ?

[@chadparsons50]

Thank you so much!

[@4Keystone]

You're very welcome! ~John

[@crystalclear7329]

Wow! This is awesome! Thank you! ❤❤❤

[@4Keystone]

Glad you like it! Thanks for your nice comment. ~John

[@rizla8602]

This video was very helpful, thank you sir!

[@4Keystone]

You are welcome! Thanks for leting me know! ~John

[@jeremy6384]

youre a very likeable guy! Excellent video.

[@4Keystone]

Oh, thank you so much! I appreciate your nice comment. ~John

[@GSM-SM]

Superb. Thank you. Keep it up.

[@4Keystone]

So nice of you to say! Thanks. ~John

[@neandertalac]

We actually need to force public services to use odt odf and such formats, as they are rarely changed. But M$ makes money by changing the format on itself. So, it would be logical to rather use more odf, than to fall into trap that is M$ format of any type

[@4Keystone]

I get what you're saying. However, the greatest majority of people use or need to be able to open Microsoft documents, spreadsheets, presentations, etc., so for now, this is the way to go. ~John

[@lankabanka486]

Thanks

[@krisballard541]

Thanks for your help. Sadly, though, I'm too scared to change my settings.

[@4Keystone]

I promise you, nothing to be scared about. We install this program and change the settings all the time. If you follow my instructions in the video, you'll be fine! ~John

[@krisballard541]

@@4Keystone My computer has Windows. I'm not sure if I changed my settings correctly.

[@4Keystone]

@@krisballard541 Changing the settings in LibreOffice doesn't affect your operating system (Windows). ~John

[@LONEWOLF6523-gc3dv]

Serious Question! Is OPEN OFFICE FOREIGN OWNED?

[@mkk94]

How to download it for macbook m1 air?

[@iwannaapple7190]

Microsoft office and libreoffice treat formulas slightly different. What operations work in LibreOffice will not work on Microsoft office. Changing over like you did does that affect that difference?

[@4Keystone]

Hi, and thanks for your question. In reality, if you change over like I showed in the video, LibreOffice should treat formulas the same as Microsoft Office. I do know that in all the years I've recommended/installed LibreOffice, I've only ever had one customer - a retired CPA - who couldn't get a particular complicated spreadsheet to work in LibreOffice so he had to go back to Microsoft Office. Otherwise, I haven't seen any issues when the changes I demonstrated in the video were made. ~John

[@iwannaapple7190]

@@4Keystone I might try it. I made a lye calculator in libre office that doesn't work anywhere else because of that. People make soap with it and it's a much cheaper option for them and me.

[@sisnow6066]

Thank you very much it was helpful

[@4Keystone]

Thanks for letting me know that you found this video useful! ~John

[@guytaylor3727]

Thank you so much for taking the time to make this video sir, but what do I do if my LibreOffice writer isn't displaying options under tools, the menu stops at customize, any suggestions?

[@4Keystone]

Hmmm That is an odd one. With Writer open, try the keyboard shortcut which is Alt + F12. That should bring up the Options. Let me know if that doesn't work for you. Thanks. ~John

[@guytaylor3727]

@@4Keystone many thanks for the reply, that didn’t work. But no hassle, I’m just being lazy, I’ll just keep manually selecting to save in .docx - thanks again 😊

[@guytaylor3727]

@@4Keystone many thanks for the reply, that didn’t work. But no hassle, I’m just being lazy, I’ll just keep manually selecting to save in .docx - thanks again 😊

[@4Keystone]

If that didn't work, I'd uninstall LibreOffice, reboot, download again, and reinstall. Honestly, I've installed LibreOffice for at least 300 customers and have never had your issue. Let me know if you decide to try this and how you make out.@@guytaylor3727

[@guytaylor3727]

@@4Keystone thanks for that, sorry for the delay. It still didn't work so I just bought Office, wasn't too expensive as purchased it off one of those key sites where they obviously buy the keys in bulk so can afford to sell them cheap. Thanks again and apologies once again for the delay

[@user-zv9xe2pj9v]

Thank you, And you have to click "apply" between each setting, right?

[@chicken3365]

nah you can just click "OK"

[@4Keystone]

@Roryphelan3365 is correct. Once you've made the changes, you just click OK. No need to hit reply between each change. ~John

[@CitizenJane-]

Today I downloaded the latest version of OpenOfficeWriter. I created a document. Later, I opened my email, attached the document and sent it off. Unfortunately the recipient couldn't open the attachment. So I went back to the document and tried to change the file extension from oO to Rich Text (it didn't want to do it) to Word 97, 2003, HTML - .doc - Anything other than oO, but every time it refused to accept the change. HELP. I just want people to be able to open the attachment. Thanks.

[@4Keystone]

Thanks for your question. You should be able to open the document and then click the SAVE AS and change the format there to .docx. If you make the changes I showed in my video, you should be good to go after that. Let me know if you still have issues after trying this. ~John

[@CitizenJane-]

@@4Keystone thank-you !!!

[@peternias7646]

idiot me i installed WS in error. now have openoffice but need to change association from WS to OO so a quick guide please to do that

[@4Keystone]

I'm assuming you mean Word Star. You should be able to change the associations that same way I show in this video. If that isn't the case, let me know and I'll try to help you. ~John

[@magnacarta9364]

Thank you mate.

[@4Keystone]

You're welcome! ~John

[@daveg2199]

Hi. My wife and I tried it twice but our computer keeps opening docs in microsoft edge/word not Libre. Please help.

[@daveg2199]

Sorry spoke too soon! It works!! Thank you very much!!!

[@4Keystone]

Dave...So glad you got it working! Enjoy LibreOffice!! ~John

[@Ritu-TheWinner]

Thank you! Sir!

[@4Keystone]

You are welcome! ~John

[@ludsnpr2272]

Thank you so much

[@4Keystone]

You are very welcome! ~John

[@romeksaar8491]

How to do set it on Open Office version 4.1.14 ?

[@4Keystone]

Thanks for your question. It works exactly the same way as I show in the video with one exception - when you click the drop-down menu to change the "always save as" setting, you may need scroll either up or down to find the Microsoft options. Otherwise, everything should work just as I showed in the video. ~John

[@romeksaar8491]

@@4Keystone Also the drop down menu where it says "Odf Format version" where you have set "1.3 extended" the highest version i can choose is 1.2 extended" does it make any difference Thanks R

[@4Keystone]

@@romeksaar8491 There is a difference between 1.2 and 1.3. ODF 1.2 was published as an ISO/IEC standard on June 17, 2015. It's the native file format of OpenOffice. ODF 1.3 was approved as an OASIS Committee Specification at the end of December 2019. It supports digital signatures for documents and OpenPGP-based encryption of XML documents. It is the default for LibreOffice. If you need to support digital signatures and XML encryption, you should uninstall OpenOffice and install LibreOffice, instead. ~John

[@romeksaar8491]

@@4Keystone Man u are correct eh, my main point of messing with this thing ya show on the video to get the word document support working should word documents ever need be opened/filled Thanks R

[@romeksaar8491]

@@4Keystone Thanks alot man i did as u recommended, now one more question inda video u say we want the latest n greatest, right ? so if i choose ODF version 1.3 and text document as an word 2010-365 (.docx) (the latest i could find on a drop-down) also spredsheet 2007-365 (the latest i could find on a drop-down) and also Powerpoint 2007-365 ? Runnin LibreOffice 7.6 Thanks in advance, mate

[@internet-hustle311]

thx bud

[@4Keystone]

You're more than welcome! ~John

[@dynahzm]

how do you make openoffice look like microsoft office gui (edit: openoffice is trash, using libreoffice instead)

[@4Keystone]

Well, you can't make LibreOffice look exactly like the Microsoft GUI (for instance, no ribbon at the top, just drop-down menus) as that would most likely be a copyright violation. Still, LibreOffice looks pretty darn close to Microsoft Office. ~John

[@dynahzm]

@@4Keystone you can actually make libreoffice have a ribbon ui by clicking view > user interface > and press "tabbed". and i was talking about APACHE OPENOFFICE

[@4Keystone]

@@dynahzmYes, it's true you can use tabs but it's still not like the Microsoft ribbon. Regarding your edit, I agree, LibreOffice is the far better of the two programs. ~John

[@larryzweig]

This has nothing to do with "acting like ms office" just setting default output format. Not at all what I am looking for & that's okay, but the title is misleading.

[@4Keystone]

Sorry you find the title misleading. Obviously, because of copyright issues, no other office program could act exactly like Microsoft Office. They can come close but not exact. ~John

[@ovimm5724]

Thank you so much!!!

[@4Keystone]

You're welcome! Happy Holidays! ~John

[@ovimm5724]

@@4Keystone To you as well!!!

[@_Factboy_Sunny_]

Thanks

[@4Keystone]

You're very welcome! ~John