We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Feature Comparison List [closed]

asked 2014-06-12 23:57:01 +0200

Killian Jones gravatar image

updated 2021-06-02 06:41:51 +0200

Alex Kemp gravatar image


I work for a company that is considering making LibreOffice ( available to it's users as an alternative to Microsot Office 2013 and as a sort of local (offline) compliment to Microsoft Office Online (Office 365). I'm trying to compare features available in the three solutions and haven't really been able to find a comprehensive list of features available in LibreOffice.

Specifically, I'm trying to compare Writer, Calc and Impress to Word/Excel/PowerPoint (online and offline) using the feature lists Microsoft has listed here as a basis:

Technet Article "Compare feature availability across Word Online and Word 2013 desktop app"

Technet Article "Compare feature availability across Excel Online and Excel 2013 desktop app"

Technet Article "Compare feature availability across PowerPoint Online and PowerPoint 2013 desktop"

Can any LibreOffice guru's hit me up with a quick yes/no next to these features for Writer?

  • Full fidelity reading view
  • Font formatting
  • Bullets and numbering
  • Hyperlinks
  • Picture tools
  • Insert online pictures
  • SmartArt
  • Apply styles
  • Simple table creation
  • Rich table formatting
  • Undo and Redo
  • Autosave
  • Clipboard
  • Find and Replace
  • Word count
  • Zoom
  • Real-time co-authoring
  • View and add comments
  • Share
  • Collaboration- advanced
  • Lists
  • Page layout tools
  • Headers and footers
  • Page breaks
  • Page numbers
  • Page layout tools- advanced
  • Print to PDF
  • Printing- advanced
  • Proofing tools
  • Proofing tools- advanced
  • Save As and Download a copy
  • Offline viewing and authoring
  • Alignment guides and live layout
  • Browse and start from professionally designed templates
  • Creation of advanced document elements
  • Document parts and themes
  • Paragraph formatting
  • IRM and password-protection
  • Mail merge
  • Present online
  • Reference tools
  • Table of Contents
  • Footnotes and endnotes
  • Citations and bibliography
  • Document translation
  • Table of Authority
  • Tell Me
  • Captions
  • Rich media
  • Apps for Office
  • VBA and Forms scripts

... These features for Calc:

  • Full fidelity reading view
  • Number formatting
  • Font and cell formatting
  • Copy and paste
  • Drag and drop cells
  • GoTo
  • Undo and redo
  • Merge cells
  • Alignment
  • Create tables
  • Insert charts
  • Fill Handle
  • Formula bar
  • Status bar aggregates
  • Functions (approx.400)
  • Hide/unhide rows, columns, and sheets
  • Autocomplete
  • Auto Sum
  • Formula tools- advanced
  • Insert/delete rows and columns
  • Rename and add sheets
  • Rename file while workbook is open
  • Add hyperlinks
  • Sort and filter data
  • Refresh existing data connections
  • Print
  • Find
  • Replace
  • View 3D charts
  • Slicer viewing
  • Save or Download a copy
  • Share
  • Real-time co-authoring
  • Embed Workbook on Web or Blog Page (OneDrive)
  • Surveys
  • Offline viewing and authoring
  • Freeze panes
  • Apply conditional formatting
  • Comment creation
  • Recommended chart creation and editing with formatting controls
  • Advanced time filtering (Timeline slicer)
  • Create external data connections
  • What if analysis tools
  • Creation of advanced analysis views (((Power View, PowerPivot, Slicers)
  • Chart animations adapt to new data
  • Apply data validation to cells
  • Rights Management: IRM and password security
  • Apply smart/recommended formatting
  • PowerPivot viewing
  • Power View viewing
  • Post to Social network and present online
  • Spreadsheet audit and compliance
  • Apps for Office
  • VBA and macro scripting
  • Tell Me

... And these features for Impress?

  • Full fidelity reading view
  • Font formatting
  • Alignment, bullets, numbers
  • Pictures
  • Insert rich media
  • Shapes ...
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 10:16:21.970139


Sorry, am no Guru and can not answer the long list from knowledge by heart. (Wouldn't expect "Full Fidelity ..., of course.) Maybe you need some testing by yourself?

Another thing: Going to use two Office Applications (or bundles of those) in parallel might be more a problem of interoperability and of differences in the UI than of lacking extra features (nobody really needs?).

Lupp gravatar imageLupp ( 2014-06-13 11:30:30 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-06-13 04:02:29 +0200

horst gravatar image

You might read through this document.

edit flag offensive delete link more


See [Tutorial] Differences between MS Word (eg .doc and .docx) and LO files (eg .odt) for a discussion of interoperability issues.

There is not now, and never will be, 100% compatibility between MS Word and LO.

MS clearly does not want to make it easy for you to use other software like LO. MS wants to sell you MS Word.

JohnHa gravatar imageJohnHa ( 2017-03-27 16:14:53 +0200 )edit

Question Tools



Asked: 2014-06-12 23:57:01 +0200

Seen: 3,005 times

Last updated: Jun 13 '14