Ask HN: Has anyone successfully used LibreOffice for their business?

I have. Been using OpenOffice.org &#x2F; LibreOffice since 2005, started business in 2007, never ever had a copy of MS office.<p>I <i>LAUGH</i> at silly FUD like &quot;you can&#x27;t run a business without MSOffice&quot;, &quot;You can&#x27;t read documents &quot;, &quot;format compatibility problems!!&quot;, because that all is just FUD.<p>If I ever (rarely, maybe 4 times total) receive a price file or spec that is unreadable by LibreOffice, I just ask to resend it to me in some open format cause I lack the software to open their proprietary file. And I did received it in a PDF or .odt every single time I asked.<p>That said, I liked the software more in their OOo days. When it became LibreOffice it became somehow more buggy and ugly. OOo with the right icon pack was very neat and had a superior interface to MSOffice. LibreOffice icons got uglified and are no longer pleasant to look at, and combined all looks... Worse.<p>Their online efforts are also <i>disastrously bad</i>. LibreOffice Online is based on a flawed idea to run LO on a server and deliver rendered images to a user. It works super shitty bad. They should have just made a web-first editor for OpenDocument file format, with concurrent editing. (Maybe when I&#x27;m finally done with the XMPP I&#x27;ll look for funding to make just this. ... )

Since you are a start-up and thus likely seeking an exit at some point, I wouldn&#x27;t recommend it. Spending 10 USD per user&#x2F;month on Microsoft 365 is a small investment but it gives most users instant familiarity with the tools and provides you with tools for collaboration (drafting contracts for instance). I don&#x27;t think you can save money if you look at training effort alone. In the worst case you will be seen as hard to integrate (and hence buy) as a company because of a weird office stack.

Well, this is probably smaller than the companies you&#x27;re thinking of, but my wife&#x27;s retail store (two owners, just her and her business partner, 0 employees) use LibreOffice. They aren&#x27;t trying to do any fancy graphing. For basic word processing and spreadsheet calculations, it works fine. It can produce some graphs, but I think in this area it is not as good as Excel (although I haven&#x27;t used Excel in a while). Not too much of a training load, if they&#x27;ve used other office suites.<p>I don&#x27;t really think there&#x27;s anything I know of (that a normal small company would use especially) in which LibreOffice will not be as good or better than Google Suite, so if that&#x27;s what your current office suite is then the transition should not be too painful. Googling for the answer works for most questions.

We&#x27;re a ~40 person wholesale distribution company and I moved our company to LibreOffice. We also use Google Suite.<p>The issues I face with my company are usually accountants&#x2F;bookkeepers are used to using Excel. LibreOffice usually can handle anything they are wanting to do. It just means a little extra time googling&#x2F;playing around with it to work the same way. I try to keep everything on Google Sheets however.<p>That said, if we were scaling post Series A (we are not), I&#x27;d look to see whether there are teams that need advanced modeling or feel comfortable with Excel. Everyone whose job is not spreadsheet wrangling can go with LibreOffice and Google Sheets.

Never had success with it, being 97% as good as Microsoft Office isn&#x27;t the same as being Microsoft Office. Formatting issues when sharing documents, tables that get blown out, looks kind of amateur sending those messed up documents to others unfortunately.

The company my wife works for is using LibreOffice entirely. Said company is a national retail service, focused on books and school related consumables, with around 40 stores opened throughout the entire country. And is using this since at least 2017, the year my wife went to work for them, possible since their beginnings in early 2000&#x27;s, but I&#x27;m not sure since I haven&#x27;t asked.<p>When she started to work for she asked me if we have LibreOffice on our computers because she had to edit some documents she took from work. I was pleasantly surprised to learn that they relied on LibreOffice for document management. Nowadays LibreOffice is installed on all our home computers alongside Microsoft Office as well. She can switch to whatever she finds easier and I taught her to always convert her documents to .RTF to be sure she has no problem switching between home and work.

Have a look at the plans of Schleswig-Holstein, a federal state of Germany. The want to switch 25.000 PCs to LibreOffice and Linux from Windows&#x2F;MS Office. Details here: <a href="https:&#x2F;&#x2F;blog.documentfoundation.org&#x2F;blog&#x2F;2021&#x2F;11&#x2F;18&#x2F;german-state-planning-to-switch-25000-pcs-to-libreoffice&#x2F;" rel="nofollow">https:&#x2F;&#x2F;blog.documentfoundation.org&#x2F;blog&#x2F;2021&#x2F;11&#x2F;18&#x2F;german-s...</a>

What kind of startup are you? Where do you want to use office? Who creates most of the content?<p>I have worked at a company that started with Googledocs and ended with Markdown (paper &#x2F; design docs) and reveal.js for presentations. And that is something I can take recommend. Why? Because it is simple text that can be stored in a repository and you gain the ability to compare versions. It is easy to change and you can convert it to almost anything. The most important target is obviously pdf to communicate with customers. Nobody wants odt, docx or other strange formats that require more than a browser.<p>Convincing the technical people was not necessary or done quick. Non coder like the CEO did like the suggestion least, but it was a revolution from the base and people who code where mostly creating content or talking at conferences.

&quot;My big concerns are support and training&quot;<p>If you find an awkward corner case in any piece of software then you will find support rather lacking from the vendor. I use LO myself: I&#x27;m a business owner and can use what I damn well like! I don&#x27;t force anyone else to use LO but we are a MS tin partner or something so get our tricks err drugs err software a bit cheaper.<p>Training: I was a trainer back in the day and it&#x27;s all about concepts and not the implementation. I&#x27;ve used Word from v1 to date and 2.0 was a sweet spot in terms of functionality and performance (2 floppies worth of code but could do quite a lot of decent WP and rudimentary DTP stuff eg hanging indents, decimal tabstops and text&#x2F;image frames with text flow. Modern LO Writer has a turtle implementation in it, coz reasons. Nowadays I struggle a bit to find things in the ribbons. Super Calc, Lotus 1-2-3, Excel and LO Calc all do the same thing in the end to a greater or lesser extent. I wrote a Finite Capacity Planner (yes: Finite) in Excel for a factory around 1995. I&#x27;d have to rewrite my functions in Python or whatever but it would run in LO quite happily.<p>Another anecdote: My wife is not IT minded in any way as such and has worked as a classroom assistant in schools catering for special needs and adult support services etc for several decades. She has had various IT offerings foisted on her from Acorn Axxx machines to PCs running Win 9x etc. At home she used to have Windows on her laptop but I eventually had enough at Win 7 when yet another graphics &quot;driver&quot; update needed a good six hours on the operating table to fix. She now runs Arch (actually!) and doesn&#x27;t care. It just has to work. She also uses LO, which seems to work OK and isn&#x27;t the oddest office suite she&#x27;s been forced to use.<p>Don&#x27;t overthink it. LO Writer and Calc are extremely capable apps and Base looks like a pretty good effort too when I&#x27;ve used it and you get all the rest of it but I tend to avoid Presentation type apps (such as &quot;Poor Point&quot;)<p>If you are capable of running a start up then LO will work fine. If some of your staff are incapable of any flexibility - I&#x27;d start to reconsider my choice of staff. A startup is all about being flexible and seeing opportunity and so on. If any modern IT user is &quot;incapable&quot; of getting on with LO then I&#x27;d question their ability to work in a startup environment.

I very much suspect that LO will be fine until one day it isn&#x27;t, and you wont realize until you are knee deep in pain that you are paying the price there and then. How much runway you have depends on the nature of the office work that you do. if you are trading complex documents with investors and their counsel for example then you may run into this immediately: docusign is gnarly, document review comments are gnarly, etc. All fixable, but at a time cost you might not have. Conversely if you are writing for consumption and not collaboration, LO might work for years.<p>The issue isnt whether LO is good (it is) but whether the LO team can compete with a trillion dollar corp that considers 365 as a central pillar of their business, invests in it accordingly, and whose changes to the software become the defacto standard overnight.

I feel like the biggest blocker to modern adoption of LibreOffice is the inability to collaborate in ways that Google Docs enables.<p>Are there open-source implementation of Docs, even poor ones?

What OSes do you use? What field are you in? Do you share documents outside the company? How much do you use comments, especially @tagged comments? Do you need versioning? Fo you need collaborative editing? What file storage do you use? How much do you all author documents, presentations, spreadsheets? Do your users use laptops directly or do they use keyboards and mice?<p>But really, probably none of that matters. If you think Google Workplace is too clunky, you’ll never be happy with LibreOffice. Just get O365 and get back to work. It’s not worth saving ~$5k annually.<p>For the last 4 years, I’ve been CIO and VP Eng of a now-series B company. We’re at about 70 FTE. We use Google Workspace and O365. We tried to move everyone to Google, but we couldn’t do it. As you noted, there’s just too much missing from it.

My company hasn&#x27;t used anything but Open&#x2F;Libre Office since its inception. No problems.<p>The only slightly related issue has been the one client who continues to send email attachments from Outlook as winmail.dat.

&gt; I work a lot on trains crossing Europe, or sometimes on flights. I just want to have my files accessible.<p>I have a similar use case (plus add in cafes where I&#x27;d rather not be on their wifi or my own mobile data). It amazes me how many company IT people I&#x27;ve spoken with over the years who just don&#x27;t comprehend some people work without being connected to the internet 100% of the time.<p>Dropbox remains my solution there. I&#x27;m also MS Office - too much interaction of documents with my clients to try anything else.

I feel it&#x27;s best to let folks use what they prefer. While having a standard way of sharing information. Fighting with tools you&#x27;re unfamiliar while trying to get work done with is a hidden cost on productivity.<p>Example, at our office we have a standard way of sharing info (Slack), and store shared information in Notion. But some folks use Google Docs&#x2F;Sheet, some prefer Excel, or Markdown files for their on work uses

speaking as a mechanic, hell yeah we depend on it every day for old and weird formats at work.<p>-the report generated by our laser alignment machine is in a 1993 ms write format. o365 says its no bueno.<p>-the diagnostic tool we use on some truck engines for valve calibration, advance and timing spits out an interactive doc in some esoteric ibm format I think? we edit the output in libre, feed it back into the tool, and it makes our adjustments.<p>-our shop floor uses libre because we don&#x27;t have enough internet to run o365 without huge delays. we switched four years ago.<p>-our ancient jit parts order system will gladly handle lotus dif files, so libre does too

Libre Office corresponds with M$ Office nearly 1-to-1 feature-wise.<p>I’ve never seen a single person react to it’s apps as being unfamiliar or different, especially considering the variety of UI shifts M$ Office has displayed since Office 2k. If you were referring to some specific API and integration with Sharepojnt or something I might understand your trepidation, but as your question stands, I have to say that I can’t think of a specific downside to it.<p>I suppose that deciding upon an output format that you will send out to clients or suppliers will be your main concern, as you will essentially choosing which version of M$ Office you are pretending to be. I find that the older pre-xml format is more universally supported but YMMV

I am using both for my business. Libre Office has excellent Draw program, I like it more than Visio.<p>But LO Calc is bad, or at least was when I was trying it last time. It has been creating broken tables especially where filters &#x2F; conditional formatting is involved and was endlessly crashing on attempt to create graph from 2 channel scope (cca 2*2000 X-Y values). OTOH in Excel I can have table with more than 30k lines with filters, sorting calculations and everything works swiftly. No, I am not going to fool around with a database.<p>In Word vs Writer scenario is not anything really appealing to me as I don&#x27;t use them too much. So I am neutral on those.

I gave it a shot about 10 years ago but quickly gave up. Libreoffice was way too limited. Exchanging word &#x2F; powerpoint with others was basically impossible, importing from ms office mostly messed up layouts. Just too much hassle. You got to focus on the business, not fighting with your office suite.<p>Recently, frustrated again with some excel shenanigans, I looked around and I discovered softmaker office. I immediately got a license and experimented a little. It seems very compatible with ms office. It still costs money, but less then ms. So in the near future I might try that route, along with thunderbird to replace outlook.

So I used to be a huge MS Office file format geek because of my work with Apache POI (<a href="https:&#x2F;&#x2F;poi.apache.org&#x2F;" rel="nofollow">https:&#x2F;&#x2F;poi.apache.org&#x2F;</a>). I spent some time playing around with LibreOffice API&#x27;s to try to use them for file format conversion.<p>I feel like LibreOffice&#x2F;OpenOffice file compatibility with MS Office peaked in the early 2000&#x27;s. The last time I tried to load a Word doc in LibreOffice a few years ago, it looked very janky. About the same as it did in 2004.<p>Sadly, I still receive 2 or 3 Office attachments a week. So MS Office compatibility is still very relevant.

I&#x27;ve never had a problem using LibreOffice or OpenOffice to replace Word&#x2F;GSuite. I&#x27;ve had some compatibility issues to open PowerPoint files, but that was usually limited to editing them. Creating presentations in LibreOffice or OpenOffice was harder than GSuite or PowerPoint as well, precisely because the latter two treated me more like I was an idiot and I&#x27;m not good at designing slides.<p>To be clear, as your edit says, your CFO and other modellers are probably going to have to use Excel. There are just things that work in Excel and nowhere else.

We (3-person dev&#x2F;design shop) never even went to LibreOffice; we&#x27;ve used OpenOffice for years. To be fair, we really only use it for accounting and producing occasional contracts and outlines. Neither program runs very well under Rosetta-2 on M1 macs, so as of this year we&#x27;ve mostly migrated over to Apple&#x27;s Numbers and Pages. For email we still use Thunderbird with a private IMAP server. Never had a need for Microsoft Office. Open&#x2F;Libre is fine for working with Excel spreadsheets sent by customers.

I have used LibreOffice Writer with <i>some</i> success, and Calc with more limited success, but in the latter case, perhaps just because I am limited with spreadsheets.<p>Writer is a problem in that it is a straight rip-off of Word, which supports the same file formats, but which is not fully compatible with Word.<p>Word and Writer handle styles differently: glyphs change, despite availability of the same fonts; alignment changes; tab stops are all over the place.<p>They handle images and floating things differently, sometimes placing things on different pages or behind other objects or text. Word online makes this even worse, because it doesn&#x27;t handle image captions properly, and converts the image and the caption to a second image.<p>I get all sorts of weird problems with Writer and Word - no particular blame attached - and unfortunately the answer is always the same: do your work in native Word on Windows, unless all your work is going to be in LibreOffice.<p>I think that the basic premises behind modern word processing are just wrong, and it&#x27;s because Word is so ubiquitous that everything else has to follow it. I think there is a space for a new style of WP which takes nothing from Word, or Writer, and which lies somewhere between that point and professional typesetting wares like LaTeX or InDesign; something which does less more professionally.<p>But it&#x27;s just a dream, and it doesn&#x27;t really take into account Excel, which is Microsoft&#x27;s killer app and probably the keystone of the company&#x27;s entire business.

Definitely. I used it, LibreOffice of course, exclsively in many businesses, including rolled it out to a business with 150 staff migrated from ms office to LO. No issues at all.

MS Office is going in the same direction as GSuite as far as I can tell (despite no clear need to do that). It&#x27;s becoming an increasingly online system that&#x27;s steadily more hostile to offline work. Using a document creation suite that works like that, or in the case of GSuite outright refuses to work offline, strikes me as a recipe for disaster in some kind of business or connectivity SHTF scenario.<p>Then of course there&#x27;s the whole parasitic, prying surveillance and snooping in the name of &quot;helpful&quot; user experience enhancement, telemetry and other bullshit corporate-speak for shamelessly sucking up your data. Another awful-smelling infection spreading among all the big corporate software players and making MS Office in its latest versions much more like the abomination that is GSuite (or anything by Google really). Do you really want most of the documentation being created by your business to be subject to perpetual viewing by these companies? I&#x27;d hope not.<p>Libre Office isn&#x27;t perfect, but at least it has much less of all the above while still keeping most of what makes an office suite simply work across the board.

My wife has used LibreOffice for years in her solo law practice. This may not have worked if she had to exchange documents with other lawyers with change tracking but either never came up or was not an issue for her.<p>She recently got a job and has to use Office but her LibreOffice experience hasn&#x27;t set her back.<p>Don&#x27;t let the naysayers stop you.

&gt;to be clear, our CFO will probably continue to use Excel, as will some of the team who build very complicated modelling sheets<p>Hiring someone to translate those &quot;complicated&quot; sheets in to a combination of python and basic CLI tools like grep to work with CSVs might be worth it in the long term, but for word processing and presentations, if you can export to PDF rather than be passing things in and out of the organization, OpenOffice should work well.<p>Your issue will be that ultimately, if you&#x27;re not exporting to PDF or ODT but trying to export to Microsoft&#x27;s proprietary format you&#x27;ll always end up chasing some obscure bug on a deadline that will make the entire endeavor not worth whatever costs were present up until that point.

In general &quot;Office&quot; applications are a bad solution to any problem, so not using them at all is best.<p>For text, Markdown with inline semantic HTML if necessary and CSS stylesheets if needed is better, since it properly separates style and presentation unlike word processors.<p>For modelling, Jupyter-like notebooks are much better than spreadsheets since they properly label objects, don&#x27;t make everything a 2D grid, and use a proper programming language.<p>For data, databases are better than spreadsheets.<p>Presentations are just documents, so there is no reason to use separate software.<p>For drawing you can use Inkscape and Gimp.<p>For collaboration you can use normal distributed version control like Git (with solutions like self-hosted Gitlab).

No, it was years ago that I tried in a small startup and it just wouldn&#x27;t scale as much as MS stuff. It&#x27;s mostly Excel that needs to be top notch or you waste time massaging data to make the libre office Calc thing accept it.<p>I like Google a little bit for its ability to remote code the spreadsheet and the sharing feature, but now in a large financial institution, Excel works perfectly fine.<p>I suppose the Word and PowerPoint alternatives are not as bad in LibreOffice, so if that&#x27;s your main tools, go for it.

Have been solely using OnlyOffice (<a href="https:&#x2F;&#x2F;www.onlyoffice.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.onlyoffice.com&#x2F;</a>) for 6 months now. Seems fine.

What is LibreOffice&#x27;s collaboration tools like? GSuite was awesome for multiple people editing at the same time and it allows for great synergy in that regard.

We use Google Workspace (fka Google Suite) at work. We also use LibreOffice for the occasional offline work, but just minimal.<p>And the CFO uses Google Workspace as well.

I&#x27;ve used LibreOffice for years. However, I&#x27;ve had many issues when editing a document alternatively in Excel and Libre. The alternate document editing works for some time, but Libre eventually always does something to the documents that they stopped being properly editable in one way or another.<p>I <i>always</i> use the same software that the C-suite uses for those files we transfer between us.

I would argue that the office suite is less relevant than the data.<p>Any suite only exists for it&#x27;s output. If you use a generic format then you can convert to specialised ones as required. If you save in a proprietary format, be prepared for vendor lockin.<p>Say HTML5 for docs, some form of CSV&#x2F;YAML for spreadsheets etc you get the idea.<p>Keep your data, then your suite decisions flow from that.

My town&#x27;s entire core infrastructure runs FOSS only. Schools, accounting, administration etc. We spend a lot of time training and answering queries, especially for non-technical people but it somehow works. The key is to have skilled people available to help out and good internal documentation

Rarely. Almost all done directly with TeX. (Yep, I&#x27;m strange)<p>I used Abiword and a lot of Gnumeric in the past. Now everything written in emacs, and then directly glued to postgresql, R or Perl. I hadn&#x27;t opened an excel since... one decade maybe.

If you want to, you can probably pull it off. Personally I would choose an office suite that has better UX, live collaborative editing and a native integration to cloud storage. But if you want to run LO it’s most probably possible.

I try to convert the company I work to use Nextcloud with thé collaborativ solutions.

The total cost of having Office 365 from everyone in the business will probably be less than 10K a year. There are 20 times more features than Libre Office or any other would offer+ things work fairly smoothly.

A bit related: with a bit of tinkering, nexcloud can edit office documents online. Pretty useful but your nextcloud server must have sufficient ram to run LibreOffice headless in the background.

If you primarily use macOS, Apple&#x27;s Pages and Keynote work fine for most use cases.<p>I agree that for finance employees, Excel is way better than anything else available.

Within latest 5 year I have been using Libre Office, I also got found Office 2003 disk last year to set it to honnor place in the working room.

To those who are using LibreOffice:<p>Are you donating towards the cost of maintenance and development?<p>If not, what changes could they make to convince you to do that?

Gsuite - TONS of updates. Subscribe to the Gsuite blog<p>Offline - works fantastic tbh. Tons of experience on long haul flights

there&#x27;s FreeOffice - <a href="https:&#x2F;&#x2F;www.freeoffice.com&#x2F;en&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.freeoffice.com&#x2F;en&#x2F;</a> . not exactly open source, but it&#x27;s free :)

No, I have considered rolling it out but ms365 winds up being the better option. E3 or E5 is worth every cent for its security and device management that is included.

I use it every day.

Use it all the time. Of course, my &quot;business&quot; consists of me and my wife and maybe a couple of kids hehe

Given how precious and valuable time is I don&#x27;t really get the aversion to using Microsoft or something similar. Pricing has come down so much that it&#x27;s less than people spend on coffee. If you are working on something worthwhile it doesn&#x27;t seem worth the effort to avoid using mainstream, productive and cheaply available commercial software.