“Probably it was written by Mr Scissors with help from Stanley the Knife, and neither of them know a great deal about typography.” Love it! This video has very useful information for aspiring and collaborating writers. Thanks CJB!
I've used both OpenOffice and LibreOffice but always tended to suffer from annoying formatting issues, as per the ones raised in the video. I resorted to firing up a VM of Windows 7 with Office 2003 to avoid these problems in the past so thanks for pointing out the availability of WPS Office, Christopher. And as always, a well-produced and easy to understand video.
In addition to WPS Office, there also exists OnlyOffice and Softmaker FreeOffice, both of which offer better compatibility with MS Office compared to Libreoffice. :)
This video was the missing link in my migration to Linux. I had not head of WPS office before watching but I have installed it and have been using it for a few weeks now. I have found it to be fully compatible with Microsoft Office file formats and I now actually prefer using WPS in comparison to Microsoft Office. I really appreciate the time and effort put into making well informed and well produced videos such as this.
You're so right. Using that stinks so much of basic computing literacy (and common sense) lack that makes author suspicious of being universally hopeless at almost anything else.
You're right about Wine but it's worth mentioning it has been improving at an amazing pace lately. It might well be a proper alternative to a VM for many scenarios in a year or two. They're fixing many 10 years old bugs a month.
Virtualbox actually has an interesting function called seamless mode that displays Windows programs running as if these were native to Linux (or macOS if one is running that instead). So if one wishes to have a semi native experience a small Windows8 or 10 VM with Microsoft Office or Adobe's software suite should do it.
This is an incredibly USEFUL video. Most all of your videos are at the very least informative and entertaining, but this one definitely can be helpful to EVERYONE who prefers running Linux. I had never considered running Office 365 online through a Linux browser! Eureka! Thank you, Chris.
There's an easier way to install fonts in Linux. Go into the root of your home folder in whatever file browser you like (in Mint's case, Nemo) use the command ctrl+h to show hidden files, make a new folder with ctrl+shift+n, name it .fonts, and copy all of the TrueType and OpenType fonts you'd like in there. If you have dfonts from your Mac, you can use a command line tool called fondu to convert them to TT format. Once you're done, send ctrl+h again to make the dotted files hidden in your home folder. The double clicking method is great for a few fonts, but if you use a lot in your work, this method is way faster.
SoftMaker Office (The FreeOffice version) is the best Native Office Suite for linux for creating Presentations from Scratch or Documents..it is Free. the paid version just adds a few saving formats....it makes PowerPoint like presentations smoother than any office suite on linux...WPS Office though is more compatible with presentations already made on Windows...and allows embedding Videos in its PowerPoint clone very very well....something SOftmaker Office lacks. I have all 3 though and use them interchangeably as needed....why not? all Free
I ripped the HDD out of my laptop and installed an SSD with Linux Mint 19 after watching one of your videos ref Linux distro's a while back. i did succeed in loading MS Office using playonlinux, but found it was just as easy to use Libre Office and export as PDF. I might try WPS Office just out of curiosity one day. Great Videos, Keep em coming
I am very thankful for your excellent video on tips on giving Linux users tips on handling the little issues that crop up converting from MS Office to Linux Office suites. Your suggestions are welcome and well presented. Like several commentators, I hadn't thought about using Office 365 on a computer running Linux. As always, I am looking forward to your video next week and keep up the good work!
bg4tification Oh yes, Mr. Shotgun is so very useful for those times when one desires the maximum results for the minimum effort. No frustrated computer user should be a stranger to Mr. Shotgun. I have yet to meet Mr. Cannon.
I find the best way to maintain compatibility of layout between documents created in Microsoft Word and LibreOffice Writer is by creating and opening all documents in _Open Document Text_ (.odt) format (after making sure that all fonts that you intend to use have been installed on both platforms). In other words, stop using the proprietary Word formats altogether; since Word understands ODT, there is no longer any real need to use them. Once you do this, you will find, that you no longer have this compatibility issue when opening documents created on the opposite platform.
The only problem with this is the fact that certain places will not accept .odt files. Amazon's self-publishing platform, KDP, will only accept .doc and .docx files. (I believe B&N's publishing platform, NOOK Press, is the same way)
@@BeckyAnn6879 So open the ODT document in Word, and export it to DOC or DOCX. However, the problem with these formats is not only the fact that they are proprietary; they also depend on your installed printer for document definition data. So if the recipient of your Word document has a different printer connected to his/her computer, even if s/he uses Word, it *still* will not look identical to the way it looked to you when it was created. For this reason, I prefer to export my text documents to PDF for submission, which both Word and Writer are now capable of doing; it's the only way to guarantee their fidelity.
@@worldhello1234 Formats like what? ODT? It's supported by LibreOffice, OpenOffice, and Word. PDF is also supported by *all three,* in that it's possible for them to export into this format.
Thankyou for this. Been trying to get my grandmother converted over to Linux, she hates Windows 10. She prefers the look and feel of XP and I made a visually near identical copy of the XP desktop. Anyway she has been a heavy MS office suite user over the years and I am glad you uploaded this. I also was a heavy user of Windows MS office products so getting Linux to be close to Windows in that regard has been a learning curve. Thank's for uploading!
The worst approach you can take to Linux is to try & make it be like Windows, It's not Windows & isn't trying to be like Windows. Embrace the Linux way & you'll love computing again. 12 years on Linux here, used Windows for 17 years previously. I wasted a year of my life trying to replicate my Windows setup on Linux when I started out before becoming so frustrated & finally it started to sink it, it was me who was the issue, I needed to change, Linux doesn't. Never looked back, from that day forward I only used software available on linux, abandoned Dreamweaver, Photoshop & MS Office & these were the days when the options were limited, today there are a plethora of options. I don't even use Wine or Virtualbox & my machine is every bit as capable & more than most Windows machines.
Forgot to mention - I got my RaspNAS up and running, thanks to your excellent instructions. Now I can access my files quickly and easily from any Linux VM, physical device, Mac or PC. Very happy!!!
VirtualBox is a very versatile solution that works well here. Having said that, a PC with a reasonably recent set of hardware is required for it to work best.
Thank you so much for the WPS Office and TTF Font tips!!! I have a complex Excel workbook, that Libra Calc did an "OK" job displaying and editing. But WPS Spreadsheets does a virtually seamless job managing. My Ubuntu laptop now does virtually everything my Windows Laptop does, but faster! Much appreciated! Got my Mr Scissors mug in the mail last week. LOL
I think the main point, for these people migrating, to consider is that they should move away from proprietary formats ASAP. Once you start using Libre Office, or Open Office, or WPS; stay away from Microsoft products. They started with an expensive office suite, which is now being turned into a subscription service. Eventually you'll get to the point where if you don't pay your Microsoft bill, they'll cut off your access to the documents you wrote. Further, they could change the ToS to take ownership of any content produced under their software platform, thereby giving them copyright control over your content. I'd rather keep using something that I have complete control of. Something that doesn't need an internet connection is also a desired feature, since I might want to work on something in the middle of nowhere. I also don't like telemetry systems.
Hey Chris your style of presenting these videos and the content is world class. Very informative, well written and presented. It is like watching a BBC production. Keep up the good work and keep these gems coming.
Something else that can be done while running MS Office in a VM wich is the best hassle-free option is that you can mount your linux home folder using samba into windows so that Documents and Downloads folders are easily acessible from windows and you avoid having duplicate files
Libre Office can read more versions of Office documents than Office can, and it can save to open file formats. If It doesn't use Comic Sans, think of it as anti-malware. :-)*
Leo Brusselman I wanna give it to my parents to make it more familiar to Windows. For me, I'll take either KDE or XFCE. I'll have to see how intense the other software will be and if I will buy a Ryzen and a new GPU.
Wine has been around for well over 20 years now -- I can remember looking into using it in a production environment back in 2000, as the organization I worked for at the time had something like 500 computers and was tired of paying Windows licensing fees. So they figured they'd switch to Linux and run some of their irreplaceable Windows apps with Wine on a Linux system. Needless to say, that idea was squashed relatively quickly. Wine has never been a reliable option -- which is not their fault, of course. They're trying to replicate the Windows API *precisely,* and that's simply not possible given Microsoft's lack of documentation on much of its low-level Windows API stuff.... And with every subsequent version of Windows, Microsoft makes more undocumented changes, so Wine is constantly playing catch-up. If you have a Windows app that doesn't change, and is, say, more than 2 or 3 years old, then maybe you can get it running on a Wine installation reliably, but that's a pretty rare situation. For most people and businesses, Wine just isn't a viable option, unfortunately.
Thanks for this, I remember a few months back in one of your videos (and indeed good discussion in the comments also) regarding the 'one step forward two steps back' in modern computing. My mum who is a pensioner finds the nature of modern Windows to be very frustrating, due to the constant changes, the their desire to push cloud services among other things. Personally myself as well has kind of had enough of it, and indeed when she needs an upgrade, I think it will be time to take the linux plunge, she loves dual screening, uses it for a lot of writing and emailing and is a lot more literate than she gives herself credit for. I will of course take the plunge at the same time as using a raspberry pi has given me my first proper exposure to the OS basics. I dislike not feeling like I am in full control (which Windows OS does to me these days), almost as much as a dislike a phone I can't change the battery in or use an SD card in. Thanks for always seeming to make really informative videos that I want to watch and learn from. Hope you have a great week
I changed my Nan's pc to Linux, it's a lot more responsive and she's more secure online now she can't install any adware or bloatware when she's surfing the web. I tried out WPS and I think it provides the best of both worlds for people used to MS Office and Google Office Apps
Now that I'm semi-retired, I'm spending some time working as a "computer buddy" in my local library, when I help other people to use computers. This throws a whole range of different challenges at me, so of which turn out to be easy and some less so. For anyone who really only needs a PC as an appliance for internet access and needs it to be as easy as possible, I'd recommend trying a ChromeBook. I now own about four of these, if I include the broken that I was given for nowt, in its broken state. For anyone changing from Windows to a ChromeBook, there is a short learning curve, mostly because the keyboard is not the same as a Windows PC one. Some of the latest ChromeBooks can also install and use Andriod apps, which might be an advantage for some. Next in line for ease of use I'd rate Endless OS. This is a free (but proprietary) Linux distro that gives a look and feel very like Android, but using a desktop based on Gnone 3. After that, I'd recommend a conventional Linux distro, such as Mint or MX (etc......). Sometimes the choice of distro will be influenced by the target hardware or software. For example, when I need decent Open GL support i prefer Mint to MX, but MX works better than Mint on my 14" HP Stream netbook.
@@derekp2674 Chromebooks are a great option for people who enjoy the cloud office experience. I used Docs for my dissertation but there are certain things that Chromebooks lack, but Windows and Linux have, which keep me from delving into the products further, but this might change soon now both Google and Microsoft have promised full support in later updates for Linux, in their respective operating systems.
@@amirpourghoureiyan1637 Yes indeed. Chromebooks are limited in what they can do. This helps to make them easy to use for those things, whilst making some other things either difficult or impossible. For example, I believe that playing physical CD's is simply impossible under the native functionality of ChromeOS.
@@derekp2674 that's a shame, a lot of older users enjoy using those features on PCs. I actively refuse PC cases without a drive bay, the amount of times hardware comes bundled with a driver disc - it's just really easy to install the software without having to dig around a website for a while. Nevermind the amount of disc-only games I have as well.
Indeed it's true that switching OS from Windows to Linux can be hard because some apps or process doesn't the same. I personally want to fully pass to Linux but what it stops me it's just some exams I have to do which requires to use Windows application. Linux is getting the love that deserves and I can't wait to be a full Linux user.
I agree that linux can be over-hyped. An OS is only usefu; if it can run the program you want to run. By the ways have you run into non chrome use websites yet?
@@billfusionenterprise Hi. I cannot give you specific answer because I only use Firefox and I don't know how you can know if the webpage is a non-chrome webpage. I hope this answer your question.
@@simonestarace5249 when certain functions do not work. Oracle doesn't always work and certain HDMIs do not work. And several other fill out forms don't
@@simonestarace5249 has nothing to do with fonts. Has to do with just the raw HTML code. What is causing it . I am not sure but shows just another problem with webpages. (outside some sites which you need a engineering workstation to view)
Great video, interesting stuff, I have been using libre office in office in Windows for years, I think Microsoft needs to sort out it's compatibility, with its own version of office. If I have a finished document and it doesn't need to be changed, I save in a pdf format, then everyone should get to see practically the same thing.
Everyone does, they use MS Office. MS actually contribute a lot of code to Linux and have worked hard on compatibility- they don't make money from Windows really, they make it from Azure which is platform agnostic. Libre Office is still well behind MS Office, although if you don't have great demands it's fine, so is Google Docs.
@@twmbarlwmstar I have old versions of ms office bouncing around somewhere, then I installed libre office, I never looked back, most people I know use it, ms office might be better, but I have such little issue with libre office I would never change, I can use it on a pi zero out side on a solar charger, in the middle of nowhere, great efforts to ms, but hat's to the guy's libre office, bringing computing to everyone.
@@williamrutter3619 While I don’t doubt you run Libre Office on a Pi Zero over solar power on a Pi Zero I do question how productivitesuch an undertaking is. What posable achievement have you made? You are stuck on a dessert island and must finish that novel? For myself If I can’t easily read it then I won’t go to work trying to, that means some Libre stuff will just get bounced back to sender. People can avoid that by using online Office which is free. I think we must accept that MS Office is the lingua franca and given there’s a free version you just bite the bullet and speak it or are disadvantaged.
Thanks very much, that was both interesting and helpful. For someone like me, who only uses a computer for browsing, communication and office software for work, the jump to Linux (Mint 20) need not be painful after having made classroom materials for about 12 years in MS Office (which of course I wish to be able to edit / repurpose at my convenience). Provided I have a reliable 'net connection at home, I can keep on using Word and Powerpoint both at home and at work while slowly moving myself over to Libre Office for materials I make new from now on. Very helpful video, thanks.
Hello Chris! 👋🏻 Here we go again, EC video brightened my Sunday with useful topic! {thunderstorm & rain, again!} I agree, VM and/or web office are the best solutions. I use VMs in all possible OS combinations so it's easy way to get to Microsoft office. I use wps office few years already, on Android. Google docs are good but lacks some functions I often use. Wine was glitchy and not reliable. Mr Scissors and Stanley the knife may not know typography but they surely know how to unbox successfully.
Hi Elvira! Here we are again. No storms here, but very dull. Well, until I turned the movie lights on to film this afternoon. So maybe it is not dull, and my eyes have yet to adjust back to sunlit normality. :)
ExplainingComputers Rarely dull weather here. Storms here are exciting and interesting. Well sometimes. Until my UPSes start to be jumpy & grumpy because of voltage drop. And occasionally power surges. Then it is not interesting anymore. 😬😅
I came across an older abandoned Lenovo Thinkpad ultra book (SSHD) and installed Mint and swapped it with the wife’s kitchen counter low end Windows laptop. There were no question / problems until there was an ask regarding scanning.
I just started learning to use Linux because of you! I've opted for Kali Linux and I'm learning Pen testing. But I've always wondered how I could use MS Office. Looks like I'll be learning to use the VM 🤓
It doesn't help that the Linux Mint repositories have a rather old version of Wine. Much better to go to Wine HQ on the web, and follow the instructions there to install the current version, which will keep itself up-to-date.
@@velanrama yes RTF is about 3 times larger than docx format, twice as large as ODT and about 30% larger than doc format. I primarily use RTF when sending documents to people who can't open a document I've sent them instead of guessing which format will work. For "small" documents works well.
In April 2020, when Windows 7 Pro becomes end of life, I will be transitioning to Linux full time. The distro I prefer is Q4OS. If I need to do any support on Windows I will use AnyDesk or VirtualBox.
I've been using Ubuntu MATE for 6 months now... The switch is painless these days, Pop! OS is the flavour of the month, but that could change by next year, lol.
Good info on how to install and migrate fonts. The biggest problem I have using Linux as a daily driver is the lack of an officially supported Gdrive program. There are options (Gnome has vfs support, and you can install google-drive-ocamlfuse), but I am always concerned that Google will change something and I'll be left without file sync
I'm using Win7 in Virtual box with Ubuntu Mate on metal. But no problem keeping the Access dB file transfering it over with wsft. But why can't Libre Base convert it?
@@FunNFury All my old databases are in Microsoft Access .mdb format (2003). Libre Base won't read them in unless I drag the data out comma separated text. But then I've lost all my queries and forms etc.
NoteTab Light... Yaay! I've been using it since 1999. It's the first "Must have" program that I'd install on all of my Windows machines for the past 20 years. Having tabs on one program makes the most sense instead of launching different instances. I also like the "Use as paste board" function where everything I'd copy would automatically be copied to a specific tab. Whenever I'm using Linux, NoteTab Light is the program I'd miss most.
Excellent tips. Especially the one concerning the fonts. Personally, I would avoid Wine or VM for mission critical work. If you're switching to Linux, go with native apps when possible. BTW Chris, If you love Linux Mint, you'll adore MX Linux. Cheers
I use both MX and Mint. These days, I wonder if Mint is a bit "over simplified for ease of use" when compared to MX. For really old and slow machines, I prefer antiX.
One time I set up Windows 10 in a VM and it worked perfectly. The second time, it was horrible. I wasn't sure if the newer version of VirtualBox did it, if the different install and set up directions I used were the problem... Because I know how well it worked the first time, I think it is worth a try - and just read as many articles as you can for set up options.
@@derekp2674 antiX is my favorite, but I can't get it installed on bare metal - only on flash drives and VMs. But, even on those, I am grateful for antiX. I hope they make a core or base (more minimal) MX, though, too.
I'm happy to report that MS Office 2013 Pro 32 bits works flawlessly using PlayOnLinux, before that I tried 2010 Home & Student but I couldn't activate it; VL license versions activates without issues using a KMS emulator and POL handles the file association without any hitches. Now I simply have no excuses to keep using Windows 10 except when I'm playing a certain game that refuses to offer native Linux support
Installing Windows apps on Ubuntu, which is itself a Virtual Machine on my Windows laptop. Next step: Run Windows on a VM in Ubuntu on a VM in Windows.
There's also FreeOffice / Softmaker Office (they are the same software, but Softmaker is the premium/paid version). It looks and behaves like MS Office (if you choose the modern layout, because it also supports the outdated LibreOffice-style layout). It has some limitations, but I found it to work better than WPS Office and I haven't had any compatibility issues so far. For me it works better than LibreOffice for most tasks, although it's slightly slower, so it might not be the best choice for an old computer.
The online office apps are slowly gain the features of the desktop app. Although I hope they don't discontinue the the desktop app when the web apps match feature wise.
For me, LibreOffice is the perfect option. Well, it doesn't render MS Office documents perfectly, but if you save everything in the OpenDocument format, and you don't have to deal with docx, pptx, etc. it's fine. I personally wouldn't trust WPS because of its Chinese origins, but you can run MS Office through Wine if you need it.
My advice: use an online office suite (GDocs, MSOnline, etc.) and then just export PDFs if you need to print. I luckily don't require an office suite; I just use vim. HTML/CSS can do any styling I require.
You failed to address the serious problem of finding an equivalent for the proprietary Calibri typeface. Also, I find the online version of Office365 to be a clumsy interface as well as buggy: it can cause corruption of files originally created in the desktop version of Office365.
Office users moving to Linux should try SoftMaker Office. There is also free version, FreeOffice. For me, this is the best MSOffice alternative. I have been using it for about a year and haven't looked back.
A very useful video; some friends enquired about moving to Linux recently, Word-compatibility being their only requirement. Cheers, Prof.! I personally use Groff, *TeX or Org-mode, but I can get away with submitting PDFs.
If you have licenses for Windows and Office to put in a VM, maybe just have another $50 used micro PC and a KVM switch? That said, I use LibreOffice at an institution that doesn't license MSO, and I've been wanting to set up some Linux machines, so this was a great video that hit the nail on the head for me.
Libreoffice or any other open source office suite is only for open-source enthusiasts. If you want actual MS Office experience on linux, you either use MS office online, MS Office 2010 under Wine or WPS Office.
I don't use LO because it is open-source, and I have few problems using it along with MSO for daily work--Writer and Calc, at least. Mostly it's about getting used to LO enough that you realize how to do any quick fixes. But I don't require letter-perfect translations, either...all in-house stuff that can have a few formatting flaws. Real difference is macro work in Excel, which I do in real Excel. I do want to try WPS, though.
When I first discovered Linux in early 2000, there was really no useful office suite in Linux. With the advent of Openiffice and then Libreoffice, I can use Linux as my daily driver.
My first try at Linux was Mandrake 6 on a Pc Mag CD. It had Kde 1, Linux was still very primitive compared to windows back then. But it has made a quantum leap over the last 20 years.
2:15 not showing comic sans in libre office is a feature, not a bug. Great video. I was looking for ways to create MS powerpoint files on my linux machine. Up till now i've always used impress and converted to pdf, but now i need to use a template, and it doesn't come out like it should. I will give office Web app a go. Thanks for the tip.
I used Libre Office for years it’s fine, but my new laptop is Windows 10 and Linux Mint so I am using Office 365. I like having my docs on One Drive. When I am away from home I just use my iPad or phone. I keep everything in One Drive
The most awesome video which i was in dire need of . The best solution is to use it online. Otherwise what will I do with the subscription money I paid for office 365. Plugins work in a bit different way such as a ref manager. The video was completely informative. Plus WPS Office looks cool and and has an intuitive interface to work with regular files on pc. For the ones to be shared with windows users office online is the best.
there is a nice linux program called "fonts manager" available from the softwarecenter if one wants to install more than one. also to mention internet sites like freefonts were one can share and use own fonts with different licenses.
@@alvimuka1853 it was there, it just took a few more steps to get there. i use to make signs instruction sheets and such. and 97 made it much easier because the functions where on the one page. In 2003 they move to this tab setup which you had to use to get to those features. Very annoying when you need them a dozen times in a document
I agree with your assessment of Wine. It really doesn't work that well and it's nearly impossible to get rid of it after installation. Your Cloud Computing video of two weeks ago caused me to attempt to dip my toe in with the big boys. Being a tightwad I gravitated to AWS Glacier. Wow, it's complicated beyond belief.
I have tried WPS but it has its issues too. I did a review of text with track changes in the WPS and when I sent it back to my customer he couldn't see it in MS Office. So unless there is 100% compatability you can get some nasty surprise. However, for personal use LibreOffice is excellent.
The issue with VM is that you still must purchase a Windows license to remain on the legal side. Crossover is not cheap and as well as this license, the license for Microsoft Office must be purchased. I develop VBA applications for businesses and of course I am mad to see all the Windows machine around. I wish they could all save a lot of $$$ by switching to Linux. Unfortunately, all the VBA macros won't run unless in a real MS Office environment. Maybe the online Office 365 will handle VBA macros without hassle? Maybe Wine environment can bring all the required MS libraries so that the VBA macros can run? I guess if a company having thousands of Windows machine switches to Linux (desktop and server), the saving can be substantial, even if they must keep paying for MS Office one way or another. The company will also have to rethink the IT support staff as a lot of things are different in Linux, often much less graphical and more command prompt actions. A new breed of IT support staff must be hired and force the current staff to go to serious training if they want to remain employed. As an individual, I guess the switch is not that difficult indeed. Linux Mint is very nice. Could you make a tutorial on setting up a home/home-business linux environment with light active directory, file server (samba) and how to connect mixed clients (Linux and Windows)? I really enjoy your clear videos. Your students are very lucky :) Thank you.
About differences in viewing of .docx in MSO and LO - MSO writes .docx and .doc not full .docx standard compiliant, which causes problems in formatting between MSO and LO. Just tell everyone to save in full .docx compilant version when using MSO.
Very good and informative video. The main thing keeping me from totally ditching windows, is the failure of Libre Office / Open Office BASE. I have some applications which use a MS Access DB with some forms and even though I tried to build them from the ground up in LO/OO, every time I try to create a form BASE crashes. The DB does recover properly but as soon as I try to work in developing a Form, they both crash. In doing this, I have not even attempted to import or copy/paste anything from MS Access just create a DB/Form with similar structure and functionality. These are not super complex DB/Forms and in reading comments all over the web, I am not alone. In fact it appears as if both LO/OO are aware of the issue but have no plans to fix it. There was even one comment 'if you don't like it use something else' and that is the problem with open source software. As difficult and obnoxious as MS can be, if enough "CUSTOMERS" have an issue they eventually fix it.
A few companies (though not many) still use Access, but 10+ years ago in a basic computer class, we were told that Access was going away, so we were barely taught any of it.
It's OK using wine to install windows applications in Linux but compatibility issues may still be present due to the fact that you won't be getting windows updates that windows users get! No updates which will cause compatibility issues!
“Probably it was written by Mr Scissors with help from Stanley the Knife, and neither of them know a great deal about typography.” Love it! This video has very useful information for aspiring and collaborating writers. Thanks CJB!
I've used both OpenOffice and LibreOffice but always tended to suffer from annoying formatting issues, as per the ones raised in the video. I resorted to firing up a VM of Windows 7 with Office 2003 to avoid these problems in the past so thanks for pointing out the availability of WPS Office, Christopher. And as always, a well-produced and easy to understand video.
Me as you I had similar issie and problem, when I tried WPS I solved all my problems. WPS is the best! Give it a try
In addition to WPS Office, there also exists OnlyOffice and Softmaker FreeOffice, both of which offer better compatibility with MS Office compared to Libreoffice. :)
This video was the missing link in my migration to Linux. I had not head of WPS office before watching but I have installed it and have been using it for a few weeks now. I have found it to be fully compatible with Microsoft Office file formats and I now actually prefer using WPS in comparison to Microsoft Office. I really appreciate the time and effort put into making well informed and well produced videos such as this.
Thanks for sharing this feedback. Great to hear when things work out. :)
You should inform mr. Scissors and Stanley that a title in Comic Sans might result in the reader not reading the rest of the document. :p
Mr Rock and Mr Paper beg to differ; they can only read text in Comic Sans.
You're so right. Using that stinks so much of basic computing literacy (and common sense) lack that makes author suspicious of being universally hopeless at almost anything else.
I rarely notice fonts unless they make text unreadable
You're right about Wine but it's worth mentioning it has been improving at an amazing pace lately. It might well be a proper alternative to a VM for many scenarios in a year or two. They're fixing many 10 years old bugs a month.
Yes, Wine and Proton now have major supporters, the future of Linux is lookin good.
Virtualbox actually has an interesting function called seamless mode that displays Windows programs running as if these were native to Linux (or macOS if one is running that instead).
So if one wishes to have a semi native experience a small Windows8 or 10 VM with Microsoft Office or Adobe's software suite should do it.
It's had that for years.
@@Yukatoshi I know that, I am mentioning it for those who didn't know it yet.
@@MegaManNeo Fair enough.
Eh? My seamless mode shows the full desktop. I don't care anyway. I have WPS office. Never using anything else. Love it even more than office.
Thank you, I always used not working wine bottles and crossfire that didn't work either.
This is an incredibly USEFUL video. Most all of your videos are at the very least informative and entertaining, but this one definitely can be helpful to EVERYONE who prefers running Linux. I had never considered running Office 365 online through a Linux browser! Eureka! Thank you, Chris.
There's an easier way to install fonts in Linux. Go into the root of your home folder in whatever file browser you like (in Mint's case, Nemo) use the command ctrl+h to show hidden files, make a new folder with ctrl+shift+n, name it .fonts, and copy all of the TrueType and OpenType fonts you'd like in there. If you have dfonts from your Mac, you can use a command line tool called fondu to convert them to TT format. Once you're done, send ctrl+h again to make the dotted files hidden in your home folder. The double clicking method is great for a few fonts, but if you use a lot in your work, this method is way faster.
You really got me with that first shot of Excel opening at the beginning of the video. LOL
I had never heard of WPS - I always learn something from you!
SoftMaker Office (The FreeOffice version) is the best Native Office Suite for linux for creating Presentations from Scratch or Documents..it is Free. the paid version just adds a few saving formats....it makes PowerPoint like presentations smoother than any office suite on linux...WPS Office though is more compatible with presentations already made on Windows...and allows embedding Videos in its PowerPoint clone very very well....something SOftmaker Office lacks. I have all 3 though and use them interchangeably as needed....why not? all Free
I ripped the HDD out of my laptop and installed an SSD with Linux Mint 19 after watching one of your videos ref Linux distro's a while back. i did succeed in loading MS Office using playonlinux, but found it was just as easy to use Libre Office and export as PDF. I might try WPS Office just out of curiosity one day. Great Videos, Keep em coming
I am very thankful for your excellent video on tips on giving Linux users tips on handling the little issues that crop up converting from MS Office to Linux Office suites. Your suggestions are welcome and well presented. Like several commentators, I hadn't thought about using Office 365 on a computer running Linux. As always, I am looking forward to your video next week and keep up the good work!
When frustrated with hardware and software issues, one can always find using Mr. Hammer a satisfying solution. Looking forward to your next video!
I use Mr sledge
Well said!
billfusionenterprise Yes I suggest everyone gets to know Mr. Sludge. He is an intimate friend of mind.
bg4tification Oh yes, Mr. Shotgun is so very useful for those times when one desires the maximum results for the minimum effort. No frustrated computer user should be a stranger to Mr. Shotgun. I have yet to meet Mr. Cannon.
Shaun Browne Thank you. I believe it was my wise father who first advised me to try to “hammer out my own problems”.
I find the best way to maintain compatibility of layout between documents created in Microsoft Word and LibreOffice Writer is by creating and opening all documents in _Open Document Text_ (.odt) format (after making sure that all fonts that you intend to use have been installed on both platforms). In other words, stop using the proprietary Word formats altogether; since Word understands ODT, there is no longer any real need to use them.
Once you do this, you will find, that you no longer have this compatibility issue when opening documents created on the opposite platform.
The only problem with this is the fact that certain places will not accept .odt files.
Amazon's self-publishing platform, KDP, will only accept .doc and .docx files. (I believe B&N's publishing platform, NOOK Press, is the same way)
@@BeckyAnn6879 So open the ODT document in Word, and export it to DOC or DOCX. However, the problem with these formats is not only the fact that they are proprietary; they also depend on your installed printer for document definition data. So if the recipient of your Word document has a different printer connected to his/her computer, even if s/he uses Word, it *still* will not look identical to the way it looked to you when it was created. For this reason, I prefer to export my text documents to PDF for submission, which both Word and Writer are now capable of doing; it's the only way to guarantee their fidelity.
Yes, but AFAIK only Libre Office support formats like that.
@@worldhello1234 Formats like what? ODT? It's supported by LibreOffice, OpenOffice, and Word. PDF is also supported by *all three,* in that it's possible for them to export into this format.
@@BeckyAnn6879 most job boards also won't accept .odt
Thankyou for this. Been trying to get my grandmother converted over to Linux, she hates Windows 10. She prefers the look and feel of XP and I made a visually near identical copy of the XP desktop. Anyway she has been a heavy MS office suite user over the years and I am glad you uploaded this. I also was a heavy user of Windows MS office products so getting Linux to be close to Windows in that regard has been a learning curve. Thank's for uploading!
The worst approach you can take to Linux is to try & make it be like Windows, It's not Windows & isn't trying to be like Windows. Embrace the Linux way & you'll love computing again. 12 years on Linux here, used Windows for 17 years previously. I wasted a year of my life trying to replicate my Windows setup on Linux when I started out before becoming so frustrated & finally it started to sink it, it was me who was the issue, I needed to change, Linux doesn't. Never looked back, from that day forward I only used software available on linux, abandoned Dreamweaver, Photoshop & MS Office & these were the days when the options were limited, today there are a plethora of options. I don't even use Wine or Virtualbox & my machine is every bit as capable & more than most Windows machines.
Forgot to mention - I got my RaspNAS up and running, thanks to your excellent instructions. Now I can access my files quickly and easily from any Linux VM, physical device, Mac or PC. Very happy!!!
Great to hear!
VirtualBox is a very versatile solution that works well here.
Having said that, a PC with a reasonably recent set of hardware is required for it to work best.
Yes, Xeon's / Threadripper's are better for the job, and you'll want 2 gpu's for full time usage.
Thank you so much for the WPS Office and TTF Font tips!!! I have a complex Excel workbook, that Libra Calc did an "OK" job displaying and editing. But WPS Spreadsheets does a virtually seamless job managing. My Ubuntu laptop now does virtually everything my Windows Laptop does, but faster! Much appreciated! Got my Mr Scissors mug in the mail last week. LOL
Great video. I do think, though, that one could just learn to love Libreoffice and accept it as it is.
You could/can if you do not have to exchange editable documents with with others.
I dont want to sound too negative but i watch all your videos on 2x speed. I really enjoy them!
Brilliant explanation.This guy really makes tasks easy to understand.
I think the main point, for these people migrating, to consider is that they should move away from proprietary formats ASAP. Once you start using Libre Office, or Open Office, or WPS; stay away from Microsoft products.
They started with an expensive office suite, which is now being turned into a subscription service. Eventually you'll get to the point where if you don't pay your Microsoft bill, they'll cut off your access to the documents you wrote. Further, they could change the ToS to take ownership of any content produced under their software platform, thereby giving them copyright control over your content.
I'd rather keep using something that I have complete control of. Something that doesn't need an internet connection is also a desired feature, since I might want to work on something in the middle of nowhere. I also don't like telemetry systems.
I think someone has made a video about the downside of subscription based software
Thanks for a very instructive lesson. I've recently levered myself off Windows to Linux Mint after 20 years!
Hey Chris your style of presenting these videos and the content is world class. Very informative, well written and presented. It is like watching a BBC production. Keep up the good work and keep these gems coming.
Many thanks for your kind feedback. Most appreciated.
Thank you very much. I wish I'd seen this when it first came out. Strengthens my resolve to convert my main machine to Linux.
Something else that can be done while running MS Office in a VM wich is the best hassle-free option
is that you can mount your linux home folder using samba into windows
so that Documents and Downloads folders are easily acessible from windows and you avoid having duplicate files
Yes, I just format secondary Hard Drives NTFS so windows has no issues reading files off it and NTFS is a lot better than FAT32 or Ex-FAT.
Nah, just go with WPS. It's an almost exact clone, interface and all.
Wps office has good compatibility, very underrated channel.
Libre Office can read more versions of Office documents than Office can, and it can save to open file formats. If It doesn't use Comic Sans, think of it as anti-malware. :-)*
Harsh lol.
Love Linux ,I use MX as newbe fomal microsoft user.
Started with Mint but I prefer Mx now.
Leo Brusselman Planning to use Manjaro
@@mix3k818 I run Manjaro KDE on an old laptop,but I didn't use it a lot until a few days ago.
So I'm still exploring the possibilities.
Leo Brusselman I wanna give it to my parents to make it more familiar to Windows.
For me, I'll take either KDE or XFCE. I'll have to see how intense the other software will be and if I will buy a Ryzen and a new GPU.
I use MX a lot too, but also use Mint as well.
Wine has been around for well over 20 years now -- I can remember looking into using it in a production environment back in 2000, as the organization I worked for at the time had something like 500 computers and was tired of paying Windows licensing fees. So they figured they'd switch to Linux and run some of their irreplaceable Windows apps with Wine on a Linux system. Needless to say, that idea was squashed relatively quickly. Wine has never been a reliable option -- which is not their fault, of course. They're trying to replicate the Windows API *precisely,* and that's simply not possible given Microsoft's lack of documentation on much of its low-level Windows API stuff.... And with every subsequent version of Windows, Microsoft makes more undocumented changes, so Wine is constantly playing catch-up. If you have a Windows app that doesn't change, and is, say, more than 2 or 3 years old, then maybe you can get it running on a Wine installation reliably, but that's a pretty rare situation. For most people and businesses, Wine just isn't a viable option, unfortunately.
Thanks for this, I remember a few months back in one of your videos (and indeed good discussion in the comments also) regarding the 'one step forward two steps back' in modern computing.
My mum who is a pensioner finds the nature of modern Windows to be very frustrating, due to the constant changes, the their desire to push cloud services among other things. Personally myself as well has kind of had enough of it, and indeed when she needs an upgrade, I think it will be time to take the linux plunge, she loves dual screening, uses it for a lot of writing and emailing and is a lot more literate than she gives herself credit for. I will of course take the plunge at the same time as using a raspberry pi has given me my first proper exposure to the OS basics. I dislike not feeling like I am in full control (which Windows OS does to me these days), almost as much as a dislike a phone I can't change the battery in or use an SD card in.
Thanks for always seeming to make really informative videos that I want to watch and learn from.
Hope you have a great week
I changed my Nan's pc to Linux, it's a lot more responsive and she's more secure online now she can't install any adware or bloatware when she's surfing the web. I tried out WPS and I think it provides the best of both worlds for people used to MS Office and Google Office Apps
Now that I'm semi-retired, I'm spending some time working as a "computer buddy" in my local library, when I help other people to use computers. This throws a whole range of different challenges at me, so of which turn out to be easy and some less so.
For anyone who really only needs a PC as an appliance for internet access and needs it to be as easy as possible, I'd recommend trying a ChromeBook. I now own about four of these, if I include the broken that I was given for nowt, in its broken state. For anyone changing from Windows to a ChromeBook, there is a short learning curve, mostly because the keyboard is not the same as a Windows PC one. Some of the latest ChromeBooks can also install and use Andriod apps, which might be an advantage for some.
Next in line for ease of use I'd rate Endless OS. This is a free (but proprietary) Linux distro that gives a look and feel very like Android, but using a desktop based on Gnone 3.
After that, I'd recommend a conventional Linux distro, such as Mint or MX (etc......). Sometimes the choice of distro will be influenced by the target hardware or software. For example, when I need decent Open GL support i prefer Mint to MX, but MX works better than Mint on my 14" HP Stream netbook.
@@derekp2674 Chromebooks are a great option for people who enjoy the cloud office experience. I used Docs for my dissertation but there are certain things that Chromebooks lack, but Windows and Linux have, which keep me from delving into the products further, but this might change soon now both Google and Microsoft have promised full support in later updates for Linux, in their respective operating systems.
@@amirpourghoureiyan1637 Yes indeed. Chromebooks are limited in what they can do. This helps to make them easy to use for those things, whilst making some other things either difficult or impossible. For example, I believe that playing physical CD's is simply impossible under the native functionality of ChromeOS.
@@derekp2674 that's a shame, a lot of older users enjoy using those features on PCs. I actively refuse PC cases without a drive bay, the amount of times hardware comes bundled with a driver disc - it's just really easy to install the software without having to dig around a website for a while. Nevermind the amount of disc-only games I have as well.
Indeed it's true that switching OS from Windows to Linux can be hard because some apps or process doesn't the same.
I personally want to fully pass to Linux but what it stops me it's just some exams I have to do which requires to use Windows application.
Linux is getting the love that deserves and I can't wait to be a full Linux user.
I agree that linux can be over-hyped. An OS is only usefu; if it can run the program you want to run. By the ways have you run into non chrome use websites yet?
@@billfusionenterprise Hi. I cannot give you specific answer because I only use Firefox and I don't know how you can know if the webpage is a non-chrome webpage. I hope this answer your question.
@@simonestarace5249 when certain functions do not work. Oracle doesn't always work and certain HDMIs do not work. And several other fill out forms don't
@@billfusionenterprise Depends if you have set a specific font to use for viewing pages. I did this and some pages show texts outside the form.
@@simonestarace5249 has nothing to do with fonts. Has to do with just the raw HTML code. What is causing it . I am not sure but shows just another problem with webpages. (outside some sites which you need a engineering workstation to view)
Hello from India....Your videos are very helpful and detailed....appreciated...Thank you for your efforts.
Great tips Chris! Big thanks and cheers to another great video.
The other compatibility issue you will have on Linux is with running VBA macros in Word, Excel, and Powerpont documents.
Oh yes, very true!
Great video, interesting stuff, I have been using libre office in office in Windows for years, I think Microsoft needs to sort out it's compatibility, with its own version of office.
If I have a finished document and it doesn't need to be changed, I save in a pdf format, then everyone should get to see practically the same thing.
Everyone does, they use MS Office. MS actually contribute a lot of code to Linux and have worked hard on compatibility- they don't make money from Windows really, they make it from Azure which is platform agnostic. Libre Office is still well behind MS Office, although if you don't have great demands it's fine, so is Google Docs.
@@twmbarlwmstar I have old versions of ms office bouncing around somewhere, then I installed libre office, I never looked back, most people I know use it, ms office might be better, but I have such little issue with libre office I would never change, I can use it on a pi zero out side on a solar charger, in the middle of nowhere, great efforts to ms, but hat's to the guy's libre office, bringing computing to everyone.
@@williamrutter3619 While I don’t doubt you run Libre Office on a Pi Zero over solar power on a Pi Zero I do question how productivitesuch an undertaking is. What posable achievement have you made? You are stuck on a dessert island and must finish that novel?
For myself If I can’t easily read it then I won’t go to work trying to, that means some Libre stuff will just get bounced back to sender. People can avoid that by using online Office which is free. I think we must accept that MS Office is the lingua franca and given there’s a free version you just bite the bullet and speak it or are disadvantaged.
Thanks very much, that was both interesting and helpful.
For someone like me, who only uses a computer for browsing, communication and office software for work, the jump to Linux (Mint 20) need not be painful after having made classroom materials for about 12 years in MS Office (which of course I wish to be able to edit / repurpose at my convenience).
Provided I have a reliable 'net connection at home, I can keep on using Word and Powerpoint both at home and at work while slowly moving myself over to Libre Office for materials I make new from now on.
Very helpful video, thanks.
Hello Chris! 👋🏻
Here we go again, EC video brightened my Sunday with useful topic! {thunderstorm & rain, again!}
I agree, VM and/or web office are the best solutions. I use VMs in all possible OS combinations so it's easy way to get to Microsoft office.
I use wps office few years already, on Android. Google docs are good but lacks some functions I often use.
Wine was glitchy and not reliable.
Mr Scissors and Stanley the knife may not know typography but they surely know how to unbox successfully.
Hi Elvira! Here we are again. No storms here, but very dull. Well, until I turned the movie lights on to film this afternoon. So maybe it is not dull, and my eyes have yet to adjust back to sunlit normality. :)
ExplainingComputers
Rarely dull weather here. Storms here are exciting and interesting.
Well sometimes.
Until my UPSes start to be jumpy & grumpy because of voltage drop. And occasionally power surges. Then it is not interesting anymore. 😬😅
I've found Fedora to be the best Linux distro nowadays. Feels like an actual OS rather than something stitched together from random parts.
I came across an older abandoned Lenovo Thinkpad ultra book (SSHD) and installed Mint and swapped it with the wife’s kitchen counter low end Windows laptop. There were no question / problems until there was an ask regarding scanning.
Thanks Chris, your videos have become a part of my Monday tech ritual!
"Seven ways to fix the world"
Great list. Although I don't know what dematerialization is. It sounds like something from Star Trek.
Simply inspired videos! Following along in my terminal. Thank you!
I just started learning to use Linux because of you! I've opted for Kali Linux and I'm learning Pen testing. But I've always wondered how I could use MS Office. Looks like I'll be learning to use the VM 🤓
Virtual Box is also good for connecting with stubborn printers that have drivers written in dot EXE files
Thanks. You did a great job explaining.
I was using Crossover to get MS Office running on Linux 13 years ago. It worked well.
Things have gotten more problematic! :)
It doesn't help that the Linux Mint repositories have a rather old version of Wine. Much better to go to Wine HQ on the web, and follow the instructions there to install the current version, which will keep itself up-to-date.
For word processor compatibility between Windows, MacOS, and Linux saving as rich text format works well.
RTF = Big file size
@@velanrama yes RTF is about 3 times larger than docx format, twice as large as ODT and about 30% larger than doc format. I primarily use RTF when sending documents to people who can't open a document I've sent them instead of guessing which format will work. For "small" documents works well.
In April 2020, when Windows 7 Pro becomes end of life, I will be transitioning to Linux full time. The distro I prefer is Q4OS. If I need to do any support on Windows I will use AnyDesk or VirtualBox.
I've been using Ubuntu MATE for 6 months now... The switch is painless these days, Pop! OS is the flavour of the month, but that could change by next year, lol.
My bad - its Jan 14th 2020! I still have a licence for Softmaker Office [Linux] so will use that for document creation.
Good info on how to install and migrate fonts.
The biggest problem I have using Linux as a daily driver is the lack of an officially supported Gdrive program. There are options (Gnome has vfs support, and you can install google-drive-ocamlfuse), but I am always concerned that Google will change something and I'll be left without file sync
It's a shame Libre Office can't easily read in or convert MS Access db files, Then I could dump Win7. Great video.
I'm using Win7 in Virtual box with Ubuntu Mate on metal. But no problem keeping the Access dB file transfering it over with wsft. But why can't Libre Base convert it?
Try wps office and dump the win 7
@@FunNFury Thank you. I've downloaded wps-office for Linux, but can't see any database program?
@@dclcav what kind of database program are you looking for?
@@FunNFury All my old databases are in Microsoft Access .mdb format (2003). Libre Base won't read them in unless I drag the data out comma separated text. But then I've lost all my queries and forms etc.
NoteTab Light... Yaay!
I've been using it since 1999. It's the first "Must have" program that I'd install on all of my Windows machines for the past 20 years.
Having tabs on one program makes the most sense instead of launching different instances. I also like the "Use as paste board" function where everything I'd copy would automatically be copied to a specific tab.
Whenever I'm using Linux, NoteTab Light is the program I'd miss most.
WPS has tabs.
Well Bygeorge looks like you really opened a can of worms with this. I mean no disrespect at all. Arthur here love your work as usual .
Thank you !! and nice seeing you again :)
I always enjoy watching your videos, sir.
Excellent tips. Especially the one concerning the fonts. Personally, I would avoid Wine or VM for mission critical work. If you're switching to Linux, go with native apps when possible. BTW Chris, If you love Linux Mint, you'll adore MX Linux. Cheers
I use both MX and Mint. These days, I wonder if Mint is a bit "over simplified for ease of use" when compared to MX. For really old and slow machines, I prefer antiX.
One time I set up Windows 10 in a VM and it worked perfectly. The second time, it was horrible. I wasn't sure if the newer version of VirtualBox did it, if the different install and set up directions I used were the problem...
Because I know how well it worked the first time, I think it is worth a try - and just read as many articles as you can for set up options.
@@derekp2674 antiX is my favorite, but I can't get it installed on bare metal - only on flash drives and VMs. But, even on those, I am grateful for antiX. I hope they make a core or base (more minimal) MX, though, too.
I'm happy to report that MS Office 2013 Pro 32 bits works flawlessly using PlayOnLinux, before that I tried 2010 Home & Student but I couldn't activate it; VL license versions activates without issues using a KMS emulator and POL handles the file association without any hitches.
Now I simply have no excuses to keep using Windows 10 except when I'm playing a certain game that refuses to offer native Linux support
WPS office
Installing Windows apps on Ubuntu, which is itself a Virtual Machine on my Windows laptop.
Next step: Run Windows on a VM in Ubuntu on a VM in Windows.
There's also FreeOffice / Softmaker Office (they are the same software, but Softmaker is the premium/paid version). It looks and behaves like MS Office (if you choose the modern layout, because it also supports the outdated LibreOffice-style layout). It has some limitations, but I found it to work better than WPS Office and I haven't had any compatibility issues so far. For me it works better than LibreOffice for most tasks, although it's slightly slower, so it might not be the best choice for an old computer.
The online office apps are slowly gain the features of the desktop app. Although I hope they don't discontinue the the desktop app when the web apps match feature wise.
Excellent tips for getting Windows fonts into Linux
For me, LibreOffice is the perfect option. Well, it doesn't render MS Office documents perfectly, but if you save everything in the OpenDocument format, and you don't have to deal with docx, pptx, etc. it's fine. I personally wouldn't trust WPS because of its Chinese origins, but you can run MS Office through Wine if you need it.
Thanks Chris - another great video.
My advice: use an online office suite (GDocs, MSOnline, etc.) and then just export PDFs if you need to print.
I luckily don't require an office suite; I just use vim. HTML/CSS can do any styling I require.
Very good explained even with my little understanding of english
Thanks for that, Chris. I have to transition a friend who relies heavily on MS Word, so this is exactly the kind of thing I need to know. 😃
You failed to address the serious problem of finding an equivalent for the proprietary Calibri typeface.
Also, I find the online version of Office365 to be a clumsy interface as well as buggy: it can cause corruption of files originally created in the desktop version of Office365.
You can easily download Microsoft fonts though....
@@Toblehrone how?
Office users moving to Linux should try SoftMaker Office. There is also free version, FreeOffice. For me, this is the best MSOffice alternative. I have been using it for about a year and haven't looked back.
WPS office for documents and Davinci Resolve for video editing. Best solutions on Linux.
Cinelerra-GG is a nice alternative for DaVinci Resolve. Not that beautiful beast, but really very powerful one, more than KDenLive.
@@d3stinYwOw yes, but I prefer Resolve more as in the past I have used Premier and Resolve is kind of like it
Take a look to Olive on Linux too
@@GooogleGoglee yes it looks promising. The appimage of kdenlive 19.04.1 is also worth checking out
A very useful video; some friends enquired about moving to Linux recently, Word-compatibility being their only requirement. Cheers, Prof.!
I personally use Groff, *TeX or Org-mode, but I can get away with submitting PDFs.
If you have licenses for Windows and Office to put in a VM, maybe just have another $50 used micro PC and a KVM switch? That said, I use LibreOffice at an institution that doesn't license MSO, and I've been wanting to set up some Linux machines, so this was a great video that hit the nail on the head for me.
you can use Windows without a license, but cannot install MS Office or Word on it, then, I think.
Excellent video sir.
Those are nice ideas and I just use different computers to run certain software on so there is no mistake and I get the work done correctly.
Libreoffice or any other open source office suite is only for open-source enthusiasts. If you want actual MS Office experience on linux, you either use MS office online, MS Office 2010 under Wine or WPS Office.
I don't use LO because it is open-source, and I have few problems using it along with MSO for daily work--Writer and Calc, at least. Mostly it's about getting used to LO enough that you realize how to do any quick fixes. But I don't require letter-perfect translations, either...all in-house stuff that can have a few formatting flaws. Real difference is macro work in Excel, which I do in real Excel. I do want to try WPS, though.
When I first discovered Linux in early 2000, there was really no useful office suite in Linux. With the advent of Openiffice and then Libreoffice, I can use Linux as my daily driver.
My first try at Linux was Mandrake 6 on a Pc Mag CD. It had Kde 1, Linux was still very primitive compared to windows back then. But it has made a quantum leap over the last 20 years.
2:15 not showing comic sans in libre office is a feature, not a bug.
Great video.
I was looking for ways to create MS powerpoint files on my linux machine. Up till now i've always used impress and converted to pdf, but now i need to use a template, and it doesn't come out like it should. I will give office Web app a go. Thanks for the tip.
I used Libre Office for years it’s fine, but my new laptop is Windows 10 and Linux Mint so I am using Office 365. I like having my docs on One Drive. When I am away from home I just use my iPad or phone. I keep everything in One Drive
The most awesome video which i was in dire need of . The best solution is to use it online. Otherwise what will I do with the subscription money I paid for office 365. Plugins work in a bit different way such as a ref manager. The video was completely informative. Plus WPS Office looks cool and and has an intuitive interface to work with regular files on pc. For the ones to be shared with windows users office online is the best.
there is a nice linux program called "fonts manager" available from the softwarecenter if one wants to install more than one. also to mention internet sites like freefonts were one can share and use own fonts with different licenses.
You can also just type "sudo apt install ubuntu-restricted-extras - y in Terminal. That way you get all the fonts and also media codecs etc.
If only the world didn't assume MSoffice as some kind of standard.
It is worth mentioning that both open office and libre office are incapable of opening ms word word art header formats
Trouble is word art was much better in pre 2000 office than post
@@billfusionenterprise when I usually think of word art I think of office 2000 to 2003 and I still use office 2003
@@alvimuka1853 it was there, it just took a few more steps to get there. i use to make signs instruction sheets and such. and 97 made it much easier because the functions where on the one page. In 2003 they move to this tab setup which you had to use to get to those features. Very annoying when you need them a dozen times in a document
@@billfusionenterprise i agree with you
@@alvimuka1853 Office 2003? Damn!!
I have Office 2007 on my main laptop and Office 2010 on my desktop.
Totally fantastic video thank you so much in showing us all these ways in using ms office in linux.
I like your explanation and analysis of technology and solving of day to day computing problems! 👍 Great work!
Thank you very much!
I agree with your assessment of Wine. It really doesn't work that well and it's nearly impossible to get rid of it after installation. Your Cloud Computing video of two weeks ago caused me to attempt to dip my toe in with the big boys. Being a tightwad I gravitated to AWS Glacier. Wow, it's complicated beyond belief.
Great video. We have this issue at my office. Some use Libre and the formatting gets broken.
Great video Chris!
You are very cool dude, I love the attitude and general feel of your videos
Thanks.
I have tried WPS but it has its issues too. I did a review of text with track changes in the WPS and when I sent it back to my customer he couldn't see it in MS Office. So unless there is 100% compatability you can get some nasty surprise. However, for personal use LibreOffice is excellent.
The issue with VM is that you still must purchase a Windows license to remain on the legal side. Crossover is not cheap and as well as this license, the license for Microsoft Office must be purchased.
I develop VBA applications for businesses and of course I am mad to see all the Windows machine around. I wish they could all save a lot of $$$ by switching to Linux. Unfortunately, all the VBA macros won't run unless in a real MS Office environment. Maybe the online Office 365 will handle VBA macros without hassle? Maybe Wine environment can bring all the required MS libraries so that the VBA macros can run?
I guess if a company having thousands of Windows machine switches to Linux (desktop and server), the saving can be substantial, even if they must keep paying for MS Office one way or another.
The company will also have to rethink the IT support staff as a lot of things are different in Linux, often much less graphical and more command prompt actions. A new breed of IT support staff must be hired and force the current staff to go to serious training if they want to remain employed.
As an individual, I guess the switch is not that difficult indeed. Linux Mint is very nice.
Could you make a tutorial on setting up a home/home-business linux environment with light active directory, file server (samba) and how to connect mixed clients (Linux and Windows)?
I really enjoy your clear videos. Your students are very lucky :)
Thank you.
You might want to checkout these free VM Windows images from Microsoft: developer.microsoft.com/en-us/microsoft-edge/tools/vms/
About differences in viewing of .docx in MSO and LO - MSO writes .docx and .doc not full .docx standard compiliant, which causes problems in formatting between MSO and LO. Just tell everyone to save in full .docx compilant version when using MSO.
WPS is a chinese version office alternative.
Thanks for another great video Chris.
Very good and informative video. The main thing keeping me from totally ditching windows, is the failure of Libre Office / Open Office BASE. I have some applications which use a MS Access DB with some forms and even though I tried to build them from the ground up in LO/OO, every time I try to create a form BASE crashes. The DB does recover properly but as soon as I try to work in developing a Form, they both crash. In doing this, I have not even attempted to import or copy/paste anything from MS Access just create a DB/Form with similar structure and functionality.
These are not super complex DB/Forms and in reading comments all over the web, I am not alone. In fact it appears as if both LO/OO are aware of the issue but have no plans to fix it. There was even one comment 'if you don't like it use something else' and that is the problem with open source software. As difficult and obnoxious as MS can be, if enough "CUSTOMERS" have an issue they eventually fix it.
A few companies (though not many) still use Access, but 10+ years ago in a basic computer class, we were told that Access was going away, so we were barely taught any of it.
Very helpful, very useful video! Thanks Chris!
Absolutely fantastic video - thanks so much!
Chris, you could try Bottles, which is a better implementation of Wine. I was able to get MS Office installed under Bottles with no problems.
Yes, Bottles is good . . . this is nearly a four year old video, and I had not tried it at that point! :)
@@ExplainingComputers I'm using Mint 21.1 Mate, btw. Great videos!😀
@12:44 You pretty much stuck to anything older than MS Office 2016 but the best idea in general is to find alternatives and stick with them.
It's OK using wine to install windows applications in Linux but compatibility issues may still be present due to the fact that you won't be getting windows updates that windows users get! No updates which will cause compatibility issues!
Thanks from Florida’s Space Coast
Greetings Sir! :)
I always learn something new. I appreciate your channel.