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.
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.
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."
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
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.
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
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
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
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?
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
@@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 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 😊
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
@@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
Do you know how to create a numbered list in Libre. Beginning with the top cell containing $10.00 and descending in one cent increments down to $1.00. How do you create this list without entering every amount?
Yes, you can create a descending list in LibreOffice Calc without manually entering each amount by using a formula. Here are the instructions as provided by Microsoft Copilot: Enter the starting value: In cell A1, enter $10.00. Enter the formula: In cell A2, enter the formula =A1-0.01 and press Enter. Copy the formula: Drag the fill handle (small square at the bottom-right corner of the cell) down from cell A2 to the cell where you want the list to end (e.g., A100). This will create a list that starts at $10.00 and decreases by one cent in each subsequent cell. (Sorry for the late reply!) ~John
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?
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
@@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.
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.
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
Sorry this reply is so late. (Moving is a pain!) On the Mac with an M1 processor, go to libreoffice.com and click the Download link at the top. On that page, right above the Download button on the right, there's a drop-down menu. Choose "MacOS - Apple Silcon" and download. Install as you would any other program on your Mac. Note; when you get to the download page, it may default to MacOS - Intel but you just change that as I mentioned above using the drop-down menu. Thanks. ~John
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
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
@@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
@@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
@@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
@@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
The options are the same. It's only getting to them that's different. But, based on your suggestion, I did create a new video. You'll find it here: ruclips.net/video/a81Jta02kbs/видео.htmlsi=nwI-csClD9VSSIA0 Thanks. ~John
LibreOffice is an alternative to Microsoft Office for those who can't afford MS Office or simply don't want to buy it. If you don't make the changes I show in this video, then anyone you send a file to would also have to have LibreOffice. Changing the settings cures that issue. If you have Microsoft Office - a current version - you do not need LibreOffice. Simple as that. ~John
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
@@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
@@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
Not sure which thing your question is asking about. If you mean why would you use LibreOffice or OpenOffice, it might be because you don't want to spend the money to purchase Microsoft Office. If you're asking why would you change the settings to act like Microsoft Office, it's because if you leave them as the default, then if you send a file to someone, they would also need LibreOffice or OpenOffice to open the file. Since Microsoft Office is the most popular office program, there's a good chance someone else would have that. ~John
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.
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
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.
Angus...Thanks so much for your input! We probably have 500+ customers using Libre and we never hear any complaints. ~John
Writer is excellent!!!. But a very small feature I wish this has: thumbnails, like Impress or Draw.
But it is a minor thing.
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.
So glad this helped you! Thanks for letting me know. ~John
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."
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
I'm making these changes to mine now. Thanks as always for the helpful info!
Glad to help! ~John
Not what I was looking for because I didn't even know this was an option. Thank you.
Sorry it wasn't what you were looking for! ~John
@@4Keystone Honestly, this was better because I didn't know it could eve be done.
Dear Sir,
Thank you for valuable Video! I learned new thing from you.
I am always thankful to you!
Basavaraj, From India.
Thank you so much for your comment. Made my day! ~John
Thank you so much, you made it so easy to follow and everything now works!!
Glad it helped! Thanks for letting me know! ~John
This is just what I was looking for!! I'm so glad I saw this video!! Thanks!!
You're so welcome! Thanks for letting me know! ~John
that was quick and painless - many thanks
You're welcome! Glad it could help. ~John
Simple, no nonsense...and it works. Thank you.
Appreciate your comment. ~John
This is just what I was looking for. I'm so glad I saw this video.
Great! So glad to hear that. Thanks for letting me know. ~John
Thanks a million from James George Cape Town South Africa and much appreciated.
You're very welcome. Thanks for letting me know where you're at! Appreciate knowing I'm happening people in places other than the US. ~John
Great info, presented very understandably. Good to know. Thanks very much.
Thanks for watching! And thanks for your comment. ~John
Thank you thank you for speaking plain English, you solved my need.
So glad my video helped you! Thanks for letting me kow. ~John
Quick, simple, and efficient! Thanks
You're welcome! ~John
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.
That makes perfectly good sense to me. Thanks for sharing! ~John
This video was very helpful, thank you sir!
You are welcome! Thanks for leting me know! ~John
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
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
Wow! This is awesome! Thank you! ❤❤❤
Glad you like it! Thanks for your nice comment. ~John
Superb.
Thank you.
Keep it up.
So nice of you to say! Thanks. ~John
Just found out your chanel. Thanks for the great video!
Thanks for your comment. ~John
youre a very likeable guy! Excellent video.
Oh, thank you so much! I appreciate your nice comment. ~John
Thanks for your help. Sadly, though, I'm too scared to change my settings.
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
@@4Keystone My computer has Windows. I'm not sure if I changed my settings correctly.
@@krisballard541 Changing the settings in LibreOffice doesn't affect your operating system (Windows). ~John
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?
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
@@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 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 😊
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
@@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
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 ?
Sorry for the delay in responding. (Moving is always such a pain!) Did you click on the General line under Load/Save? ~John
Thank you very much it was helpful
Thanks for letting me know that you found this video useful! ~John
Thank you so much!!!
You're welcome! Happy Holidays! ~John
@@4Keystone To you as well!!!
Do you know how to create a numbered list in Libre. Beginning with the top cell containing $10.00 and descending in one cent increments down to $1.00. How do you create this list without entering every amount?
Yes, you can create a descending list in LibreOffice Calc without manually entering each amount by using a formula. Here are the instructions as provided by Microsoft Copilot:
Enter the starting value: In cell A1, enter $10.00.
Enter the formula: In cell A2, enter the formula =A1-0.01 and press Enter.
Copy the formula: Drag the fill handle (small square at the bottom-right corner of the cell) down from cell A2 to the cell where you want the list to end (e.g., A100).
This will create a list that starts at $10.00 and decreases by one cent in each subsequent cell.
(Sorry for the late reply!) ~John
@4Keystone Thank you so much!
Thank you mate.
You're welcome! ~John
Thank you!!!!!
You're very welcome! ~John
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?
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
@@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.
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.
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
@@4Keystone thank-you !!!
Thank you! Sir!
You are welcome! ~John
Hi. My wife and I tried it twice but our computer keeps opening docs in microsoft edge/word not Libre. Please help.
Sorry spoke too soon! It works!! Thank you very much!!!
Dave...So glad you got it working! Enjoy LibreOffice!! ~John
Thank you so much
You are very welcome! ~John
How to download it for macbook m1 air?
Sorry this reply is so late. (Moving is a pain!) On the Mac with an M1 processor, go to libreoffice.com and click the Download link at the top. On that page, right above the Download button on the right, there's a drop-down menu. Choose "MacOS - Apple Silcon" and download. Install as you would any other program on your Mac. Note; when you get to the download page, it may default to MacOS - Intel but you just change that as I mentioned above using the drop-down menu. Thanks. ~John
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
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
thanks!
You bet! ~John
How to do set it on Open Office version 4.1.14 ?
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
@@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
@@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
@@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
@@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
Serious Question! Is OPEN OFFICE FOREIGN OWNED?
Open Office is now owned by the Apache Software Foundation which is an American nonprofit corporation. ~John
@@4Keystone Thanks John for the heads up.
you need to update this video. Doens't really apply to the newer versions of LibreOffice.
The options are the same. It's only getting to them that's different. But, based on your suggestion, I did create a new video. You'll find it here: ruclips.net/video/a81Jta02kbs/видео.htmlsi=nwI-csClD9VSSIA0 Thanks. ~John
I suppose I could make LibreOffice act like M$ Office, but why would I want to?
LibreOffice is an alternative to Microsoft Office for those who can't afford MS Office or simply don't want to buy it. If you don't make the changes I show in this video, then anyone you send a file to would also have to have LibreOffice. Changing the settings cures that issue. If you have Microsoft Office - a current version - you do not need LibreOffice. Simple as that. ~John
Thanks
You're very welcome! ~John
thx bud
You're more than welcome! ~John
how do you make openoffice look like microsoft office gui (edit: openoffice is trash, using libreoffice instead)
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
@@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
@@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
Why would I do that?!
Not sure which thing your question is asking about. If you mean why would you use LibreOffice or OpenOffice, it might be because you don't want to spend the money to purchase Microsoft Office. If you're asking why would you change the settings to act like Microsoft Office, it's because if you leave them as the default, then if you send a file to someone, they would also need LibreOffice or OpenOffice to open the file. Since Microsoft Office is the most popular office program, there's a good chance someone else would have that. ~John
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.
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
Thank you so much!
You're very welcome! ~John
Thanks
You're welcome! ~John