Feature Comparison List


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
  • 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
  • Surveys
  • Offline viewing and authoring
  • Freeze panes
  • Apply conditional formatting
  • Comment creation
  • Recommended chart creation and
    editing with formatting controls
  • Advanced time filtering (Timeline
  • 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
  • Apply smart/recommended formatting
  • PowerPivot viewing
  • Power View viewing
  • Post to Social network and present
  • 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
  • SmartArt
  • Hyperlinks
  • View and edit slide notes
  • Create and manage slides
  • Apply themes and theme variants
  • Apply basic transitions and
  • Full selection of animations and
  • Arrange objects
  • Undo and redo
  • Clipboard
  • Share
  • View and add comments
  • Real-time co-authoring
  • Save As or Download a copy
  • Print to PDF
  • Navigation—slide sorter
  • Proofing tools
  • Run Slide Show
  • Slideshow
  • Embed presentation on web or blog
  • Tell Me
  • Offline viewing and authoring
  • Table creation/editing and formatting
  • Design tools- advanced
  • Reviewer tools- advanced
  • Create custom animation
  • Apply rich formatting to text,
    shapes, and pictures
  • Broadcast slide show
  • Rights management: Apply and consume
    IRM and password protection
  • Full ink support
  • Headers and footers
  • Integration with Excel for charts
  • Present online through Lync or the
    Office Presentation Service
  • Presenter view
  • Apps for Office

Thanks for any help! Obviously some of these are pretty easy to test myself, but as I’m not all that familiar with LibreOffice. With the more advanced features, it’s probably just easier to ask the experts.

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?).

You might read through this document.

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.