2013-08-24

Japanese page created

New page

{{OrigLang|}}

''Disclaimer: This page is work in progress. It is a compilation by users and '''not''' an official document by the Document Foundation. Please feel free to improve this page.''

==Introduction==

This page compares the features of '''LibreOffice 4.1''' and '''Microsoft Office 2013'''. It separates major and minor feature differences and also includes LibreOffice extensions. The comparison highlights differences and therefore does not display any features which are present in both office suites.

== General office suite: LibreOffice vs. Microsoft Office ==

{| class="wikitable" width="100%"

|-

! width="33%" | Major Feature Differences

! width="33%" | LibreOffice 4.1

! width="33%" | MS Office 2013

|-

| Cross-platform availability

| {{yes|Windows, Mac OS X and Linux}} (based on the same code base).

| {{partial|Windows and Mac OS X}} (based on different code bases resulting in some format compatibility problems and differences in the user interface). Mac OS X Version is old version "Office 2011".

|-

| Supported versions of MS Windows

| {{yes|Windows XP, Vista, 7, 8}}

| {{partial|Windows 7, 8}}

|-

| Portable version that runs on USB flash disks (without installation)

| {{yes|yes}}

| {{no|no}} (discontinued MS Office Starter 2010 edition runs on USB flash disks)

|-

| Open Source

| {{yes|yes}}, licensed under GNU LGPL Version 3

| {{no|no}}, proprietary and closed-source

|-

| Full integration of all office components

| {{yes|supported}}, Start Center, creation and opening of files of other office components.

| {{no|not supported}}

|-

| Availability free of charge

| {{yes|yes}}

| {{no|no}}, proprietary programme plus additional charges for language packs. 30-day trial version available.

|-

| Eco-system of extensions

| {{yes|complex ecosystem of valuable extensions}} (over 180 on [http://extensions.libreoffice.org extensions.libreoffice.org] and over 700 on [http://extensions.services.openoffice.org extensions.services.openoffice.org]) for LibreOffice (including automatic updates).

| {{partial|partly}}, no centralized extension system.

|-

| Localization

| {{yes|110 languages}}

| {{partial|84 languages (37 main languages for purchase, 47 local Language Interface Packs for free download (58 were available for Office 2010 and older))}}

|-

| Changing language of the user interface on the fly

| {{yes|supported}}

| {{partial|supported}}, but requires additional purchase of language packs / download of local LIPs

|-

| Additional writing aids

| {{yes|extended support}} (spell-check dictionaries, hyphenation patterns, thesaurus and grammar check, specialized dictionaries as extensions ([http://extensions.services.openoffice.org/de/taxonomy/term/88 1]. [http://extensions.services.openoffice.org/de/taxonomy/term/246 2], [http://extensions.services.openoffice.org/de/taxonomy/term/233 3], [http://extensions.libreoffice.org/extension-center?getCategories=Dictionary&getCompatibility=any 4], [http://extensions.services.openoffice.org/de/taxonomy/term/231 5], [http://extensions.services.openoffice.org/de/dictionaries 6], [http://extensions.libreoffice.org/extension-center?getCategories=Language%20Tools&getCompatibility=any 7]))

| {{partial|limited}}, requires additional purchase of language packs

|-

| Support of complex languages and special font features (ligatures, true small caps, old style numbers, proportional or mono-spaced numbers, capital spacing, true superscript/subscript)

| {{yes|comprehensive}} support of SIL Graphite font technology (not available of Mac OS X). Support of OpenType optional features limited to localized forms (locl) ([https://bugs.freedesktop.org/show_bug.cgi?id=58941 bug 58941]).

| {{partial|limited}} via OpenType supporting ligatures, stylistic sets, number spacing options, number forms, contextual alternates.

|-

| Easy access to vector clip art

| {{yes|yes}} via LO Gallery (clipart extensions ([http://extensions.libreoffice.org/extension-center?getCategories=Gallery+Contents&getCompatibility=any&sort_on=positive_ratings&path=%2FLibreOffice-Extensions-and-Templates%2Fextension-center&portal_type=PSCProject&SearchableText= 1] or [http://extensions.services.openoffice.org/en/taxonomy/term/169 2]))

| {{partial|selection more limited}}

|-

| Macro scripting languages

| {{yes|multiple languages}}, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell and Python).

| {{partial|single language}}, support for Visual Basic for Applications (VBA). Indirectly also Visual Basic or Visual C# by using automation.

|-

| CMIS protocol support to access Document Management Systems like Alfresco, Nuxeo, SharePoint

| {{yes|supported}}

| {{partial|inbuilt support only for SharePoint and Skydrive}}

|-

| Support of ISO standardized OpenDocument (ODF) format

| {{yes|advanced support, v. 1.2 extended}}

| {{partial|limited (Windows), v. 1.2}}, no ODF support on MacOS X

|-

| PDF export extended options

| {{yes|multiple options}} (Additional options: detailed image settings, watermarks, HybridPDF, embedding of standard fonts, transition effects, tagged pdf, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures)

| {{no|no additional options}}

|-

| Creation of HybridPDFs (ODF file embedded in PDF for full editing)

| {{yes|supported}}

| {{no|not supported}}

|-

| Import of graphics formats SVG vector graphics, PSD Photoshop and CorelDraw

| {{yes|supported}}

| {{no|not supported}}

|-

| Import of MS Visio files

| {{yes|supported}}

| {{no|not supported}} (only via MS Visio which is not part of MS Office)

|-

| Import of video and audio formats FLAC Audio flac, Flash Video (flv), Matroska Media, OGG Audio, Ogg Video, Quicktime Video and WebM Video

| {{yes|supported}}

| {{no|not supported}}

|-

| Drawing programme

| {{yes|LibreOffice Draw}}

| {{no|no}}

|-

| PIM and email programme

| {{no|not part of office suite}}, referring to [http://www.mozilla.org/thunderbird/ Mozilla Thunderbird] with [http://www.mozilla.org/projects/calendar/lightning/ Mozilla Lightning].

| {{yes|MS Outlook}}

|-

| Import & Export of Microsoft OOXML files

| {{partial|Good support of real life OOXML files (e.g. .xlsx, .docx, .pptx)}}

| {{yes|Advanced support of transitional (default) and strict OOXML files}}

|-

| PDF Import

| {{partial|partial}}, into Draw with the limitation that text is imported line-based ([https://bugs.freedesktop.org/show_bug.cgi?id=32249 bug 32249]).

| {{yes|supported}}, into MS Word

|-

| User Interface approach

| {{partial|Classic UI; New Sidebar currently available as experimental feature}}

| {{partial|Ribbon UI; Classic UI available as third-party paid extension}}

|-

| User interface improved to enable use on touch screen devices

| {{no|no}}, ports for Android and iOS in development ([http://arstechnica.com/information-technology/2012/07/libreoffice-for-android-advances-document-viewer-is-on-the-way/ 1],[http://www.linuxuser.co.uk/features/the-future-of-libreoffice-android-ios-fixes-and-more 2],[http://www.muktware.com/videos/5202/libreoffice-running-android-interview-michael-meeks 3])

| {{partial|User interface improved for touch screen devices, but not redesigned}}

|-

| Online version of office suite

| {{no|no}}, in development: [http://www.h-online.com/open/news/item/LibreOffice-Cloud-not-coming-next-month-1479077.html experimental version].

| {{yes|[http://office365.microsoft.com Office 365]}}

|-

| Synchronous collaborative editing

| {{no|no}}, in development: [http://arstechnica.com/business/news/2012/03/libreoffice-developers-demo-collaborative-editing-prototype.ars experimental version]

| {{yes|supported}}

|-

! Minor Feature Differences

! LibreOffice 4.1

! MS Office 2013

|-

| Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM

| {{yes|supported}}

| {{no|not supported}}

|-

| Import of additional video and audio formats: CD Audio, Vivo Video.

| {{yes|supported}}

| {{no|not supported}}

|-

| Written in language(s)

| {{partial|C++, Java, Python}}

| {{partial|C++, C, (ASM)|}}[http://www.lextrait.com/vincent/implementations.html 1]

|-

| Enhanced list of recent files and folders

| {{partial|partial}} ([https://bugs.freedesktop.org/show_bug.cgi?id=61174 bug 61174], [https://bugs.freedesktop.org/show_bug.cgi?id=60743 60743]). Option to clear list of recent documents.

| {{yes|supported}} (option to set recent files as permanent)

|-

| Digital signatures / Signature Line

| {{partial|single signature without visual features}} ([https://bugs.freedesktop.org/show_bug.cgi?id=63001 bug 63001])

| {{yes|supported}}

|-

| Ink annotations (e.g. on a windows tablet computer)

| {{no|not supported}}, (only support for import of existing ink annotations from MS Word file format)

| {{yes|supported}}

|-

| Live preview while formatting

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=37048 bug 37048])

| {{yes|supported}}

|-

| Import of graphics formats MEZ, WMZ, PCZ, CGM

| {{no|not supported}}

| {{yes|supported}}

|}

== Word processors: LibreOffice Writer vs. Microsoft Word ==

{| class="wikitable" width="100%"

|-

! width="33%" | Major Feature Differences

! width="33%" | LO Writer 4.1

! width="33%" | MS Word 2013

|-

| Working with large documents

| {{yes|stable layout}}

| {{no|layout problems}}<sup>[http://www.datamation.com/applications/how-libreoffice-writer-tops-ms-word-12-features-3.html a]</sup>

|-

| Handling of captions for graphics or image boxes

| {{yes|stable layout}}

| {{no|layout problems}}

|-

| Styles (page styles, frame styles, list styles)

| {{yes|supported}}

| {{no|not supported}}

|-

| Overlining of text

| {{yes|supported}}

| {{no|no, but [http://word.tips.net/T000268_Overlining_Characters.html complicated workaround]}}

|-

| Master documents for longer texts

| {{yes|supported}}

| {{no|supported but deprecated [http://www.addbalance.com/word/masterdocuments.htm because it causes file corruption]}}

|-

| Business card wizard <sup>[http://wiki.documentfoundation.org/ReleaseNotes/3.6#Label_.2F_business_card_wizard a]</sup>

| {{yes|supported}}

| {{no|not supported}}

|-

| Text auto completion of words already used before

| {{yes|supported}}

| {{no|not supported}}

|-

| XForms documents creation

| {{yes|supported}}

| {{no|not supported}}

|-

| Mathematical calculations in tables

| {{yes|complex calculations}}

| {{no|only basic arithmetic}}

|-

| [http://help.libreoffice.org/Writer/Using_the_Direct_Cursor DirectCursor] (allows to enter text anywhere on a page)

| {{yes|supported}}

| {{no|not supported}}

|-

| DocBook import & export

| {{yes|supported}}

| {{no|not supported}}

|-

| Import from Lotus WordPro

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to MediaWiki (Wikipedia) format

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to XHTML

| {{yes|supported}}

| {{no|not supported}}

|-

| Extended label creation features <sup>[http://wiki.documentfoundation.org/ReleaseNotes/3.6#Label_.2F_business_card_wizard a]</sup>

| {{yes|supported}} (generic database access, synchronise content)

| {{partial|partial}}

|-

| Frames

| {{yes|desktop-like features like text in multiple columns and text-wrap around graphics}}

| {{partial|concept of "horizontal frames" is more limited}}

|-

| Grammar check

| {{partial|out of the box only 4 languages}} (English, Russian, Hungarian and Brazilian Portuguese)<br />

extensions: e.g. [http://www.languagetool.org Languagetool] for 29 languages (level of language support varies), [http://extensions.libreoffice.org/extension-center/grammalecte Grammalecte] for French, [http://extensions.libreoffice.org/extension-center/corretor-gramatical-cogroo/ CoGroo] for Brazilian Portuguese, [http://www.duden.de/shop/die-duden-rechtschreibpruefung-9-0-fuer-openoffice-und-libreoffice Duden Korrektor (commercial)] for German

| {{yes|out of the box ([http://office.microsoft.com/en-us/language-packs/proofing-tools-for-office-language-packs-FX101828851.aspx 22 languages supported] with additional costs)}}

|-

| Picture styles & additional effects

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=59906 bug 59906])

| {{yes|supported}}

|-

| Table styles

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=34391 bug 34392]), in development as GSOC 2013 project ([http://fridrich.blogspot.de/2013/05/libreoffice-google-summer-of-code-2013.html 1]).

| {{yes|supported}}

|-

| Print comments in right margin

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=36815 bug 36815]), only on next page or at the end of text

| {{yes|supported}}

|-

| View changes in the right margin in "track changes" mode

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=34355 bug 34355])

| {{yes|supported}}

|-

| Diagonal borders in tables

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=51665 bug 51665])

| {{yes|supported}}

|-

| Extended reading mode of documents

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=55168 bug 55168])

| {{yes|supported}}

|-

| Collapse and expand parts of a document

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=47746 bug 47746])

| {{yes|supported}}

|-

| Simultaneous editing of a document

| {{no|not supported, }} [http://www.h-online.com/open/news/item/LibreOffice-collaboration-over-instant-messaging-demonstrated-1484237.html in development]

| {{yes|supported}} (via Skydrive or Sharepoint)

|-

| Border around characters

| {{no|not supported}}, in development as GSOC 2013 project ([http://fridrich.blogspot.de/2013/05/libreoffice-google-summer-of-code-2013.html 1]).

| {{yes|supported}}

|-

| XML import / export

| {{no|no export}}

| {{yes|supported}}

|-

! Minor Feature Differences

! LO Writer 4.1

! MS Word 2013

|-

| Protected cells in tables (allows better creation of forms)

| {{yes|supported}}

| {{no|not supported}}

|-

| Open erroneous .doc files

| {{yes|better recovery mode}}<sup>[http://www.techsoup.org/learningcenter/software/page4765.cfm a],[http://answers.microsoft.com/en-us/office/forum/office_2010-word/how-to-recover-the-corrupted-word-document/87c494f4-136b-465c-806a-3b90743a61bc b]</sup>

| {{no|more frequently denies opening those files}}

|-

| Wizard to create personalized letter templates

| {{yes|supported}}

| {{no|not supported}}

|-

| Import Hangul WP97 and T602 documents

| {{yes|supported}}

| {{no|not supported}}

|-

| Import & Export Unified Office Format

| {{yes|supported}}

| {{no|not supported}}

|-

| Import & Export AportisDoc (Palm), PocketWord documents

| {{yes|supported (requires Java installed)}}

| {{no|not supported}}

|-

| Import of legacy Mac OS word processing documents (MS Word for Mac (1-5.1), MS Works for Mac, ClarisWorks, AppleWorks, Write Now, MacWrite Pro)

| {{yes|supported}}

| {{no|not supported}}

|-

| Logo toolbar and interpreter

| {{yes|supported}}

| {{no|not supported}}

|-

| Bibliographic features

| {{partial|basic inbuilt support}}. Excellent extensions: e.g. [http://www.zotero.org/ Zotero], [http://www.mendeley.com/ Mendeley], [http://bibus-biblio.sourceforge.net/wiki/index.php/Main_Page Bibus], [http://jabref.sourceforge.net/OOPlugin-jabref.php JabRef], [http://www.endnote.com/training/tutorials/EndNoteX3/EndNote_X3.asp Endnote].

| {{yes|supported}} plus extensions: e.g. [http://www.zotero.org/ Zotero],[http://www.mendeley.com/ Mendeley], [http://www.endnote.com/ Endnote].

|-

| Rotate images

| {{partial|rotation supported only for 90° increments. Rotation of vector graphics not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=34423 bug 34423]), alternative extensions [http://extensions.services.openoffice.org/en/project/WriterRotationTool WriterRotationTool] or [http://extensions.openoffice.org/en/node/4793? Easy Image Editor].

| {{yes|supported}}

|-

| Advanced find & replace / Special characters

| {{partial|partial}} ([https://bugs.freedesktop.org/show_bug.cgi?id=38261 bug 38261]), extension: [http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer Alternative dialog Find & Replace for Writer]

| {{yes|supported}}

|-

| Complex Outline numbering / Multilevel list

| {{partial|different numerically equivalent format not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=35217 bug 35217])

| {{yes|supported}}

|-

| Decorative page borders

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=39270 bug 39270])

| {{yes|supported}}

|-

| Add watermarks to pages

| {{no|not supported}}, [http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=38917 workaround exists]. Watermark option in PDF export.

| {{yes|supported}}

|-

| Support for paragraphs longer than 65534 characters

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=30668 bug 30668])

| {{yes|supported}}

|-

| Horizontal split view of the same document

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=31481 bug 31481]), workaround: Windows > New Window to clone document window.

| {{yes|supported}}

|-

| Outline view

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=38262 bug 38262]), workaround: Navigator > Content View to drag and promote/demote headings

| {{yes|supported}}

|-

| Draft view

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=39080 bug 39080])

| {{yes|supported}}

|-

| Password protection of tracked changes

| {{no|not supported}}

| {{yes|supported}}

|-

| Export to [http://de.wikipedia.org/wiki/XML_Paper_Specification XPS format] and MS Works format

| {{no|not supported}}

| {{yes|supported}}

|}

== Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel ==

{| class="wikitable" width="100%"

|-

! width="33%" | Major Feature Differences

! width="33%" | LO Calc 4.1

! width="33%" | MS Excel 2013

|-

| Comparison of two spreadsheet files

| {{yes|supported}}

| {{no|not supported}}

|-

| Page styles (in addition to cell styles)

| {{yes|supported}}

| {{no|not supported}}

|-

| Hyphenation in cells

| {{yes|supported}}

| {{no|not supported}}

|-

| Import Lotus 123 data

| {{yes|supported}}

| {{no|not supported}}

|-

| Import Quattro Pro 6 data

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to XHTML

| {{yes|supported}}

| {{no|not supported}}

|-

| Exporting of a single chart as image (e.g. jpg, png, svg, pdf)

| {{yes|supported}}

| {{no|not supported}}

|-

| [http://www.dwheeler.com/openformula/ OpenFormula standard]

| {{yes|largely supported}}

| {{partial|partial}}

|-

| Number of columns per sheet

| {{partial|max. 1024 columns}} ([https://bugs.freedesktop.org/show_bug.cgi?id=50916 bug 50916])

| {{yes|up to 16384 columns}}

|-

| Chart styles

| {{no|not supported}} (bugs [https://bugs.freedesktop.org/show_bug.cgi?id=62925 62925], [https://bugs.freedesktop.org/show_bug.cgi?id=62540 62540], [https://bugs.freedesktop.org/show_bug.cgi?id=39097 39097])

| {{partial|Selection of some pre-set chart styles and layouts}}

|-

| Interactive diagrams / PivotChart

| {{no|not supported}}

| {{yes|supported}}

|-

| Import Access databases

| {{no|not supported}}

| {{yes|supported}}

|-

| Export generic XML

| {{no|not supported}}

| {{yes|supported}}

|-

! Minor Feature Differences

! LO Calc 4.1

! MS Excel 2013

|-

| Flexible CSV export

| {{yes|supported ([http://www.surveygizmo.com/survey-software-support/tutorials/export-to-csv-from-office-spreadsheet-excel-calc-numbers/ 1], [http://www.sitepackage.de/service/dokumentation/24-speichern-von-csv-daten-in-openoffice-calc.html 2])}}

| {{no|not supported}}

|-

| View clone of spreadsheet in new window

| {{yes|independent window}}

| {{no|cannot be moved outside the application window}}

|-

| Chart type ''Stepped lines'' for XY (Scatter) graphs

| {{yes|suported}}

| {{no|not supported}}

|-

| Import Unified Office Format

| {{yes|supported}}

| {{no|not supported}}

|-

| Import & Export from / to Pocket Excel

| {{yes|supported}}

| {{no|not supported}}

|-

| Rotate charts

| {{yes|supported}}

| {{no|not supported}}

|-

| Formatting of cells

| {{yes|more detailed}}<br />e.g. feature to hide cell when printing

| {{partial|less features}}

|-

| Advanced find & replace / Cell Format

| {{partial|partial (Styles supported, Cell Format not supported)}}

| {{yes|supported}}

|-

| Import from Gnumeric

| {{partial|partial (experimental) support}}

| {{no|not supported}}

|-

| Printing of selected chart only

| {{no|not supported}}, workarounds [http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=47971 1], [http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=1593 2] ([https://bugs.freedesktop.org/show_bug.cgi?id=45893 bug 45893])

| {{yes|supported}}

|-

| Quick analysis feature

| {{no|not supported}}

| {{yes|supported}}

|-

| Flash fill

| {{no|not supported}}

| {{yes|supported}}

|-

| Chart recommendations

| {{no|not supported}}

| {{yes|supported}}

|-

| 'Publishing' spreadsheet for online team meetings

| {{no|not supported}}

| {{yes|supported}}

|-

| Sparklines (to give a quick overview of the trend in a data range)

| {{no|not supported}}, extension: [http://extensions.openoffice.org/en/project/eurooffice-sparkline EuroOffice Sparkline]

| {{yes|supported}}

|-

| Add points to a line, possibility to bend lines

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=36943 bug 36943])

| {{yes|supported}}

|-

| Copy only visible cells

| {{no|not supported}}, extension: [http://extensions.libreoffice.org/extension-center/copy-only-visible-cells Copy only visible cells]

| {{yes|supported}}

|-

| Polynomial trend lines

| {{no|not supported}}, extension: [http://extensions.libreoffice.org/extension-center/improved-trend-lines CorelPolyGUI]

| {{yes|supported}}

|-

| Export to [http://de.wikipedia.org/wiki/XML_Paper_Specification XPS format]

| {{no|not supported}}

| {{yes|supported}}

|}

== Presentation software: LibreOffice Impress vs. Microsoft Powerpoint ==

{| class="wikitable" width="100%"

|-

! width="33%" | Major Feature Differences

! width="33%" | LO Impress 4.1

! width="33%" | MS Powerpoint 2013

|-

| Hyphenation support

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to XHTML

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to HTML

| {{yes|supported}}

| {{no|not supported}} (removed feature since MS Office 2013)

|-

| Export to Flash format (SWF)

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to EPS

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to SVG

| {{yes|supported}}

| {{no|not supported}}

|-

| Presentation remote control for Android smartphones

| {{yes|supported}}

| {{no|not supported}}

|-

| Edit embedded videos

| {{partial|via external programs}}

| {{yes|directly in the program}}

|-

| Comments and reply to comments

| {{partial|partial}}

| {{yes|supported}}

|-

| SmartArt diagrams

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=37932 bug 37932]), solution: [http://extensions.libreoffice.org/extension-center/smart smArt extension]

| {{yes|supported}}

|-

| Save highlights and drawings during presentation

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=51928 bug 51928)]

| {{yes|supported}}

|-

| Broadcast presentation on the Internet

| {{no|only via export to PDF or SWF}}

| {{yes|supported}}

|-

| Collaboration features. Several people working on same presentation

| {{no|not supported}}

| {{yes|supported}}

|-

| Animated diagrams

| {{no|not supported}}

| {{yes|supported}}

|-

| Record a slide show

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=34959 bug 34959])

| {{yes|supported}}

|-

! Minor Feature Differences

! LO Impress 4.1

! MS Powerpoint 2013

|-

| Number of slide layouts

| {{yes|12}}

| {{partial|9}}

|-

| Export to Unified Office Format

| {{yes|supported}}

| {{no|not supported}}

|-

| Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM, PWP

| {{yes|supported}}

| {{no|not supported}}

|-

| Embedding of fonts in presentation file

| {{yes|supported}}

| {{partial|supported on Windows. No support for embedding fonts in Powerpoint on MacOS X}}

|-

| Editing of master slides

| {{partial|limited editing}}, in development as GSOC 2013 project ([http://fridrich.blogspot.de/2013/05/libreoffice-google-summer-of-code-2013.html 1]).

| {{yes|powerful editing}}

|-

| Creation of automatically starting presentations

| {{no|not supported}}, extension: [http://extensions.libreoffice.org/extension-center/impressrunner ImpressRunner]

| {{yes|supported}}

|-

| Export presentation to video formats

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=34959 bug 34959])

| {{yes|supported}} (only to .wmv format)

|-

| Export to [http://de.wikipedia.org/wiki/XML_Paper_Specification XPS format]

| {{no|not supported}}

| {{yes|supported}}

|-

| Slide zoom and pan

| {{no|not supported}} ([https://bugs.freedesktop.org/show_bug.cgi?id=38263 bug 38263])

| {{yes|supported}}

|}

== Database programme: LibreOffice Base vs. Microsoft Access ==

{| class="wikitable" width="100%"

|-

! width="33%" | Major Feature Differences

! width="33%" | LO Base 4.1

! width="33%" | MS Access 2013

|-

| Available on MacOS X

| {{yes|supported}}

| {{no|no version for MacOS X}}

|-

| SQL syntax highlighting

| {{yes|supported}}

| {{no|not supported}}

|-

| Native connector to MySQL databases

| {{yes|supported}}

| {{no|not supported}}

|-

| Native connector to PostgreSQL databases

| {{yes|supported ([[PostgreSQL-SDBC]])}}

| {{no|not supported}}

|-

| Integration of Mozilla Thunderbird address books

| {{yes|supported}}

| {{no|not supported}}

|-

| Pivot tables

| {{no|not supported}}

| {{yes|supported}}

|-

| Crosstab queries

| {{no|not supported}}

| {{yes|supported}}

|-

| "Linked tables" capability

| {{no|not supported}}

| {{yes|supported}}

|-

| Imported table from Calc/Excel - keep fields format

| {{no|not supported}}

| {{yes|supported}}

|-

! Minor Feature Differences

! LO Base 4.1

! MS Access 2013

|-

| Native connectors to dBase databases

| {{yes|supported}}

| {{no|not supported (removed feature since Office 2013}}

|-

| Native connectors to SharePoint lists, Microsoft Outlook and Paradox databases

| {{no|not supported}}

| {{yes|supported}}

|-

| Union queries

| {{no|not supported}}

| {{yes|supported}}

|-

| Nz(), formatnumber() function in Sql statment

| {{no|not supported}}

| {{no|not supported}}

|-

| Edit MS Access files

| {{partial|limited}} olders driver "Microsoft.Jet.OLEDB.4.0" works fine for read/write, while "Microsoft.ACE.OLEDB.12.0" driver only reads; ([https://bugs.freedesktop.org/show_bug.cgi?id=43187 bug 43187])

| {{yes|supported}}

|}

== Extensions: LibreOffice extensions adding outstanding features to LibreOffice==

LibreOffice has a complex eco-system of extensions (over 180 on [http://extensions.libreoffice.org extensions.libreoffice.org] and over 700 on [http://extensions.services.openoffice.org extensions.services.openoffice.org]). Selection of some extensions adding valuable features to LibreOffice:

{| class="wikitable" width="100%"

|-

! width="33%" |

! width="67%" | LibreOffice Extensions

|-

| General office suite: LibreOffice

|

* [http://extensions.libreoffice.org/extension-center/openoffice.org2googledocs-export-import-to-google-docs-zoho-webdav OpenOffice.org2GoogleDocs] exports, updates and imports documents to and from Google Docs, Zoho and WebDAV servers.

* [http://extensions.services.openoffice.org/project/TeamDrive TeamDrive] allows to shared spaces in the TeamDrive collaboration software.

* [http://www.wollmux.net Wollmux] is a complex centralized system for templates, forms and letter heads developed by the city of Munich (in German language).

* [http://extensions.libreoffice.org/extension-center/elaix eLAIX] allows users to write and read ILIAS learning modules offline and to export to ePUB3 e-book file format.

* [http://extensions.services.openoffice.org/project/alfrescoconnector Oracle Connector for Alfresco CMS] allows to connect LibreOffice with the Alfresco Document management server.

* [http://extensions.libreoffice.org/extension-center/libreoffice-server-installation-gui LibreOffice Server Installation GUI] facilitates parallel and server installations of LibreOffice.

|-

| LibreOffice Writer

|

* [http://extensions.libreoffice.org/extension-center/texmaths-1 TexMaths] adds an LaTex equation editor to LibreOffice

* [http://extensions.libreoffice.org/extension-center/dmaths DMaths] adds a comprehensive mathematical tool box to LibreOffice Writer

* [http://extensions.libreoffice.org/extension-center/chemistry Chemistry] allows to insert chemistry formulas as image from formula.

* [http://extensions.services.openoffice.org/project/coooder COOoder] provides syntax highlighting for LibreOffice Writer.

* [http://extensions.services.openoffice.org/project/AddPics AddPics] creates a Writer document from pictures of scanned pages.

* [http://extensions.services.openoffice.org/project/writertools Writer's Tools] is a set of utilities for frequent writers.

* [http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer Alternative find & replace dialog] for Writer.

* [http://extensions.libreoffice.org/extension-center/typography-toolbar Typography toolbar] for advanced use of Graphite smart font features.

* [http://extensions.openoffice.org/de/project/qrcodegen QR code Generator]

* File format filters

** [http://extensions.libreoffice.org/extension-center/export-freemind Export-Freemind] allows to export Writer documents to Freemind mind manager.

** [http://extensions.libreoffice.org/extension-center/writer2latex-1 Writer2LaTex] allows to export Writer documents to LaTex.

** [http://extensions.services.openoffice.org/project/Writer2ePub Writer2ePub] allows to export to the a free and open e-book standard ePub.

|-

| LibreOffice Calc

|

* [http://extensions.libreoffice.org/extension-center/geooo GeOOo] allows to create thematic maps with LibreOffice.

* [http://extensions.libreoffice.org/extension-center/improved-trend-lines CorelPolyGUI]: Chart trend lines improved: polynomial trend line, force intercept of trend line and moving average trend line

* [http://extensions.libreoffice.org/extension-center/olap-calc-extension PalOOCa OLAP Calc Extension]: Connecting Calc to access Palo or XMLA capable OLAP servers.

* File format filters:

** [http://extensions.services.openoffice.org/de/project/Calc2LaTeX Calc2LaTeX] allows to convert Calc tables to LaTeX.

|-

| LibreOffice Impress

|

* [http://extensions.libreoffice.org/extension-center/export-as-images Export as Images] allows to export all the Impress slides or Draw pages as images of JPG, PNG, GIF, BMP and TIFF format.

* [http://extensions.libreoffice.org/extension-center/opencards OpenCards] is a free award-winning flashcard learning software.

|-

| LibreOffice Draw

|

* [http://extensions.libreoffice.org/extension-center/barcode Barcode] enables LibreOffice to add barcodes to documents.

* [http://extensions.libreoffice.org/extension-center/geooo GeOOO] allows the creations of thematic maps with LibreOffice.

* [http://extensions.libreoffice.org/extension-center/cadlo Cadlo] makes it possible to make technical drawings in LibreOffice Draw.

|-

| LibreOffice Base

|

* [http://extensions.libreoffice.org/extension-center/access2base Access2Base] implements a OOo/LibO Basic library for Base applications.

|}

==See also==

* [http://www.datamation.com/applications/how-libreoffice-writer-tops-ms-word-12-features-1.html How LibreOffice Writer Tops MS Word: 12 Features, by Bruce Byfield (2012-04-10)].

* [http://www.datamation.com/open-source/libreoffice-vs.-ms-office-spreadsheets-and-slide-shows-1.html LibreOffice vs. MS Office: Spreadsheets and Slide Shows, by Bruce Byfield (2012-06-06)]

* [http://www.datamation.com/applications/how-microsoft-office-tops-libreoffice-11-features-1.html How Microsoft Office Tops LibreOffice: 11 Features, by Bruce Byfield (2012-04-26)].

* [http://www.techsoup.org/learningcenter/software/page4765.cfm Microsoft Office vs. OpenOffice.org - Idealware does a head-to-head comparison of the two office suites, by Brett Bonfield and Laura S. Quinn (2010-07-02)].

* [https://www.heise.de/artikel-archiv/ct/2008/22/146 Duell am Arbeitsplatz, by Ralf Nebelo and Dorothee Wiegand (c't 22/2008, German)].

[[Category:Development]]

[[Category:Documentation]]

Show more