LibreOffice - Make It Compatible With MS Office & Office 365 | Layout & Fonts

LibreOffice - Make It Compatible With MS Office & Office 365 | Layout & Fonts
Revisiting a video on LibreOffice and how with just a few settings you can make it compatible with MS Office & Office 365. Take a look and let me know what you think in the comments below.
EBUZZ STORE: 👚👚👚
Ebuzz Central Store : ebuzz-central....
JOIN THIS CHANNEL TO GET ACCESS TO PERKS:
/ @ebuzzcentral
WANT TO SUPPORT THE CHANNEL? 👍🤑💰
Patreon: / ebuzzcentral
WANT TO BUY ME A CUP OF COFFEE? 👍🤑💰
Buy Me A Cup Of Coffee: buymeacoffee.c...
WANT TO SUPPORT THE CHANNEL? 👍🤑💰
PayPal : [e-mail]
FIND ME ON SOCIAL:
Reddit: / ebuzzcentral
Twitter: / ebuzzcentral
Linkedin: / troy-holt-0b2991b4
MeWe: mewe.com/i/troyh
Discord : / discord

[@robertleemeyer]

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.

[@MyAmazingUsername]

OnlyOffice uses the MS Office format natively. It will work. Switch and avoid further embarrassment.

[@costascostas1760]

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

[@TheCocoaDaddy]

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.

[@Juliodax]

@@TheCocoaDaddy thank you. You answer my question regard to send as PDF, because this preserve the "layout" .

[@claudio.corona]

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.

[@MyAmazingUsername]

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.

[@fabricio4794]

LibreOffice stuck on Time,meanwhile Only Office and Softmaker Free Office,goes to Save the Linux Community,reverse enginnering MS stuff....

[@Skullysism]

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! 😁

[@eBuzzCentral]

Agree

[@afriquelesud]

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.

[@Jana-x1n5h]

Can I use Gmail to email docs from libreoffice?

[@felixandy]

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.

[@AndrewHalliwell]

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.

[@davebassi7340]

People clearly didn’t watch the video fully. He tells you exactly how to make it MS compatible. Thanks!

[@Rick_Gregor]

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

[@jamescobban857]

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

[@williamwallace9826]

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.

[@ronch550]

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.

[@Hubbabub65]

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

[@genkiferal7178]

thanks. i might try those suggestions

[@jesse7631]

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.

[@211sweetypie]

Great video! Very detailed and informative. This is easy to understand and follow. Thanks for the time you put into this . Much appreciated.

[@RetosSpace]

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!

[@eBuzzCentral]

Thank you so much for your words and for becoming a member to my channel.

[@genkiferal7178]

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.

[@jeffrodrequez]

Great video (as always). I guess I missed the initial post of this video, thanks for re-posting, very helpful!

[@RMKry]

So LibreOffice still not load correct Word and Excel doc?

[@p.l.3568]

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

[@jon5784]

Amazing help my friend!! Thank you.

[@yvesbeilher637]

OK, ty, now, please can you tell how you make ms office compatible with libreoffice? 😃

[@Farrywind]

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.

[@JDY01]

do you have window on WPS application?

[@pieralessi7426]

Good but can I get the fonts for free? No crack

[@TheSillybits]

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!

[@NADEEMKHAN-sj5hn]

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

[@davidwayne9982]

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

[@oldproji]

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.

[@williamwallace9826]

Try FreeOffice

[@fullscale4me]

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

[@WifeMommy-sm9rl]

Hi, is there an Alt text for Libre?

[@stevenmendoza472]

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

[@alphonsealexander]

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

[@stevenmendoza472]

@@alphonsealexander Ohh configure ipconfig I am New to Linux don"t think I know how .... I'm Still trying to share Files on Samba....

[@hu-tv]

any option to Move menubar into title bar?

[@SB-qm5wg]

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.

[@costascostas1760]

Which is a sign that linux is missing collaborating suit. Unless businesses amd organisations take up foss we are not going anywhere

[@OliverpaintsAu]

What is your favorite Pdf reader/editor then?

[@TM86880]

Troy, thank you for this, this really helped out greatly!

[@kain3568]

I use Libre Office and would like to learn to use it more.

[@snich1950]

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]

And what I did in the video was make it compatible

[@williamwallace9826]

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

[@patrickmclaughlin6013]

... and YOU own your files ...

[@krisballard541]

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,

[@91722854]

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

[@bertvantol9669]

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

[@DaleonM4]

He says how to do it in the video

[@Juliodax]

Here 6:54 you can see View == User Interface == Selection: Standard Toolbar, Tabbed, etc.

[@ShambhalinGardens-n2i]

does not work for me

[@ramaningle6194]

How did you get that green colour for your tab/buttons? Please share.

[@tech889]

Why didn't you installed Microsoft clear type fonts? How're gonna use calibre font? Is it illegal?

[@crapphone7744]

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.

[@ZedusUA]

onlyoffice is way better in compatability, but yeah, "export to jpg" natively exists in only libre...

[@morenaso3695]

Buen video, en mi opinión personal uso onlyoffice, sería bueno que en algún momento se juntaran con libreoffice. Saludos

[@asifshamsi5630]

Is there anyway to open MS Access database in Libre Office Base?

[@xBinyWolf]

Is there a way to play audio files from powerpoint in libre office?

[@wendysmith1453]

thank you for your video, it was very helpful.

[@johnwarr7552]

"Libré" ? :-)

[@smile768]

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.

[@andynl6443]

Nice work!

[@chuckowens2010]

Thought you were not a fan of the Manjaro's

[@charlesedwards8683]

Kool office for linux

[@HughNolan-tt1eg]

Is there a MS Publisher equivalent for LibreOfice?

[@mexicovisionalmundo3898]

Libre Office Draw maybe... Libre Office Draw can Edit PDF.

[@williamwallace9826]

@@mexicovisionalmundo3898 Yes, Draw is the LibreOffice equivalent to MS Publisher.

[@androidbox6876]

The year on the panel is 2021 🙄

[@jktolford8272]

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.

[@davidwayne9982]

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

[@josephkurdziolek4483]

You're back on Manjaro? That's a good distro for the most part