I want to stress that paid software has accountability and support, usually it is way more robust since people want to make money out of it, they have to sell it to you and keep on selling it to you ;) Open Source is a great, just not the unicorn you are looking for, because developers need to eat too :D
Thank you, and very true. @nofreenamesotreg, I can see your thoughts on this, but as I pointed out in the video, LibreOffice has a support model for revenue generation, so they are not accountable for support and ongoing development as well. We, as users have to choose to get that support package.
@@nofreenamestoreg In my experience, FOSS just works better. Probably because the project usually starts out of pure necessity and then eventually gets shared (and improved by) the world, while paid software is a product and usually works like this: "Hey, let's make the new version even flashier. Add 500 buttons and 120 AI buzzwords if needed, as long as this year's profit goals are met." Devs are usually loaded so it's often made as a side-project because they're simply bored or out of pure altruism. Ofc, nothing is black and white as there are marketing and engineering-driven companies; I was comparing FOSS and closed-source software (like Adobe or Windows).
You're only half right.. Yes, FOSS is made by people (and I love it), but it's usually not for people - it's for themselves and then shared with others. Nothing wrong with that but the result is that most of the FOSS software is designed (both functionally and UX-wise) by programmers and for programmers. I am programmer so I am happy, but it is what keeps FOSS mostly on the fringe. Yes, paid software is made for profit.. But how do you make best profit? By offering what people want at their acceptable price. And to do that, they often have initial investments and much larger budgets, allowing for UX design team, Q&A team and so on. None of that is wrong IMHO - and it can be also done in FOSS way.. And it is being done! If you take a look at many of the large FOSS projects - GNOME, Linux (kernel), Firefox, Ubuntu, Red Hat stuff and so on, they all have big foundations or companies behind them and work exactly the same as for-profit SW companies do.. GNOME developers are making the software for profit (they get wages) and it's not only okay, it's good.
@rouchar As someone who's worked in I.T. since '99?....I can say I've used proprietary software...and you get more peace of m9nd woth open-source. It might jot LOOK as shiny and flashy as the paid-for stuff?....but it just WORKS!...And its less buggy...and while there are th8ngs some folks wanna do that open source can't do?....the "basics" are just fine...
I've used LibreOffice for years and love it, I'm a writer and the PDF conversion is a fantastic tool for me when copy editing. Before that I used Open Office and before that I used Microsoft but the cost was prohibitive back then, now with this subscription model it's untouchable. A good alternative to Microsoft for first time users is Only Office, the desktop version. It's more like the way Office is now.
I love Libre office but Calc does not run all the code that Excel has embedded into spreadsheets. In college they taught us to code in Visual Basic for Excel. The code was not compatible with Open Office, which I used at the time. Propietary software makes it hard for business to use Open Source. I only use Open Source in my business and at home. I don't want a license that can be rescinded and lose all access to my work. If MS decides to charge a fee to use their propietary software the world will have to pay up. MS would hold the whole world hostage. Everybody has stand together to prevent that ever happening!
Totally understand this kind of incompatibility. I think this, however, is the extremely low percentage of most "spreadsheet" use cases. People use spreadsheets for lists, simple calculations, scientific data and charts, and so much more that I think are much more common cases these dasy. Yes, if you're a finance guru who has 10000 macros and VB scripts in excel, then calc won't just work for you as is for sure. That doesn't make Calc worse, just not compatible for those use cases.
A lot of people use spreadsheets to put together things that really should be done with database instead. I was guilty of this for years until I saw the light.
I don’t want to “stand together” I like buying quality software from Microsoft and other vendors, and I see software as something we should be willing to pay for
I won't use MS-Office unless mandated for a project. When it comes down to brass tax, I tell people to use what they want to create a document and then in those cases you can always upload into NextCloud or Google Docs (cringe) or O364 (bigger cringe) for "collaboration" purposes. I got through grad school using LibreOffice and nobody knew the difference because everything was submitted as PDF.
I lost points on assignments due to formatting compatibility bugs of OpenOffice when I opened it in Word and hit print without review (those known bugs are gone). Had a friend I got into using it later and she had issues with not being able to do collaborative markings in files and see other's marks. Later it seemed to be working but there was a bug where Microsoft users couldn't remove her marks from their documents through Microsoft Office + its own formatted files. ^_^
Microsoft Access is the killer MS Office app for me. I have not seen any other software that comes close for standalone apps, one or few users, or for rapid prototyping, or for reporting using data from other databases
FYI: I found this video, because Microsoft has just deleted my Excel 2013 without permission, notification, leaving no trace in a trash can. I have deadlines, work to do, and suddenly I have no tool I paid for. I cannot even re-install it because it says I have some beta software on my disk? I cannot download because it wants me to buy again or upgrade to Office 365 or similar. This is unbelievable that a rich company could kick you in the butt like this!
The dealbreaker for me is that Calc doens't support tables, which I thought were the bases of any spreadsheet. I love the new excel functions and use them daily but I can live without them, but not without tables, where I work people fill tables with data then everything else gets calculated and displayed for them, I can't work without calling tables by their name in formulas.
It does, but not quite in the same way as Excel has it implemented. You can setup Calc to provide all the features, but it's done differently for sure. Data Ranges is one way, but not the exact same. As anyone who knows will point out, Data Ranges aren't yet dynamic. But there is also the feature to connect a database type object in Calc (similar in Excel) thought you continue working with the data in Calc, and this is more dynamic with all the same features and more.
I have to take another look at the database option, I have been thinking about that, there are a lot of info that repeats in many workbooks (employees, vehicles, scheduled teams) I'm using macros to update that info when the user opens the workbook and prompt the user to pick the new location of the main data (in case the path changed name). If I can use Calc to update a database I would give it another go. By the way @AwesomeOpenSource would you recommend the libre office database or a solution like mariaDB? I'm looking for something permanent, for the long term, but also simple enough to not require a database engeenir, just an office tools expert self taught.
Been using Libre for several years. For all these years I have been experiencing a bug - a document that has been open for many hours (without working, just opened in bg) hangs intentionally when im back to it. Only way its kill task and next start need to restore all open documents. And it sometimes works strangely slow in terms of instant responsiveness (like typing text and letters appear as if with a slight delay). All this alweys remind me, that this is a free product. But yes, for a free product it is good. Done same job as MS but no cost. For most user its good free alternative with minimal cons.
Make sure you report the bug to the LibreOffice team, and provide logs, and file size, how long it'sopen for, whether it's on Linux, Windows, MacOS, or all of them, and whether you document has images, what format they are saved in, etc. As much info as you can provide is help;ful to them.
@@AwesomeOpenSource now, it crashed twice in an hour. And the second time it did not restore the text maded in last hour. This is the last straw, I'd rather use a normal product than this free but complete rubbish.
Excellent video. You struck a nerve at Microsoft with this video because I'm seeing many Microsoft shills in the comments....they're probably bots. Keep up the great work.
I appreciate it. My goal is to start conversation, not to make people angry. I have no issue with someone saying MS is better, as long as they can give concrete examples of why it's better. It's truly about what you need to do with the software. I believe LibreOffice can do anything MS can, it's more about how you do it, and whether you're willing to relearn some things.
@@unitedstates3068 Only a small subset of professionals need powerquery. I've worked in offices, and as a programmer, since before MS Office even existed, and I have never come across anyone who needed powerquery. I'm sure in certain professions it more prevalent - but for the vast majority of MS Office users LibreOffice would be just fine.
While the translation from MS to Libre office got much better, the Impress /ppt one still needs work. Got problems with animstions, themes and similar. One that i really enjoy is LibreMath. As someone in stem that application can save a lot of time. In Writer still not sure how to insert images so they don't move. For Calc never really used it, but from what I've seen it is just like Excel. It is missing some functions from Excel though.
Interesting, I've struggled with images forever in Word. I'll be honest, Pages on Mac has images, and any other "floating" context stuff implemented perfectly, and better than any other solution. Would love to see LibreOffice get to that level with inserted items.
Although I love libre office and think it's fantastic, it is NOT better than or even on par with MS Office. At least not yet. So many issues with calc and impress. Also missing some useful features eg flash fill. Will continue supporting them and hope they catch up but not there yet
I appreciate your thoughts and input. I hope you're providing this feedback to the LibreOffice folks as well. As much as software teams know what they need, they are not all knowing, and can use guidance from their users and community.
If you use both and know of missing and different features or compatibility bugs and want to support them getting better, please report them as bugs if reports don't already exist. Some things may change quickly while others may take years or not get changed but reports are used by the developers to find things to change. Could be differences in the bugs I reporte but my reports seemed to get addressed much better back when Sun Microsystems ran things and has been significantly downgraded since it became LibreOffice.
I am a chartered Accountant, And I can confirm 99% of people in my community don't use libre office because we can not navigate through tabs with Alt shortcuts, This is the most important thing people want for speed working.
@@LibreOfficeHispano is this like blender mouse button all over again? if i remember correctly, smarter everday channel has a video on topic about this very thing. it's about the bicycle where the control is reversed.
Haven't tried the nextcloud integration but messed with collabora on android a bit (I'm a newer cell phone user). It has been a mix of good and bad but I have only done very minor things like nearly unformatted documents and spreadsheets that I just used for a table layout. Some bugs I ran into under that basic use have vanished with updates so I have hopes it can be useful.
I like Writer more than Word because Writer makes it easy to edit my styles, apply my styles have a style serve as a chapter marker Add a page break add a horizontal line create, update, and format a table of contents Put in a full-page image Print in book format Export to pdf Export to epub All of which is between mildly annoying to "like pulling teeth" in Word.
Styles are a great part of Writer. I didn't even consider Word a contender when considering other basics like lists required a lot of editing to remove silly font variations per level by editing each level's rules individually while OpenOffice offered rules to have a level be a modification based on the previous level. Some of that went away in newer ODF formats but the simple numbering style is still available. Some of the worst parts of LibreOffice have been its attempt to change from its roots to be more Microsoft Office like. I don't mind if it can be set (/downgraded) to act like Microsoft, but don't make that the only option and be willing to expand on to being a better program than Microsoft offers instead of trying to be a clone. Imagine if we lost styles to "comply".
It's amazing. My daughter had to do several presentations for school last year, and she started on powerpoint, then continued in Impress at home, and finished in powerpoint, and never had to reformat, change transitions, or effects, and it all worked quite well.
I have Libre' Office installed on every PC I own, Linux, Widows, and even Mac. Now, I am retired and the last time I used the Presentation (Impress) part, although it worked the same way as MS's application, when making a presentation, if what you did in it was played back on MS's app, it did not look the same. (File was quite compatible, just what you saw was not the same as intended.) Of course that was few generations back software wise. So, I even now will say if you develop a presentation using Impress, display it in Impress for the best results. Other than that issue, I was and I believe still is a great piece of software. No one should be using MS's product in my opinion.
If Libre Office Base was anywhere close to being in the same league as Access (it isn't, not even close), I would consider using Libre Office instead of Microsoft Office.
I guess it depends on the league you want to play in. I'd say Access is minor leagues, while Base plays with the big boys. You can have base talk to any number of alternative back ends, MySQL, MariaDB, PostGres, and more.
@@AwesomeOpenSource Access is supposed to have the ability to talk to others through back ends but I think you have to find+install them separately. Other than data corruption and proprietary formats, I don't know what Access has that the opensource big boys don't.
Problem with Calc if you're coming from Excel is that it's lagging in the newer functions so you can't open your sheets properly if you make use of the new functions like I do.
If you're doing extremely complex functions and calculations, there likely will be things you need to address. Again, MS is the company using non standard things in their software, not the open source options.
@@AwesomeOpenSource To be clear, I'm a rabid, zealous detractor of Excel and it's bloated, anachronistic MO. I use it grudgingly, and only when I have to (i.e. at work). For nearly everything else I use Google sheets (not without its flaws, either, to be sure). That aside, I'm unaware of any officiating body that regulates standard spreadsheet cell functions. I'd argue that any function implemented identically by both Excel and Google Sheets could be considered a sort of de-facto standard.
I'm enjoying your videos and appreciate what you're doing. The following is intended as feedback only: I assume the ad duration and locations in the timeline are set by you, and they seem to be a little excessive. Several 55-second ad breaks for a 24-minute video are nearly more than I'll "pay". Most technical videos that I watch have about three 20-second ads for a 20-minute video.
Ad duration is not something I seem to have any control over. Placement to some extent, yes..I only put 3 per episode if it's over 20 minutes generally. If less, I do 2. I also don't control if UA-cam adds more though.
HI, i used to do some volunteer work on PC's, mainly on ex lease and donated machines, typically OEM we would image with the Dell / HP OEM cd. Once Win XP / 7 / 10 was reinstalled we would grab Libre Office, VLC media player, Firefox , Dosbox and some shareware dos games all runable of a cdrom image and install them as a fairly usable budget home PC Some of the older machines, say Pentium 4 / C / M , Core2's we would install Linux Puppy, then the free apps Anyway Libre Office worked fine, the issues around 2005-2015 was minimum and mainly fonts not translating properly, but the few people that complained was very low and the advice was search the net and get the microsoft basic font pack that is available and install them - the problem was not serious they would edit some documents from work created in MS Office and when it saved the font and tab and margin was not 100% the same - oh some advance excel features did not come over, i believe possibly pivot tables was one issue Regards George
Let me fix the statement, it's 95% of all documents before LO 24.8 and 99.9999% after, I have lot's of documents with array formulas that will finally be added with 24.8 afeter 5 years of waiting
LO provides most of the MO functionalities, as far as programming (VB) is not necessary. LO VB language is so cumbersome that there is a great difficulty to translate simple MO-VB operations in LO-VB ones.
It has tons of features. The thing that stops most people is that the features aren't where they are used to them being in some other software suite, and they have a hard time retraining themselves on where to go, or how to access the features they use regularly.
Ya know working for Dell for the many years I did. MS Office was something I trained on and as a MSDN partner paid by Dell I had all the MS programs I wanted. Life after Dell was do I really need Office? No After I could no longer install it on my computers I switched to Open office just to write a simple office or a spread sheet. After no body was not paying me to use a computer. I am going for free if possible.
I've read some complaints, that LO is not even close to Office, and LO is for those who don't want to pay MS. Well, I don't pay for MS, the company where I work does that, and I can install O365 on up to 5 devices. Gues what, at home and for my personal use I only use LO.. At work I might say it's impossible to switch to LO, we have so many additional components developed for Word and Excel that I cannot even remember all of them. We also do an intensive use of MS Access. Well, at home, I don't need that, so LO does the job for me. Also, in our company the last person who told me LO is BS, had no idea on how to use Styles in Word. That made me laugh :)
I think people confuse "more built for MS" with "is not as good as MS". You said it quite well. It's that you already have investment in building things to work with Microsoft through their closed source methods. It's not that it couldn't be done again for LibreOffice, it would simply be a lot of work.
Sun Microsystems used to develop tools and services to help with migrating things from Microsoft Office to StarOffice/OpenOffice. Oracle put an end to sane access to anythign that wasn't already opensource as they took over. Dad had a copy of Office from work; don't know if it was okay or not in terms of licensing. Uncle paid for Microsoft Office in his shop. On their last upgrade they thought it was a multiuser license they purchased for their machines and began installing it on their 6 or so computers. By the time they hit the last one the installer removed the old copy before rejecting the new install due to the issue of many installs on one license key. They called the # on the popup about the illegitimate install where it was explained it wasn't a valid license for all those installs. He wanted to purchase not only the license for that machine but for all machines that were not legitimately licensed but Microsoft apparently cannot sell licenses when you call their # about illegitimate license issues...facepalm for Microsoft and I put OpenOffice or LibreOffice on as a workaround but they opted to stop buying Microsoft Office for machines when they saw it was doing what they needed (maybe still bought 1 or 2 for compatibility reasons).
I was a corporate accountant for nearly 40 years. I went from spreadsheeting on a mainframe system to DOS based spreadsheets - Lotus 1-2-3, Quattro Pro, Excel - to Excel on Windows. I've never had use for macros in spreadsheeting and I've built and used some pretty seriously complex spreadsheets. Ok, I did create a button with a little macro behind it for importing data when I had to give a spreadsheet to a complete moron to use. He still managed to f*** it up. What can I say: make a thing idiot proof and they'll just build a better idiot. But apart from that macros in spreadsheets were completely pointless. People whining that LibreOffice etc. aren't compatible with their macros tells me that they aren't using spreadsheets and the other tools available to them correctly.
@@dingokidneys thank you so much for Sharon this. I love to hear about people who specialize and have the experience to make amazing statements like this.
To go out of your way to use Office is ridiculous, if it's put in front of you, then it's far more understandable. Libre-Office is great! I hope I can convince my office to convert to it one day.
Thanks, and I hope in the next month or so I'll be ready to put it out to the world. No idea where or how just yet, but I'm working on it in my 3 minutes of spare time a week. ;-)
Such a beautiful dedication to your loved ones - I hope this truly inspires your daughter and many others. I'm in complete agreement with you. People can achieve great things if they do just two: always believe in themselves, and start. @@AwesomeOpenSource I hope you'll forgive me as I don't mean to nit pick but I've spotted a couple of typos in the snippets caught during the video and the proof-reader would be remiss if I didn't at least mention them. In the second paragraph, third line of Chapter 1 you write "… more an more lazy", I'm guessing you meant "and". The second one I spotted is in the last paragraph in the same chapter just before the section break where Dave's mind wanders into the past where you right "morre" instead of "more". Would love to buy your finished book as an eBook or as a printed work; seven years to find the ending you're happy with is quite a long time - but then some people always /say/ they'll write their book but never do, whilst others just get on and _do_ the work required. Wishing you many successes with Entanglement and its sequels, should they already be under consideration. - Mark
Thank you so much. Yes, I'm just starting my editing now. I"m sure I have dozens of typos, and imagine my use of commas, semicolons, and more is atrocious. But, I'm working steadily through it as I can.
Every time I've tried Libre Office, somehow the first thing I needed to do was vertically center align a title page. In Word, this is three clicks. In Writer, it was a massive time waste sunk into eventually finding out "vertical alignment isn't a thing that people do, so we don't."
@@AwesomeOpenSource yes. Horizontal is easy, but I also needed to center between the top and bottom of the page. All the solutions I found involved manually placing a text frame or something. I know enough about layout settings that I would need a gun to my head to put a bunch of empty lines (tap Enter a bunch.)
Insert>frame>frame and setting that frame to be vertically centered is probably still the way to have it actually centered + stay that way if changing font sizes or adding lines. Other objects can be inserted and similarly aligned too. I usually just get away with format>paragraph>spacing>above paragraph to nudge it acceptably close and adjusting page margins for a page style only applied to that page would work too. Once I find I need to do more advanced/specific page layout in a controlled fashion, I usually leave Writer/Word/etc. behind for software like scribus or lyx/tex/latex. Others seem to use quarto for some document publishing and asciidoc, troff/groff, etc. as an alternative to tex/latex. Once things are described as a markdown language, I usually find the battle annoying to learn which of the many markdown languages is the one in use just to find it uses its own variation of one of them; a # of websites do that which butchers attempts to type comments with standard paragraph separations.
I don't imagine they have one built in, but there are dozens of open source tools that can query multiple datasets and let you do things with the data for some amazing analytics. Also, I would imagine its far less than the 99.9% of regular users who really need something like Power Query.
Desktop intalled grammarly doesn't work with LibreOffice for some reason. If it did then Libreoffice would certainly be a more well used tool for writers. Language Tool's extension goes some way to filling that gap. Onlyoffice is getting much better. Free Office is a very competent alternative too.
@@AwesomeOpenSource The primary reason for us is that we have a lot of clients that are in the legal and financial sectors who do heavy formatting in Microsoft Office. We found that Libre had issues in too many cases with them. Most people will not run into the issues, but for our business we had to change. We tried Softmaker and OnlyOffice. Both worked better for the heavier edited docs. Ended up with OnlyOffice as our team liked the layout better.
You should open a bug report so that they can remove Tables from the menubar and its choices like "Insert table (ctrl+F12)".. If they agree to and you decide you need table-like capabilities, you can insert a calc spreadsheet into a writer dog.
Hi! First of all, thanks a lot for the video, it was very informative. Is it possible for you to teach us how to integrate Libre Office with Nextcloud for online editing? Thanks for reading.
Let me see what I can do. I run the AIO of nextcloud, so just added collabora to it, and I can edit online, but if you want collaborative editing, I think that takes a little more setup.
For writer, page properties are under format>page style>page. If you use styles, you can adjust the properties per style. If stuff doesn't reach the printer consistently with those results, also double check that you don't have setting and defaults outside the program altering things. Otherwise any other issues you had adjusting those?
All I can say is make sure it's been reported, and add your own comment to the issue. The more comments an issue gets, the more it becomes a priority to address in future releases.
Once a bug report exists, make sure they have a sample file that expresses the problem (and a similar one that doesn't if it has a clear transition from working to broken). Any details you can add could help too like "gets slower after 7 images" or "slows down if adding multiple image formats",
I would love to ditch MS, but I'm an author of childrens books, and use Publisher to produce them. I need pictures and detailed writing to accompany the pictures. If LO can do this I'm all for it. I was excited to see Writer LO, but I don't think it does what Publisher can.
I believe that LibreOffice does indeed import .pub files into its LibreOffice Draw. But as with any import scheme, be prepared to do a little formatting fixing. Give it a try to see. Although, you could elect to write your childrens books in LibreOffice Writer.
Indeed Publisher files can be imported into Draw, but I'd suggest you check out Scribus. I think for your needs it might better suit your more advanced use cases. It's also free and open source.
@@AwesomeOpenSource Awesome, Awesome! Thanx, for the tip, I'll have to check this out! I really don't care for MS and their a-nine service. Hope it works!
great presentation, the office suite is very important when seriously considering desktop transition. May I ask what OS distribution you are using (along with what desktop environment)?
MS products now provide (absolutely incredible and _vital_) value by enabling collaboration on documents while also denying access to export controlled employees within an organization. Businesses today can deal with substandard/basic formatting options ... but collaboration and permissions is now vital. In the future, enabling automation from docs (or linking such docs to code) is going to be super-vital.
Automation and code in docs has been around for decades, and it's an almost unused feature by 99.999% of people, and the ones who do use it are generally trying to run a macro on your system to give you malware, or steal your data. The tool isn't the bad part, it's the way it's used. It's like a hammer, it can be used to construct incredible things, or very easily to destroy something.
Do you know how to create a numbered list in Libre. Beginning with the top cell containing $10.00 and descending in one cent increments down to $1.00. How do you create this list without entering every amount?
I'm not a calc expert but I'd put 10 in top cell (let's call it A2), and in second cell put "=A2-0.01", then copy that cell, and paste it as far down as you want to go. You may can click and drag down to copy as well, but haven't tried it.
I am blind and tried libra once and it didn’t really work with NVDA, if the document had headings a menu would come up at every heading and I would have to escape out of it every time I go to a heading
As they don't have a rule that it has to be downloaded from them or their official mirrors, the total downloads will be higher. Important to also consider if its downloads for a single version. Some users don't regularly update it, some downloaded installers may not be ran while others are ran multiple times on multiple machines, and some installs may not even get used.
Yeah, but after we install it, we play with it for a few mins and are repetitively disappointed with it so it goes unused on our computers. We're doing real work with Microsoft Office - the one we actually use. Even at home because it does the job. I've installed Libre many times over the last 10 or so years and every time I hope it gets better. But no, might be a little better looking that it was over the years, but still disappointing. I use MS and LO just sits there unused. Eventually I uninstall it and try again in a year or so.
@@brianwheat1 Yeah, I tried to use Libre Office when I was a uni student, but I quickly discarded that idea and pay for Microsoft Office instead. My biggest issue was it's compatibility with MO. Everywhere I go, people use MO. If I try to open a file from LO to MO or vice versa, something's gonna be different, or even broken. That would lead to a massive headache during group projects. Ngl, MO is easier to use. And if I'm stuck on something, a simple google search would lead to an answer. Meanwhile with LO, I have to really dig into it. Sometimes people with the same "dumb" question I have in forums got pretentious answers that sound like: "It's not what it's designed for. Why are you even asking this?"
I talked to my college IT department to ask for StarOffice access back in the day; their version cost money but they had 5 licenses all unused so they gave me access to 1. I also explained it was free on newer versions and they ended up upgrading and enabling it for all students; start menu bloat ensued against all those students wishes and understanding. ^_^
LibreOffice is cool and awesome, you have to take your time to learn it like you are new and there's no alternative . You will not feel it well if you compare it with MS Office.
I'm old, so was always raised with two spaces after period. Does the one space not make it feel all squished to you? Easy enough to change in bulk with the amazing editing power of LibreOffice and open source though.
@@AwesomeOpenSource I'm old too, and it's a hard habit to break! When we learned, it was on a typewriter, and two spaces there is correct. However, "modern" software like Word and all publishing software (Affinity Publisher FTW) automatically adjusts the spacing. Because of that, adding more than one space creates distracting "rivers" of white space in columns of text. All decent publishers will methodically strip out the extra spaces prior to publication. Happy writing and publishing!
@@AwesomeOpenSource tools>autocorrect>autocorrect options...>options>ignore double spaces if you are changing to not using them anymore. What you do is an option and sometimes some fonts and characters need a little tweaking to look good for either style. I was taught 2 spaces by some teachers and 1 space by people who studied and did professional publishing. It also seems related to monospaced fonts vs the rest and how well kerning and such is working. I wouldn't trust the average modern word processor to be adjusting it in any relevant way; if you need that you should use things like tex/latex but even then you may need to force what is done sometimes to be consistent about it.
Editing in there can be more painful than expected but for a basic edit it may get by. but last I tried it I found that a basic paragraph has each line split into separate text objects so line wrap between them is now manually moving data and it was common that documents more advanced than text may lose parts of the document. You may find other programs like Scribus(?) or Inkscape may help with some PDF files differently.
I have been using Libreoffice a long time. I translate sensitive documents docx files to be exact. I love the UI and the many features of Libreoffice but the performance is terrible on large docx files. 100-300+ page files with some low-res pngs and text. It can take 30 40 sometimes 60 minutes to load a file. And editing is painfully slow with notifications that LibreOffice isn’t responding Wait or Shutdown constantly after all editing. A painfully slow processing large docx files. Now to all the disbelievers i tried this on three different laptops with three different levels of RAM and three different OS one of which is MacOS. In all three laptops the same results slow load times for large files and extremely slow editing. Even breaking a 300+ page file into bite sizes files is get same result. So i have to do word processing translations in Onlyoffice which loads in 5-10 seconds and edit in seconds without my favorite Libreoffice features. Statistically speaking with same terrible performance on three different computers tells me that there is a bug. And i read in computer blogs that others have experienced the same
I have even experienced the same issues whether it was a .deb snap flatpak and dmg. Horrible performance on large files on three separate computers. I am truly sad to report this. But for now i have to use OnlyOffice to get get work done
Is this a file with a lot of images or something? My book is more than 250 pages, and I've moved it from docx to LibreOffice multiple times, and had no issues with it at all.
@@AwesomeOpenSource Why would I have the same exact issues on three different computers (2 with Linux and 1 with MacOS) ? Why do the same exact files of mine open and edit on OnlyOffice in seconds? Why can I open and edit in FreeOffice in seconds? But not LibreOffice on three computers?
it's like a version of office sure, but can it do Macros, Formulas, Reports like office does without bugs?? i don't think so. Does it have a giant community where you can get your problem solved by searching for literally 3 minutes and not getting headaches?? again i don't think so.
To say "without bugs" is such an odd turn of phrase when talking about Office. As I say in my video I use Office all the time for my day job, and it's 1000% buggy for everything. I'd say LibreOffice is much more stable, and yes, it has macros, formulas, reports, charts, even mail-merge and so much more.
I had a 365 subscription but the redo button didnt even work in any of the apps. Completely unusable. And I found no solution after weeks of searching. Finally decided to ditch it. Have used LibreOffice ever since.
Microsoft Office is not bug free, let alone bug free in their Macros so I don't know what you want there and you don't have VBA but do have its own version of Basic while also having javascript, python, etc. as additional programming languages. In Writer you can use insert>ole object>formula object to bring in a formula and file>new>formula to just work on a formula as a file. In additon to its help which can be installed or accessed ton the web, LibreOffice has its own help/forums but many things were answered many years ago on the OpenOffice forums. Many 3rd party sources for how to do things exist too. Few things I looked up took me long to find unless I didn't know how to ask the question and then even google, microsoft office, etc. fail to be of any additional use. If you want the feeling of "few bugs", you can always set a timer for a short time in the future and when the time is reached you can force close on the office suite without saving or run a memory editor on it and edit a bit of the memory randomly. When you want to step up your game, install Linux and give psdoom.sourceforge.net/ a try but that is way beyond an office suite at that point.
@@zedtrek I used open office and libre office years ago. I wanted to know how it improved, but this video is too long and not straight to the point. I use google docs for the moment being and am satisfied with it.
All the MS fans keep making these overly generalized statements with no actual examples. I'm happy to hear any real examples for the average business owner on this. Tell me what Calc or Writer, or Draw can't do.
Document sharing used to work with generally only minor issues 20 years ago. The issues I ran into and saw from others were all resolved many years ago. Are there current sharing issues you have seen recently? Last I checked it was still best to share documents as .doc or maybe .docx if you needed its newer capabilities; sharing as a .odt is a bad plan because Microsoft has many longstanding issues with that format in general and not jsut with LibreOffice copies of it.
Thunderbird, Evolution, KMail, NextCloud Mail, Geary, and dozens more in the open source space. I'm partial to Thunderbird, the built in calendar is really nice.
I'd love to hear your thoughts on what make it not close? Again, I'm not talking about that .0001% of the population who use some kind of special tooling in Office, but the average user.
Ive recently ditched libre for only office. Runs way better IMO Sadly i have to have excel to open 1 file from 1 vendor i work with once a month. Its so annoying.
LibreOffice forked back when Oracle bought Sun Microsystems and started closing up open projects, slalling development, etc. Can't remember but I think it was befor it became Apache OpenOffice taht LibreOffice formed and by a chunk of the original staff. Development has been much faster and changes seemed to flow from OpenOffice to LibreOffice but not really back the other way much. I have disagreed with some of LibreOffice's changes and path they choose to head; both are options still in case of running into bugs or undesired features but I generally point everyone to Libre until there is a need to not be using it..
Sadly no its not...once you get serious with pivot tables it fails ... Excel still wins... But I'm hoping they catch up one day... But I been hoping for 10 years...lol
If anything, Excel is pulling further ahead. Power Query is a game changer. And they are also gonna integrate python programs into Excel. It's not even close.
@@stephencooper3583 yea, I could not agree more.. But maybe with ai, it will make open source projects advance faster being that everyone can write code with it.
@@stephencooper3583 If they are just now integrating Python+Excel then its catching up instead of pulling ahead. Maybe people want power query badly enough it will be in LibreOffice or maybe they will shrug their shoulders and use the already existing database interfaces+sql.
Libre Office is an amazing stuff, but with this "so much better than Microsoft Office" oh boy, you really got carried away. Unless of course you have no idea what Excel and Word can really do
I use Excel and Word every single day for my full time job. I as an employee of companies who use Microsoft, can tell you that 99.9% of the people who use those applications could 100% use LibreOffice for their work.
They both have things the other cannot do. Neither counts as overall superior and there are things they both do but one or the other is really awkward to do it, find how to do it, or may not even be able to do it.
If you downgrade to the older StarOffice, it had an email client and even a complete replacement for Windows taskbar+desktop. I recall a bug where you could delete an email on an unrefreshed IMAP mailbox that had been altered and it could delete the wrong message. Unfortunately those were lost when StarOffice became opensource so it probably had code owned by others that couldn't be released but may have been left out as an undesired maintenance burden.
I tried to implement libre at my company, almost worked, but without a OneDrive equivalent for shared documents that are edited at the same time by multiple users, I couldn't make it work. Trying to move away from Live spreadsheets was a no go. Such a shame, I liked the software.
Well, you can use NextCloud, and get all the sharing and permissions around a shared system, plus a lot of nice features on top of that. Also, it' get a syncing plugin for live synced editing.
Not sure about multiple people working on one document at the same time instead of separate times but that sounds like a disaster to implement in a standard office setting with having to have software present merge conflicts to its user base and expecting them to do the task of resolving such conflicts. Locking files works to have only one user on it at a time and some documents can be logically broken up across several files which can then be edited simultaneously and brought together with a main document. Maybe I am overthinking it and git with flat XML ODF document (.fodt and friends) files or rearchiving .odt with zip comression disabled is acceptable in general offices. It would certainly do the job but I don't know that it serves any good purpose for an 'office user' workflow either. In addition to nextcloud, I think LibreOffice probably still has capabilities to use things like ftp in save/open dialogs for reading/writing to network storage but haven't tried that for many many years. Other cloud storage should work as long as it presents its storage to the OS as a drive letter.
I used all the other alternatives and still went back to using MS Office. Even when using add ons to make it look like MS Office, LibreOffice still looked horrible.
The aesthetic is just a really odd reason to me to not want to use something. I get it if you say it literally cannot do these things that I need it to do, but to just say it doesn't look like what I'm used to...I don't understand it.
I programmed in msoffice years ago and already then, msoffice had object riented VBA and an object model that made things SO much easier. Frankly, I tried to use the same in LibreOffice (which I use daily) and it SUCKS! I started Msoffice in 1993, so I am no amateur at software deve and certainly not in office automation using VBA, but LibreOffice scripting SUCKS!
if you have a project where you need to use standart of formating- then you need a microsoft office 2010-2019.Libre office, wps and others is for kids.
If you need consistent formatting then you should be using pdf or tex/latex. You should never mix different versions of Microsoft Office if you need to guarantee consistent formatting; even then it does have bugs that can cause formatting to change when you close and reopen it within the same version. Interacting between any different programs will generally be worse than then issues you run into between program versions.
I've never tried it, and not knowing what your issue is, have you setup your email on your system, and does Writer know what email client you're using?
Tools>Options...>Internet>Email>Email program may need to be set. I don't know if Tools>Options...>LibreOffice>User Data>email being set matters in any way for this as I don't use email features from LibreOffice but it is good filling out those pages so details can autopopulate properly in documents and only need to be edited once to impact all documents in the future when things change (you move, get a new phone number/email, share a document with a colleague who needs their own details entered, etc.).
Tried using it a few months back and the worse part was when it would crash, it would corrupt not only the file I was working on but all those that were open in any of its apps. Worst part was when I tried to open that file, it would tell me it needed to be repaired and doing so, "Poof!"...the file would just disappear, gone, deleted! And these were not huge files...nothing more than 10 pages...😡
Hasn't ever been lighter or faster in my testing, but it also brought some of its own code around whereas Microsoft got to use Microsoft code that already loaded with Windows and they handled multiplatform code differently. There has been some good code cleanup in OpenOffice and LibreOffice but it still seems slower to load and bigger once up. Some of that is probably how each program in the suite interacts with the others.
I tried to look up why you would sort order paragraphs...not really sure why you'd do that, didn't find anything in my search. Curious what this means.
I'm having trouble with LibreOffice when writing my thesis. I need to organize my reference list alphabetically, but I can't find a way to sort it. Microsoft Word has this feature, but it's a big inconvenience with a long reference list. How do other researchers manage this in LibreOffice?"
@@GMFahimMugdhoso my university forced us to use MS office, as I had to upload the docx file. For references, they had us use Mendley. You install the desktop version of Mendley (have to double-check the name, as they were going though some changes). And add a Mendley toolbar plug-in to the word processor program. You can import your PDF research source papers to the desktop app (automatically extracting the source info-author, title, date, etc…) or add each one manually, and you can sort them by folders and projects so all your research references are organized. Each time you want to add a reference in your word processor, you click add in the toolbar plugin and find your reference from the list. When you’re done, in the toolbar you click insert REFERENCES. You select the style of your references (E.g. MLA). If your reference style isn’t on the list, you can import it.
@@GMFahimMugdhoI wrote a long comment but UA-cam blocked it. In short, the answer to your question of how university taught us to do references for research papers and thesis, you install the desktop version of Mendeley and install the Mendedey toolbar plugin in the word processor to sync with the desktop app.
Select multiple paragraphs and then Tools>Sort... though you may need to select column # and column separators to make sure it does all of the sorting as entries get similar. 7.6.0 should have an option to sort entries by identifier before you bring it into the document if you are doing the more formal bibliography database as LibreOffice documentation teaches. You can get further control by expanding and using a database separately for bibiliography. Not sure if 3rd party Zotero does more useful stuff beyond that. LibreOffice can also maintain things to a degree that start as Tools>Footnotes/Endnotes to update thing a bit as they change within lines.
I have used Libre Office for years now, just love it.
Me too, and thank you for watching and jumping in.
@@AwesomeOpenSource would you pay for it?
Same here!
I love LibreOffice on smaller files.
I can't stress this enough:
- Free And Open Source software is made by people for the people.
- Paid software is made by companies for the profit.
I want to stress that paid software has accountability and support, usually it is way more robust since people want to make money out of it, they have to sell it to you and keep on selling it to you ;)
Open Source is a great, just not the unicorn you are looking for, because developers need to eat too :D
Thank you, and very true. @nofreenamesotreg, I can see your thoughts on this, but as I pointed out in the video, LibreOffice has a support model for revenue generation, so they are not accountable for support and ongoing development as well. We, as users have to choose to get that support package.
@@nofreenamestoreg In my experience, FOSS just works better. Probably because the project usually starts out of pure necessity and then eventually gets shared (and improved by) the world, while paid software is a product and usually works like this: "Hey, let's make the new version even flashier. Add 500 buttons and 120 AI buzzwords if needed, as long as this year's profit goals are met."
Devs are usually loaded so it's often made as a side-project because they're simply bored or out of pure altruism.
Ofc, nothing is black and white as there are marketing and engineering-driven companies; I was comparing FOSS and closed-source software (like Adobe or Windows).
You're only half right..
Yes, FOSS is made by people (and I love it), but it's usually not for people - it's for themselves and then shared with others. Nothing wrong with that but the result is that most of the FOSS software is designed (both functionally and UX-wise) by programmers and for programmers. I am programmer so I am happy, but it is what keeps FOSS mostly on the fringe.
Yes, paid software is made for profit.. But how do you make best profit? By offering what people want at their acceptable price. And to do that, they often have initial investments and much larger budgets, allowing for UX design team, Q&A team and so on. None of that is wrong IMHO - and it can be also done in FOSS way..
And it is being done! If you take a look at many of the large FOSS projects - GNOME, Linux (kernel), Firefox, Ubuntu, Red Hat stuff and so on, they all have big foundations or companies behind them and work exactly the same as for-profit SW companies do.. GNOME developers are making the software for profit (they get wages) and it's not only okay, it's good.
@rouchar As someone who's worked in I.T. since '99?....I can say I've used proprietary software...and you get more peace of m9nd woth open-source. It might jot LOOK as shiny and flashy as the paid-for stuff?....but it just WORKS!...And its less buggy...and while there are th8ngs some folks wanna do that open source can't do?....the "basics" are just fine...
We use a loot Libre Office on our company. It's just fantastic!!!!!
Absolutely!
Always faithful, free, fantastic, fine, futuristic.
100%
Big like !!!!
I’m an old user of LibreOffice and it’s awesome
It seriously rocks!
I've used LibreOffice for years and love it, I'm a writer and the PDF conversion is a fantastic tool for me when copy editing. Before that I used Open Office and before that I used Microsoft but the cost was prohibitive back then, now with this subscription model it's untouchable. A good alternative to Microsoft for first time users is Only Office, the desktop version. It's more like the way Office is now.
Great feedback! Love it.
👍🏼Nice demo video. Thank you! Will check it out.
My pleasure.
I was a bit traumatized when using this type of download so much that I had to buy Windows Office to avoid having a bad time again.
And where did you get it from because I am looking for a key although this LibreOffice looks very good and safe
BNH Software came to my aid and I repeat it is a trauma that I carry but this Libre Office looks like a good option
Fantastic presentation of the features and usage of the product. Thank you for doing this!!!
Thank you.
As I head a group of companies, I only allow FOSS and then LibreOffice. This has never failed me. Even clients have to comply if they want help.
That's awesome!
Actually I think LibreOffice is so underrated.
100%
I love Libre office but Calc does not run all the code that Excel has embedded into spreadsheets. In college they taught us to code in Visual Basic for Excel. The code was not compatible with Open Office, which I used at the time. Propietary software makes it hard for business to use Open Source. I only use Open Source in my business and at home. I don't want a license that can be rescinded and lose all access to my work. If MS decides to charge a fee to use their propietary software the world will have to pay up. MS would hold the whole world hostage. Everybody has stand together to prevent that ever happening!
Totally understand this kind of incompatibility. I think this, however, is the extremely low percentage of most "spreadsheet" use cases. People use spreadsheets for lists, simple calculations, scientific data and charts, and so much more that I think are much more common cases these dasy. Yes, if you're a finance guru who has 10000 macros and VB scripts in excel, then calc won't just work for you as is for sure. That doesn't make Calc worse, just not compatible for those use cases.
I thought you could script in OpenOffice with Python, Javascript, Bean, and their own LibreOffice Basic?
I'm sure you can. I'm definitely not an expert on it. I would be shocked if you couldn't script in several ways though.
A lot of people use spreadsheets to put together things that really should be done with database instead. I was guilty of this for years until I saw the light.
I don’t want to “stand together” I like buying quality software from Microsoft and other vendors, and I see software as something we should be willing to pay for
I won't use MS-Office unless mandated for a project.
When it comes down to brass tax, I tell people to use what they want to create a document and then in those cases you can always upload into NextCloud or Google Docs (cringe) or O364 (bigger cringe) for "collaboration" purposes.
I got through grad school using LibreOffice and nobody knew the difference because everything was submitted as PDF.
Love it!
brass tacks
I lost points on assignments due to formatting compatibility bugs of OpenOffice when I opened it in Word and hit print without review (those known bugs are gone). Had a friend I got into using it later and she had issues with not being able to do collaborative markings in files and see other's marks. Later it seemed to be working but there was a bug where Microsoft users couldn't remove her marks from their documents through Microsoft Office + its own formatted files. ^_^
Microsoft Access is the killer MS Office app for me. I have not seen any other software that comes close for standalone apps, one or few users, or for rapid prototyping, or for reporting using data from other databases
LibreBase can connect to all kinds of external data sources. Not saying it's the same as access, as it shouldn't be.
FYI: I found this video, because Microsoft has just deleted my Excel 2013 without permission, notification, leaving no trace in a trash can. I have deadlines, work to do, and suddenly I have no tool I paid for. I cannot even re-install it because it says I have some beta software on my disk? I cannot download because it wants me to buy again or upgrade to Office 365 or similar. This is unbelievable that a rich company could kick you in the butt like this!
Pretty cruddy of them for sure. I'm sorry you're having to deal with that at all, but also glad something open source is available for you.
I have been using libre office and wps office. If anyone is having a problem there are dozens of office suites in Linux!!
Indeed there are.
The dealbreaker for me is that Calc doens't support tables, which I thought were the bases of any spreadsheet.
I love the new excel functions and use them daily but I can live without them, but not without tables, where I work people fill tables with data then everything else gets calculated and displayed for them, I can't work without calling tables by their name in formulas.
It does, but not quite in the same way as Excel has it implemented. You can setup Calc to provide all the features, but it's done differently for sure. Data Ranges is one way, but not the exact same. As anyone who knows will point out, Data Ranges aren't yet dynamic. But there is also the feature to connect a database type object in Calc (similar in Excel) thought you continue working with the data in Calc, and this is more dynamic with all the same features and more.
I have to take another look at the database option, I have been thinking about that, there are a lot of info that repeats in many workbooks (employees, vehicles, scheduled teams) I'm using macros to update that info when the user opens the workbook and prompt the user to pick the new location of the main data (in case the path changed name).
If I can use Calc to update a database I would give it another go.
By the way @AwesomeOpenSource would you recommend the libre office database or a solution like mariaDB? I'm looking for something permanent, for the long term, but also simple enough to not require a database engeenir, just an office tools expert self taught.
Been using Libre for several years. For all these years I have been experiencing a bug - a document that has been open for many hours (without working, just opened in bg) hangs intentionally when im back to it. Only way its kill task and next start need to restore all open documents.
And it sometimes works strangely slow in terms of instant responsiveness (like typing text and letters appear as if with a slight delay).
All this alweys remind me, that this is a free product. But yes, for a free product it is good. Done same job as MS but no cost. For most user its good free alternative with minimal cons.
Make sure you report the bug to the LibreOffice team, and provide logs, and file size, how long it'sopen for, whether it's on Linux, Windows, MacOS, or all of them, and whether you document has images, what format they are saved in, etc. As much info as you can provide is help;ful to them.
@@AwesomeOpenSource now, it crashed twice in an hour. And the second time it did not restore the text maded in last hour.
This is the last straw, I'd rather use a normal product than this free but complete rubbish.
Excellent video. You struck a nerve at Microsoft with this video because I'm seeing many Microsoft shills in the comments....they're probably bots. Keep up the great work.
I appreciate it. My goal is to start conversation, not to make people angry. I have no issue with someone saying MS is better, as long as they can give concrete examples of why it's better. It's truly about what you need to do with the software. I believe LibreOffice can do anything MS can, it's more about how you do it, and whether you're willing to relearn some things.
Naw, bots could have responded to the "what is missing/better/etc." followup questions better than some commenters.
For me that wants to run basic spreadsheets and document work it has it all. For professionals I think not.
But why? I'm a professional, and I use LibreOffice for everything with no issues. It works differently, but it's not worse.
@@AwesomeOpenSource no powerquery.... would have to switch to database structure [pros/cons]
@@unitedstates3068 Only a small subset of professionals need powerquery. I've worked in offices, and as a programmer, since before MS Office even existed, and I have never come across anyone who needed powerquery. I'm sure in certain professions it more prevalent - but for the vast majority of MS Office users LibreOffice would be just fine.
Good information! You could have added saving in MS Office compatible file format for those who must deal with docs in both suites.
Good point!
While the translation from MS to Libre office got much better, the Impress /ppt one still needs work. Got problems with animstions, themes and similar.
One that i really enjoy is LibreMath. As someone in stem that application can save a lot of time.
In Writer still not sure how to insert images so they don't move.
For Calc never really used it, but from what I've seen it is just like Excel. It is missing some functions from Excel though.
Interesting, I've struggled with images forever in Word. I'll be honest, Pages on Mac has images, and any other "floating" context stuff implemented perfectly, and better than any other solution. Would love to see LibreOffice get to that level with inserted items.
@@AwesomeOpenSourceNo no, even in MS I struggle with them. Especially when you add some captions and you have to re-edit some text.
Although I love libre office and think it's fantastic, it is NOT better than or even on par with MS Office. At least not yet. So many issues with calc and impress. Also missing some useful features eg flash fill. Will continue supporting them and hope they catch up but not there yet
I appreciate your thoughts and input. I hope you're providing this feedback to the LibreOffice folks as well. As much as software teams know what they need, they are not all knowing, and can use guidance from their users and community.
If you use both and know of missing and different features or compatibility bugs and want to support them getting better, please report them as bugs if reports don't already exist. Some things may change quickly while others may take years or not get changed but reports are used by the developers to find things to change. Could be differences in the bugs I reporte but my reports seemed to get addressed much better back when Sun Microsystems ran things and has been significantly downgraded since it became LibreOffice.
I am a chartered Accountant, And I can confirm 99% of people in my community don't use libre office because we can not navigate through tabs with Alt shortcuts, This is the most important thing people want for speed working.
Thanks for the info! What about the data pivoting, charts, and automated formulae with Calc?
Not sure if you mean Tabs in the toolbar, or Sheets in the spreadsheet, but both can be navigated with hotkeys.
I can navigate using the keyboard, but instead of Alt, it is Control. Is that change a really big obstacle?
@@LibreOfficeHispano is this like blender mouse button all over again? if i remember correctly, smarter everday channel has a video on topic about this very thing. it's about the bicycle where the control is reversed.
Then remap the hotkeys until you can?
Great video! Glad you're liking the Nextcloud Office app too :)
I love it! And thank you to all of you for making the amazing open source software you do!
Haven't tried the nextcloud integration but messed with collabora on android a bit (I'm a newer cell phone user). It has been a mix of good and bad but I have only done very minor things like nearly unformatted documents and spreadsheets that I just used for a table layout. Some bugs I ran into under that basic use have vanished with updates so I have hopes it can be useful.
Ive been using Libre Office since 2008
You rock!
I like Writer more than Word because Writer makes it easy to
edit my styles,
apply my styles
have a style serve as a chapter marker
Add a page break
add a horizontal line
create, update, and format a table of contents
Put in a full-page image
Print in book format
Export to pdf
Export to epub
All of which is between mildly annoying to "like pulling teeth" in Word.
Agree. I love the styles in LibreOffice Writer.
Styles are a great part of Writer. I didn't even consider Word a contender when considering other basics like lists required a lot of editing to remove silly font variations per level by editing each level's rules individually while OpenOffice offered rules to have a level be a modification based on the previous level. Some of that went away in newer ODF formats but the simple numbering style is still available. Some of the worst parts of LibreOffice have been its attempt to change from its roots to be more Microsoft Office like. I don't mind if it can be set (/downgraded) to act like Microsoft, but don't make that the only option and be willing to expand on to being a better program than Microsoft offers instead of trying to be a clone. Imagine if we lost styles to "comply".
I was pleasantly surprised about powerpoint in libreoffice or impress
It's amazing. My daughter had to do several presentations for school last year, and she started on powerpoint, then continued in Impress at home, and finished in powerpoint, and never had to reformat, change transitions, or effects, and it all worked quite well.
I have Libre' Office installed on every PC I own, Linux, Widows, and even Mac. Now, I am retired and the last time I used the Presentation (Impress) part, although it worked the same way as MS's application, when making a presentation, if what you did in it was played back on MS's app, it did not look the same. (File was quite compatible, just what you saw was not the same as intended.) Of course that was few generations back software wise. So, I even now will say if you develop a presentation using Impress, display it in Impress for the best results. Other than that issue, I was and I believe still is a great piece of software. No one should be using MS's product in my opinion.
I can say for certain in the last few years it's gotten to where you go between Impress and PP without much issue at all.
If Libre Office Base was anywhere close to being in the same league as Access (it isn't, not even close), I would consider using Libre Office instead of Microsoft Office.
I guess it depends on the league you want to play in. I'd say Access is minor leagues, while Base plays with the big boys. You can have base talk to any number of alternative back ends, MySQL, MariaDB, PostGres, and more.
@@AwesomeOpenSource Access is supposed to have the ability to talk to others through back ends but I think you have to find+install them separately. Other than data corruption and proprietary formats, I don't know what Access has that the opensource big boys don't.
Base is nowhere close to Access.
@@mirror1766 Access supports most - MS SQL Server, Oracle, Postgre SQL, DB2 - without needing to install anything....
Problem with Calc if you're coming from Excel is that it's lagging in the newer functions so you can't open your sheets properly if you make use of the new functions like I do.
If you're doing extremely complex functions and calculations, there likely will be things you need to address. Again, MS is the company using non standard things in their software, not the open source options.
@@AwesomeOpenSource To be clear, I'm a rabid, zealous detractor of Excel and it's bloated, anachronistic MO. I use it grudgingly, and only when I have to (i.e. at work).
For nearly everything else I use Google sheets (not without its flaws, either, to be sure).
That aside, I'm unaware of any officiating body that regulates standard spreadsheet cell functions.
I'd argue that any function implemented identically by both Excel and Google Sheets could be considered a sort of de-facto standard.
Totally undeerstand, but the open document format is the open standard for document interoperability. This is what any of them should follow.
I'm enjoying your videos and appreciate what you're doing.
The following is intended as feedback only:
I assume the ad duration and locations in the timeline are set by you, and they seem to be a little excessive. Several 55-second ad breaks for a 24-minute video are nearly more than I'll "pay". Most technical videos that I watch have about three 20-second ads for a 20-minute video.
Ad duration is not something I seem to have any control over. Placement to some extent, yes..I only put 3 per episode if it's over 20 minutes generally. If less, I do 2. I also don't control if UA-cam adds more though.
HI, i used to do some volunteer work on PC's, mainly on ex lease and donated machines, typically OEM we would image with the Dell / HP OEM cd.
Once Win XP / 7 / 10 was reinstalled we would grab Libre Office, VLC media player, Firefox , Dosbox and some shareware dos games all runable of a cdrom image and install them as a fairly usable budget home PC
Some of the older machines, say Pentium 4 / C / M , Core2's we would install Linux Puppy, then the free apps
Anyway Libre Office worked fine, the issues around 2005-2015 was minimum and mainly fonts not translating properly, but the few people that complained was very low and the advice was search the net and get the microsoft basic font pack that is available and install them - the problem was not serious they would edit some documents from work created in MS Office and when it saved the font and tab and margin was not 100% the same - oh some advance excel features did not come over, i believe possibly pivot tables was one issue
Regards
George
That's AWESOME! Thanks for sharing!
I would like to see more new and current information from the open source area.
Make sure you subscribe if you haven't already.
Let me fix the statement, it's 95% of all documents before LO 24.8 and 99.9999% after, I have lot's of documents with array formulas that will finally be added with 24.8 afeter 5 years of waiting
That's great!
LO provides most of the MO functionalities, as far as programming (VB) is not necessary.
LO VB language is so cumbersome that there is a great difficulty to translate simple MO-VB operations in LO-VB ones.
its the features that are important...
It has tons of features. The thing that stops most people is that the features aren't where they are used to them being in some other software suite, and they have a hard time retraining themselves on where to go, or how to access the features they use regularly.
Ya know working for Dell for the many years I did. MS Office was something I trained on and as a MSDN partner paid by Dell I had all the MS programs I wanted. Life after Dell was do I really need Office? No After I could no longer install it on my computers I switched to Open office just to write a simple office or a spread sheet. After no body was not paying me to use a computer. I am going for free if possible.
Love it!
I've read some complaints, that LO is not even close to Office, and LO is for those who don't want to pay MS. Well, I don't pay for MS, the company where I work does that, and I can install O365 on up to 5 devices. Gues what, at home and for my personal use I only use LO..
At work I might say it's impossible to switch to LO, we have so many additional components developed for Word and Excel that I cannot even remember all of them. We also do an intensive use of MS Access. Well, at home, I don't need that, so LO does the job for me.
Also, in our company the last person who told me LO is BS, had no idea on how to use Styles in Word. That made me laugh :)
I think people confuse "more built for MS" with "is not as good as MS". You said it quite well. It's that you already have investment in building things to work with Microsoft through their closed source methods. It's not that it couldn't be done again for LibreOffice, it would simply be a lot of work.
Sun Microsystems used to develop tools and services to help with migrating things from Microsoft Office to StarOffice/OpenOffice. Oracle put an end to sane access to anythign that wasn't already opensource as they took over.
Dad had a copy of Office from work; don't know if it was okay or not in terms of licensing. Uncle paid for Microsoft Office in his shop. On their last upgrade they thought it was a multiuser license they purchased for their machines and began installing it on their 6 or so computers. By the time they hit the last one the installer removed the old copy before rejecting the new install due to the issue of many installs on one license key. They called the # on the popup about the illegitimate install where it was explained it wasn't a valid license for all those installs. He wanted to purchase not only the license for that machine but for all machines that were not legitimately licensed but Microsoft apparently cannot sell licenses when you call their # about illegitimate license issues...facepalm for Microsoft and I put OpenOffice or LibreOffice on as a workaround but they opted to stop buying Microsoft Office for machines when they saw it was doing what they needed (maybe still bought 1 or 2 for compatibility reasons).
I was a corporate accountant for nearly 40 years. I went from spreadsheeting on a mainframe system to DOS based spreadsheets - Lotus 1-2-3, Quattro Pro, Excel - to Excel on Windows. I've never had use for macros in spreadsheeting and I've built and used some pretty seriously complex spreadsheets. Ok, I did create a button with a little macro behind it for importing data when I had to give a spreadsheet to a complete moron to use. He still managed to f*** it up. What can I say: make a thing idiot proof and they'll just build a better idiot. But apart from that macros in spreadsheets were completely pointless. People whining that LibreOffice etc. aren't compatible with their macros tells me that they aren't using spreadsheets and the other tools available to them correctly.
@@dingokidneys thank you so much for Sharon this. I love to hear about people who specialize and have the experience to make amazing statements like this.
To go out of your way to use Office is ridiculous, if it's put in front of you, then it's far more understandable. Libre-Office is great! I hope I can convince my office to convert to it one day.
Well said
Never mind Libre... When and where can we get a copy of your book? Btw the dedication was beautiful!
Thanks, and I hope in the next month or so I'll be ready to put it out to the world. No idea where or how just yet, but I'm working on it in my 3 minutes of spare time a week. ;-)
Such a beautiful dedication to your loved ones - I hope this truly inspires your daughter and many others. I'm in complete agreement with you. People can achieve great things if they do just two: always believe in themselves, and start.
@@AwesomeOpenSource I hope you'll forgive me as I don't mean to nit pick but I've spotted a couple of typos in the snippets caught during the video and the proof-reader would be remiss if I didn't at least mention them. In the second paragraph, third line of Chapter 1 you write "… more an more lazy", I'm guessing you meant "and". The second one I spotted is in the last paragraph in the same chapter just before the section break where Dave's mind wanders into the past where you right "morre" instead of "more".
Would love to buy your finished book as an eBook or as a printed work; seven years to find the ending you're happy with is quite a long time - but then some people always /say/ they'll write their book but never do, whilst others just get on and _do_ the work required.
Wishing you many successes with Entanglement and its sequels, should they already be under consideration.
- Mark
Thank you so much. Yes, I'm just starting my editing now. I"m sure I have dozens of typos, and imagine my use of commas, semicolons, and more is atrocious. But, I'm working steadily through it as I can.
@@AwesomeOpenSource LOL you find 3 minutes extra? You're the man!
Every time I've tried Libre Office, somehow the first thing I needed to do was vertically center align a title page. In Word, this is three clicks. In Writer, it was a massive time waste sunk into eventually finding out "vertical alignment isn't a thing that people do, so we don't."
When you say vertically align, I'm not sure what that means...you mean center the title in the center vertically?
@@AwesomeOpenSource yes. Horizontal is easy, but I also needed to center between the top and bottom of the page. All the solutions I found involved manually placing a text frame or something. I know enough about layout settings that I would need a gun to my head to put a bunch of empty lines (tap Enter a bunch.)
Insert>frame>frame and setting that frame to be vertically centered is probably still the way to have it actually centered + stay that way if changing font sizes or adding lines. Other objects can be inserted and similarly aligned too. I usually just get away with format>paragraph>spacing>above paragraph to nudge it acceptably close and adjusting page margins for a page style only applied to that page would work too.
Once I find I need to do more advanced/specific page layout in a controlled fashion, I usually leave Writer/Word/etc. behind for software like scribus or lyx/tex/latex. Others seem to use quarto for some document publishing and asciidoc, troff/groff, etc. as an alternative to tex/latex. Once things are described as a markdown language, I usually find the battle annoying to learn which of the many markdown languages is the one in use just to find it uses its own variation of one of them; a # of websites do that which butchers attempts to type comments with standard paragraph separations.
I like google drive documents, because of the convenience of co-editing. I used it a lot on college for team works.
Also available through NextCloud with Collabora and an add-on.
What is LibreOffice's answer to Power Query?
I don't imagine they have one built in, but there are dozens of open source tools that can query multiple datasets and let you do things with the data for some amazing analytics. Also, I would imagine its far less than the 99.9% of regular users who really need something like Power Query.
Probably Base+database's power, 3rd party plugins, and/or writing macros?
I don't know if this function exist in ms word but I use search and replace by regex and also by text format in Writer. It is crazy awesome feature.
Yep, used that myself on more than one occasion.
Yep, MS Word has this function, too, but the syntax is a bit different.
Desktop intalled grammarly doesn't work with LibreOffice for some reason. If it did then Libreoffice would certainly be a more well used tool for writers. Language Tool's extension goes some way to filling that gap.
Onlyoffice is getting much better. Free Office is a very competent alternative too.
Interesting. Thought I saw something on integrating grammarly the other day, but may be misremembering.
I prefer OnlyOffice, but Libre is an excellent choice as well.
I need to take another look at OnlyOffice. It's been a while.
@@AwesomeOpenSource The primary reason for us is that we have a lot of clients that are in the legal and financial sectors who do heavy formatting in Microsoft Office. We found that Libre had issues in too many cases with them. Most people will not run into the issues, but for our business we had to change. We tried Softmaker and OnlyOffice. Both worked better for the heavier edited docs. Ended up with OnlyOffice as our team liked the layout better.
No tables and graphics slow af (calc) Graphics can be somewhat remedied with the proper settings.
What kind of graphics?
You should open a bug report so that they can remove Tables from the menubar and its choices like "Insert table (ctrl+F12)".. If they agree to and you decide you need table-like capabilities, you can insert a calc spreadsheet into a writer dog.
@@AwesomeOpenSource Graphs
@@mirror1766 Read my post again slowly, Tables in Calc... haven't found a good way of doing them like in Excel.
Hi! First of all, thanks a lot for the video, it was very informative. Is it possible for you to teach us how to integrate Libre Office with Nextcloud for online editing? Thanks for reading.
Let me see what I can do. I run the AIO of nextcloud, so just added collabora to it, and I can edit online, but if you want collaborative editing, I think that takes a little more setup.
The only reason I have not fully switched to Libre office is because it is very difficult to set up print areas and page set up.
Keep working on it. I believe in you.
For writer, page properties are under format>page style>page. If you use styles, you can adjust the properties per style. If stuff doesn't reach the printer consistently with those results, also double check that you don't have setting and defaults outside the program altering things. Otherwise any other issues you had adjusting those?
Oh, hands down, i work in an enterprise system i have to use 365, i have no choice but i love using and do use Libre Office is far better than MS 365.
Thank you my friend!
Theres an annoying bug in libre office where if you put more than a few different format images in a writer doc it becomes unbearably slow
All I can say is make sure it's been reported, and add your own comment to the issue. The more comments an issue gets, the more it becomes a priority to address in future releases.
Once a bug report exists, make sure they have a sample file that expresses the problem (and a similar one that doesn't if it has a clear transition from working to broken). Any details you can add could help too like "gets slower after 7 images" or "slows down if adding multiple image formats",
I would love to ditch MS, but I'm an author of childrens books, and use Publisher to produce them. I need pictures and detailed writing to accompany the pictures. If LO can do this I'm all for it. I was excited to see Writer LO, but I don't think it does what Publisher can.
I believe that LibreOffice does indeed import .pub files into its LibreOffice Draw. But as with any import scheme, be prepared to do a little formatting fixing. Give it a try to see. Although, you could elect to write your childrens books in LibreOffice Writer.
Indeed Publisher files can be imported into Draw, but I'd suggest you check out Scribus. I think for your needs it might better suit your more advanced use cases. It's also free and open source.
@@AwesomeOpenSource Awesome, Awesome! Thanx, for the tip, I'll have to check this out! I really don't care for MS and their a-nine service. Hope it works!
great presentation, the office suite is very important when seriously considering desktop transition. May I ask what OS distribution you are using (along with what desktop environment)?
Sure thing. I'm using Kubuntu 24.04 on that video. KDE Plasma 6
@@AwesomeOpenSource thank you kindly, I'll make sure to have a VM test to see how it handles my needs
MS products now provide (absolutely incredible and _vital_) value by enabling collaboration on documents while also denying access to export controlled employees within an organization. Businesses today can deal with substandard/basic formatting options ... but collaboration and permissions is now vital. In the future, enabling automation from docs (or linking such docs to code) is going to be super-vital.
Automation and code in docs has been around for decades, and it's an almost unused feature by 99.999% of people, and the ones who do use it are generally trying to run a macro on your system to give you malware, or steal your data. The tool isn't the bad part, it's the way it's used. It's like a hammer, it can be used to construct incredible things, or very easily to destroy something.
Do you know how to create a numbered list in Libre. Beginning with the top cell containing $10.00 and descending in one cent increments down to $1.00. How do you create this list without entering every amount?
I'm not a calc expert but I'd put 10 in top cell (let's call it A2), and in second cell put "=A2-0.01", then copy that cell, and paste it as far down as you want to go. You may can click and drag down to copy as well, but haven't tried it.
I am blind and tried libra once and it didn’t really work with NVDA, if the document had headings a menu would come up at every heading and I would have to escape out of it every time I go to a heading
Odd. Definitely report that to the project. These are the kinds of feedback items that will help them improve over time.
@AwesomeOpenSource i tried it again and everything works how it should, i love it
LibreOffice 🔥🔥🔥
Wooo!
In Spanish Libre and Gratis are different, both translate into “free”.
100% my point. English speakers get the Free in Free and Open Source Software confused to mean Gratis...it's meant to be Libre.
FYI, LibreOffice is used by over 200million (yes, that is million) users and downloaded many times over.
And it should be even more.
As they don't have a rule that it has to be downloaded from them or their official mirrors, the total downloads will be higher. Important to also consider if its downloads for a single version. Some users don't regularly update it, some downloaded installers may not be ran while others are ran multiple times on multiple machines, and some installs may not even get used.
Yeah, but after we install it, we play with it for a few mins and are repetitively disappointed with it so it goes unused on our computers. We're doing real work with Microsoft Office - the one we actually use. Even at home because it does the job. I've installed Libre many times over the last 10 or so years and every time I hope it gets better. But no, might be a little better looking that it was over the years, but still disappointing. I use MS and LO just sits there unused. Eventually I uninstall it and try again in a year or so.
@@brianwheat1 Yeah, I tried to use Libre Office when I was a uni student, but I quickly discarded that idea and pay for Microsoft Office instead. My biggest issue was it's compatibility with MO. Everywhere I go, people use MO. If I try to open a file from LO to MO or vice versa, something's gonna be different, or even broken. That would lead to a massive headache during group projects.
Ngl, MO is easier to use. And if I'm stuck on something, a simple google search would lead to an answer. Meanwhile with LO, I have to really dig into it. Sometimes people with the same "dumb" question I have in forums got pretentious answers that sound like: "It's not what it's designed for. Why are you even asking this?"
We use this way back in college. I thought Libre Office was created in our country, the word "Libre" in english means FREE 😅
Indeed! And the English "Free" is one of those special words that has numerous meanings, so it causes so much confusion.
I talked to my college IT department to ask for StarOffice access back in the day; their version cost money but they had 5 licenses all unused so they gave me access to 1. I also explained it was free on newer versions and they ended up upgrading and enabling it for all students; start menu bloat ensued against all those students wishes and understanding. ^_^
LibreOffice is cool and awesome, you have to take your time to learn it like you are new and there's no alternative . You will not feel it well if you compare it with MS Office.
Thanks for the tips!
I love this channel and the value it brings, but let's be real here, LibreOffice is NOT better than MS Suite, as unfortunate as that sound may be.
VERY true
I need more concrete examples personally, but we are each welcome to our own thoughts for sure.
Calc and Writer are ok, but Base can't handle many images before it crashes in my experience.
Not sure you should really store images in a database. You should really store them in a file system, then reference them in the db, but I understand.
@@AwesomeOpenSource got used to that in Paradox 7. Brilliant db by Borland. Maybe they did what you suggest, in BLOB fields.
Good stuff! On your book ... *_one space_* after a period/sentence. And congrats on wrapping that up!
I'm old, so was always raised with two spaces after period. Does the one space not make it feel all squished to you? Easy enough to change in bulk with the amazing editing power of LibreOffice and open source though.
@@AwesomeOpenSource I'm old too, and it's a hard habit to break! When we learned, it was on a typewriter, and two spaces there is correct. However, "modern" software like Word and all publishing software (Affinity Publisher FTW) automatically adjusts the spacing. Because of that, adding more than one space creates distracting "rivers" of white space in columns of text. All decent publishers will methodically strip out the extra spaces prior to publication. Happy writing and publishing!
Already stripped them this morning! Thanks for the info
@@AwesomeOpenSource tools>autocorrect>autocorrect options...>options>ignore double spaces if you are changing to not using them anymore. What you do is an option and sometimes some fonts and characters need a little tweaking to look good for either style. I was taught 2 spaces by some teachers and 1 space by people who studied and did professional publishing. It also seems related to monospaced fonts vs the rest and how well kerning and such is working. I wouldn't trust the average modern word processor to be adjusting it in any relevant way; if you need that you should use things like tex/latex but even then you may need to force what is done sometimes to be consistent about it.
I tried that PDF editing in Draw. I guess I need to find a guide to teach me how.
Definitely takes a bit of work at first.
Editing in there can be more painful than expected but for a basic edit it may get by. but last I tried it I found that a basic paragraph has each line split into separate text objects so line wrap between them is now manually moving data and it was common that documents more advanced than text may lose parts of the document. You may find other programs like Scribus(?) or Inkscape may help with some PDF files differently.
I have been using Libreoffice a long time. I translate sensitive documents docx files to be exact. I love the UI and the many features of Libreoffice but the performance is terrible on large docx files. 100-300+ page files with some low-res pngs and text. It can take 30 40 sometimes 60 minutes to load a file. And editing is painfully slow with notifications that LibreOffice isn’t responding Wait or Shutdown constantly after all editing. A painfully slow processing large docx files. Now to all the disbelievers i tried this on three different laptops with three different levels of RAM and three different OS one of which is MacOS. In all three laptops the same results slow load times for large files and extremely slow editing. Even breaking a 300+ page file into bite sizes files is get same result. So i have to do word processing translations in Onlyoffice which loads in 5-10 seconds and edit in seconds without my favorite Libreoffice features. Statistically speaking with same terrible performance on three different computers tells me that there is a bug. And i read in computer blogs that others have experienced the same
I have even experienced the same issues whether it was a .deb snap flatpak and dmg. Horrible performance on large files on three separate computers. I am truly sad to report this. But for now i have to use OnlyOffice to get get work done
Is this a file with a lot of images or something? My book is more than 250 pages, and I've moved it from docx to LibreOffice multiple times, and had no issues with it at all.
@@AwesomeOpenSource Why would I have the same exact issues on three different computers (2 with Linux and 1 with MacOS) ? Why do the same exact files of mine open and edit on OnlyOffice in seconds? Why can I open and edit in FreeOffice in seconds? But not LibreOffice on three computers?
@@AwesomeOpenSource Low-res pngs. 300 page with predominant text. I process documents daily.
You forgot LibreOffice Draw! The Visio equivalent
I did, didn't mean to, but I don't use Draw for more than editing PDFs honestly. I know it can likely do tons more stuff though.
it's like a version of office sure, but can it do Macros, Formulas, Reports like office does without bugs?? i don't think so. Does it have a giant community where you can get your problem solved by searching for literally 3 minutes and not getting headaches?? again i don't think so.
To say "without bugs" is such an odd turn of phrase when talking about Office. As I say in my video I use Office all the time for my day job, and it's 1000% buggy for everything. I'd say LibreOffice is much more stable, and yes, it has macros, formulas, reports, charts, even mail-merge and so much more.
I had a 365 subscription but the redo button didnt even work in any of the apps. Completely unusable. And I found no solution after weeks of searching. Finally decided to ditch it. Have used LibreOffice ever since.
Microsoft Office is not bug free, let alone bug free in their Macros so I don't know what you want there and you don't have VBA but do have its own version of Basic while also having javascript, python, etc. as additional programming languages. In Writer you can use insert>ole object>formula object to bring in a formula and file>new>formula to just work on a formula as a file. In additon to its help which can be installed or accessed ton the web, LibreOffice has its own help/forums but many things were answered many years ago on the OpenOffice forums. Many 3rd party sources for how to do things exist too. Few things I looked up took me long to find unless I didn't know how to ask the question and then even google, microsoft office, etc. fail to be of any additional use.
If you want the feeling of "few bugs", you can always set a timer for a short time in the future and when the time is reached you can force close on the office suite without saving or run a memory editor on it and edit a bit of the memory randomly. When you want to step up your game, install Linux and give psdoom.sourceforge.net/ a try but that is way beyond an office suite at that point.
I'm almost 4 minutes in the video and I'm still waiting to know why libre is better than microft office.
It's open source, it abides the open document format standards, it is cross platform, and it's supported by 1000s of developers.
Mate, it's free, opensource and it works...what else you need?
@@zedtrek I used open office and libre office years ago. I wanted to know how it improved, but this video is too long and not straight to the point. I use google docs for the moment being and am satisfied with it.
Libre office will be best only for home usage and not document sharing and calc cant compete with excel
All the MS fans keep making these overly generalized statements with no actual examples. I'm happy to hear any real examples for the average business owner on this. Tell me what Calc or Writer, or Draw can't do.
Document sharing used to work with generally only minor issues 20 years ago. The issues I ran into and saw from others were all resolved many years ago. Are there current sharing issues you have seen recently? Last I checked it was still best to share documents as .doc or maybe .docx if you needed its newer capabilities; sharing as a .odt is a bad plan because Microsoft has many longstanding issues with that format in general and not jsut with LibreOffice copies of it.
I just use libre on the Nextcloud AIO docker
It's awesome, isn't it?
I'm using onlyoffice for the least formating errors from microsoft documents
That's awesome! I used to see those differences (10 or more years ago), but really don't see that anymore either.
What about an Outlook replacement?
Thunderbird, Evolution, KMail, NextCloud Mail, Geary, and dozens more in the open source space. I'm partial to Thunderbird, the built in calendar is really nice.
Better? not even close. Good enough for people that don't want to pay Microsoft? Yes.
How is it 'not even close' ?
at least ONE honest and thinking guy!!!
I'd love to hear your thoughts on what make it not close? Again, I'm not talking about that .0001% of the population who use some kind of special tooling in Office, but the average user.
Excel has better graphing.
Other than that I've had no problems with the spreadsheet in LibreOffice.
Ive recently ditched libre for only office.
Runs way better IMO
Sadly i have to have excel to open 1 file from 1 vendor i work with once a month. Its so annoying.
As long as you can use Open ?Source for most of it, you're winning IMO.
I don't think only office can beat Libreoffice.
I use Open Office. I've never heard of this one.
I'm surprised by that. I think OpenOffice was going to end production at some point. LibreOffice was a fork of LibreOffice 12 or 15 years ago.
LibreOffice forked back when Oracle bought Sun Microsystems and started closing up open projects, slalling development, etc. Can't remember but I think it was befor it became Apache OpenOffice taht LibreOffice formed and by a chunk of the original staff. Development has been much faster and changes seemed to flow from OpenOffice to LibreOffice but not really back the other way much. I have disagreed with some of LibreOffice's changes and path they choose to head; both are options still in case of running into bugs or undesired features but I generally point everyone to Libre until there is a need to not be using it..
I have no problem with opensource office suites but they dont include an outlook like Email program
Nope, but Thunderbird works great, or you could do NextCloud mail, and use Collabora along with this, for a more full suite.
Nice
Thanks.
Sadly no its not...once you get serious with pivot tables it fails ... Excel still wins... But I'm hoping they catch up one day... But I been hoping for 10 years...lol
If anything, Excel is pulling further ahead. Power Query is a game changer. And they are also gonna integrate python programs into Excel. It's not even close.
@@stephencooper3583 yea, I could not agree more.. But maybe with ai, it will make open source projects advance faster being that everyone can write code with it.
@@stephencooper3583 If they are just now integrating Python+Excel then its catching up instead of pulling ahead. Maybe people want power query badly enough it will be in LibreOffice or maybe they will shrug their shoulders and use the already existing database interfaces+sql.
I have the Libre Office Writer
Do you use it? It's pretty great.
Libre Office is an amazing stuff, but with this "so much better than Microsoft Office" oh boy, you really got carried away. Unless of course you have no idea what Excel and Word can really do
I use Excel and Word every single day for my full time job. I as an employee of companies who use Microsoft, can tell you that 99.9% of the people who use those applications could 100% use LibreOffice for their work.
They both have things the other cannot do. Neither counts as overall superior and there are things they both do but one or the other is really awkward to do it, find how to do it, or may not even be able to do it.
Pivot tables in Excel work better still.
Better because they? do what?
No email client. Word headers & footers don't work as well in LibreOffice.
But LibreOffice has Headers and Footers. Don't need a mail client, literally dozens of them out there. Why do you need one in your office suite?
If you downgrade to the older StarOffice, it had an email client and even a complete replacement for Windows taskbar+desktop. I recall a bug where you could delete an email on an unrefreshed IMAP mailbox that had been altered and it could delete the wrong message. Unfortunately those were lost when StarOffice became opensource so it probably had code owned by others that couldn't be released but may have been left out as an undesired maintenance burden.
Libreoffice 👍👍👍👍
Indeed!
What about OnlyOffice?
OnlyOffice is also an amazing product, but I'm definitely more familiar with LibreOffice.
how long has it taken you to figure this out?
Too long my friend.
I tried to implement libre at my company, almost worked, but without a OneDrive equivalent for shared documents that are edited at the same time by multiple users, I couldn't make it work. Trying to move away from Live spreadsheets was a no go. Such a shame, I liked the software.
Well, you can use NextCloud, and get all the sharing and permissions around a shared system, plus a lot of nice features on top of that. Also, it' get a syncing plugin for live synced editing.
Not sure about multiple people working on one document at the same time instead of separate times but that sounds like a disaster to implement in a standard office setting with having to have software present merge conflicts to its user base and expecting them to do the task of resolving such conflicts. Locking files works to have only one user on it at a time and some documents can be logically broken up across several files which can then be edited simultaneously and brought together with a main document.
Maybe I am overthinking it and git with flat XML ODF document (.fodt and friends) files or rearchiving .odt with zip comression disabled is acceptable in general offices. It would certainly do the job but I don't know that it serves any good purpose for an 'office user' workflow either.
In addition to nextcloud, I think LibreOffice probably still has capabilities to use things like ftp in save/open dialogs for reading/writing to network storage but haven't tried that for many many years. Other cloud storage should work as long as it presents its storage to the OS as a drive letter.
I used all the other alternatives and still went back to using MS Office. Even when using add ons to make it look like MS Office, LibreOffice still looked horrible.
The aesthetic is just a really odd reason to me to not want to use something. I get it if you say it literally cannot do these things that I need it to do, but to just say it doesn't look like what I'm used to...I don't understand it.
MS Office appearance and organization is the easy selling point for me to get people to use LibreOffice over MS Office.
I programmed in msoffice years ago and already then, msoffice had object riented VBA and an object model that made things SO much easier. Frankly, I tried to use the same in LibreOffice (which I use daily) and it SUCKS!
I started Msoffice in 1993, so I am no amateur at software deve and certainly not in office automation using VBA, but LibreOffice scripting SUCKS!
Perhaps a different scripting language then? LO supports about 5 or 6 I believe.
Same here...DOM was great and so was VBA. Funny to see people saying "Who needs macros?" 🤭
Pa MS office je skroz besplatno ,ko još koristi platnu verziju kada ima "izlečenu" ,a Libre bi morao da plati ......
Ne znam gdje dobijate potpuno besplatnu verziju MS Officea, ali ovdje u SAD-u nije besplatna osim ako niste ukrali neku vrstu ključa.
@@AwesomeOpenSource зашто би крао кад људи сами дају ....... "диаков(тачка)нет "на пример ,15 година без проблема
if you have a project where you need to use standart of formating- then you need a microsoft office 2010-2019.Libre office, wps and others is for kids.
What does MS Office have to do with a standard of formatting? You can set any formatting you want with Styles in either product.
@@AwesomeOpenSource in spite of promises of Microsoft Office compatibility the products compatibility is far from perfect
If you need consistent formatting then you should be using pdf or tex/latex. You should never mix different versions of Microsoft Office if you need to guarantee consistent formatting; even then it does have bugs that can cause formatting to change when you close and reopen it within the same version. Interacting between any different programs will generally be worse than then issues you run into between program versions.
I love your content, but you going to have to miss me with this one.
@@glendonh3711 missing you already my friend. Always open to good conversation on any topic.
I have a problem sending an email from Write.
I've never tried it, and not knowing what your issue is, have you setup your email on your system, and does Writer know what email client you're using?
Tools>Options...>Internet>Email>Email program may need to be set. I don't know if Tools>Options...>LibreOffice>User Data>email being set matters in any way for this as I don't use email features from LibreOffice but it is good filling out those pages so details can autopopulate properly in documents and only need to be edited once to impact all documents in the future when things change (you move, get a new phone number/email, share a document with a colleague who needs their own details entered, etc.).
One downside to libreoffice is that it doesn't have search function
Incorrect. Not sure what you're talking about specifically, but there are definitely several different search functions.
General speaking, Save money, but not equal to earn money with commercial world
I disagree 100%. You can make money with Open Source, and contribute back to open source in the same way.
@@AwesomeOpenSource me too. Productiviy is less to communicate the commercial world
I use both, but LibraOffice is too buggy.
Not seen any issues in LibreOffice in years. See issues in MS Office all the time, even today.
@@AwesomeOpenSourceevery time I try in hope LibreOffice has improved, I’m normally back to MS within a day.
Tried using it a few months back and the worse part was when it would crash, it would corrupt not only the file I was working on but all those that were open in any of its apps. Worst part was when I tried to open that file, it would tell me it needed to be repaired and doing so, "Poof!"...the file would just disappear, gone, deleted!
And these were not huge files...nothing more than 10 pages...😡
Honestly LibreOffice is much better and lighter on the device.
Agree totally.
Hasn't ever been lighter or faster in my testing, but it also brought some of its own code around whereas Microsoft got to use Microsoft code that already loaded with Windows and they handled multiplatform code differently. There has been some good code cleanup in OpenOffice and LibreOffice but it still seems slower to load and bigger once up. Some of that is probably how each program in the suite interacts with the others.
There is no way to sort order paragraph in libre office word. This is very unfortunate
I tried to look up why you would sort order paragraphs...not really sure why you'd do that, didn't find anything in my search. Curious what this means.
I'm having trouble with LibreOffice when writing my thesis. I need to organize my reference list alphabetically, but I can't find a way to sort it. Microsoft Word has this feature, but it's a big inconvenience with a long reference list. How do other researchers manage this in LibreOffice?"
@@GMFahimMugdhoso my university forced us to use MS office, as I had to upload the docx file. For references, they had us use Mendley. You install the desktop version of Mendley (have to double-check the name, as they were going though some changes). And add a Mendley toolbar plug-in to the word processor program. You can import your PDF research source papers to the desktop app (automatically extracting the source info-author, title, date, etc…) or add each one manually, and you can sort them by folders and projects so all your research references are organized.
Each time you want to add a reference in your word processor, you click add in the toolbar plugin and find your reference from the list. When you’re done, in the toolbar you click insert REFERENCES. You select the style of your references (E.g. MLA). If your reference style isn’t on the list, you can import it.
@@GMFahimMugdhoI wrote a long comment but UA-cam blocked it. In short, the answer to your question of how university taught us to do references for research papers and thesis, you install the desktop version of Mendeley and install the Mendedey toolbar plugin in the word processor to sync with the desktop app.
Select multiple paragraphs and then Tools>Sort... though you may need to select column # and column separators to make sure it does all of the sorting as entries get similar. 7.6.0 should have an option to sort entries by identifier before you bring it into the document if you are doing the more formal bibliography database as LibreOffice documentation teaches. You can get further control by expanding and using a database separately for bibiliography. Not sure if 3rd party Zotero does more useful stuff beyond that.
LibreOffice can also maintain things to a degree that start as Tools>Footnotes/Endnotes to update thing a bit as they change within lines.