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. MS Office 2013/2016 do not write out the Strict format by default (it has to be selected).But that's slowly been changing due to the free offerings out there. This issue is slated to be addressed in the next revision to ISO/IEC 29500. MS Office 2007 was supposed to be able to read this format (which was to be the same as ECMA-376 1st Edition), but Microsoft broke this. A lengthier analysis by the European Commission can be found here. The answer here indicates how LO handles these various formats. None of these versions are compatible with each other (i.e., are equivalent).

ISO/IEC 29500 Strict / ECMA-376 2nd Edition (read only by MS Office 2010 read / write by MS Office 2013/2016).ISO/IEC 29500 Transitional (read / write by MS Office 2010/2013/2016 and Mac Office 2011).ECMA-376 1st Edition (read / write by MS Office 2007 read only by MS Office 2010/2013).It is also important to more clearly indicate which version of OOXML the statement “.xlsx and. Only Microsoft “fully” supports these formats. Does LibreOffice fully support Microsoft.

Excel libre office