it's little frustrating that youtube is a thumbnail and title and all around clickbait game ... good info does not go out there easily for people that needs it! your channel is one of the greatest linux and tech channels i know! I don't use LibreOffice but saved your video to send it to anyone on need keep up the good work Sir! 😁
Here the word "compatible" means "look like" rather than 'functionally equivalent'. There are substantial differences between the way that Office handles certain items and the way that LibreOffice handles them. For example, documents (.docx) created in LibreOffice may not work properly when opened in MS Word, specifically headers, outlines and (most especially) tables. This is especially important when you are working remotely and writing documents in LibreOffice (because you love Linux) for a company that lives/breathes MS Office (because they are run by bean counters) and the documents you send to them -- full of multiple hierarchical sections and subsections and chock full of tables -- won't work properly when opened in MS Word. Not that this ever happened to me ... more than once a week.
I had the same issue sending a word document created by a newer office version..... kept being asked why it doesn't look good and I had no idea what yhey were talking about until I walked into my bosses room to see it myself.... For libreoffoce the biggest issue is that the default style is not the same as the normal style in office so office will use its own settings regardless what you have for your default. might be good to create a custom paragraph style as a basis for the rest
I agree with you but I don't consider this video a "compatibility" video at all, for the very reasons you mention. I have also experienced issues in saving documents in Microsoft file formats only to have the document "misbehave" in MS Word. Over the years, I've found that even though the document looks "correct" in MS Word, it might actually have formatting issues that Writer (or some other application) might "expose". I've submitted several bug reports about Writer not displaying or handling MS Word documents correctly and when the technical analysis starts, it was often due to the MS Word document having "problems" that MS Word apparently masked. Most often, I found when saving documents in MS Office formats, issues arise because LibreOffice supported functions that MS Office didn't support or that were broken. As a result, things would look funky in MS Office and would look perfect in Writer or Calc. One feature I LOVE about Writer is being able to include simply formulas in a table. I use this when creating invoices. I have different rows for the line items and the "Total" row has a simple formula to calculate the total for the rows above. Comes in real handy sometimes. I load that in MS Word and things break. Anyway, I' a fan of LibreOffice because it really can hold its own as a standalone office suite. When I generate documents to send to others, I'll use PDF since that's pretty much ubiquitous. If they need to edit the document, only then will I export to an appropriate format.
OnlyOffice saved me from this and because of that I don't think MS Office is necessary in Linux anymore. LibreOffice could not do that despite having more than a decade being the main Linux office suite.
Troy putting out Excellent Content and at a Furious pace, Well Done!! You have no idea how much you have helped a noob like me in this Linux journey..Thank You from Cape Town, South Africa!
Does anyone here know where I can get an Office key? I'm a bit desperate. I recently downloaded the programs and one came with malware that damaged my PC.
Two other fonts that can make a document more compatible with MS Office is ttf-carlito - A sans-serif font metrically compatible with Calibri ttf-caladea - A serif font metrically compatible with Cambria
Hey I was having the same problem with the fonts on Solus plasma and KDE Neon... so I copied a Windows fonts Folder and Used KDE Font Management , Install from file... and that worked for me all the Fonts I needed...working in LibreOffice and OnlyOffice ... My LibreOffice Icon Theme ( Oxygen ) with the (Grouped Bar Compact) User Interface ... Nice Video Great Work.....
😅😅😅😅Off topic bro buh been looking for someone who uses solus like me can you tell me how l can configure ipconfig l know it's deprecated but is there some way to get it back to solus
Excellent point of downloading the MS True Type fonts as it fixes minor alignment glitches seen when printers are different. I would turn off 'Always ask if not saving in ODF format' and turn on auto-save with a shorter time. I like 5 minutes as I live in a hurricane susceptible area so seasonal power outages are frequent. Other niceties: enable create backup (off by default - WHY???), turn on 'fill in header 'Edit document properties before saving' and enable more spelling and grammar settings in 'Langauge Settings'.
You forgot to mention that you need to change the save-types for the other apps, not just writer. You have to change Calc to save as xlsx and impress to pptx, etc.
Personally, I keep the save as ODF as the default. If i need to send a word doc, I'll save as .xdoc later. OFF keeps things neat and as you set it up, saving as docx by default may lose important formatting in the transfer. Always save in native format for your own purposes.
Very handy indeed, thanks a lot! I have another issue too though, maybe you know the answer to that as well: In MS Word when dragging and dropping an image into a table, the table / column adjusts / stretches to the image size if bigger. Thats very handy because when I prepare all images on a certain size beforehand, I can neatly drag and drop them in without messing op the table proportions. Now in Libre Office that doesn’t happen. No matter what image size, the table / column size dictates the size of the image resulting into a lot of work adjusting (resizing) the images one after the other in the table in the Libre Office document. Do you get what I am trying to explain? If so I would be most obliged to learn how to get the same behavior as in Word with Libre Office. Thanks!
I added two extensions and now there is a huge ugly lighter grey toolbar under the original main toolbar. How can I toggle this off? My monitor is too small for such wasted space.
My main issue is trying to use the Microsoft access database on Linux. It doesn’t seem there is much of a solution for that as you have to convert the whole database to a different format to use it. Which doesn’t work for my use case because the database needs to be accessed by both windows and Linux computers. Windows virtualization seem like the only answer.
Does it change automatically because i install it from chaotic aur on tromjaro and when i go to settings it shows all set to Times new roman as default
With Office 365 and sharepoint, so much is done online that it's becoming less of an issue. I used LibreOffice at my last job (even though I wasn't supposed to) and just pasted the data into sharepoint excel. Done.
Nice refresher about fonts etc. Very useful if you haven't done it before. The dark theme compatibility really needs sorting out as default by the devs. WPS Office is apparently the best for compatibility, so useful if you have to work on some complicated document a MS Office user has sent you.
I have written six books using LibreOffice in Windows. Sadly, though, there is always a problem when I send my books to my editor. Hopefully, things will go more smoothly when I send my next book to my editor,
i ENJOY your "how to" tutorials-- looking forward to the rest of ONLY OFFICE ones--- I really need to learn how to use that.. It's good software and I get kinda turned around in it for some reason..
I'm using LibreOffice 7.5.9 (late 2023 release, i think). What's nuts is that when i print, the page size is incorrect. Like, if I'm working with a paper size of Folio or Long Bond (8.5" x 13"), when it comes time to print and i select Long Bond (from the Print options window), the printout still comes out wrong. I have to export to PDF before i can print it properly. I like LO because it kinda stands for something but man, things like this shouldn't even happen in 2023.
anyone knows how to add mendeley cite on libre office? or wps office? I've tried onlyoffice in which the desktop version doesnt really manage to login to it whereas the online version does, but Im also on the brink of just installing MS office using winapps on linux or probably bottles
For the people who stepped over from Microsoft Office, they will like the MS Office interface on Libre Office. I heard there is such an interface update on Libre Office, but how ??
LibreOffice would be more compatible with MSOffice if there were a few major users of MSOffice who wanted to migrate. But all the big companies, and particularly governments, are bribed by Microsoft and threatened with FUD. That leaves nobody to fund the enhancement of compatibility. There are also issues with patents on TTF although that appears to be mostly FUD as at least the base patents have expired in the US. However corporations, unlike individuals, cannot install TT Fonts on Linux because of licensing. Most European governments have adopted Linux, which implies using something other than MSOffice, but I have yet to find a single North American government that has changed or will even discuss the issue. For example the Government of the Province of Ontario web site will not deliver government publications to browsers on Linux because their web site asks the browser "is Adobe version 9 installed", which can never be true on Linux because Adobe stopped supporting Linux at the request of M$.
Troy, you should realize that Microsoft replace Arial with Calibri as the default san-serif font in Office like over a decade ago. Arial is the worst font ever made, and thankfully Microsoft came to their senses and replaced it with the much better font Calibri.
You just install fonts and changed the looks of LibreOffice. I was expecting that you will install or add something that will make opening/editing Word documents actually 'compatible' with Microsoft's.
@@eBuzzCentral What you showed doesn't do anything at all to fix the problems with page layout that we encounter when opening a Word document in Writer.
LibreOffice is pretty mediocre and not very compatible with importing layouts, nor with exporting documents properly. OnlyOffice on the other hand is extremely compatible and also FOSS. From flathub. Switching is easy.
My clients know to send me work in .odt and .ods formats. My entire organisation do not use anything Microsoft. If they don't comply, they simply don't get helped at all. We render rather essential services. We don't bow to big tech.
I love MS Office, but frankly, it’s just ridiculously overpriced for anyone other than those who have money to throw away. In the past I have only used Libreoffice for its fantastic 300 ppi pdf files, but having now gone from desktop to laptop, Libreoffice is my choice. Sorry Microsoft, your ongoing lifetime charges for 365 just isn’t doable anymore.
Is not your fault... the bots of meta aka facebook and cie make hard day to a lot of content creator who give real good content. And your subject (linux) is not in the main stream value by Meta... is anoying time for sure
He mentioned that people have been asking for advice on how to make Libre Office compatible w/ microsoft & said he was re-releasing an old video, He *could* have just typed replies that referred to that old video. Perhaps he *did* reply referring to the old video & still got persistent requests. Anyway he didn't have to remake it & I'm grateful not to search it.
Sorry, but I have to disagree about FreeOffice. FreeOffice is FAR more Microsoft Office compatible than LibreOffice. (Yes, I have both on my Windows computer, and I have tested Microsoft compatibility extensively.) Admittedly, FreeOffice doesn't include a database program -- but neither do many editions of Microsoft Office.
I installed LINUX in my friends office in CAli that owned an insurance business and wsa " REQUIRED" to run windows---- and he ran the LINUX for 2 years and they never knew the difference!!! All this compaitible stuff-- is a CROCK.. I've never had a problem with anything opening correctly-- EXCEPT when i copy things off the internet the formatting is not right... (but that's HTML difference- not MS OFFICE difference)... THANKS for the VIDEO though- I can use this part!!!
People clearly didn’t watch the video fully.
He tells you exactly how to make it MS compatible.
Thanks!
it's little frustrating that youtube is a thumbnail and title and all around clickbait game ... good info does not go out there easily for people that needs it! your channel is one of the greatest linux and tech channels i know! I don't use LibreOffice but saved your video to send it to anyone on need keep up the good work Sir! 😁
Agree
You let a couple of punctuation marks slip in there! More vigilance required!
Here the word "compatible" means "look like" rather than 'functionally equivalent'. There are substantial differences between the way that Office handles certain items and the way that LibreOffice handles them. For example, documents (.docx) created in LibreOffice may not work properly when opened in MS Word, specifically headers, outlines and (most especially) tables. This is especially important when you are working remotely and writing documents in LibreOffice (because you love Linux) for a company that lives/breathes MS Office (because they are run by bean counters) and the documents you send to them -- full of multiple hierarchical sections and subsections and chock full of tables -- won't work properly when opened in MS Word. Not that this ever happened to me ... more than once a week.
OnlyOffice uses the MS Office format natively. It will work. Switch and avoid further embarrassment.
I had the same issue sending a word document created by a newer office version..... kept being asked why it doesn't look good and I had no idea what yhey were talking about until I walked into my bosses room to see it myself....
For libreoffoce the biggest issue is that the default style is not the same as the normal style in office so office will use its own settings regardless what you have for your default. might be good to create a custom paragraph style as a basis for the rest
I agree with you but I don't consider this video a "compatibility" video at all, for the very reasons you mention. I have also experienced issues in saving documents in Microsoft file formats only to have the document "misbehave" in MS Word. Over the years, I've found that even though the document looks "correct" in MS Word, it might actually have formatting issues that Writer (or some other application) might "expose". I've submitted several bug reports about Writer not displaying or handling MS Word documents correctly and when the technical analysis starts, it was often due to the MS Word document having "problems" that MS Word apparently masked. Most often, I found when saving documents in MS Office formats, issues arise because LibreOffice supported functions that MS Office didn't support or that were broken. As a result, things would look funky in MS Office and would look perfect in Writer or Calc. One feature I LOVE about Writer is being able to include simply formulas in a table. I use this when creating invoices. I have different rows for the line items and the "Total" row has a simple formula to calculate the total for the rows above. Comes in real handy sometimes. I load that in MS Word and things break.
Anyway, I' a fan of LibreOffice because it really can hold its own as a standalone office suite. When I generate documents to send to others, I'll use PDF since that's pretty much ubiquitous. If they need to edit the document, only then will I export to an appropriate format.
@@TheCocoaDaddy thank you. You answer my question regard to send as PDF, because this preserve the "layout" .
OnlyOffice saved me from this and because of that I don't think MS Office is necessary in Linux anymore. LibreOffice could not do that despite having more than a decade being the main Linux office suite.
Troy putting out Excellent Content and at a Furious pace, Well Done!! You have no idea how much you have helped a noob like me in this Linux journey..Thank You from Cape Town, South Africa!
Thank you so much for your words and for becoming a member to my channel.
Great video (as always). I guess I missed the initial post of this video, thanks for re-posting, very helpful!
Great video! Very detailed and informative. This is easy to understand and follow. Thanks for the time you put into this . Much appreciated.
Does anyone here know where I can get an Office key? I'm a bit desperate. I recently downloaded the programs and one came with malware that damaged my PC.
Friend, BNH Software helped me. I hope this information is useful to you.
Thanks, I'm just a little desperate
Amazing help my friend!! Thank you.
Two other fonts that can make a document more compatible with MS Office is
ttf-carlito - A sans-serif font metrically compatible with Calibri
ttf-caladea - A serif font metrically compatible with Cambria
thanks. i might try those suggestions
Hey I was having the same problem with the fonts on Solus plasma and KDE Neon... so I copied a Windows fonts Folder and Used KDE Font Management , Install from file... and that worked for me all the Fonts I needed...working in LibreOffice and OnlyOffice ... My LibreOffice Icon Theme ( Oxygen ) with the (Grouped Bar Compact) User Interface ... Nice Video Great Work.....
😅😅😅😅Off topic bro buh been looking for someone who uses solus like me can you tell me how l can configure ipconfig l know it's deprecated but is there some way to get it back to solus
@@alphonsealexander Ohh configure ipconfig I am New to Linux don"t think I know how .... I'm Still trying to share Files on Samba....
Excellent point of downloading the MS True Type fonts as it fixes minor alignment glitches seen when printers are different. I would turn off 'Always ask if not saving in ODF format' and turn on auto-save with a shorter time. I like 5 minutes as I live in a hurricane susceptible area so seasonal power outages are frequent.
Other niceties: enable create backup (off by default - WHY???), turn on 'fill in header 'Edit document properties before saving' and enable more spelling and grammar settings in 'Langauge Settings'.
Troy, thank you for this, this really helped out greatly!
You forgot to mention that you need to change the save-types for the other apps, not just writer. You have to change Calc to save as xlsx and impress to pptx, etc.
Personally, I keep the save as ODF as the default. If i need to send a word doc, I'll save as .xdoc later. OFF keeps things neat and as you set it up, saving as docx by default may lose important formatting in the transfer.
Always save in native format for your own purposes.
Very handy indeed, thanks a lot! I have another issue too though, maybe you know the answer to that as well: In MS Word when dragging and dropping an image into a table, the table / column adjusts / stretches to the image size if bigger. Thats very handy because when I prepare all images on a certain size beforehand, I can neatly drag and drop them in without messing op the table proportions.
Now in Libre Office that doesn’t happen. No matter what image size, the table / column size dictates the size of the image resulting into a lot of work adjusting (resizing) the images one after the other in the table in the Libre Office document.
Do you get what I am trying to explain? If so I would be most obliged to learn how to get the same behavior as in Word with Libre Office. Thanks!
How did you get that green colour for your tab/buttons? Please share.
I added two extensions and now there is a huge ugly lighter grey toolbar under the original main toolbar. How can I toggle this off? My monitor is too small for such wasted space.
Onlyoffice font out the box is Arial and save as .docx without all the extra work, but this is good to know for Libre Office fanboys
do you have window on WPS application?
My main issue is trying to use the Microsoft access database on Linux. It doesn’t seem there is much of a solution for that as you have to convert the whole database to a different format to use it. Which doesn’t work for my use case because the database needs to be accessed by both windows and Linux computers. Windows virtualization seem like the only answer.
4:00 always save as docx = ftw
Can I use Gmail to email docs from libreoffice?
Nice work!
OK, ty, now, please can you tell how you make ms office compatible with libreoffice? 😃
Does it change automatically because i install it from chaotic aur on tromjaro and when i go to settings it shows all set to Times new roman as default
With Office 365 and sharepoint, so much is done online that it's becoming less of an issue. I used LibreOffice at my last job (even though I wasn't supposed to) and just pasted the data into sharepoint excel. Done.
Which is a sign that linux is missing collaborating suit. Unless businesses amd organisations take up foss we are not going anywhere
thank you for your video, it was very helpful.
I use Libre Office and would like to learn to use it more.
Nice refresher about fonts etc. Very useful if you haven't done it before. The dark theme compatibility really needs sorting out as default by the devs.
WPS Office is apparently the best for compatibility, so useful if you have to work on some complicated document a MS Office user has sent you.
I have written six books using LibreOffice in Windows. Sadly, though, there is always a problem when I send my books to my editor. Hopefully, things will go more smoothly when I send my next book to my editor,
Hi, is there an Alt text for Libre?
i ENJOY your "how to" tutorials-- looking forward to the rest of ONLY OFFICE ones--- I really need to learn how to use that.. It's good software and I get kinda turned around in it for some reason..
Why didn't you installed Microsoft clear type fonts? How're gonna use calibre font?
Is it illegal?
I'm using LibreOffice 7.5.9 (late 2023 release, i think). What's nuts is that when i print, the page size is incorrect. Like, if I'm working with a paper size of Folio or Long Bond (8.5" x 13"), when it comes time to print and i select Long Bond (from the Print options window), the printout still comes out wrong. I have to export to PDF before i can print it properly.
I like LO because it kinda stands for something but man, things like this shouldn't even happen in 2023.
So LibreOffice still not load correct Word and Excel doc?
anyone knows how to add mendeley cite on libre office? or wps office? I've tried onlyoffice in which the desktop version doesnt really manage to login to it whereas the online version does, but Im also on the brink of just installing MS office using winapps on linux or probably bottles
Is there anyway to open MS Access database in Libre Office Base?
Is there a way to play audio files from powerpoint in libre office?
For the people who stepped over from Microsoft Office, they will like the MS Office interface on Libre Office.
I heard there is such an interface update on Libre Office, but how ??
He says how to do it in the video
Here 6:54 you can see View == User Interface == Selection: Standard Toolbar, Tabbed, etc.
Is there a MS Publisher equivalent for LibreOfice?
Libre Office Draw maybe...
Libre Office Draw can Edit PDF.
@@mexicovisionalmundo3898 Yes, Draw is the LibreOffice equivalent to MS Publisher.
Buen video, en mi opinión personal uso onlyoffice, sería bueno que en algún momento se juntaran con libreoffice. Saludos
Kool office for linux
Thought you were not a fan of the Manjaro's
What is your favorite Pdf reader/editor then?
LibreOffice would be more compatible with MSOffice if there were a few major users of MSOffice who wanted to migrate. But all the big companies, and particularly governments, are bribed by Microsoft and threatened with FUD. That leaves nobody to fund the enhancement of compatibility. There are also issues with patents on TTF although that appears to be mostly FUD as at least the base patents have expired in the US. However corporations, unlike individuals, cannot install TT Fonts on Linux because of licensing.
Most European governments have adopted Linux, which implies using something other than MSOffice, but I have yet to find a single North American government that has changed or will even discuss the issue. For example the Government of the Province of Ontario web site will not deliver government publications to browsers on Linux because their web site asks the browser "is Adobe version 9 installed", which can never be true on Linux because Adobe stopped supporting Linux at the request of M$.
Troy, you should realize that Microsoft replace Arial with Calibri as the default san-serif font in Office like over a decade ago. Arial is the worst font ever made, and thankfully Microsoft came to their senses and replaced it with the much better font Calibri.
Good but can I get the fonts for free? No crack
You just install fonts and changed the looks of LibreOffice. I was expecting that you will install or add something that will make opening/editing Word documents actually 'compatible' with Microsoft's.
And what I did in the video was make it compatible
@@eBuzzCentral What you showed doesn't do anything at all to fix the problems with page layout that we encounter when opening a Word document in Writer.
LibreOffice is pretty mediocre and not very compatible with importing layouts, nor with exporting documents properly. OnlyOffice on the other hand is extremely compatible and also FOSS. From flathub. Switching is easy.
LibreOffice stuck on Time,meanwhile Only Office and Softmaker Free Office,goes to Save the Linux Community,reverse enginnering MS stuff....
My clients know to send me work in .odt and .ods formats. My entire organisation do not use anything Microsoft. If they don't comply, they simply don't get helped at all. We render rather essential services. We don't bow to big tech.
... and YOU own your files ...
I will bet my paycheck against the stale donut that the tables won't work if you've done any formatting on them at either end.
"Libré" ? :-)
onlyoffice is way better in compatability, but yeah, "export to jpg" natively exists in only libre...
I love MS Office, but frankly, it’s just ridiculously overpriced for anyone other than those who have money to throw away. In the past I have only used Libreoffice for its fantastic 300 ppi pdf files, but having now gone from desktop to laptop, Libreoffice is my choice. Sorry Microsoft, your ongoing lifetime charges for 365 just isn’t doable anymore.
Try FreeOffice
Is not your fault... the bots of meta aka facebook and cie make hard day to a lot of content creator who give real good content. And your subject (linux) is not in the main stream value by Meta... is anoying time for sure
The year on the panel is 2021 🙄
He mentioned that people have been asking for advice on how to make Libre Office compatible w/ microsoft & said he was re-releasing an old video, He *could* have just typed replies that referred to that old video. Perhaps he *did* reply referring to the old video & still got persistent requests. Anyway he didn't have to remake it & I'm grateful not to search it.
Sorry, but I have to disagree about FreeOffice. FreeOffice is FAR more Microsoft Office compatible than LibreOffice. (Yes, I have both on my Windows computer, and I have tested Microsoft compatibility extensively.) Admittedly, FreeOffice doesn't include a database program -- but neither do many editions of Microsoft Office.
You're back on Manjaro? That's a good distro for the most part
I installed LINUX in my friends office in CAli that owned an insurance business and wsa " REQUIRED" to run windows---- and he ran the LINUX for 2 years and they never knew the difference!!! All this compaitible stuff-- is a CROCK.. I've never had a problem with anything opening correctly-- EXCEPT when i copy things off the internet the formatting is not right... (but that's HTML difference- not MS OFFICE difference)... THANKS for the VIDEO though- I can use this part!!!