Optimizing LibreOffice To Work Like Microsoft Office ...

[@IsaacSF]

I've been using Linux since highscool. Using Libre office to write papers with the math input mode was great, I got great notes because of it. Some professors used to think I was using latex. Now in my master I have to actually use latex, but I didn't even consider learning it for a long time because of libre office.

[@MichaelNROH]

For some formulars, especially when digitalizing something it's great. The only flaw it really has is that it isn't a calculator

[@verified_tinker1818]

Consider using Typst. It's LaTeX but better.

[@Daniel_VolumeDown]

If you don't need colaboration I higlhly recommend texmacs (it is not related to latex but can kind of export to latex and you can use soem latex names if you want (although I find texmacs shortcut and "tab" driven typing faster)). Writing math equations is really fast if you learn it. There is also LyX which actually uses latex and you can type things directly in latex or use kind of wyswig version. I didn't used LyX yet though

[@The_Movie_Thieves]

​@@MichaelNROH since when Latex condoms started making office? Yeah they do need it for their own but I didn't think they'd make their own instead of Microsoft's.

[@vanc6671]

Had to switch to onlyoffice because libreoffice's dark mode was just so bad. It just looked like high contrast instead of dark mode. Its ui was also similar to ms office 2011 which threw me off badly.

[@MichaelNROH]

Initially this was my reason as well, but after I discovered the icon themes within the application and the toolbars it became superior quite quickly. It's still a personal preference however

[@weil46]

Yea onlyoffice is was better when it's come to similarly to ms office

[@Sollace]

Yeah. I use OnlyOffice too. I find it's also a lot better at displaying word documents correctly.

[@emerson-biggons7078]

Yeah I switched to Only Office for one reason. Checkboxes. Google Drive has amazing checkbox support, onlyoffice works pretty well, and libreoffice makes me scream with how obtuse it is. I know thats a pretty random problem, but I use spreadsheets, good programmable checkboxes are a requirement for me and the horribly confusing checkboxes in LO is just so bad it isn't worth it. This is a me problem tho

[@bombaglad32]

@@MichaelNROH the default experience of onlyoffice is worth a lot

[@NiGhtPiSH]

I do love the default classic looks of LibreOffice. I never really liked the ribbon interface that was introduced in Office 2007 and stuck with 2003 for the longest time, before moving to OpenOffice and then LibreOffice. It has served me well ever since. I don't do fancy stuff with macros in Calc, but following good practices to correctly format my text documents and they do look the part and there aren't any compatibility issues. Most compatibility issues I've come across through the years have been due to improper formatting from other users.

[@FengLengshun]

For me the most annoying thing is color. I have had issues where my formatted Table and PivotTable would just look all messed up when I put it into LO. Unfortunately, I work with a lot of document for a lot of users, so it has to work with what people expect them to work - so MS Office and/or Google Sheet. One of the biggest blocker is that I can't expect docx and xlsx files to look right in the MS Office people use and ODS files confuses people (especially on mobile as they try to open it from WhatsApp - where we often send files that don't need to be sent from email). It's just not worth the hassle for me.

[@ContantContact]

Same here. I have used menu systems since PCs existed. I never even look at the ribbon menus. I did see them in MSO at work, but didn't use them.

[@JuanLopez-vf3mo]

Thanks a lot, Michael!

[@MichaelNROH]

Thank you ❤️

[@xard64]

I've been using OpenOffice and the later on LibreOffice over decade for my own needs (including all school and thesis work). While the menu layout usability has always been bit hit or miss and UI hasn't ever looked that appealing it has been a great tool to get my tasks done reliably: though I haven't ever had to exchanged word documents between MS Office users, which might explain the good experience I've had. One less mentioned area where the Open/LibreOffice shines even compared to MS Office is how it handles localization: the MS Office locales on countries which use comma as decimal separator can be a nightmare. When using a local with comma as decimal delimiter Excel cell scripting parameter separator IS NOT comma but semicolon and yes, this does break compatibility! (also I could go on how wonky the Excel CSV import is with locales and encodings, but that's a whole different can of worms) The usual advice I've seen that if you want to use MS Office products in your native language: just don't unless it happens to be en_US.

[@hansmatos2504]

Writer is not as powerful as Word? I made my entire thesis using only LO Writer, giving it the APA formatting my university demanded, the legends, sections, pagination, margin and everything. Not sure why it wouldn't be as good as Word...

[@MichaelNROH]

It's more about niche features like connecting the program to some other application. ERP software comes to mind in some cases. As a standalone I would say it's mostly up to par

[@FengLengshun]

LibreOffice is powerful. The main issue is when you start to interface and interact outside of the ecosystem. It just creates confusion and more work for people as there's usually something that needs to be fixed after it interacted with LO. I pretty much gave up and went with WPS Office. I don't like it, but it has caused the least problem for me working in an office environment.

[@Spark_Plug17]

Same. I have gone full linux for about 5 months now and use it as my daily driver. I'm currently making my thesis with LO too. I'm still learning about margin and stuff but i think i could make it work

[@ASilverNMeep886]

I had a class that graded based on Word specific grammar checks and metrics (Passive/Active voice, Reading difficulty, etc). I know there are plug-ins for OnlyOffice at least, and you could use other tools online I guess. However, when working under those conditions and as a group on a document, it was better to just use Word. For personal or less strict uses, I could probably be satisfied with OnlyOffice or LibreOffice.

[@mjdxp5688]

I think people who say FOSS alternatives such as LibreOffice or GIMP aren't powerful enough are either just unwilling to learn a new user interface or make use of some extremely specific and niche feature that they "can't live without".

[@sanderhulsman-m1k]

Thanks for showing me as a windows desktop user the libre office suite, and with it a first impression of its many options.

[@WololoWololo2]

We need more KZbinrs like you to advertise Linux and get people into Linux 😊❤ Your work is beyond the prices keep it up!

[@thieftheodore]

These alternative office works great if you are working alone. As soon as the documents/spreadsheet needed to be worked on together with office users it'll soon become messy.

[@pazu8728]

@@thieftheodore that is the main issue for me not be able to switch completely to linux.

[@ChristopheStrobbe]

That really depends on the features you need. I have been using LibreOffice, and earlier OpenOffice, since 2003 or 2004. With Writer, I have rarely had issues, even with large documents (100+ pages). With Calc, exchange spreadsheets has worked well most of the time, except when changing template characteristics. The biggest issue is rendering issues when exchanging slides with Microsoft PowerPoint, because positioning is often different.

[@mojojojo2888]

@thieftheodore I'm a 35 year old teacher (so it's not like I'm some college student linux fan that tries to convert people all over the place) and we work with documents quite a bit at work. I used to think like this too for the longest of times, but at some point I realized that the problem isn't that a particular file needs to be worked by many people (and microsoft office users) but that most people are really clueless on how to use a computer. I mean, here in Greece (and I guess probably everywhere else as well) most people can't get through their skull that pdfs are for sharing files with other people, while and doc/odt files are for editing. Simple as that. They just share averything in doc format ("just in case"...) and of course many times it's gonna look attrocious on someone else's computer, sometimes even if you're both using microsoft office, (if you're on different versions). The thing is we all aren't obligated to use the exact same office suit, or have the same fonts installed on our computers. If you want me to send you a file just to read something (say a student test or some lesson notes), I will happily do so, but it's gonna be a pdf so that it looks exactly how I expect it to look in your pc. If you want to edit it, I will happily send you an odt converted to doc but from that point on excuse me but you have to learn how to change a goddamn font and don't expect things to magically look how you expect them to look when they are not supposed to. I expect that there are gonna be lines of work where this is simply not possible, but let's not kid ourselves, in many cases (if not most) we are only torturing ourselves playing "the office tech support guy" because of computing illiteracy and our colleagues refusing to learn a fucking new thing when they're required by the times we live in. You simply can't be working with documents for a living and refuse to internalize such simple things. Edit: The fun fact is that people my age, tend to get what I'm saying. Most of the times I don't have problems with them. The people that act like immovable mountains are the older colleagues, like around 45 and upwards.

[@SenileOtaku]

And HOW is that any different between using different versions of MSWord/MSAwful? Microsoft can't manage to maintain compatibility between different releases.

[@thieftheodore]

@@SenileOtaku the difference is office usually provide you work laptop (usually ThinkPad t14s) that have same version of windows + office pre installed.

[@midimittens]

Really appreciate this as a newer LibreOffice user coming from the M365 world, thanks for making this video! :)

[@evans-uu5wm]

Nice video! And onlyoffice also looks good resembling Office 365

[@MichaelNROH]

[@domojestic4155]

I've personally seen OnlyOffice break a few PPTX files, whereas LibreOffice renders them fantastically. It does have a much sleeker UI, but as far as functionality goes, Libre definitely still blows it out of the water! Plus, no extra features behind a paywall, which is nice.

[@NJ-wb1cz]

​@@domojestic4155 onlyoffice works better for documents though

[@imaguyyesmale]

Yup, onlyoffice last time i checked didnt even have an insert OLE Object function yet, but maybe its just me who is illiterate

[@NJ-wb1cz]

@@imaguyyesmale why would it support ole objects?... No one should ever use docs with those.

[@ChristopheStrobbe]

I have been using LibreOffice, and earlier OpenOffice, since 2003 or 2004 and it has been my office suite of choice ever since. I never liked the Microsoft Office ribbon, so I still use the traditional look.

[@philipwood7673]

Thanks for this, I've recently switch to Linux and have been loking for a way to transition over to Libre Office. I'll be rewatching this video multiple times as i tweak my settings. One issue I have found already is that Libre Office lacks some of the newer formulae that Excel offers, so I will have to either wait for them to catch up or come up with a new way to do what I've previously done in Excel

[@MichaelNROH]

Out of curiosity, what are some of the missing ones?

[@philipwood7673]

@@MichaelNROH I've noticed FILTER and UNIQUE seem to be missing from the Libre Office I've used, and I'm pretty sure it's the latest version. I think they've only been introduced to Excel in the last 12-18 months though, so it's probably just a case of Libre Office needing to catch up.

[@MrHellUnleasher]

@@philipwood7673 From what I gather, these are already available in the latest version (24.8).

[@tubeDude48]

Absolutely ! 👍 Have used it for years on Linux Mint.

[@Isjan-og4ph]

Found this video to be immensely helpful, thank you !

[@EduardoMarchesan-z1k]

Congrats, keep the good work, love your videos, subscribing

[@Flying-Bunny]

Main limitation of libre office, and a deal breaker for me, is the lack of collaborative options. I work in a team, and we do require that. Other main limitation is that most of my work is in a sheet and excel and Google Sheet are far more advanced tools.

[@SenileOtaku]

I could see you claiming MSExcel might (I emphasize *might*) be more advanced than LibreOffice Calc, but Google Sheets?????? Google's online spreadsheet and wordprocessor tools are useful for automatically shared documents, and for live, sumultaneous multi-user editing, but functionally it is FAR inferior and substandard.

[@mayhoth8900]

I have to admit that I try to avoid word processors and generally office suits as best as I can (as an Emacs user, using a word processor seems only marginally better that having to use an electrical type writer), but if I must, Libre Office seems to be both more powerful and more hackable. I mean, in LibreOffice you can use Regular Expressions in the standard search dialog (a thing which is hard to achieve in MS Word even when using macros!), and you can easily prettify the XML output so the resulting files become actually readable and editable in a real text editor. Sadly, you cannot savely edit a .docx file in LibreOffice, because all the finer details of the layout tend to get messed up (which is not, by the way, LibreOffice's fault. Although the docx format is an ISO standard, it is apparently MS which does not implement it correctly, so that we get the impression that the other programs do it wrong.) This is, by the way, the only reason that I still keep a VM around with Windows 10 and MS Office 2016...

[@ContantContact]

I used Open Office since before 1.0, and then LibreOffice when that split came about. EVEN at work where I had MS Office, where they allowed OpenOffice but not LibreOffice. The main difference now, is that I retired and started using Linux only several years ago.

[@Anthony-bl4rc]

Very good quality. Subbed

[@little_forest]

Switching to standard LibreOffice from MS products is really simple and has barely any problems... at least compared to going back, since the tabbed MS Office layout is extremely confusing and nonsensical... you just cannot find anything if you try to find anything from a sensible point of view...

[@Flying-Bunny]

Despite them being quite different, I find them both quite intuitive in that regard, they just have two different approaches. I guess it's mostly a matter of habbits.

[@FengLengshun]

The tab interface is easy to use. You just click a tab, find the icon that looks like what you want to do. Or: just press Alt Q, and type what you need to do. I only remember a few things I do manually, but for those the tabbed view makes it easy to do as it's easy to click the icons or memorize the Alt command sequence. In comparison, finding stuff in LO takes a long time, especially when they don't surface sensible "often-used stuff" and have decent command searcher a la MS Office and Google Sheet.

[@little_forest]

@@FengLengshun Well, what is combined in each tab, does not make sense, so if you look for a specific thing that you dop not know where to find it, the LibreOffice menu is structured in a way that you have a chance of finding the functionality, I do not in the tabbed view, even though I have worked with it in the past past. So it really does not matter whether it is tabbed or standard menu, as long as the structure and organization is logical enough. To find sh*t in MS office products, I need to use an internet search, not so with LO. And again: even though I am used both.

[@FengLengshun]

@@little_forest Why would you need an internet search? Just use the command searcher at the top of the window (Alt Q). As for me, I grew up with MS Office so it's more annoying trying to make sense of LibreOffice's logic for menu. Google Sheet has been better because they don't have as much and properly groups sub-command. It is pretty subjective, though these days I just use command searcher when it's not something I need to do all the time.

[@jimuren]

Nice job with this video, Michael!

[@junglejamesie]

To set the default save file types, you dont need to open up each individual program to do it. You can do it from just one program via the pull down menus.

[@lKrauzer]

I use OnlyOffice instead of LIbreOffice solely because of it's default appearance

[@AL-Hanafi1]

Yeah but it doesn't support other language ( Arabic , Hebrew , Chinese etc . . . ) in my use case Arabic

[@lKrauzer]

@@AL-Hanafi1 I can see this being an issue, fortunatelly for me it is not

[@50-50_Grind]

Thanks for this visual handholding guide.

[@yiannisspanos694]

Has anyone made a script to do that automatically? If not, is it possible to do it once and then save move the config to another device? I would like to now the spefic config paths I need to copy, so that I don't have to add the whole config folder in my dotfiles git repo. Also, if someone helps, I will try to upstream them to bluefin and Bazzite.

[@MichaelNROH]

There used to be I think. I don't know if there are any recent ones though. Technically speaking, you should be able to copy the libreoffice config directory (particularly the user directory) from one PC to the other. E.g. with the flatpak version I could copy "~/.var/app/org.libreoffice.LibreOffice/config/libreoffice/4/users" to a different PC

[@yiannisspanos694]

@@MichaelNROH thank you! Although I can't sync that on github. So many unnecessary files.

[@mike__5kp]

I tried to do this and it didn't work so well so I proceeded to look for an office key and everything is working fine for me at the moment.

[@yavuzs7]

Sorry, where did you get them? I have a problem with my Excel and I want to try to see if it solves my problem.

[@mike__5kp]

ehh I used BNH Software and I haven't had any more problems so I can't complain

[@SenileOtaku]

Why look for a MSAwful key? A rPi Zero and PyKMS will do the same thing for less.

[@p0358]

@@SenileOtakuthese are just scam bots, that’s why

[@Simte]

It is certainly the best solution to use instead Office. Thank you for some tips I didn't know in so many years of Linux usage.

[@MichaelNROH]

Thanks

[@EugeniaLoli]

Actually, OnlyOffice has better compatibility with office formats.

[@nigelphillips7454]

@@MichaelNROH on micro soft 365 app can i click on buy then cancel payment before trial ends also which option makes me an admin basic,personal or family option please let me know asap would mean a lot to me i liked and subscribed to your video

[@nigelphillips7454]

@@MichaelNROH on micro soft 365 app can i click on buy then cancel payment before trial ends also which option makes me an admin basic,personal or family option please let me know asap would mean a lot to me i liked and subscribed to your video

[@tp_exe]

i switched to libre like 2 days ago but unable to adapt BEST TIMING FOR THIS VIDEO

[@bejoalan]

Libre is great. I would love to use it as my main office program. I have Libre installed in all of my system, whether its Linux or Windows. Sadly, compatibility is the main issue for me since my work still requires us to send/ receive documents in docx, pptx, or xlsx format. My current best solution is WPS Office. But it's not an open-source program. Also, it still has some version limitation on Linux.

[@vishalkumar040393]

I wrote my entire PhD thesis and two scientific papers using LibreOffice. It is the only office suite I use. Yes, collaboration is sometimes hard, but with new version it is much more polished and stable with MS Office.

[@Toastyisburning]

I noticed your theme changed to gtk4 at 2:14, how did you get it to look like that? Mine still is themed like gtk3.

[@MichaelNROH]

It's a legacy theme called adw-gtk3 or something like that. Since Gnome 47 is right around the corner (with it's legacy libadwaita), it felt right to show it like that

[@mkyral]

… and before OpenOffice, there was a StarOffice ;-)

[@ottomaier7127]

And Softmaker Office, which is still avaliable, in the case that someone does not want LibreOffice.

[@Daniel_VolumeDown]

8:24 why would you show onlyoffice and wps office when talking about "more restrictive" office? I would argue that onlyoffice is simmilar in terms of features (some things works better and some are little worse than libreoffice) and wps office is basically full clone of ms office (note though that you should use it via wine (bottles or something) if you want new features since linux version is outdated; wps office is also closed source and chinese so there is that)

[@amortalbeing]

The best office suit I have seen that resembles MS Office, by a huge margin, has been the WPS Office!, not only it really brings the same look and feel! it actually is much more compatible than libre office when it comes to office files! the only down side is its closed source, but free to use. so if its not an issue for you, then by all means go for it and use it!

[@MrPlazma]

Good video as always! As a new linux user i find your videos really helpful

[@MichaelNROH]

Thank you

[@eMorphized]

I did have an issue with LibreOffice in older versions, where if you didn't have autosave enabled and used too many OLE objects and images, Writer would segfault. But if you saved after adding each object, it would stay within the segment and not crash.

[@anon_y_mousse]

It's weird to me that others complain about LO's dark mode. I've been using the FlatPak version for the past year or so and it had a good dark mode built-in. It even made the paper view a nice dark gray. Funny thing is, I never bothered to look if it had a dark mode before because I barely ever used it, but lately I've been doing the daily crypto quotes from the newspaper and I copy them into Writer to print them off.

[@bigfatpandalaktana2747]

Switching to LibreOffice because my KMS activated MS Office was disabled actually made me consider other completly free software and now I use Arch Linux with free software for everything but gaming!

[@ninetydirectory3798]

Not even massagrev's script?

[@bigfatpandalaktana2747]

@@ninetydirectory3798 what's that

[@bigsmoke4568]

Same here! I tried re-installing with KMS and it just won't work at all. I wonder if a Windows update secretly bricked KMS 🤔

[@InnerFire6213]

Why not arch for gaming i use it primarily for gaming. But i guess if you play fortnite or valorant it makes sense not to use linux to game

[@jimmyking92]

One of your best videos to date.

[@leticiavianaviana9558]

Thanks for the video 😁😁

[@jimkyle8008]

When using Linux Mint Cinnamon 21.3, I wished to take three screenshots of a web page and then paste them into a Libreoffice Writer document in a sequence running down the page. I started by saving each screenshot as a separate file in the Documents folder. However, when I copied and pasted the first screenshot into a blank page of Writer and then positioned the cursor underneath it in order to paste the second screenshot below the first, I found that the second screenshot actually replaced the first. I could find no way round this problem until I had the idea of first creating a table consisting of one column and three rows on the blank Writer page and then pasting the screenshots one at a time into each of the cells. Although this workaround achieved the desired result, it was a bit of a pain having to do this, especially since it's very easy to paste multiple screenshots with each one below the one above in Microsoft Word.

[@roiborromeo7921]

WPS is available in Linux too, you don't have to do anything, it's already modern enough

[@Star_dragon]

@@roiborromeo7921 But I have lot of privacy concerns about its privacy concern and its ads.

[@abdullaheyni]

thanks this really helps

[@g04tn4d0]

Check out Only office, as well. Looks a lot more like M365.

[@MichaelNROH]

I actually switched from it, since it kept "saving" to my Fileserver, but it actually didn't write anything. It basically said that it saved, and I lost 3 hours of work. Got into LibreOffice afterwards

[@block_01_]

I wish that it had a working reference manager that worked like words, that’s the only reason why I have a windows vm on my work laptop (I’m an apprentice software engineer so I have to do assignments and course work)

[@gorschill8456]

Which document do you have open at 7:40 ? Could you please share link or where to find it?

[@randallstewart1224]

This never gets to the core question: Why would anyone want their word processor to work like MS Office/Word? I took Microsoft a generation to force it into the office space though a variety of strategies, none of which had anything to do with its relative merits. I was fortunate enough to have started buying word processing software before there was an MS Word, and I retired in 2016 without having ever to install it.

[@Fox-in-sox]

I'm seriously thinking of switching from 365 to Linux. Thank you for this video. It is so information rich that I'm going to have to set playback to 50% and re-watch a half dozen times. Best regards.

[@definitlynotbenlente7671]

The biggest issue i have experineced is that libre office does not have the same feature set as ms and ofthen the way to get to a result is very diferent and becouse ms office has a monopoly All training ij college is on MS office if you want to use libre office your on your own

[@SenileOtaku]

If the college is teaching you to ONLY use a specific package, rather than teaching general concepts transferrable across multiple packages, they are doing you a GREAT disservice. You should be learning how to adapt concepts to other scenarios, otherwise you haven't learned anything at all.

[@krky86]

do you know a way to fix the issue when an document written in libreoffice gets its formatting messed up in MSoffice or even onlyoffice, in the case when numbers that refer to footnotes lose their superscript formatting, and instead of appearing as small numbers above a word, they appear as regular numbers?

[@NJ-wb1cz]

It just doesn't have the best compatibility with documents. And given enormous old complicated codebase, I wouldn't bet on things improving

[@theseal6681]

Works for me since i only used pirated ms office 2003 and the ui was really easy to move to 😀

[@kote315]

Inconvenient default settings are a huge problem for many programs. It's great that in Linux and related software you can configure anything you want, and the system does not resist. But still, most people (including me) are too lazy to spend time fiddling with the settings of the damn office suite!

[@MichaelNROH]

Well, they are not inconvenient per say, just different from Microsoft. I do believe however that a simple toggle in the top right or something would be more efficient though

[@kote315]

@@MichaelNROH Well, I had a random experience of teaching at school. We (me and a bunch of students) couldn't find how to change the font color in Impress in ten minutes. I think such UI design can be called "inconvenient". (This happened a few years ago and things are probably better now..)

[@originzz]

@@kote315or you could consider the fact that Microsoft is such a monopoly that their UI designs which may be called terrible are implanted in everyone's minds from youth

[@kote315]

@@originzz Changing the text color is one of the most basic and obvious functions, which logically should be somewhere in a visible place. But if you don't have the properties panel open, you'll never find it. Neither the main menu nor the context menu will help you (you can find Styles - Font Effects, but this is a little different, although it will work). You should guess that the properties panel opens from the sidebar on the right. Google screenshots of any version of PowerPoint since 2003, you will find a button to change the color right on the main panel, where it should be. I'm not saying that all Microsoft software is good or Linux-related software is bad, but in this particular case it's better, whether we like it or not.

[@user-dz3ph7dl4m]

the dark theming is my only thing I dislike with Libreoffice - very poor clarity. selecting Elementary icon theme mitigates this somewhat. but it needs to be improved (a few more shades of grey). For me the only upgrades needed are ms fonts installed, the word spacing and elementary icons. tabbed view doesn't do it for me at all. i wish i knew this stuff a few years ago - i did some consulting on my own and was determined to use linux only (which I did) - but I did have some formatting issues (probably the spacing item here). wasn't the end of the world but added some time when going back and forth with client on reports.

[@TheChessPatzer]

Only three minor issues with LO Writer so far: 1. It doesn't save vertical text orientation in text boxes when transferred to MS Word. You have to reset the orientation manually. This is a pain when you have several pages with vertical text boxes. 2. The procedure for hiding text is complicated, and cannot [at least easily] be assigned to a command key. The best [clumsy] workaround is to select a block of text to be hidden, then check the "hidden" option for the characters, and use shift-ctrl-Y to repeat the operation for the next block. Obviously you have to go back to character formatting again if you interrupt this process by using some other command. 3. Lo has no way to display unique 128-type barcodes or QR-codes automatically in a mail merge. You have to convert the codes individually, which defeats the purpose of mail merging.

[@MichaelNROH]

Hm, a workaround for the text box might be using an older docx version since then Microsoft uses it's compatibility tools to read it.

[@RogerioDuarte]

I love libreoffice I've used a lot in college.

[@Layla_r0se]

Majoriti pengguna biasa takkan guna function yang pelik2. Untuk badan tertentu, benda ni free je. Masa lepas microsoft update, tak perlu pergi jumpa mana2 tech assistance.

[@agent0422]

Why is it that open-source software is always the opposite of user-friendly? Isn't the point of the open-source philosophy that everyone should be able to use it? In that case, you'd think that open-source programs should be MORE user-friendly than their for-profit competitors. But still, every open-source program I've used has a UI that looks like it was designed in '80s and a UX that actively makes your workflow worse. What's up with that?

[@MichaelNROH]

It's mostly that many developers are not good designers. And for those that are it's often complex coming into a project that late in development

[@Star_dragon]

I can understand but if the UI is too familiar, they may get sued by a proprietary software company. As they are mostly run by NGO like the document foundation fighting a company like Microsoft is suicide .

[@SenileOtaku]

I don't know about that. The MSWindows UI looks like crap. Unless you're using GNOME Desktop as your example. Then yes, GNOME looks like crap too, and is severely ugly, unusable, counterproductive, and user-hostile.

[@ArifGhostwriter]

🇬🇧 👍🏽 October 2024 Awesome walk-through!

[@Erianthor]

Just a question, if I may...is it possible to setup graphs in LibreOffice Base forms/reports? I've worked a bit with MS Access before, but can't seem to find that feature in Base.

[@markwarburton8563]

I've used LibreOffice for many years, but one thing that really irks me is the stupid way it implements page numbering starting from something other than 1, or changing from one style (e.g. i, ii, iii, iv) to another (1, 2, 3). It's hidden in format -> paragraph -> text flow. You have to insert a page break and then select a page style and, finally, you can choose a page number to start numbering from. This really all needs to be in one dialog, not buried in the depths.

[@NadineNabih]

my issues is with compatability with other users , most of my classmates basically use windows and microsoft office but for me as a linux user this does not work well , mostly with text moves or appears differntly

[@fatinebadr7244]

i was initially wanna switch completly to using libreoffice , but it was just impossible , so basicly why in th work we use VM access to windows machine to work whitch are not something i can change , its actually the decision of the bank i working with , and they have also a office licence too so basicly everything is there using office , basicly simple task without using macros did happen to do just fine using libre office as transition to me , but when it come to macros , i did just learn they completly not work since VB et basic is not the same , even the math calculation stuff dont work always if there a bit complicated passed from microsoft office to libreoffice ,... so i can only try to use libreoffice on the regular basic stuff and keep office for those tidious matter of compatibilty with my work

[@roccociccone597]

I really hope that libre office will get a UI overhaul so it looks a little nicer.

[@hornsteinhof7592]

Hasn't it gotten just that a while ago? Might be mistaken but it does feel like not too long since the latest redesign

[@greypsyche5255]

Don't expect much from it. Open source apps usually use gtk or qt and both toolkits are not great for these types of programs. Krita is ugly, GIMP is ugly, LibreOffice is ugly. The only way to make a usable and great looking application is to use custom GUIs. OnlyOffice is a good example and it doesn't use gtk or qt.

[@MichaelNROH]

It needs a color palette update and more modern looking default icons in my opinion. This is the main part that makes it look "dated".

[@Rousent]

I've never used Libre office (I'm definitely gonna use it in the future) but always see people complain on its appearance. But if you can customize it to have the ribbon interface, customize the content for the tabs and even download icon and color themes, then whats really the problem?

[@MichaelNROH]

Some complain about some functionalites like Power BI integration and some table types, but globally speaking, it's only a fracture of people who actually use that. With some elbow grease, LibreOffice can also support these things with maybe some different solutions but it's just not widespread enough for big companies to jump on it yet

[@albertxion513]

People really only complain about appearance because it looks awful on windows.

[@kylos90]

Hi, great video! Which Linux distribution are you using? It looks beautiful.

[@MichaelNROH]

It's Fedora

[@till2911]

I am currently using wps office but thinking about switching because of ads and it not beeing open source

[@СаняСаня-з2т]

Main disadvantage is that it renders .docx files differently. So, if you'll share perfectly formatted file in LibreOffice it would be different in ms office.

[@SenileOtaku]

That's because Microsoft refuses to play nicely. Using MSAwful is just surrendering to the bully.

[@rajeevgopwani9736]

Very useful tips

[@deathdoor]

A lot of these tips feels like things that should come as default.

[@proyectoelevate]

Libreoffice is great tool! honestly the only thing holding me from fully transitioning to linux is the video editing. Unfortunately still sucks.

[@nonk123]

the only problem i have with lowriter is how badly screwed up the formatting gets whenever a professor forces .doc submissions (not even .docx and definitely not .odt) and opens the document in ms word 2003... page numbers: gone math formulas: gone cross-references and captions: gone pictures: splattered all over the page don't get me started on those mostly blank pages with just a single word from the preceding paragraph and in the end, i'm the one blamed for submitting an "incomplete" document the same happens whenever i have to print my document outside of its native software on my laptop. even ms word 2021 can't figure out the .odt format yet

[@arthurdefreitaseprecht2648]

@@nonk123 yes, but this is basically a problem imposed by word, they has to be legally obliged to deal with odt recently, otherwise they would still ignore it. To print I recommend always using PDF.

[@doveofdestiny]

Could you make a thunderbird or email client video for linux. Thunderbird is fairly confusing, and it would nice to learn how to use it propely.

[@ottomaier7127]

I had the same problem, when I switched to Linux. eM Client (which is my favorite) unfortunately is not available for Linux. I tried several mail clients, and am finally using Evolution, which works well, and the GUI is ok, much better than confusing Thunderbird.

[@Dumb_Killjoy]

I second this. I've been trying off and on to get it to work with my college email for a few weeks with no luck.

[@ottomaier7127]

Yep, this is my experience, too. I finally used Evolution, which is not best, but working, and has a much clearer interface than Thunderbird.

[@enabalic]

​@@ottomaier7127 Have you tried Geary? I used it before and it worked properly. Also its UI is the simplest I've seen out of all popular email clients on Linux.

[@fabricio4794]

This Layout changes are Good,i did it

[@erhangok7119]

How did you make the main frame look more like gtk4? I am using Fedora 40 and it does not look like yours at all after i did all the settings you recommended.

[@MichaelNROH]

It's a gtk 3 legacy theme called adw3

[@saleeshsaleesh-t9y]

Hi mcichael , thank you for the video on libre office , is there any place where i can find perfect tutorials for libreoffice

[@home-of-the-brave]

What do you Choose for Teams ? ;-) We use this for Group Chat, phone calls and Video Chat

[@MichaelNROH]

Teams actually. Microsoft recommends to install the online version as a Progressive Web App (Install Website in Chromium based browser) which is nearly identical to the local version. The one thing that I don't know is, if custom backgrounds work. I think they are supported but I'm not sure.

[@thechicotube96]

Is there a work around to enable Flash Fill on calc (Ctrl + E on excel) ?

[@mac1991seth]

Here's the problem. As much as everyone likes to hate on Microsoft - rightfully so - the changes they implemented in the Office suite, while often hated and criticized, eventually were all adapted and accepted. And at this point you actually have to put extra work into changing non-Microsoft software to look and behave more like Microsoft. Which means only a fraction of people who found this video will even bother. They have MS Office at home.

[@MichaelNROH]

It depends a lot on how people used to use a product. Microsoft did a lot in terms of usability that was objected at first, yet were really good. I think that this is often missing from Open Source software since existing users tend to like a certain way on how they use a program

[@SenileOtaku]

Not in THIS home. Those sorts of products are not welcome here.

[@habibanshori4529]

When i try print to pdf worksheet in libre calc, the pdf output larger then ms.excel and i can't select text object on the pdf. Any solutions of this?

[@AdryCM]

Hola guapo, disculpa no es mejor WPS? Qué opinion tienes de esa paquetería? Saludos! ❤

[@puteraryu4390]

great video! quick question, after i arrange Tab and Toolbar, how to export it so i can restore it if i upgrade computer? thanks

[@gittube417]

I use and like Libreoffice but is there a way to create a "back button' ???? Very annoying without this feature. Thanks.

[@JayKang11]

For me, I couldn’t handle that mouse scroll was zoom and not next page in my presentations… I wish I could find a solution to that…

[@MichaelNROH]

Impress does not zoom for me but scroll through the slides like on Windows. Are you sure that you didn't change anything?

[@paulyname]

I am thinking in buying a MacBook air M3. A friend told my that Openoffice works fine but what about libre?

[@rorywalters1614]

The Mac version of Libre Office writer is basically unusable with the Magic Mouse. Writer has a stupid horizontal scroll bar that couldn’t be turned off, which is horrible for the Magic Mouse because accidentally horizontal scrolls could be easily triggered. Pages and Word never had that stupid horizontal scroll.

[@Seyram_yak]

5:27 I can't find the 2010 option on mine

[@thomaskish8392]

Libre office just needs to fix the tabbed view for dark mode....

[@jimbojumbo-os1np]

Id rather keep using pirated ms office with internet blocked from 3rd party firewall. Libre office takes ages to load even when not opening a file so why deal with that on a 3k pc with a pci5 nvme AND have to mod it to be usable. Load time might not be a priority for everyone but i open multiple office programs 10-20 times a day so it got real anoying when i tried to switch.

[@bhbr-xb6po]

That title is self-contradictory

[@KazrBrekker]

In Tabbed view stuff like Title Headings don't properly show up

[@vsz-z2428]

4:59 dude this bug is so annoying it happens in all gtk3 apps

[@ronch550]

Biggest problem with LibreOffice is compatibility with Microsoft Office. Whether it's Microsoft's fault or LO's fault, people will encounter problems. Let's have it: MS Office compatibility is paramount to gain widespread acceptance otherwise people just can'tor won't use it. Free is nice but if I can't collaborate with others then it's just a no-go.

[@Highironwolf]

What I really need is an alternative to outlook that isn’t Microsoft or Mozilla.

[@MichaelNROH]

Sooo, Google then? I'm not quite sure what you are after. If it's an email client then there's Evolution

[@andrii_suprunenko]

ms office is not a world's standard. You can use any analog and it's not your problem if some document crushed in ms office

[@MichaelNROH]

Technically speaking, when sending documents to external partners, you wouldn't use editable files like these anyway.

[@domojestic4155]

Unfortunately, the part where you said "it's not your problem" just isn't true. If you work in an office where everyone uses MSOffice and you refuse to send things in DOCX, PPTX, or XLSX, then you'll functionally be avoiding your job, and you won't be working there much longer. So, it's not your problem so long as it's not your employer's to keep you employed. Which is a pretty tough situation to be in.

[@andrii_suprunenko]

@@domojestic4155 it’s a circle. Everyone use ms office because everyone use ms office)

[@MichaelNROH]

@@domojestic4155 In an office you typically don't get to choose the office suite anyway and everyone uses the same software. Also, I only said that it only applies to sending files to an external company which you have no control over.

[@domojestic4155]

@@MichaelNROH Right, that's what I was getting at: what the commenter said about it "not being your problem" simply doesn't function because, as you mentioned, you may not get to pick your software, or alternatively, your choice may be actively hindering your ability to do work with other parties, which will greatly affect their disposition to working with you. It's unfortunate that we're still at the stage where open standards aren't conformed to and avoiding Microsoft's nigh-spyware is pretty much a requisite in the modern working world, but it *is* the world we currently live in. Though I do think we can gradually move away from that.

[@SenileOtaku]

Now just **WHY** would I want LibreOffice to work & look like Microsoft Awful? One of it's benefits is it's NOT MSO.

[@darkxse7en]

How do I sync Linux Libre Office Documents on OneDrive?

[@cjaydip]

What about Onenote version in Libreoffice?

[@cptfarzkizz8823]

I never liked Libre, in the past it wasn't compatible with DOCX or any MS format, even though it claimed it was. Apache still worked better, even though they say the same team made both, and on that I am very skeptical . I'll add in I have not used it in years , so that all could have changed.

[@sargo92]

I tried installing ms office 2007 version through heroic launcher and Word and excel worked, powerpoint didn't for some unknown reason.