"laboratorio linux"

Linux Para Todos

Dom, 21.12.2014

Diferencias entre LibreOffice 4.0 y Microsoft Office 2013

Diferencias entre LibreOffice 4.0 y Microsoft Office 2013

Con el reciente lanzamiento de LibreOffice 4.0 y la noticia sobre la posibilidad de que Microsoft lance una versión nativa de Office para Linux, vale la pena echar una mirada a las diferencias entre una suite ofimática y la otra.

Dicha comparación llega de la mano de los propios chicos de LibreOffice a través de su wiki oficial, en donde ponen en evidencia las virtudes, así como las variadas deficiencias, de LibreOffice 4.0 ante Microsoft Office 2013.

Una de las diferencias que más se remarca es la disponibilidad de las suites en distintas plataformas, siendo LibreOffice 4.0 la que más plataformas soporta —por obvias razones—, estando presente incluso en más versiones de Windows que el propio Office 2013 (Windows XP, Vista, Windows 7 y Windows 8 contra solamente Windows 7 y 8).

General office suite: LibreOffice vs. Microsoft Office

Major Feature DifferencesLibreOffice 4.0MS Office 2013
Cross-platform availabilityWindows, Mac OS X and Linux (based on the same code base).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 WindowsWindows XP, Vista, 7, 8Windows 7, 8
Portable version that runs on USB flash disks (without installation)yesno (discontinued MS Office Starter 2010 edition runs on USB flash disks)
Open Sourceyes, licensed under GNU LGPL Version 3no, proprietary and closed-source
Full integration of all office componentssupported, Start Center, creation and opening of files of other office components.not supported
Availability free of chargeyesno, proprietary programme plus additional charges for language packs. 30-day trial version available.
Eco-system of extensionscomplex ecosystem of valuable extensions (over 170 on extensions.libreoffice.org and over 690 on extensions.services.openoffice.org) for LibreOffice (including automatic updates).partly, no centralized extension system.
Localization111 languages37 languages (37 main languages for purchase, 58 local Language Interface Packs for free download (only available for Office 2010 and older))
Changing language of the user interface on the flysupportedsupported, but requires additional purchase of language packs / download of local LIPs
Additional writing aidsextended 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 technologylimited via OpenType supporting ligatures
Easy access to vector clip artyes via LO Gallery (clipart extensions (1 or 2))selection more limited
Macro scripting languagesmultiple 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.
CMIS protocol support to access Document Management Systems like Alfresco, Nuxeo, SharePointsupportedinbuilt support only for SharePoint and Skydrive
Support of ISO standardized OpenDocument (ODF) formatadvanced supportlimited
PDF export extended optionsmultiple 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 additional options
Creation of HybridPDFs (ODF file embedded in PDF for full editing)supportednot supported
Import of graphics formats SVG vector graphics, PSD Photoshop and CorelDrawsupportednot supported
Import of MS Visio filessupportednot supported (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 Videosupportednot supported
Drawing programmeLibreOffice Drawno
PIM and email programmenot part of office suite, referring to Mozilla Thunderbird with Mozilla Lightning.MS Outlook
PDF Importpartial, into Draw with the limitation that text is imported line-based (bug 32249).supported, into MS Word
Import of Windows Media video and audio formats as well as AAC-Audio (Advanced Audio Coding)broken, workaround for .wma and .wmv and workaround for .aac exist.supported
User interface improved to enable use on touch screen devicesno, ports for Android and iOS in development (1,2,3)user interface improved for touch screen devices, but not redesigned
Online version of office suiteno, in development: experimental version.Office 365
Synchronous collaborative editingno, in development: experimental versionsupported
Import of media formats: MP4, MOV with H.264-Videonot supported (bug 60535)supported
Minor Feature DifferencesLibreOffice 4.0MS Office 2013
Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPMsupportednot supported
Import of additional video and audio formats: CD Audio, Vivo Video.supportednot supported
Support of Firefox themes (Personas)supportednot supported
Ink annotations (e.g. on a windows tablet computer)not supported, (only support for import of existing ink annotations from MS Word file format)supported
Live preview while formattingnot supported (bug 37048)supported
Import of graphics formats MEZ, WMZ, PCZ, CGMnot supportedsupported
Import of audio and video formats RMI, SNDnot supportedsupported

Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature DifferencesLO Writer 4.0MS Word 2013
Working with large documentsstable layoutlayout problemsa
Handling of captions for graphics or image boxesstable layoutlayout problems
Styles (page styles, frame styles, list styles)supportednot supported
Framesdesktop-like features like text in multiple columns and text-wrap around graphicsconcept of "horizontal frames" is more limited
Overlining of textsupportedno, but complicated workaround
Master documents for longer textssupportedsupported but deprecated because it causes file corruption
Extended label creation features asupported (generic database access, synchronise content)partial
Business card wizard asupportednot supported
Text auto completion of words already used beforesupportednot supported
XForms documents creationsupportednot supported
Mathematical calculations in tablescomplex calculationsonly basic arithmetic
DirectCursor (allows to enter text anywhere on a page)supportednot supported
DocBook import & exportsupportednot supported
Import from Lotus WordProsupportednot supported
Export to MediaWiki (Wikipedia) formatsupportednot supported
Export to XHTMLsupportednot supported
Grammar checkout of the box only 4 languages (English, Russian, Hungarian and Brazilian Portuguese)

extensions: e.g. Languagetool for 29 languages (level of language support varies), Grammalecte for French, CoGroo for Brazilian Portuguese, Duden Korrektor (commercial) for German

out of the box (22 languages supported with additional costs)
Comments for text rangessupported, but limited to a single paragraph.supported
Rotate imagesmissing (bug 34423), solution: extensions WriterRotationTool or Easy Image Editorsupported
Picture styles & additional effectsnot supported (bug 59906)supported
Table stylesnot supported (bug 34392)supported
Print comments in right marginnot supported (bug 36815), only on next page or at the end of textsupported
View changes in the right margin in "track changes" modenot supported (bug 34355)supported
Diagonal borders in tablesnot supported (bug 51665)supported
Extended reading mode of documentsnot supported (bug 55168)supported
Collapse and expand parts of a documentnot supported (bug 47746)supported
Simultaneous editing of a documentnot supported, in developmentsupported (via Skydrive or Sharepoint)
XML import / exportno exportsupported
Minor Feature DifferencesLO Writer 4.0MS Word 2013
Protected cells in tables (allows better creation of forms)supportednot supported
Open erroneous .doc filesbetter recovery modea,bmore frequently denies opening those files
Wizard to create personalized letter templatessupportednot supported
Import Hangul WP97 and T602 documentssupportednot supported
Import & Export Unified Office Formatsupportednot supported
Import & Export AportisDoc (Palm), PocketWord documentssupported (requires Java installed)not supported
Logo toolbar and interpretersupportednot supported
Bibliographic featuresbasic inbuilt support. Excellent extensions: e.g. Zotero, Mendeley, Bibus, JabRef, Endnote.supported plus extensions: e.g. Zotero,Mendeley, Endnote.
Decorative page bordersnot supported (bug 39270)supported
Add watermarks to pagesnot supported, workaround exists. Watermark option in PDF export.supported
Support for paragraphs longer than 65534 charactersnot supported (bug 30668)supported
Horizontal split view of the same documentnot 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 formatnot supportedsupported

Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature DifferencesLO Calc 4.0MS Excel 2013
Comparison of two spreadsheet filessupportednot supported
OpenFormula standardlargely supportednot supported
Page styles (in addition to cell styles)supportednot supported
Hyphenation in cellssupportednot supported
Import Lotus 123 datasupportednot supported
Import Quattro Pro 6 datasupportednot supported
Export to XHTMLsupportednot supported
Exporting of a single chart as image (PNG, JPG)supportednot supported
Number of columns per sheetmax. 1024 columns (bug 50916)up to 16384 columns
Interactive diagrams / PivotChartnot supportedsupported
Import Access databasesnot supportedsupported
Export generic XMLnot supportedsupported
Minor Feature DifferencesLO Calc 4.0MS Excel 2013
View clone of spreadsheet in new windowindependent windowcannot be moved outside the application window
Formatting of cellsmore detailled
e.g. feature to hide cell when printing
less features
Import Unified Office Formatsupportednot supported
Import & Export from / to Pocket Excelsupportednot supported
Import from Gnumericpartial (experimental) supportnot supported
Quick analysis featurenot supportedsupported
Flash fillnot supportedsupported
Chart recommendationsnot supportedsupported
'Publishing' spreadsheet for online team meetingsnot supportedsupported
Sparklines (to give a quick overview of the trend in a data range)not supported, extension: EuroOffice Sparklinesupported
Add points to a line, possibility to bend linesnot supported (bug 36943)supported
Copy only visible cellsnot supported, extension: Copy only visible cellssupported
Polynomial trend linesnot supported, extension: CorelPolyGUIsupported
Export to XPS formatnot supportedsupported

Presentation software: LibreOffice Impress vs. Microsoft Powerpoint

Major Feature DifferencesLO Impress 4.0MS Powerpoint 2013
Hyphenation supportsupportednot supported
Export to XHTMLsupportednot supported
Export to HTMLsupportednot supported (removed feature since MS Office 2013)
Export to Flash format (SWF)supportednot supported
Export to EPSsupportednot supported
Export to SVGsupportednot supported
Presentation remote control for Android smartphonessupportednot supported
Edit embedded videosvia external programsdirectly in the program
Comments and reply to commentspartialsupported
SmartArt diagramsnot supported (bug 37932), solution: smArt extensionsupported
Save highlights and drawings during presentationnot supported (bug 51928)supported
Broadcast presentation on the Internetonly via export to PDF or SWFsupported
Collaboration features. Several people working on same presentationnot supportedsupported
Animated diagramsnot supportedsupported
Record a slide shownot supportedsupported
Minor Feature DifferencesLO Impress 4.0MS Powerpoint 2013
Number of slide layouts129
Export to Unified Office Formatsupportednot supported
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM, PWPsupportednot supported
Editing of master slideslimited editingpowerful editing
Creation of automatically starting presentationsnot supported, extension: ImpressRunnersupported
Export to XPS formatnot supportedsupported

Database programme: LibreOffice Base vs. Microsoft Access

Major Feature DifferencesLO Base 4.0MS Access 2013
SQL syntax highlightingsupportednot supported
Native connector to MySQL databasessupportednot supported
Integration of Mozilla Thunderbird address bookssupportednot supported
Minor Feature DifferencesLO Base 4.0MS Access 2013
Native connectors to dBase databasessupportednot supported (removed feature since Office 2013
Native connectors to SharePoint lists, Microsoft Outlook and Paradox databasesnot supportedsupported


Otras características interesantes presentes en LibreOffice 4.0 y no en Office 2013 —o estarlo parcialmente— son: la posibilidad de ejecutar la suite desde un dispositivo USB sin necesidad de estar instalada en el sistema anfitrión, el hecho de ser software de código abierto, contar con integración total entre sus componentes, ser completamente gratuito, contar con un organizado ecosistema de complementos, soportar más de 100 idiomas, soporte para lenguajes como JavaScript o Python, soporte completo del formato ODF, opciones extendidas al exportar PDFs, así como la posibilidad de importar gráficos vectoriales, archivos PSD, archivos de MS Visio, archivos FLAC, OGG, MKV y WebM, entre otros.

Claro que hay muchas otras áreas en las que Microsoft Office sale ganando: importación no parcial de PDFs (así como archivos WMA, WMV, MP4, MOV y AAC), una interfaz fácil de usar en dispositivos táctiles, una versión en línea funcional al cien por ciento, vista preliminar mientras se da formato, además de otras cuantas. No obstante, no se trata de una tabla para ver cuál de las dos suites es mejor, se trata de de una tabla de referencia para que el usuario valore cuál de las dos puede cubrir mejor sus necesidades.

En la wiki hay más tablas comparativas —entre LibreOffice Writer y Microsoft Word o LibreOffice Calc y Microsoft Excel, por ejemplo— a las que en verdad vale la pena dedicar unos minutos de nuestro tiempo.


Fuente: Wiki de The Document Foundation | I love Ubuntu | ubunlog

Campus WinCoffee

Nuestra Web de Material Didáctico Manuales, Video Tutoriales, programas gratuitos.


Red SOStenible

Revista Linux+

Ubuntu 14.04 LTS Trusty

Agente Contador

Stats counter, realtime web analytics, heatmap creator

Contador de Visitas

Esta semana
Semana anterior
Este mes
Mes anterior
Total de Visitas

Server Time: 2014-12-21 06:23:08

Paises que nos Visitan

Spain 47.6%Spain
Mexico 15.4%Mexico
Argentina 8%Argentina
Chile 4.7%Chile
Colombia 4.3%Colombia
Venezuela 2.9%Venezuela
Peru 2.9%Peru
United States 2.6%United States
Ecuador 2.4%Ecuador
Uruguay 1.1%Uruguay
Bolivia 0.9%Bolivia
Guatemala 0.8%Guatemala
El Salvador 0.8%El Salvador
Costa Rica 0.8%Costa Rica

¿Quién está en línea?

Hay 214 invitados y ningún miembro en línea