I used libreoffice during college, then I used it during my masters, I wrote my thesis on it. I'm a teacher now and I still use libreoffice. Yeah, it may not be eyecandy, but it delivers!
My wife used Word for her masters thesis. It got to the point where the DOCX file was massive and took forever to open. A week before she needed to submit to the printers, Word gave up on the file with a 'cannot open file' type message. In desperation, I installed Libreoffice on my Windows notebook and opened the file. It took a while to open and kept spitting back messages about correcting invalid references etc. But it did open. And then saved to 40% of the Word file size. Libreoffice does DOCX better than Microsoft. That is a demonstration in compatibility!!
In my conclusion, it is always better to have a legal office. You save yourself a lot of problems in the future if you are a person who does not have much knowledge of computers.
On a slight note, NEVER set the default to docx format. It is so not recommended to save in docx format in libre office, IF you're going to edit it later. ALWAYS save in .odf format, BUT when you want to share the doc you can save it as .DOCX for sharing.
@@nicole-secondaryemail-mort9617 cause if you save and edit it as a docx file the file may break, so you should save it as an odf file and edit it that way. When you need to share it you just save it again as a docx.
Same here! I used Wordpad, but then started to use Libre Office for my RPG ideas. Being able to drop images in and wrap to background is so useful. Glad to hear you had success with it.
I use libre office version 6.1.6.3, i think that's the corporate version at the time. for most of my linux research and linux book summaries. all i can say is, for me, it works great. never had any issues with it, very stable too. thank you for sharing your knowledge.-Debian 9 user.
@@dreamleaf6784 Well, autocorrect works perfectly for me! The problem with inserting images is a general one of all the office software and not at all specific of Libreoffice. Just search about how to handle it and after a bit of trying you'll learn how to make it easy. I wrote my master's thesis with hundreds of images and all the technical aspects in Libreoffice so you can definitely use it with ease for any purpose.
Thank you Chris for this tutorial. For Ubuntu Users: If you get an error that says the latest installer is already installed like I did (And still don't have the MS fonts), then you need to renew the license agreement by typing this: sudo apt-get install --reinstall ttf-mscorefonts-installer. Then ok the message and click YES to agree to EULA.
@@hyperspeed1313 Don't know about that. Chris probably does though. All I can say is I got an error and then when I went into the directory of /usr/share/fonts there was a folder there called ttfmsfonts. In that folder was a README file that said to issue the command I show above. Honestly, I wasn't trying to be a smart-ass or a know-it-all. I was just trying to help out.
I switched to Libre Office from Microsoft Office, and found it amazing! I've used both of them, but you must break a bank to maintain MS Office. Thank you for this video.
The default layout of LibreOffice is actually closer to the old MSO 2003 layout. New LO also comes with an option to turn on tabbed toolbars, effectively giving something similar to MSO 2007 (and later) ribbon interface. The fonts is a definite must for formatting purposes, though there are licensing issues with some of them. Usually it doesn't open as garbage on either LO or MSO, but it attempts the closest matching installed font, else a default font. This tends to mean layout changes as character spacings differ between fonts. Most word processing uses standard character encodings like UTF or ASCII, so the most common letters would work perfectly fine no matter the font chosen (except when going for some weird font like Dingbats). Also DOCX and ODF (or rather ODT for text documents) were the two competing open document formats. MSO's DOCX won due to MSO having such a huge user base. But there were lots of controversy as MS tended to add non-standard stuff into their format. Same goes for XLSX and ODS. There is also filter packs you can install for MSO so it can in fact handle ODF formats: www.microsoft.com/en-us/download/details.aspx?id=17062 BTW, if you use styles in your documents (which really you should be doing even in MSO) then Libre's style manager palette is a much nicer way of working with them. As for Calc, it really just feels like Excel 2003. Though I do miss auto table formatting and the filer buttons on table headers. I have run into one situation where Calc just doesn't work well - formatting numbers in engineering notation, it only has scientific, in Excel you can fiddle with some custom formatting options to simulate engineering notation. As for VBA, yep that's a big problem. LO does have SBasic which is very similar and you do get translate tools which does a lot of the grinds to change VBA scripts to SBasic. But they're never perfect and you will have to tweak them. Else just stick to MSO for these things.
It's a matter of age, I guess. I like the LibreOffice display because it looks like MS Office did when I started using it years ago: simpler, cleaner, and with the traditional universal menu system. It's one system for nearly all applications.
A very good point! Lots of people don't realize that Bill Gates took a ton of typography courses and is the father of many of these copyrighted fonts we use today.
@@ChrisTitusTech and you know what, I tend to like the default button layout more than the contextual grouping you did here. I never did care for Microsoft's decision to implement it back in 2012.
@@ChrisTitusTech Both statements about Bill Gates are total news to me. Microsoft chased Apple on all things font and DTP, stuffing up endlessly along the way. They did however muscle out all competition by fair means and foul which is why the fonts people use most are from Microsoft Office. Only few of which were commissioned by them. I think you have got your stories all mixed up. It was Steve Jobs who took Calligraphy courses that lead to his perfectionism with typography on the Mac.
@@ChrisTitusTech Actually knowing what I know of Bill Gates the notion of him taking time off from building the Microsoft empire to do typography courses, sounds quite ridiculous.
Yeah, you are right! Steve jobs was the one that took calligraphy courses and made many of the fonts we use today. Hard to keep these facts straight since everyone stole from everybody. Gates was just the best thief of them all because he understood the contracts and legal process. The true inventors of the personal computer of today were the Xerox PARC folks.
I ditched Microsoft Office five years ago and installed Libre Office on Mac, Linux and Windows 10. I have never looked back, my staff love it, I haven't felt like I am missing any features or usability.
less that it doesn't live up to it's actuall title, but more that it's one of the most helpful videos for "LibreOffice to MsOffice compatability" and etc
Thanks for posting this video! Given all the years I've been using LibreOffice, I never enabled the experimental features. :) lol I have mixed thoughts about changing LibreOffice to look more like MS Office, but I can definitely understand the desire to do so. The main thing is people spend time to learn how much functionality LibreOffice really has. Calc doesn't support VB Script for macros, so I can understand that being an issue. However, Calc does provide a *ton* of features and functions similar to Excel. My dad is an Excel "power" user and does a lot with multi-sheet spreadsheets, including hiding rows, using formulas that span multiple sheets, and a bunch of other stuff I never knew Excel could do. lol I switch him to LibreOffice years ago and he'll have an occasional question about how to do something, and I've always found the answer by doing a little research. I just don't use spreadsheet applications with much frequency at all. In any event, thanks for posting the video!
Calc does have scripting available via LibreOffice Basic, or you can use Python, Javascript and possibly others. Having used both VB script and LibreOffice Basic, I will have to admit that the former is more intuitive and easier to program in, but they both have their quirks.
Pity IBM killed the vastly superior Lotus Smartsuite about 20y ago. Lotus 1-2-3 was made by engineers, and it showed. Excel still cannot do what Lotus did with a mouse click, and even when it can do some of it, VBS is required. They dumbed down corporate workflow for no good reason.
Thank you Chris for this video. I am a user of LibreOffice. I use it exclusively. I have never really understood why Windows Office users always had some gripes about LibreOffice. Now my understanding of their issues has increase.
I am a Linux Guy and so LibreOffice has been on my hands for all my years in computing- I have learnt to work on it better via this video by setting it to work like MS office -- you can't imagine how many times I shared wrongly saved extension with windows guys
I use it all the time, and for what I do, it works very well! I am not a business. I REFUSE to be held captive by Microsoft's scams where Office is concerned!
I have both, and use both. I do not follow the rule that goes like this "when the only tool you have is a hammer, everything looks like a nail". I had 10 years of using MS Office and an a similar time 10 years with LibreOffice, I have no problems in using either. You do need a bit of memory to remember word processing shortcuts. As for spread-sheets, I can load my complex sheets with either product and functionality is the same.
Thank you thank you! I never thought of just defaulting the save to docx, set it and forget it. Now I can share with family again w/o manually saving as docs. I did have to install calibri separately (which was easy), for some reason it wasn't included in the microsoft ttf install.
thank you very much. this is awesome , i am a recent convert to LibreOffice and this has made it so much easier to work with others who are still using MS
Before I used Libreoffice but gave up due to several reasons. But the new iteration of Libreoffice feels very polished and good for those used to Microsoft Word. I ran the new program for a bit and not having any frustration episodes so far. Good thing !
I tried a few of my Excel spreadsheets and they loaded just fine. From my side, it looks like I will have to get used to their coding structure for formulas. Bu that won't keep me from getting deeper into this. I'm glad you posted the fonts portion, I never thought about that.
Chris, I went a step further and setup a keyboard shortcut to hide/unhide the menubar because the menubar looks foreign with that UI style. Really love your content.
I remember in the last 2 years I worked 2009/2010, I used OpenOffice, the predecessor of LibreOffice, twice to safe complex Word document of colleagues. Word would crash on it, after opening it in OpenOffice and saving it again, they were re-usable in Word again.
The opening comments can also be said of Microsoft Office: having used LibreOffice at home when I recently changed jobs and had to usr excel I found exactly the same - ooen it up, try to do a couple of things, and yeuck. Unfortunately I didn't have the give up option to be ablecto just close it. Even now, 8 months later, I regularly get frustrated by excel's way of doing things (which is not surprising having used first OpenOffice and now LibreOffice for 10+ years). It all boils down to what you're used to, but that doesn't counteract the learning curve of any different package - it just makes it harder to switch.
Thank you for this video, I wanted to transition everything to linux and became frustrated with the font and general structure and then went back to windows for some excel work. Please make more of this videos that help in transitioning
I just saw this video today. Thanks for this. Since my son was using his laptop mainly for online games and watching TH-cam videos, we did not get him Office for his laptop when we bought it a couple of years ago. Now that he has to use it for online college classes due to the pandemic, I loaded LO and have had to teach him to save his files in MSO formats (mainly Word) since LO did not do that automatically. His classes require the use of MSO formats (or PDF's depending on the situation). My son is intellectually challenged, so he does not pick up on these things easily, being able to change the default format LO saves in will be a big help, especially since classes will be starting up again. THANKS!!! BTW, he is using it on a Windows laptop, I need to see if I need to change the default font, too, I did not think of that. His teachers have not complained about incompatible fonts, only file format.
Thank you for this sir. I have seen this video years ago, i am just revisiting this video again. this is a 4 year old video but still a gold for information. Thank you.
5 ปีที่แล้ว +4
I switched from MS Office to Open Office when MS Office introduced the ribbon toolbars (which I believe was Office 2007). I was annoyed at that change of interface and never ever used MS Office again. Then in 2011, IIRC, there was this drama between Open Office and Libre Office and I switched to Libre Office. I was still a Windows user back then, for many years. I was never a power user of any office suite, I mostly used Word/Writer for writing homework, essays and reports in school, and Excel for converting tabular data to CSV files for data analysis in college. That said, I find Libre Office to be somewhat poop, so I rarely use it (pretty much only when someone sends me a MS Office file). I mostly use LaTeX for writing documents (and I write it in Kate), and I typically use custom NodeJS scripts when working with tabular data and CSV files. For presentations and slide shows, I either use LaTeX or Corel Draw (which I really miss on Linux).
LaTeX has a pretty steep learning curve, but it is my choice when writing up my resume. Documents have never been prettier.
5 ปีที่แล้ว
@@trapspringer9891 I learnt it in college. I studied physics, and we did everything in LaTeX. This was before I switched to Linux, so this is one of the things that only got better as I switched. MikTeX under Windows is not the nicest experience.
If you use CorelDraw for layout purposes, you may want to take a look at Scribus. It's effectively a WYSIWYG editor for stuff like magazine / newspaper layouts. There is also a graphical overlay onto Latex called GNU TeXmacs, perhaps decent though I only tried it out, for me text layouts is secondary, I'm much more into graphics work professionally.
@@benriful Scribes describe[sd] itself as "Open Source Desktop Publishing" so it's more than a "WYSIWYG editor"; it's intended for DTP layout and not word processing, unlike Word or Writer which are intended for word processing, but have DTP layout features bolted on.
Thank you for the vid. This is exactly what I'm looking for. So now I could use libre office to create documents for collaboration. Those you mentioned are what's holding me back in ditching Office 2013 (via wine) on my Linux laptop.
I used Libre in my office while everybody is using microsoft, although for most part Libre office delivers, it can be frustrating when document format is everything. Apparently when exported to Docx, my counterparts with microsoft sometimes sees stuff different than I.
I don't use a word processor much anymore, but my LibreOffice is nicely setup: around 8 icon themes to choose from, several color theme settings, reconfigured menu & toolbar, several plugin extensions, Emacs keybindings + original/alternate keybindings on top of that and it's all synced with my TexLive install: it's a great program if you're willing to put the time in.
Also, Brother Chris, if your recipient doesn't need to modify the document, then you can send the document as PDF very easily, and there's no concern about the loss of fidelity. Look under the File menu. Perfect! :-)
I was more used to the old, old MS Office, so the LibreOffice default is just as well for me too anyway. For people used to MS Office, my condolences. It's a bit like the tail wagging the dog. I mean, it's just the UI menu stuff anyway. This isn't rocket science.
Such a pity there is no local ms office application for Linux but its amazing how good Libreoffice is. I remember trying it back in 2015 and had a horrible experience with it saving documents so they work on windows but now it is so much easier.
Dude could you make tutorials on covering the topics in red hat exams. And also, maybe lab exercises vm from centos would be really cool.. You explanations are clear and easy to understand. Thanks
Having used both products, I honestly prefer libre office over Microsoft office. In my opinion it's way more powerful and customizable. Did my MSc thesis using this application and the end result had a professional look and feel to it. Received lots of positive feedback on the finished product
Nice video guide on changing defaults! I'm lucky not to be worried about sharing documents with others but I too once changed at least the theme somehow and remember it felt... difficult. Having the Microsoft fonts installed is handy either way, so if it isn't for FreeOffice (which is really nice btw albeit closed source) this comes in handy also.
This has been exactly my gripe about Libre / Linux. The biz world runs on MS Office and the lack of familiarity with the UI on Libre Writer. Great video with many helpful tips.
I always use LibreOffice for my work and home. The occasion I fallback to MS Office is only when some nasty old Excel doc with really really big data bogs LibreCalc down. For such big table, LibreCalc tend to be slow and sluggish on my old PC. Except such rare occasion, LibreOffice is much better than old Office 2007 I have used before.
Thanks alot Chris, indeed its very useful to know these, lets call them "optimizations" in order to make the adjustments and use it better, hopefully this will help a lot more people to start learning and using Libreoffice much more and less dependant on just microsofts programs and OS.
This was actually helpful, particularly things like view style, save, fonts. Another irritation is the context menu that pops up on right click on highlighted text. I had to customize mine (and wife's). You could add more on that as the discussions on the libreoffice help forums are confusing. They use different terminology of in libre land and yet sometimes switch back to MS terminology, very confusing
Chris, I found this very helpful thanks. Could you or do you have a video explaining how to stop Microsoft office taking over when I try to send an email through LibreOffice.
4 things LO does need: (1) An easy way to set up alternating page numbers (2) Tabbed windows (3) Popup terminal (4) File-manager - maybe solarized & dark mode options since people like that.
As with MS Word, you MUST establish styles in LibreOffice. In doing so you are not futzing with the margins and tabs in the ruler. As for long documents of 300 pages, I'm unsure. When I last tried to set up a LibreOffice document with styles to produce manufacturing and mechanical equipment user documentation, now five years ago (now is 3NOV2020, Tuesday), the line art illustrations and illustrated images (images with call outs in a graphic frame, disappeared on document reopen using ODT, DOC, and DOCX. I use LibreOffice for cover letters / resumes using the fully defined template of about 10 styles. Works fine save for a few updated version that blew up the template on reopen. Ensure the styles using bullet lists or number lists are fully defined, yet the bug was in LibreOffice. Reverted to the prior version, works in the second newest version and fine since then. Microsoft, with each office update, foils LibreOffice and other productivity suites by changing the .xxxX (.docx) formats in minor yet myriad ways. I wholly despise the MS Office 2007+ ribbons as this GUI change requires more click, 50% to 75% more mouse clicks, to complete a task. I mean to try using LibreOffice for long, heavily illustrated manuals saving the file in the ODT and DOCX formats again. If you open a LibreOffice ODT or DOC or DOCX file, you will find the page size definition changes. The MS Word presentation indicates the text is larger by point size or more spacing between text lines. Else, when using LibreOffice exclusively to produce content, and save to PDF, with PDF views set (Bookmarks, Document Fit, and like open PDF view), LibreOffice appears competent.
If Liberation Serif, a free open source font, is not installed on a computer then font substitution should occur. This might cause subtle issues with spacing and formatting but its not going to "look like Chinese". However, its a reasonable suggestion to use the MS fonts and to save as docx (Word) and xlsx (Excel) formats. Whatever you do, do NOT use the old DOC format which was deprecated 10 years ago, wastes disk space with its bloated files, and has security issues. Libre Office is much easier to install on Windows. You run the install and done. Libre Office will not automatically update but frequent updates are available if you are interested.
Yes. Learn Libreoffice by converting your most complex documents from Microsoft Office to Libreoffice. I have faith in you, Chris. You can do it for sure.
I've been using Libreoffice for about 2 years and only just learned today that UI contextual groups are a thing, effectively substituting one of my main features I miss from MS Office, the Ribbon UI.
The way to insert is to tap F11, and in the current edition (2022) the way to turn off overwrite is through the lower right hand portion of the line just above the task bar. This is the lower line with page numbers, word count, character count, page style, language, and zoom reports. Between the language box and the zoom box in the lower right portion of the screen, 'OVERWRITE' will appear when the word processor has gotten onto overwrite mode. Simply click on that report. OVERWRITE will vanish, and your keying will return to normal insert mode. There! Remember. The general principle when learning digital devices is to tap/click EVERYTHING to see what it does. Devices teach themselves to you, if you will simply keep exploring. That is how children exceed adults in learning speed with regard to digital devices.
Dear Chris, I removed the LibreOffice which was default in Mint 19.2 Cinammon and installed the Flatpack one (Oracle).... but I can't install the MScore fonts (: ... I tried all the proposals you mentioned... Any other suggestion?
I found a solution... I installed them from the "windows/fonts" folder... but I can't install them simultaneously by selecting ALL of them... is there a solution for it?
Been a long time Linux user. When I was repairing Photocopiers,Printers & fax machines, Quite often so called broken printers where incompatible versions of micro$oft office or uninstalled fonts and or paper formats eg metric, imperial and customary this is in a world where the floppy was still king and e-mail was still quite new (file transfers) USB was a dream. Even now I support 4 machines that have different versions of office most of the nubs would have a problem with the change of interface... Each machine has a job to do and sometimes you leave a machine where it is rather than upgrade for upgrades sake. Office is font, printer and version dependent for layout has been that way for over 20 years and still is. Yes i have seen the same document print differently from the same computer to different printers and or different driver languages on the same printer. Business chose office as a standard for not other reason than it was easy to get and work with windows. Some times i long for the day when real Men/Woman would write there own drivers...
Also, you might want to store all of your original long term documents in the open ODF format, and convert to Microsoft Office format, or formats, on demand.
Thank you. I’m old and have left Microsoft do to costs and their constantly changing. I’ve supported them since 123 when they first came on. But the constant upgrades and higher and higher costs and I only use office writer and math parts for letters and spreadsheets it’s not worth the hassle. Again I trying to teach myself and old man with a fading memory.
So I installed Carlito Font instead cause they said that I needed a license or something. And that Carlito Font was like very Identical to Calibri it wouldnt be a problem compatiblility wise. so everything is good. Great video
So I had a question for you. Microsoft word/office 365 has a document translation function. I wanted to ask if LibreOffice has this? (Or a work around?) I may need this feature for some business needs. But I don't want to go back to anything Microsoft or windows if there's a way to avoid it. I like Linux and LibreOffice a lot better. Plus cheaper. LibreOffice is also a wonderful product.
what version of LibreOffice are you using? your interface looks super clean and it is not available (only "contextual single") with the newest version under Windows 10 :(( also i cant download the fonts...your link only opens a txt document...
I'm not a big MS fan, but from all the alternatives I've seen, they all have their quirks, which is why MS Excel is so popular, out of the box, it works, can be customized without having to download and configure additional features. Many of us have decades invested into Excel and VBA, and to have to navigate around re-learning how to do old things, a new way, skipping countless hours wondering how to fix the things that don't crossover between LibreOffice and MS Office, you mays well just fork over the money, and stay with Excel, a name that people have been familiar with since Lotus 1-2-3 went extinct.
Agreed... the free programs are fine if you're doing something simple. But the more advanced you get, Excel starts to really pull away from the pack. VBA and more recently Power Query are absolute game changers that the free programs can match. As a statistician who works with data, there are simply things I can do in Excel that I just can't do with the free alternatives. Light users: Any suite will do (might as well save money and use a free one). Regular users: Free may still be ok, but you might find yourself missing a few features. Advanced users: Excel really shines. Unless you want to learn a coding language like SAS or Python, it's the clear choice. Just my $0.02.
You cover all the bases. This how I been doing this way over a decade. The other things to cover is online office tools. Sometimes I have to use this to correspond to a Windows user. Just so there is no problem with file sharing. If for any reason LibreOffice can't take care of it. Another thing I do, for a quick send. This is only if it don't need to be professional and the other party don't need to edit it. Is just a screenshot as a .jpeg or any other type of format. I even went as far as .pdf or a .html webpage. So they see it as I see it. Been with Linux for 16 years and not once I had to use Windows to do a task. Everybody can do it, if you think outside the box. Sometime I do things in a orthodox way, if I need to do it that way. My way of thinking is the end game. If at the end of my computer task is a finish product in any shape or form and I'm doing it all in Linux. Then it's a win win to me.
Nice show! It's about time someone show how to install those Microsoft fonts, they're all free, why don't they per-install them. Copy-write lawyers make life difficult! Years ago we install Open Office on XP, we couldn't stand 2007 Office ribbons so we still save files in (doc.) for better capability with modern Office .
Helo There. Please note EULA during install at 8:05. It say that is permited to use those fonts ONLY if you have Vista or Office licensed on the computer.
I saw a recent tutorial on the newer versions, if u send a document from this program the reciever needs to have libre office to read it BUT simple work around save and send as a PDF then most ppl will be able to read it.
Started with Libre office and switched to Word subscription service to finish my book on multiple devices...PC, Chrome book, tablet and phone. Libre office is very hard to use on many devices...no android app or apple app and moving around files is a pain. You get what you pay for but on a single device Libre office is great for simple uses.
A tip: If you have dual booted windows and linux and you want windows fonts , just copy the fonts folder in windows folder in u r C drive and paste it in /usr/share/fonts in your linux and you good to go!!
On a Debian based system I always swap out the LibreOffice that you get pre-installed for the repositories with the flatpak. Debian repositories (Ubuntu's repos as well) tend to get old really fast cause they don't update them. Flatpaks are up to date,. As far as snaps are concerned, I'm with you on that one!
@Donald Mickunas Key word is bleeding edge. I don't keep everything up to date and rolling releases tend to break themselves as far as OS components are concerned. I use my computer to get actual work done and most times I don't have time to figure out how the latest rolling update broke my system. There are only a few programs i actually worry about keeping up to date. LibreOffice is one of them because of security concerns (I use a lot of macros). I don't keep everything up to date all the time, just a few select programs.
VIDEO REQUESTED: 1) Font management: It's great that Ubuntu and other distros provide fonts for the world, but how do I eliminate the non-western fonts I don't use and install the western fonts that I need. Thanks! ALSO: 2) I would appreciate some instruction on how to backup/restore/manage iPhone on Linux. THANKS!
It doesn't just take more space on your drive to use a flatpak. There's overhead with the container, and possibly redundant libraries in RAM if multiple programs could otherwise be using the same libraries. I hate flatpaks and snaps in general, and the only benefits are for the package maintainers. For end users, they are just a losing proposition. I only have libreoffice installed in order to use it in headless mode to do conversions from the commandline. A very nice feature, one as far as I know completely absent in MS office and similar proprietary suites, but I had to spin up a container every time I called it, it definitely wouldn't be worth it.
Ive never found anything bad with LibreOffice, looks or function. I was on open office then went to LibreOffice, when lots of bugs crashes open office.
@@Shadow25720 i don't like the ribbon, i think menus and all common tools out in the open is far more efficient. All i am saying is that people so accustomed to MS office will think the design old fashioned or even inherently broken due to aged design.
Indeed and that's not a bad thing. Office 2000, XP and 2003 used to be great. I can't blame those who got used to the new Ribbon Theme however, let alone sometimes a new look make things feel fresh (even though in business environments that's rather less helpful).
![Making LibreOffice More Like Microsoft Office [For Free]](/img/n.gif)
I used libreoffice during college, then I used it during my masters, I wrote my thesis on it. I'm a teacher now and I still use libreoffice. Yeah, it may not be eyecandy, but it delivers!
Yes indeed! In fact, I think Libre's new version is actually quite elegant.
You should send your students an ODF file as an April fool's day joke.
@@greasysteve5671 Just imagine,
"The frick is an ODF file?!"
Then that one Linux kid is just thinking "Oh yeah."
Mr. Hinojosa, that's amazing!
My wife used Word for her masters thesis. It got to the point where the DOCX file was massive and took forever to open. A week before she needed to submit to the printers, Word gave up on the file with a 'cannot open file' type message. In desperation, I installed Libreoffice on my Windows notebook and opened the file. It took a while to open and kept spitting back messages about correcting invalid references etc. But it did open. And then saved to 40% of the Word file size. Libreoffice does DOCX better than Microsoft. That is a demonstration in compatibility!!
In my conclusion, it is always better to have a legal office. You save yourself a lot of problems in the future if you are a person who does not have much knowledge of computers.
I totally agree. I recently had some malware problems and now I'm looking for my Windows Office again.
If you want to save yourself some time, BNH Software recently helped me with Windows Offices.
On a slight note, NEVER set the default to docx format. It is so not recommended to save in docx format in libre office, IF you're going to edit it later. ALWAYS save in .odf format, BUT when you want to share the doc you can save it as .DOCX for sharing.
Can you help me understand why this matters?
Joined to question higher.
@@nicole-secondaryemail-mort9617 cause if you save and edit it as a docx file the file may break, so you should save it as an odf file and edit it that way. When you need to share it you just save it again as a docx.
@@TAmzid2872 Got it, thank you!
@@TAmzid2872why should it break? Isn't libre compatible with docx?
Been using it for years in my law practice. It checks all the boxes for me. Love it.
I've written and published a tabletop RPG (The Chronicles of Ember) with LibreOffice. I don't miss MS Office at all.
Same here! I used Wordpad, but then started to use Libre Office for my RPG ideas. Being able to drop images in and wrap to background is so useful. Glad to hear you had success with it.
I use libre office version 6.1.6.3, i think that's the corporate version at the time. for most of my linux research and linux book summaries. all i can say is, for me, it works great. never had any issues with it, very stable too. thank you for sharing your knowledge.-Debian 9 user.
I've been using Libreoffice for years and I think it's great! I see no reason why anyone would think of going back to use Microsoft office
auto save is a big reason i’m going back
Auto correct doesn't work as good and when I try to embed a picture, it goes in a weird place and it's hard to fix.
@@dreamleaf6784 Well, autocorrect works perfectly for me! The problem with inserting images is a general one of all the office software and not at all specific of Libreoffice. Just search about how to handle it and after a bit of trying you'll learn how to make it easy. I wrote my master's thesis with hundreds of images and all the technical aspects in Libreoffice so you can definitely use it with ease for any purpose.
@@maybethisismarq I never had such problem!
Thank you Chris for this tutorial. For Ubuntu Users: If you get an error that says the latest installer is already installed like I did (And still don't have the MS fonts), then you need to renew the license agreement by typing this:
sudo apt-get install --reinstall ttf-mscorefonts-installer. Then ok the message and click YES to agree to EULA.
Casual2020 What about sudo dpkg-reconfigure ttf-mscorefonts-installer?
@@hyperspeed1313 Don't know about that. Chris probably does though. All I can say is I got an error and then when I went into the directory of /usr/share/fonts there was a folder there called ttfmsfonts. In that folder was a README file that said to issue the command I show above. Honestly, I wasn't trying to be a smart-ass or a know-it-all. I was just trying to help out.
I switched to Libre Office from Microsoft Office, and found it amazing! I've used both of them, but you must break a bank to maintain MS Office. Thank you for this video.
Thanks. Timing of this upload is perfect for me, having installed Zorin OS last week as a new-to-Linux convert...
The default layout of LibreOffice is actually closer to the old MSO 2003 layout. New LO also comes with an option to turn on tabbed toolbars, effectively giving something similar to MSO 2007 (and later) ribbon interface.
The fonts is a definite must for formatting purposes, though there are licensing issues with some of them. Usually it doesn't open as garbage on either LO or MSO, but it attempts the closest matching installed font, else a default font. This tends to mean layout changes as character spacings differ between fonts. Most word processing uses standard character encodings like UTF or ASCII, so the most common letters would work perfectly fine no matter the font chosen (except when going for some weird font like Dingbats).
Also DOCX and ODF (or rather ODT for text documents) were the two competing open document formats. MSO's DOCX won due to MSO having such a huge user base. But there were lots of controversy as MS tended to add non-standard stuff into their format. Same goes for XLSX and ODS. There is also filter packs you can install for MSO so it can in fact handle ODF formats: www.microsoft.com/en-us/download/details.aspx?id=17062
BTW, if you use styles in your documents (which really you should be doing even in MSO) then Libre's style manager palette is a much nicer way of working with them.
As for Calc, it really just feels like Excel 2003. Though I do miss auto table formatting and the filer buttons on table headers. I have run into one situation where Calc just doesn't work well - formatting numbers in engineering notation, it only has scientific, in Excel you can fiddle with some custom formatting options to simulate engineering notation.
As for VBA, yep that's a big problem. LO does have SBasic which is very similar and you do get translate tools which does a lot of the grinds to change VBA scripts to SBasic. But they're never perfect and you will have to tweak them. Else just stick to MSO for these things.
I use LibreOffice BTW
OH PLEASE PLEASE PLEASE PLEASE THOSE I USE BTWs ARE THE WORST THINGS EVA
@@gayanekhachatryan7509 I USE CAPITALS BTW
no caps btw
@@gayanekhachatryan7509 specially "I use Arch BTW"😂😂
lol
It's a matter of age, I guess. I like the LibreOffice display because it looks like MS Office did when I started using it years ago: simpler, cleaner, and with the traditional universal menu system. It's one system for nearly all applications.
yeah, agree (:
There are copyright reasons why LibreOffice doesn't look like MS Office or have some of it's features installed be default, out of the box.
A very good point! Lots of people don't realize that Bill Gates took a ton of typography courses and is the father of many of these copyrighted fonts we use today.
@@ChrisTitusTech and you know what, I tend to like the default button layout more than the contextual grouping you did here. I never did care for Microsoft's decision to implement it back in 2012.
@@ChrisTitusTech Both statements about Bill Gates are total news to me. Microsoft chased Apple on all things font and DTP, stuffing up endlessly along the way. They did however muscle out all competition by fair means and foul which is why the fonts people use most are from Microsoft Office. Only few of which were commissioned by them.
I think you have got your stories all mixed up. It was Steve Jobs who took Calligraphy courses that lead to his perfectionism with typography on the Mac.
@@ChrisTitusTech Actually knowing what I know of Bill Gates the notion of him taking time off from building the Microsoft empire to do typography courses, sounds quite ridiculous.
Yeah, you are right! Steve jobs was the one that took calligraphy courses and made many of the fonts we use today. Hard to keep these facts straight since everyone stole from everybody. Gates was just the best thief of them all because he understood the contracts and legal process. The true inventors of the personal computer of today were the Xerox PARC folks.
I ditched Microsoft Office five years ago and installed Libre Office on Mac, Linux and Windows 10. I have never looked back, my staff love it, I haven't felt like I am missing any features or usability.
This video should be titled “how to make Libre Office work in a Microsoft Word world”
It definitely does not live up to its actual title
less that it doesn't live up to it's actuall title, but more that it's one of the most helpful videos for "LibreOffice to MsOffice compatability" and etc
Thanks for posting this video! Given all the years I've been using LibreOffice, I never enabled the experimental features. :) lol I have mixed thoughts about changing LibreOffice to look more like MS Office, but I can definitely understand the desire to do so. The main thing is people spend time to learn how much functionality LibreOffice really has. Calc doesn't support VB Script for macros, so I can understand that being an issue. However, Calc does provide a *ton* of features and functions similar to Excel. My dad is an Excel "power" user and does a lot with multi-sheet spreadsheets, including hiding rows, using formulas that span multiple sheets, and a bunch of other stuff I never knew Excel could do. lol I switch him to LibreOffice years ago and he'll have an occasional question about how to do something, and I've always found the answer by doing a little research. I just don't use spreadsheet applications with much frequency at all.
In any event, thanks for posting the video!
Calc does have scripting available via LibreOffice Basic, or you can use Python, Javascript and possibly others.
Having used both VB script and LibreOffice Basic, I will have to admit that the former is more intuitive and easier to program in, but they both have their quirks.
Pity IBM killed the vastly superior Lotus Smartsuite about 20y ago. Lotus 1-2-3 was made by engineers, and it showed. Excel still cannot do what Lotus did with a mouse click, and even when it can do some of it, VBS is required. They dumbed down corporate workflow for no good reason.
Thank you Chris for this video. I am a user of LibreOffice. I use it exclusively. I have never really understood why Windows Office users always had some gripes about LibreOffice. Now my understanding of their issues has increase.
I thinkLibreOffice is better and easier than Microsoft
I am a Linux Guy and so LibreOffice has been on my hands for all my years in computing- I have learnt to work on it better via this video by setting it to work like MS office -- you can't imagine how many times I shared wrongly saved extension with windows guys
I use it all the time, and for what I do, it works very well! I am not a business. I REFUSE to be held captive by Microsoft's scams where Office is concerned!
I have both, and use both. I do not follow the rule that goes like this "when the only tool you have is a hammer, everything looks like a nail". I had 10 years of using MS Office and an a similar time 10 years with LibreOffice, I have no problems in using either.
You do need a bit of memory to remember word processing shortcuts. As for spread-sheets, I can load my complex sheets with either product and functionality is the same.
Thank you thank you! I never thought of just defaulting the save to docx, set it and forget it. Now I can share with family again w/o manually saving as docs. I did have to install calibri separately (which was easy), for some reason it wasn't included in the microsoft ttf install.
I am student and I m switching to linux just because of you...wanted to say "THANKYOU"🤝
thank you very much. this is awesome , i am a recent convert to LibreOffice and this has made it so much easier to work with others who are still using MS
Before I used Libreoffice but gave up due to several reasons. But the new iteration of Libreoffice feels very polished and good for those used to Microsoft Word. I ran the new program for a bit and not having any frustration episodes so far. Good thing !
I tried a few of my Excel spreadsheets and they loaded just fine. From my side, it looks like I will have to get used to their coding structure for formulas. Bu that won't keep me from getting deeper into this. I'm glad you posted the fonts portion, I never thought about that.
how's the progress?
Your prelude to this video is SPLENDID.
Chris, I went a step further and setup a keyboard shortcut to hide/unhide the menubar because the menubar looks foreign with that UI style. Really love your content.
Thanks for this - I use Libre Office on my lunux systens, and now have some ideas to make it more useful to my users.
I remember in the last 2 years I worked 2009/2010, I used OpenOffice, the predecessor of LibreOffice, twice to safe complex Word document of colleagues. Word would crash on it, after opening it in OpenOffice and saving it again, they were re-usable in Word again.
Moved over 15 years ago. Excellent program. Also use Scribus to produce a 40 page magazine twice a year.
The opening comments can also be said of Microsoft Office: having used LibreOffice at home when I recently changed jobs and had to usr excel I found exactly the same - ooen it up, try to do a couple of things, and yeuck. Unfortunately I didn't have the give up option to be ablecto just close it.
Even now, 8 months later, I regularly get frustrated by excel's way of doing things (which is not surprising having used first OpenOffice and now LibreOffice for 10+ years).
It all boils down to what you're used to, but that doesn't counteract the learning curve of any different package - it just makes it harder to switch.
Thank you for this video, I wanted to transition everything to linux and became frustrated with the font and general structure and then went back to windows for some excel work. Please make more of this videos that help in transitioning
Seems more like the title would be MS Word vs Libre Writer
I just saw this video today. Thanks for this. Since my son was using his laptop mainly for online games and watching TH-cam videos, we did not get him Office for his laptop when we bought it a couple of years ago. Now that he has to use it for online college classes due to the pandemic, I loaded LO and have had to teach him to save his files in MSO formats (mainly Word) since LO did not do that automatically. His classes require the use of MSO formats (or PDF's depending on the situation). My son is intellectually challenged, so he does not pick up on these things easily, being able to change the default format LO saves in will be a big help, especially since classes will be starting up again. THANKS!!! BTW, he is using it on a Windows laptop, I need to see if I need to change the default font, too, I did not think of that. His teachers have not complained about incompatible fonts, only file format.
Thank you for this sir. I have seen this video years ago, i am just revisiting this video again.
this is a 4 year old video but still a gold for information. Thank you.
I switched from MS Office to Open Office when MS Office introduced the ribbon toolbars (which I believe was Office 2007). I was annoyed at that change of interface and never ever used MS Office again. Then in 2011, IIRC, there was this drama between Open Office and Libre Office and I switched to Libre Office. I was still a Windows user back then, for many years. I was never a power user of any office suite, I mostly used Word/Writer for writing homework, essays and reports in school, and Excel for converting tabular data to CSV files for data analysis in college.
That said, I find Libre Office to be somewhat poop, so I rarely use it (pretty much only when someone sends me a MS Office file). I mostly use LaTeX for writing documents (and I write it in Kate), and I typically use custom NodeJS scripts when working with tabular data and CSV files. For presentations and slide shows, I either use LaTeX or Corel Draw (which I really miss on Linux).
LaTeX has a pretty steep learning curve, but it is my choice when writing up my resume. Documents have never been prettier.
@@trapspringer9891 I learnt it in college. I studied physics, and we did everything in LaTeX. This was before I switched to Linux, so this is one of the things that only got better as I switched. MikTeX under Windows is not the nicest experience.
If you use CorelDraw for layout purposes, you may want to take a look at Scribus. It's effectively a WYSIWYG editor for stuff like magazine / newspaper layouts. There is also a graphical overlay onto Latex called GNU TeXmacs, perhaps decent though I only tried it out, for me text layouts is secondary, I'm much more into graphics work professionally.
@@benriful
Scribes describe[sd] itself as "Open Source Desktop Publishing" so it's more than a "WYSIWYG editor"; it's intended for DTP layout and not word processing, unlike Word or Writer which are intended for word processing, but have DTP layout features bolted on.
Thank you for the vid. This is exactly what I'm looking for. So now I could use libre office to create documents for collaboration. Those you mentioned are what's holding me back in ditching Office 2013 (via wine) on my Linux laptop.
I used Libre in my office while everybody is using microsoft, although for most part Libre office delivers, it can be frustrating when document format is everything. Apparently when exported to Docx, my counterparts with microsoft sometimes sees stuff different than I.
I don't use a word processor much anymore, but my LibreOffice is nicely setup: around 8 icon themes to choose from, several color theme settings, reconfigured menu & toolbar, several plugin extensions, Emacs keybindings + original/alternate keybindings on top of that and it's all synced with my TexLive install: it's a great program if you're willing to put the time in.
Also, Brother Chris, if your recipient doesn't need to modify the document, then you can send the document as PDF very easily, and there's no concern about the loss of fidelity. Look under the File menu. Perfect! :-)
That's how we roll
I like libreoffice more when it's not customized to match microsoft office.
but for ppl used with ms office..
I was more used to the old, old MS Office, so the LibreOffice default is just as well for me too anyway. For people used to MS Office, my condolences. It's a bit like the tail wagging the dog. I mean, it's just the UI menu stuff anyway. This isn't rocket science.
Such a pity there is no local ms office application for Linux but its amazing how good Libreoffice is. I remember trying it back in 2015 and had a horrible experience with it saving documents so they work on windows but now it is so much easier.
Dude could you make tutorials on covering the topics in red hat exams. And also, maybe lab exercises vm from centos would be really cool..
You explanations are clear and easy to understand. Thanks
Thank you, Chris. LibreOffice is great. I began with its precursor, StarOffice, when it became libre.
Thanks universe to make me find this video, and thank you, Chris, for making it
Having used both products, I honestly prefer libre office over Microsoft office. In my opinion it's way more powerful and customizable. Did my MSc thesis using this application and the end result had a professional look and feel to it. Received lots of positive feedback on the finished product
Nice video guide on changing defaults!
I'm lucky not to be worried about sharing documents with others but I too once changed at least the theme somehow and remember it felt... difficult.
Having the Microsoft fonts installed is handy either way, so if it isn't for FreeOffice (which is really nice btw albeit closed source) this comes in handy also.
This has been exactly my gripe about Libre / Linux. The biz world runs on MS Office and the lack of familiarity with the UI on Libre Writer. Great video with many helpful tips.
the arial and Calibri font are build in the LibreOffice 7.1 but it is good to set it as default!
also to customize the extension is good advice!
What good timing, I made this switch a few days ago
I always use LibreOffice for my work and home. The occasion I fallback to MS Office is only when some nasty old Excel doc with really really big data bogs LibreCalc down. For such big table, LibreCalc tend to be slow and sluggish on my old PC. Except such rare occasion, LibreOffice is much better than old Office 2007 I have used before.
btw I use LaTeX :D
What? Not Tex? Or something like GNU TeXmacs?
@@benriful I'm a filthy casual. All the cool kids use groff nowadays
"cool kids" :D
@Vornamed Nachnamed Rmarkdown and its derivatives is pretty neat too, since you'll be doing the computation in R anyway.
Thank you Chris! I know you did this 3 years ago - but thank you anyway!
Libreoffice finally changed the UI to 2007 instead of using the 2003 one like Open office?
Thanks alot Chris, indeed its very useful to know these, lets call them "optimizations" in order to make the adjustments and use it better, hopefully this will help a lot more people to start learning and using Libreoffice much more and less dependant on just microsofts programs and OS.
Very useful video Brother ! Thankyou !
This was actually helpful, particularly things like view style, save, fonts. Another irritation is the context menu that pops up on right click on highlighted text. I had to customize mine (and wife's). You could add more on that as the discussions on the libreoffice help forums are confusing. They use different terminology of in libre land and yet sometimes switch back to MS terminology, very confusing
Very helpful. I am just starting out in Ubuntu and was curious about cross platform compatibility. I'm subscribing to learn more.
Thank you for helping me put faith back in Libre!!
There are some less open alternatives as well: Softmaker Office (costs) and WPS Office (free, but not OS).
Whoa!!! You've done great work here. Thank you. I need this.
Chris,
I found this very helpful thanks. Could you or do you have a video explaining how to stop Microsoft office taking over when I try to send an email through LibreOffice.
4 things LO does need: (1) An easy way to set up alternating page numbers (2) Tabbed windows (3) Popup terminal (4) File-manager - maybe solarized & dark mode options since people like that.
As with MS Word, you MUST establish styles in LibreOffice. In doing so you are not futzing with the margins and tabs in the ruler. As for long documents of 300 pages, I'm unsure. When I last tried to set up a LibreOffice document with styles to produce manufacturing and mechanical equipment user documentation, now five years ago (now is 3NOV2020, Tuesday), the line art illustrations and illustrated images (images with call outs in a graphic frame, disappeared on document reopen using ODT, DOC, and DOCX.
I use LibreOffice for cover letters / resumes using the fully defined template of about 10 styles. Works fine save for a few updated version that blew up the template on reopen. Ensure the styles using bullet lists or number lists are fully defined, yet the bug was in LibreOffice. Reverted to the prior version, works in the second newest version and fine since then.
Microsoft, with each office update, foils LibreOffice and other productivity suites by changing the .xxxX (.docx) formats in minor yet myriad ways. I wholly despise the MS Office 2007+ ribbons as this GUI change requires more click, 50% to 75% more mouse clicks, to complete a task.
I mean to try using LibreOffice for long, heavily illustrated manuals saving the file in the ODT and DOCX formats again.
If you open a LibreOffice ODT or DOC or DOCX file, you will find the page size definition changes. The MS Word presentation indicates the text is larger by point size or more spacing between text lines.
Else, when using LibreOffice exclusively to produce content, and save to PDF, with PDF views set (Bookmarks, Document Fit, and like open PDF view), LibreOffice appears competent.
If Liberation Serif, a free open source font, is not installed on a computer then font substitution should occur. This might cause subtle issues with spacing and formatting but its not going to "look like Chinese". However, its a reasonable suggestion to use the MS fonts and to save as docx (Word) and xlsx (Excel) formats. Whatever you do, do NOT use the old DOC format which was deprecated 10 years ago, wastes disk space with its bloated files, and has security issues. Libre Office is much easier to install on Windows. You run the install and done. Libre Office will not automatically update but frequent updates are available if you are interested.
Yes. Learn Libreoffice by converting your most complex documents from Microsoft Office to Libreoffice. I have faith in you, Chris. You can do it for sure.
I've been using Libreoffice for about 2 years and only just learned today that UI contextual groups are a thing, effectively substituting one of my main features I miss from MS Office, the Ribbon UI.
The latest Libreoffice also has tabbed and compact toolbars that look like the usual Office UI. Good for tablets and convertibles.
The way to insert is to tap F11, and in the current edition (2022) the way to turn off overwrite is through the lower right hand portion of the line just above the task bar. This is the lower line with page numbers, word count, character count, page style, language, and zoom reports.
Between the language box and the zoom box in the lower right portion of the screen, 'OVERWRITE' will appear when the word processor has gotten onto overwrite mode.
Simply click on that report. OVERWRITE will vanish, and your keying will return to normal insert mode.
There!
Remember. The general principle when learning digital devices is to tap/click EVERYTHING to see what it does. Devices teach themselves to you, if you will simply keep exploring. That is how children exceed adults in learning speed with regard to digital devices.
Dear Chris, I removed the LibreOffice which was default in Mint 19.2 Cinammon and installed the Flatpack one (Oracle).... but I can't install the MScore fonts (: ...
I tried all the proposals you mentioned... Any other suggestion?
I found a solution... I installed them from the "windows/fonts" folder... but I can't install them simultaneously by selecting ALL of them... is there a solution for it?
Can you talk about an alternative for Evernote on Linux? Cloud & mobile devices ready
I've been using Libre Office for years. It's vastly less buggy and annoying than using MS Office, which I've used extensively for decades.
Even though I’ve been using Linux for 6 months now, I’ve had no need to use LibreOffice. But I’ll give it a try, just so I can know how to use it.
but when you open docx from libre office, isnt it gonna screw up the formating when you open it in ms office?
Thank you for this instructive video. i will change my settings as you suggest. Very helpful.
Been a long time Linux user. When I was repairing Photocopiers,Printers & fax machines, Quite often so called broken printers where incompatible versions of micro$oft office or uninstalled fonts and or paper formats eg metric, imperial and customary this is in a world where the floppy was still king and e-mail was still quite new (file transfers) USB was a dream. Even now I support 4 machines that have different versions of office most of the nubs would have a problem with the change of interface... Each machine has a job to do and sometimes you leave a machine where it is rather than upgrade for upgrades sake. Office is font, printer and version dependent for layout has been that way for over 20 years and still is. Yes i have seen the same document print differently from the same computer to different printers and or different driver languages on the same printer. Business chose office as a standard for not other reason than it was easy to get and work with windows. Some times i long for the day when real Men/Woman would write there own drivers...
Also, you might want to store all of your original long term documents in the open ODF format, and convert to Microsoft Office format, or formats, on demand.
Thanks. Great video concerning change management. Cheers.
Thank you. I’m old and have left Microsoft do to costs and their constantly changing. I’ve supported them since 123 when they first came on. But the constant upgrades and higher and higher costs and I only use office writer and math parts for letters and spreadsheets it’s not worth the hassle. Again I trying to teach myself and old man with a fading memory.
i didnt get that VistaFont stuff i copied and pasted in the terminal but te link is alittle cut short
So I installed Carlito Font instead cause they said that I needed a license or something. And that Carlito Font was like very Identical to Calibri it wouldnt be a problem compatiblility wise. so everything is good. Great video
So I had a question for you. Microsoft word/office 365 has a document translation function. I wanted to ask if LibreOffice has this? (Or a work around?) I may need this feature for some business needs. But I don't want to go back to anything Microsoft or windows if there's a way to avoid it. I like Linux and LibreOffice a lot better. Plus cheaper. LibreOffice is also a wonderful product.
Thanks for this. I was missing the ttf-vista-fonts, having just previously added the ttf-ms-fonts from the AUR in Manjaro.
what version of LibreOffice are you using? your interface looks super clean and it is not available (only "contextual single") with the newest version under Windows 10 :(( also i cant download the fonts...your link only opens a txt document...
I'm not a big MS fan, but from all the alternatives I've seen, they all have their quirks, which is why MS Excel is so popular, out of the box, it works, can be customized without having to download and configure additional features. Many of us have decades invested into Excel and VBA, and to have to navigate around re-learning how to do old things, a new way, skipping countless hours wondering how to fix the things that don't crossover between LibreOffice and MS Office, you mays well just fork over the money, and stay with Excel, a name that people have been familiar with since Lotus 1-2-3 went extinct.
Agreed... the free programs are fine if you're doing something simple. But the more advanced you get, Excel starts to really pull away from the pack. VBA and more recently Power Query are absolute game changers that the free programs can match. As a statistician who works with data, there are simply things I can do in Excel that I just can't do with the free alternatives.
Light users: Any suite will do (might as well save money and use a free one).
Regular users: Free may still be ok, but you might find yourself missing a few features.
Advanced users: Excel really shines. Unless you want to learn a coding language like SAS or Python, it's the clear choice.
Just my $0.02.
Bring the soda & pocorn, here comes a true conspiracy theory.....
You cover all the bases. This how I been doing this way over a decade. The other things to cover is online office tools. Sometimes I have to use this to correspond to a Windows user. Just so there is no problem with file sharing. If for any reason LibreOffice can't take care of it. Another thing I do, for a quick send. This is only if it don't need to be professional and the other party don't need to edit it. Is just a screenshot as a .jpeg or any other type of format. I even went as far as .pdf or a .html webpage. So they see it as I see it. Been with Linux for 16 years and not once I had to use Windows to do a task. Everybody can do it, if you think outside the box. Sometime I do things in a orthodox way, if I need to do it that way. My way of thinking is the end game. If at the end of my computer task is a finish product in any shape or form and I'm doing it all in Linux. Then it's a win win to me.
I switched over and it works great if you're willing to put a little elbow grease into it! I prefer the way LO looks to MSW.
Nice show! It's about time someone show how to install those Microsoft fonts, they're all free, why don't they per-install them. Copy-write lawyers make life difficult! Years ago we install Open Office on XP, we couldn't stand 2007 Office ribbons so we still save files in (doc.) for better capability with modern Office .
Of course the most stable version of Libre Office you get from Ubuntu, Pop! OS, Linux Mint or Peppermint :)
Helo There. Please note EULA during install at 8:05. It say that is permited to use those fonts ONLY if you have Vista or Office licensed on the computer.
Great point, this was actually added to the top comment the day I released it.
Thanks for the assistance - I'm jumping ship!
I saw a recent tutorial on the newer versions, if u send a document from this program the reciever needs to have libre office to read it BUT simple work around save and send as a PDF then most ppl will be able to read it.
Started with Libre office and switched to Word subscription service to finish my book on multiple devices...PC, Chrome book, tablet and phone. Libre office is very hard to use on many devices...no android app or apple app and moving around files is a pain. You get what you pay for but on a single device Libre office is great for simple uses.
A tip: If you have dual booted windows and linux and you want windows fonts , just copy the fonts folder in windows folder in u r C drive and paste it in /usr/share/fonts in your linux and you good to go!!
On a Debian based system I always swap out the LibreOffice that you get pre-installed for the repositories with the flatpak. Debian repositories (Ubuntu's repos as well) tend to get old really fast cause they don't update them. Flatpaks are up to date,. As far as snaps are concerned, I'm with you on that one!
@Donald Mickunas Key word is bleeding edge. I don't keep everything up to date and rolling releases tend to break themselves as far as OS components are concerned. I use my computer to get actual work done and most times I don't have time to figure out how the latest rolling update broke my system. There are only a few programs i actually worry about keeping up to date. LibreOffice is one of them because of security concerns (I use a lot of macros). I don't keep everything up to date all the time, just a few select programs.
However I as a rule do use libreoffice at work and that kind of makes other users need to install it
VIDEO REQUESTED: 1) Font management: It's great that Ubuntu and other distros provide fonts for the world, but how do I eliminate the non-western fonts I don't use and install the western
fonts that I need. Thanks! ALSO: 2) I would appreciate some instruction on how to backup/restore/manage iPhone on Linux. THANKS!
Font Manager ,simple font management for GTK+ desktop environments. Used this do deactivate the needless fonts.
fontmanager.github.io/
It doesn't just take more space on your drive to use a flatpak. There's overhead with the container, and possibly redundant libraries in RAM if multiple programs could otherwise be using the same libraries. I hate flatpaks and snaps in general, and the only benefits are for the package maintainers. For end users, they are just a losing proposition.
I only have libreoffice installed in order to use it in headless mode to do conversions from the commandline. A very nice feature, one as far as I know completely absent in MS office and similar proprietary suites, but I had to spin up a container every time I called it, it definitely wouldn't be worth it.
Thank you, Chris. Very informative.
Ive never found anything bad with LibreOffice, looks or function. I was on open office then went to LibreOffice, when lots of bugs crashes open office.
LibreOffice looks like how Microsoft Office used to look like!
And I love it for that. But most people clearly think it to be a backwards or antiquated design.
@@schemage2210 But you can aktivate the ribbon toolbars, then it will look like MS Office
@@Shadow25720 i don't like the ribbon, i think menus and all common tools out in the open is far more efficient. All i am saying is that people so accustomed to MS office will think the design old fashioned or even inherently broken due to aged design.
Indeed and that's not a bad thing.
Office 2000, XP and 2003 used to be great.
I can't blame those who got used to the new Ribbon Theme however, let alone sometimes a new look make things feel fresh (even though in business environments that's rather less helpful).
@@AlucardNoir Yes but wasn't 2003 also the one that used those expander arrows like the 9X/NT5.x startmenus for more entries?