

LibreOffice can focus on its "substance" by creating an Office rival with zero learning curve. Some may argue that LibreOffice should be able to stand alone from MS Office, but that's simply not going to happen given that suite's nearly 20 years of market dominance. The "polish, not substance" comes from the fact that they improved on things that spreadsheet users don't often need in areas like cell formatting options and font choices, but still left severe workflow handicaps for anyone looking to move to Calc from Excel.

The press surrounding the 4.2 release and new core is exactly what inspired the article. I understand that the core has been rewritten. When coming to grips with a data dump, this limitation hurts Libre. Libre Calc can only accommodate 1,024 columns, about 15 times less than is possible from Excel.Libre Calc, along with the entire Libre Office package, has built-in compatibility with a variety of Document Management Systems (SharePoint, IBM FileNet, Domino, etc.) and legacy file formats.This is an example where Libre Office exceeds the capabilities of Microsoft Excel. Libre Calc allows you to view multiple sheets at the same time within one instance of the program, Excel does not.Looking at Calc specifically, since we're almost all reliant on Microsoft Excel, the differences are few, but some are substantial. Take a look at this chart for some of the major differences in the suites, and the individual programs. Libre Office also has a user community developing (often free) extensions to the suite, mimicking missing Microsoft Office features or, sometimes, increasing the Libre abilities past what Microsoft can do. With its latest update, Libre Office now offers the Group Policy options IT teams are accustomed to finding with Microsoft Office, which increases the potential deployments of Libre. Given that Libre Office has been making the biggest publicity push lately, we'll focus on them.įor 90% of the work performed by a typical company, Libre Office can be used without a problem in lieu of Microsoft Office. Open Office and Libre Office are free options that are installed on individual machines, and do their best to mimic the full Office experience. Basic ones like Google Docs offer minimal features, but are easily accessible in the cloud. But that's slowly been changing due to the free offerings out there.
