Microsoft Office LibreOffice Karşılaştırması

Libreoffice Türkiye Vikisi sitesinden
Yakusha (Mesaj | katkılar) tarafından oluşturulmuş 19:57, 15 Eylül 2012 tarihli sürüm

(fark) ← Önceki hâli | en güncel halini göster (fark) | Sonraki hâli → (fark)
Atla: kullan, ara

Şablon:OrigLang Disclaimer: This page is work in progress. It is a compilation by users and not an official document by the Documentfoundation. Please feel free to improve this page.

Introduction

This page compares the features of LibreOffice 3.6 and Microsoft Office 2010. 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

Major Feature Differences LibreOffice 3.6 MS Office 2010
Cross-platform availability Windows, Mac OS X and Linux (based on the same code base). partly, Windows and Mac OS X (based on different code bases resulting in some format compatibility problems and differences in the user interface).
Portable version that runs on USB flash disks (without installation) yes no (discontinued MS Office Starter edition runs on USB flash disks)
Open Source yes, licensed under GNU LGPL Version 3 no, proprietary and closed-source
Full integration of all office components supported, Start Center, creation and opening of files of other office components. not supported
Availability free of charge yes no, proprietary programme plus additional charges for language packs. 30-day trial version available.
Eco-system of extensions complex ecosystem of valuable extensions (over 150 on extensions.libreoffice.org and over 678 on extensions.services.openoffice.org) for LibreOffice (including automatic updates). partly, no centralized extension system.
Localization 111 languages 57 languages
Changing language of the user interface on the fly supported supported, but requires additional purchase of language packs
Additional writing aids extended support (spell-check dictionaries, hyphenation patterns, thesaurus and grammar check, specialized dictionaries as extensions) 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 via Graphite font technology limited via OpenType supporting ligatures
Easy access to vector clip art yes via LO Gallery (clipart extensions (1 or 2)) selection more limited
Macro scripting languages multiple languages, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell and Python). single language, support for Visual Basic for Applications (VBA). Indirectly also Visual Basic or Visual C# by using automation.
Support of ISO standardized OpenDocument (ODF) format advanced support limited
PDF export multiple options (watermarks, embedding of standard fonts, transition effects, tagged pdf, extended security options, comments, encryption and PDF forms) few options
Creation of HybridPDFs (ODF file embedded in PDF for full editing) supported not supported
PDF Import yes, into Draw (limitation that text is imported line-based) no
Import of graphics formats SVG vector graphics, PSD Photoshop and CorelDraw yes no
Import of MS Visio files yes no (only via MS Visio which is not part of MS Office)
Import of video and audio formats FLAC Audio flac, Matroska Media, OGG Bitstream, Quicktime Video and WebM Video yes no
Drawing programme LibreOffice Draw no
PIM and email programme no, referring to Mozilla Thunderbird with Mozilla Lightning. MS Outlook
Online version of office suite no, in development: experimental version. Office 365
Synchronous collaborative editing no, in development: experimental version yes
Import of Windows Media video and audio formats broken, workaround exists. yes
Minor Feature Differences LibreOffice 3.6 MS Office 2010
Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM supported not supported
Import of additional video and audio formats: CD Audio, Vivo Video. supported not supported
Ink annotations (e.g. on a windows tablet computer) not supported supported
Live preview while formatting not supported (bug 37048) supported
Import of graphics formats MEZ, WMZ, PCZ, CGM not supported supported
Import of audio and video formats RMI, SND not supported supported

Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature Differences LO Writer 3.6 MS Word 2010
Working with large documents stable layout layout problemsa
Handling of captions for graphics or image boxes stable layout layout problems
Styles (page ~, (hierarchic) paragraph ~, character ~, frame ~, and list ~) supported no frame styles, list styles, or page styles
Frames desktop-like features like text in multiple columns and text-wrap around graphics concept of "horizontal frames" is more limited
Reply to comments supported not supported
Overlining of text supported not supported
Master documents for longer texts supported supported but deprecated because it causes file corruption
Label / business card wizard a supported not supported
Text auto completion of words already used before supported not supported
XForms documents creation supported not supported
Mathematical calculations in tables complex calculations only basic arithmetic
DirectCursor (allows to enter text anywhere on a page) supported not supported
DocBook import & export supported not supported
Import from Lotus WordPro supported not supported
Export to MediaWiki (Wikipedia) format supported not supported
Export to XHTML supported not supported
Rotate images missing (bug 50916), solution: WriterRotationTool extension supported
Picture styles & additional effects not supported supported
Print comments in right margin not supported (bug 36815), only on next page or at the end of text supported
Comments for text ranges not supported (bug 38244), scheduled for version 3.7 supported
View changes in the right margin in "track changes" mode not supported (bug 34355) supported
Diagonal borders in tables not supported (bug 51665) supported
Simultaneous editing of a document not supported, in development supported (via Skydrive or Sharepoint)
Grammar check out of the box only three languages (English, Russian and Hungarian)

extensions: e.g. Languagetool for 27 languages, Grammalecte for French, CoGroo for Brazilian Portuguese, Duden Korrektor (commercial) for German

out of the box (20 languages supported with additional costs)
XML import / export no export supported
Minor Feature Differences LO Writer 3.6 MS Word 2010
Protected cells in tables (allows better creation of forms) supported not supported
Open erroneous .doc files better recovery modea,b more frequently denies opening those files
Wizard to create personalized letter templates supported not supported
Import Hangul WP97 and T602 documents supported not supported
Import & Export Unified Office Format, AportisDoc(Palm), PocketWord documents supported not supported
Bibliographic features basic inbuilt support. Excellent extensions: e.g. Zotero, Mendeley, Bibus, JabRef, Endnote. supported plus extensions: e.g. Zotero,Mendeley, Endnote.
Decorative page borders not supported (bug 39270) supported
Add watermarks to pages not supported, workaround exists. Watermark option in PDF export. supported
Horizontal split view of the same document not supported (bug 31481), workaround: Windows > New Window to clone document window. supported
Additional views (outline and draft) not supported (bug 39080) supported
Export to XPS format and MS Works format not supported supported

Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences LO Calc 3.6 MS Excel 2010
Comparison of two spreadsheet files supported not supported
OpenFormula standard largely supported not supported
Page styles (in addition to cell styles) supported not supported
Hyphenation in cells supported not supported
Import Lotus 123 data supported not supported
Import Quattro Pro 6 data supported not supported
Export to XHTML supported not supported
Number of columns per sheet max. 1024 columns (bug 50916) up to 16384 columns
Interactive diagrams / PivotChart not supported supported
Import Access databases not supported supported
Import & Export XML not supported supported
Minor Feature Differences LO Calc 3.6 MS Excel 2010
View clone of spreadsheet in new window independent window cannot be moved outside the application window
Formatting of cells more detailled
e.g. feature to hide cell when printing
less features
Import Unified Office Format supported not supported
Import & Export from / to Pocket Excel supported not supported
Sparklines (to give a quick overview of the trend in a data range) not supported, extension: EuroOffice Sparkline supported
Add points to a line, possibility to bend lines not supported (bug 36943) supported
Icon sets in conditional formatting not supported (bug 36943) supported
Copy only visible cells not supported, extension: Copy only visible cells supported
Polynomial trend lines not supported, extension: CorelPolyGUI supported
Export to XPS format not supported supported

Presentation software: LibreOffice Impress vs. Microsoft Powerpoint

Major Feature Differences LO Impress 3.6 MS Powerpoint 2010
Hyphenation support supported not supported
Export to XHTML supported not supported
Export to Flash format (SWF) supported not supported
Export to EPS supported not supported
Export to SVG supported not supported
SmartArt diagrams not supported, solution: smArt extension supported
Save highlights and drawings during presentation not supported supported
Edit embedded videos via external programs directly in the program
Broadcast presentation on the Internet only via export to PDF or SWF supported
Animated diagrams not supported supported
Record a slide show not supported supported
Minor Feature Differences LO Impress 3.6 MS Powerpoint 2010
Number of slide layouts 12 9
Export to Unified Office Format supported not supported
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM, PWP supported not supported
Creation of automatically starting presentations not supported, extension: ImpressRunner supported
Editing of master slides limited editing powerful editing
Export to XPS format not supported supported

Database programme: LibreOffice Base vs. Microsoft Access

Major Feature Differences LO Base 3.6 MS Access 2010
SQL syntax highlighting supported not supported
Native connector to MySQL databases supported not supported
Minor Feature Differences LO Base 3.6 MS Access 2010
Native connectors to SharePoint lists, Microsoft Outlook and Paradox databases not supported supported


Extensions: LibreOffice extensions adding outstanding features to LibreOffice

LibreOffice has a complex eco-system of extensions (over 160 on extensions.libreoffice.org and over 680 on extensions.services.openoffice.org). Selection of some extensions adding valuable features to LibreOffice:

LibreOffice Extensions
General office suite: LibreOffice
  • OpenOffice.org2GoogleDocs exports, updates and imports documents to and from Google Docs, Zoho and WebDAV servers.
  • TeamDrive allows to shared spaces in the TeamDrive collaboration software.
  • Wollmux is a complex centralized system for templates, forms and letter heads developed by the city of Munich (in German language).
  • eLAIX allows users to write and read ILIAS learning modules offline.
  • Oracle Connector for Alfresco CMS allows to connect LibreOffice with the Alfresco Document management server.
LibreOffice Writer
  • TexMaths adds an LaTex equation editor to LibreOffice
  • DMaths adds a comprehensive mathematical tool box to LibreOffice Writer
  • Chemistry allows to insert chemistry formulas as image from formula.
  • COOoder provides syntax highlighting for LibreOffice Writer.
  • AddPics creates a Writer document from pictures of scanned pages.
  • Writer's Tools is a set of utilities for frequent writers.
  • File format filters
    • Export-Freemind allows to export Writer documents to Freemind mind manager.
    • Writer2LaTex allows to export Writer documents to LaTex.
    • Writer2ePub allows to export to the a free and open e-book standard ePub.
LibreOffice Calc
  • GeOOo allows to create thematic maps with LibreOffice.
  • File format filters:
    • Calc2LaTeX allows to convert Calc tables to LaTeX.
LibreOffice Impress
  • Export as Images allows to export all the Impress slides or Draw pages as images of JPG, PNG, GIF, BMP and TIFF format.
  • OpenCards is a free award-winning flashcard learning software.
LibreOffice Draw
  • Barcode enables LibreOffice to add barcodes to documents.
  • GeOOO allows the creations of thematic maps with LibreOffice.
  • Cadlo makes it possible to make technical drawings in LibreOffice Draw.
LibreOffice Base

See also