Setting LibreOffice/OpenOffice To Act Like Microsoft Office

Поделиться
HTML-код
  • Опубликовано: 11 дек 2024

Комментарии • 122

  • @angusorvid8840
    @angusorvid8840 Год назад +15

    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
      @4Keystone  Год назад

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

    • @Juliodax
      @Juliodax 9 месяцев назад

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

  • @mediaflmcreation
    @mediaflmcreation 6 месяцев назад +9

    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
      @4Keystone  6 месяцев назад

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

  • @soulaesthete8563
    @soulaesthete8563 Год назад +1

    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
      @4Keystone  Год назад +3

      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

  • @caitlinl3734
    @caitlinl3734 2 года назад +9

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

    • @4Keystone
      @4Keystone  2 года назад +1

      Glad to help! ~John

  • @mansfieldtime
    @mansfieldtime 26 дней назад

    Not what I was looking for because I didn't even know this was an option. Thank you.

    • @4Keystone
      @4Keystone  15 дней назад

      Sorry it wasn't what you were looking for! ~John

    • @mansfieldtime
      @mansfieldtime 15 дней назад

      @@4Keystone Honestly, this was better because I didn't know it could eve be done.

  • @basavarajchougala3384
    @basavarajchougala3384 2 года назад +4

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

    • @4Keystone
      @4Keystone  2 года назад +3

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

  • @taslad5157
    @taslad5157 4 месяца назад +3

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

    • @4Keystone
      @4Keystone  4 месяца назад

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

  • @crimson3356
    @crimson3356 2 года назад +4

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

    • @4Keystone
      @4Keystone  2 года назад +1

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

  • @werhold
    @werhold 2 года назад +4

    that was quick and painless - many thanks

    • @4Keystone
      @4Keystone  2 года назад +1

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

  • @gerry5249
    @gerry5249 7 месяцев назад +1

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

    • @4Keystone
      @4Keystone  7 месяцев назад

      Appreciate your comment. ~John

  • @asd67lkj
    @asd67lkj 3 месяца назад +1

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

    • @4Keystone
      @4Keystone  3 месяца назад

      Great! So glad to hear that. Thanks for letting me know. ~John

  • @jamesgeorge-pj9un
    @jamesgeorge-pj9un Месяц назад +1

    Thanks a million from James George Cape Town South Africa and much appreciated.

    • @4Keystone
      @4Keystone  Месяц назад

      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

  • @ChicagoDreamer5
    @ChicagoDreamer5 Год назад +3

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

    • @4Keystone
      @4Keystone  Год назад

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

  • @larryglatt2548
    @larryglatt2548 Год назад +1

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

    • @4Keystone
      @4Keystone  Год назад +1

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

  • @sharp_focus
    @sharp_focus 2 года назад +2

    Quick, simple, and efficient! Thanks

    • @4Keystone
      @4Keystone  2 года назад +1

      You're welcome! ~John

  • @badpiggies988
    @badpiggies988 5 месяцев назад +1

    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
      @4Keystone  5 месяцев назад

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

  • @rizla8602
    @rizla8602 Год назад +1

    This video was very helpful, thank you sir!

    • @4Keystone
      @4Keystone  Год назад

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

  • @neandertalac
    @neandertalac Год назад +3

    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
      @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

  • @crystalclear7329
    @crystalclear7329 4 месяца назад

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

    • @4Keystone
      @4Keystone  4 месяца назад

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

  • @GSM-SM
    @GSM-SM Год назад +1

    Superb.
    Thank you.
    Keep it up.

    • @4Keystone
      @4Keystone  Год назад

      So nice of you to say! Thanks. ~John

  • @vukhuat4251
    @vukhuat4251 2 месяца назад

    Just found out your chanel. Thanks for the great video!

    • @4Keystone
      @4Keystone  Месяц назад

      Thanks for your comment. ~John

  • @jeremy6384
    @jeremy6384 5 месяцев назад

    youre a very likeable guy! Excellent video.

    • @4Keystone
      @4Keystone  4 месяца назад

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

  • @krisballard541
    @krisballard541 Год назад +1

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

    • @4Keystone
      @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
      @krisballard541 Год назад

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

    • @4Keystone
      @4Keystone  Год назад

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

  • @guytaylor3727
    @guytaylor3727 Год назад +1

    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
      @4Keystone  Год назад +1

      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
      @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
      @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
      @4Keystone  Год назад +1

      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
      @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

  • @Caesar7118
    @Caesar7118 3 месяца назад

    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 ?

    • @4Keystone
      @4Keystone  3 месяца назад

      Sorry for the delay in responding. (Moving is always such a pain!) Did you click on the General line under Load/Save? ~John

  • @sisnow6066
    @sisnow6066 Год назад

    Thank you very much it was helpful

    • @4Keystone
      @4Keystone  Год назад

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

  • @ovimm5724
    @ovimm5724 2 года назад +1

    Thank you so much!!!

    • @4Keystone
      @4Keystone  2 года назад

      You're welcome! Happy Holidays! ~John

    • @ovimm5724
      @ovimm5724 2 года назад

      @@4Keystone To you as well!!!

  • @TheGreatCanines
    @TheGreatCanines Месяц назад

    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?

    • @4Keystone
      @4Keystone  Месяц назад +1

      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

    • @TheGreatCanines
      @TheGreatCanines Месяц назад

      @4Keystone Thank you so much!

  • @magnacarta9364
    @magnacarta9364 8 месяцев назад

    Thank you mate.

    • @4Keystone
      @4Keystone  8 месяцев назад

      You're welcome! ~John

  • @gailmakar1839
    @gailmakar1839 2 месяца назад

    Thank you!!!!!

    • @4Keystone
      @4Keystone  Месяц назад

      You're very welcome! ~John

  • @iwannaapple7190
    @iwannaapple7190 10 месяцев назад

    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
      @4Keystone  10 месяцев назад

      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
      @iwannaapple7190 10 месяцев назад

      @@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.

  • @CitizenJane-
    @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
      @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-
      @CitizenJane- Год назад

      @@4Keystone thank-you !!!

  • @Ritu-TheWinner
    @Ritu-TheWinner Год назад

    Thank you! Sir!

  • @daveg2199
    @daveg2199 Год назад

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

    • @daveg2199
      @daveg2199 Год назад

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

    • @4Keystone
      @4Keystone  Год назад +1

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

  • @ludsnpr2272
    @ludsnpr2272 Год назад

    Thank you so much

    • @4Keystone
      @4Keystone  Год назад

      You are very welcome! ~John

  • @mkk94
    @mkk94 4 месяца назад

    How to download it for macbook m1 air?

    • @4Keystone
      @4Keystone  3 месяца назад

      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

  • @peternias7646
    @peternias7646 6 месяцев назад

    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
      @4Keystone  5 месяцев назад

      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

  • @porkyV2
    @porkyV2 28 дней назад

    thanks!

  • @romeksaar8491
    @romeksaar8491 Год назад

    How to do set it on Open Office version 4.1.14 ?

    • @4Keystone
      @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
      @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
      @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
      @romeksaar8491 Год назад +1

      @@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
      @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

  • @LONEWOLF6523-gc3dv
    @LONEWOLF6523-gc3dv 3 месяца назад

    Serious Question! Is OPEN OFFICE FOREIGN OWNED?

    • @4Keystone
      @4Keystone  3 месяца назад

      Open Office is now owned by the Apache Software Foundation which is an American nonprofit corporation. ~John

    • @LONEWOLF6523-gc3dv
      @LONEWOLF6523-gc3dv 3 месяца назад

      @@4Keystone Thanks John for the heads up.

  • @dalecleveland144
    @dalecleveland144 25 дней назад

    you need to update this video. Doens't really apply to the newer versions of LibreOffice.

    • @4Keystone
      @4Keystone  15 дней назад

      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

  • @averagebodybuilder
    @averagebodybuilder 13 дней назад

    I suppose I could make LibreOffice act like M$ Office, but why would I want to?

    • @4Keystone
      @4Keystone  12 дней назад

      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

  • @_Factboy_Sunny_
    @_Factboy_Sunny_ 10 месяцев назад

    Thanks

    • @4Keystone
      @4Keystone  10 месяцев назад

      You're very welcome! ~John

  • @internet-hustle311
    @internet-hustle311 11 месяцев назад

    thx bud

    • @4Keystone
      @4Keystone  11 месяцев назад

      You're more than welcome! ~John

  • @dynahzm
    @dynahzm Год назад +1

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

    • @4Keystone
      @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
      @dynahzm Год назад +1

      @@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
      @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

  • @marvinmep.extraoficial
    @marvinmep.extraoficial 2 месяца назад

    Why would I do that?!

    • @4Keystone
      @4Keystone  Месяц назад

      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

  • @larryzweig
    @larryzweig 4 месяца назад

    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
      @4Keystone  4 месяца назад

      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

  • @chadparsons50
    @chadparsons50 6 месяцев назад +1

    Thank you so much!

    • @4Keystone
      @4Keystone  6 месяцев назад +1

      You're very welcome! ~John

  • @lankabanka486
    @lankabanka486 3 месяца назад

    Thanks

    • @4Keystone
      @4Keystone  3 месяца назад

      You're welcome! ~John