Comparativo de Características: LibreOffice - Microsoft Office

TDF LibreOffice en español Document Liberation Project Blogs comunitarios Weblate Nextcloud Redmine Preguntas y respuestas Donar

• Inicio
• Desarrollo
• Diseño
• Control de calidad
• Eventos
• Documentación
• Sitio web
• Regionalización
• Accesibilidad
• Mercadotecnia
• Diversity
• Wiki Help

• Inicio Documentación
• Publicaciones oficiales
• Otros recursos
• Preg. Frecuentes
• Cómos
• Macros
• Desarrollo de documentación

Esta página compara las características de LibreOffice 24.8.4

(descarga) y Microsoft Office 2019/365. La tabla separa las diferencias de características mayores y menores y también incluye notas sobre las extensiones de LibreOffice. La comparación resalta las diferencias y, por lo tanto, no muestra ninguna característica que esté presente en ambas suites ofimáticas.

Las suites de oficina están disponibles para diferentes factores de forma. Hay tablas de comparación independientes disponibles para:

• Escritorio: Notebooks, Computadoras de escritorio y Chromebooks
• Móvil: Smartphones y Tablets
• Online: Oficina basada en navegador web

La tabla de comparación de características se actualiza continuamente y está en progreso. Es una compilación de usuarios y 'no' un documento oficial de Document Foundation. Por favor, siéntate libre de mejorar esta página. La última actualización de esta tabla se realizó el 16.12.2024

Desktop office: Notebooks, Desktop computers

Carácterísticas generales de los Paquetes de oficina: LibreOffice vs. Microsoft Office

Principales diferencias	LibreOffice 24.8	MS Office 2024 / 365
Disponibilidad multiplataforma (PC escritorio)	Sí. Windows, macOS, Linux, FreeBSD, NetBSD, OpenBSD y Haiku. (basado en la misma base de código). ChromeOS a través de Collabora Office	Parcial. Windows y macOS sin soporte para Linux, FreeBSD, NetBSD, OpenBSD, Haiku o Chrome OS Las versiones de Windows y macOS tienen algunos problemas de compatibilidad de formatos de documentos, conjuntos de características algo diferentes y diferencias en la interfaz de usuario; La versión de macOS no incluye la aplicación de base de datos MS Access, no incluye MS Publisher, y también carece de otras características (ver más abajo). Hay inconsistencias/diferencias de características en las versiones de Windows, entre la versión de venta de "MS Office 2019" y la versión de alquiler de "Office 365": algunas funciones están incluidas solo en la versión de alquiler (las funciones recientemente agregadas también difieren entre macOS y MS Windows) inconsistencias en el conjunto de características (ver más abajo).
Versiones compatibles de MS Windows	Sí. Windows 7 SP1, 8, 8.1, 10, 11, Windows Server 2008, 2012, 2016, 2019, 2022. (Las versiones hasta LibreOffice 5.4 todavía funcionan en Windows XP SP3 y Vista)	Sí. Versión de venta de MS Office 2019: Windows 10; Server 2019. Versión de alquiler de MS Office 365: Windows 7 SP1, 8.1, 10, Server 2008 R2, Server 2012, Server 2016 ([1] ).
Versiones compatibles de macOS	Sí. 10.15+ (Catalina). Intel and Apple Silicon. ([2]).	Sí. Las tres versiones más nuevas. ([3])
Versión portátil que se ejecuta en unidades USB (sin instalación)	Sí (Descargas)	No
Código Libre	Sí, con licencia de MPLv2 y otros.	No, propietario y de código cerrado
Integración completa de todos los componentes de la oficina.	Sí. Desde cada componente de la oficina, los archivos de todos los demás componentes se pueden abrir y crear de nuevo. Centro de Inicio con acceso a módulos de oficina, archivos y plantillas usados ​​recientemente.	No
Disponibilidad sin costo	Sí (Descarga) (Colabora)	No, software privativo para comprar o alquilar. Cuando finaliza la suscripción para la versión de alquiler, las aplicaciones entran en modo de solo lectura (ver o imprimir) y no se pueden crear nuevos documentos. La versión de compra es una licencia perpetua. Versión de prueba de un mes disponible para la versión de alquiler (pero no para la versión de compra única).
Disponibilidad de extensión	Sí. Ecosistema complejo de extensiones (más de 600 en extensiones.libreoffice.org y más de 800 en extensiones.openoffice.org), incluidas las actualizaciones automáticas. Las extensiones y plantillas se pueden instalar desde LibreOffice ("Gestor de Extensiones")	Parcial, No hay un sistema de extensiones centralizado para complementos y macros. Microsoft AppSource para Office 365. [4] Las aplicaciones de Office no son compatibles con macOS
Localización	Sí. 119 idiomas ( Lista detallada de soporte de idiomas en LibreOffice)	Parcial. 91 idiomas en la versión de Windows, 27 idiomas en la versión de macOS (idioma de visualización para (algunas) aplicaciones de oficina) [5], [6], [7]
Compatibilidad con idiomas (RTL) Escritura_de_derecha_a_izquierda (p. Ej., Árabe) y otras escrituras complejas	Sí. Soporte completo, basado en la biblioteca de modelado de texto HarfBuzz⁠	Sí
Ayudas de escritura adicionales	Sí. Soporte extendido (diccionarios de revisión ortográfica, patrones de división de palabras, tesauro y revisión gramatical, diccionarios especializados como extensiones ([8]). Lista detallada de ayudas de escritura de LibreOffice para más de 150 idiomas.	Parcial. "Herramientas de corrección" más limitadas para 92 idiomas en la versión de Windows o 58 en la versión de macOS [9], [10],[11]
Tecnología del lenguaje	Sí. Soporte completo, basado en la biblioteca de corrección ortográfica más popular Hunspell LibreOffice Language Technology – News & Best practices, YouTube, Hunspell 1.7, LibreOffice vs MS Office, Better coverage: words, Unicode, morphology, 3 false alarms in Word, zero in Writer	Parcial. Limitado
Compatibilidad con idiomas complejos y funciones especiales de fuente inteligente (ligaduras, mayúsculas pequeñas, números de estilo antiguo, números proporcionales o monoespaciados, espacio entre mayúsculas y superíndice / subíndice real)	Parcial. Compatibilidad total con la tecnología de fuentes SIL Graphite ([12],[13]) y compatibilidad total con las funciones opcionales de OpenType ([14],[https://docs.microsoft.com/en- us/typography/opentype/spec/ featurelist], [15]) por sintaxis y UI (tdf#58941). Consulte también LibreOffice Smart Font HowTo. Soporte para Apple Advanced Typography (AAT) disponible en todas las plataformas. Interoperabilidad: no hay soporte para las funciones opcionales de OpenType en OOXML, y ODF 1.2 no proporciona soporte para las funciones opcionales de OpenType (soporte programado para ODF más adelante)	Parcial. Limitado a través de ligaduras compatibles con OpenType, conjuntos estilísticos, opciones de espaciado de números, formas de números y alternativas contextuales. [16] Soporte para funciones opcionales de OpenType en OOXML.
Soporte de variación de fuente.	Parcial. Soporte limitado para la representación de fuentes en pantalla, sin soporte para impresión y exportación de PDF. tdf#152206	Parcial. Soporte limitado para la representación de fuentes en pantalla, sin soporte para impresión y exportación de PDF.
Fácil acceso a imágenes prediseñadas vectoriales	Sí. a través de LO Gallery (extensiones de imágenes prediseñadas ([17]) o [18]). Extensión para la integración de imágenes prediseñadas de OpenClipart.org. Control de barra de herramientas adicional para insertar Emojis (experimental: tdf#100100)	Parcial. La selección de imágenes prediseñadas necesita de la búsqueda con Bing en Imágenes Online. Selección ampliada de "iconos". Acceso a fotos de archivo (No disponible en las versiones de venta de MS Office 2019)
Lenguajes de macro / script	Sí. Múltiples lenguajes, soporte para una amplia variedad (LibreOffice Basic, JavaScript, BeanShell y Python). Importación y exportación de Visual Basic para aplicaciones (VBA), consulte ([19] y las notas de la versión).	Parcial. Lenguaje único, soporte para Visual Basic para Aplicaciones (VBA). Indirectamente también Visual Basic o Visual C # mediante el uso de la automatización.
Compatibilidad con el protocolo CMIS para acceder a los sistemas de gestión de documentos	Sí. Soporte para Alfresco, Google GDrive, Nuxeo, MS SharePoint, MS OneDrive, IBM FileNet Lotus Live Files, Lotus Quickr Domino, OpenDataSpace y OpenText ELS (tdf#62437)	Parcial. Soporte incorporado solo para MS SharePoint y MS OneDrive
Suporte para estándares ISO OpenDocument Formato (ODF)⁠	Parcial. Soporte avanzado, ODF v1.3 extendido (tdf#162118)	Parcial. Soporte limitado en la versión de MS Windows y la versión en línea, ODF v1.2. La compatibilidad con ODF en la versión macOS y las versiones móviles (Android, iOS) es limitada y requiere el uso de un servicio de conversión de formato de archivo en línea. [20] [21]
Opciones extendidas de exportación de PDF	Sí. Support of PDF standard PDF 1.7. Multiple options (Additional options: Tagged PDF, Time stamp protocol⁠, detailed image settings, Hybrid PDF, transition effects, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures, and PDF signatures according to PAdES⁠ standard). Support for font embedding of all font types (incl. OpenType CFF fonts (.otf)). Support for PDF/A-1, PDF/A-2 (archiving) and PDF/UA (universal accessibility) standards.	Parcial. High or low quality PDF, page and markup to print in Access, Word, Excel, and PowerPoint [22]; pictures resolution and non-printing informations in Publisher. No support for font embedding of OpenType CFF fonts in PDF export [23].
Clasificación de documentos	Sí. Document classification in Writer, Calc, and Impress according to TSCP-standards (also with multiple policies). See: [24] and [25].	Parcial. No inbuilt document classification system, but Information Rights Management (IRM) supported
Import of SVG vector graphics (.svg, .svgz)	Sí	Sí, .svg files supported
Import of Encapsulated PostScript (EPS) vector graphics (.eps)	Sí (with some rendering issues: tdf#81497, tdf#67464)	No. Support for .eps images entirely removed in Office 2019 and rental version ([26]). In Office 2016 sales version, it was turned off by default due to security issues, but could be manually enabled via Windows registry ([27]). There were general rendering issues of .eps files in PDF export ([28]).
Insert PDF as an image into documents	Sí ([29])	No
Creation of Hybrid PDFs (ODF file embedded in PDF for full editing)	Sí	No
Import from raster graphics software: Adobe Photoshop (.psd)	Sí	No
Import from vector graphics / DTP software: CorelDraw (v1-X7), Corel Presentation Exchange, Adobe/Macromedia Freehand (v3-11), Adobe PageMaker, Zoner/Callisto Draw (.zmf), QuarkXPress 3.1 to 4.1	Sí	No
Import of MS Visio files	Sí. Supported (Visio 2000-2013)	No (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 (.mkv), OGG Audio, Ogg Video, Quicktime Video, WebM Video, Real Audio (.ra), Real Media (.rm), Digital Video (.dv), Audio Codec (.ac3), and Ogg Opus (.opus)	Sí	No
Drawing and vector graphics software	Sí. LibreOffice Draw, drawing and vector graphics software that supports pages (up to 300cm x 300cm), layers, numerous drawing tools and DTP features.	Parcial. MS PowerPoint provides some features of a drawing software.
PIM and email software	No. Not part of LibreOffice, referring to alternative PIM software such as Mozilla Thunderbird. See the comparison on this wiki: Mozilla Thunderbird vs. Microsoft Outlook. Mail Merge Wizard sends out emails directly from LibreOffice without email software. LibreOffice-wide access to address books via Base.	Sí. MS Outlook
Desktop publishing (DTP) software	Parcial. Writer supports many advanced DTP features (see section on Writer in this comparison table). Draw supports frame-based DTP features. Import of MS Publisher files (and from other DTP software) in Draw.	Parcial. MS Publisher (MS Publisher will be retired 2026.)
Integrated Development Environment (IDE) feature set	Parcial. The BASIC Integrated Development Environment (IDE) does not have: 1. Refactoring facilities (Renaming affects dependencies/Extract Method/Extract interface etc.) (tdf#92251, tdf#94524, tdf#94526, tdf#94527, tdf#94528, tdf#94529, tdf#94530); 2. Intellisense (or any other code completion functionality) such as auto-code-completion and showing the properties and methods of an object (tdf#66185); 3. Error checking (the IDE actually knows its symbols).	Sí. Supported with Visual Basic for Applications and/or additional purchase of Office Developer Tools for Visual Studio (Windows-only). macOS version only supports a simplified Visual Basic Editor.
Import & Export of Microsoft OOXML files	Parcial. Good and extended support of real life OOXML files (e.g. .xlsx, .docx, .pptx), standardized (transitional) OOXML files, as well as import of OOXML-strict files. [30]	Sí. Advanced support of transitional (default) and strict OOXML files
PDF Import	Parcial, into Draw and Writer with the limitation that text is imported line-based (tdf#32249).	Sí, into MS Word
Synchronous collaborative editing	No. Not available in the desktop applications (tdf#133984), see development information: Collaborative Editing and Track changes. Plans for collaborative editing (Peer-to-peer collaboration) as of July 2024.	Sí. Support in desktop applications via MS OneDrive, MS SharePoint or MS Teams. Support in desktop applications varies: Real-time "co-authoring" in MS Word, MS PowerPoint, and MS Excel (only via AutoSave) [31] (MS PowerPoint 2021 sales version only allows for co-authoring (via AutoSave). Simplified "sharing" of office documents in MS Word, Excel, PowerPoint via OneDrive, OneDrive for Business, or SharePoint. AutoSave feature, which automatically saves every few seconds, is supported in MS Word, MS Excel, and MS PowerPoint, if files are stored on OneDrive, OneDrive for Business, or SharePoint Online. Supported in MS Office online versions. Collaboration with online versions is possible.
User Interface approach	Sí. Highly customizable UI concept "MUFFIN" [32],[33]: Available user interfaces: (1) Classic UI with multiple toolbars mode, and Sidebar panel. (2) Single Toolbar mode, and Sidebar panel. (3) Notebookbar Tabbed UI. (4) Notebookbar Grouped Compact UI. (5) Notebookbar Tabbed Compact UI. (6) Notebookbar Contextual Single UI (Writer and Draw). Customization possible: Several icon themes available (Karasa Jaga, Breeze, Breeze Dark, New Colibre, Elementary, Sifr, Sifr Dark, Sukapura, Tango). Colour themes "Normal" and "Dark" via Tools ▸ Options ▸ LibreOffice ▸ Application Colors. Light, dark and high contact modes Application color modes in 7.5, [34]	Parcial. Ribbon UI; Colour themes ([35]) on MS Windows: Colorful, Dark Gray, Black, White, Dark mode. On macOS: Colorful, Classic, Dark mode.
User interface improved to enable use on touch screen devices on desktop operating systems.	No (tdf#102015)	Parcial. Slightly adjusted user interface for touch screen devices, but no redesign.
Keyboard driven menu system (search function to better find features in office suite), Head-Up-Display (HUD).	Sí. It can be invoked with the menu Help ▸ Serch Commands or the shortcut ⇧ Shift + Esc. tdf#91874 blog	Sí. Tell Me search bar. Search with voice (supported in Windows rental version, not supported in MS Office 2021 sales versions; not available on macOS)
Accessibility checker	Sí. Accessibility checker and support for PDF/UA. Accessibility improvements, Accessibility checker in 7.5, [36]. Extension for text documents: AccessODF.	Sí. [37], [38].
Chat with other authors (collaborative editing)	No	Sí. In-app chat with co-authors for shared files on SharePoint Online or OneDrive for Business. Not supported for OneDrive Consumer or any other storage location. Non-persistent chat (history not preserved; new users see only newly incoming messages). (Not supported in MS Office 2019 sales version; not supported on Android and iOS).
Integration of instant Messaging (IM), voice, video, or screen sharing.	No	Sí. Skype integration (not supported in macOS version).
Dictation / speech recognition	No	Sí in MS Word, MS PowerPoint, MS Outlook [39]. Voice audio is sent to Microsoft cloud servers and returned as text. (Not supported in MS Office 2021 sales versions)
Inserting and editing 3D models	No (previous support in Impress for glTF (.dae/.kmz) 3D models removed in version 6.0)	Sí in PowerPoint, Word, and Excel. Insert animated 3D graphics in PowerPoint, Word, and Excel (Supported in Windows rental version, not supported in MS Office sales versions.)
Support of color fonts	Parcial. Support for color fonts using color layers (COLR/CPAL OpenType tables) and color bitmaps (CBLC/CBDT or sbix tables). No support for color fonts using SVGs (SVG table) and COLR version 1 format (tdf#151057).	Sí. [40]
Support of math fonts	No (tdf#103680), workaround using TexMaths extension with XeLaTeX/​LuaLaTeX compiler. [41]	Sí
Minor Feature Differences	LibreOffice 24.8	MS Office 2024 / 365
Generation of QR codes and barcodes	Sí. QR codes and one-dimensional barcodes. In Impress, Draw, Writer and Calc	Sí. [42]
Support of graphics formats: WebP	Sí	Parcial. Import only
Import of graphics formats APNG, DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM	Sí	No
Import of Classic Mac OS legacy vector and bitmap graphics formats: BeagleWorks, ClarisWorks, GreatWorks, MacPaint, MacWorks, SuperPaint, MacDraw, MacDraw II, RagTime for Mac 2-3, ClarisDraw, MacDraft	Sí	No
Import of additional video and audio formats: CD Audio, Vivo Video.	Sí	No
Drawing features: Arrow endings	Sí. Substantially wider selection, including Crow’s feet notation	No. Less supported arrow endings
Drawing features: Point Eraser, Lasso, Sketched outline style.	No	Sí. ([43]) (not available on macOS). ([44])
Drawing shapes: Sinusoid shape	Sí	No
Document metadata fields according to Dublin Core / XMP	Sí. Since LO 24.2 (tdf#138792)	No
Document converter wizard	Sí	No
Euro currency converter wizard	Sí	No
Expert config to access a multitude of settings from UI	Sí	No
Support for multiple color palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc)	Sí (note: tdf#92354)	No
Import MathML formula from clipboard	Sí	No
Import of StarOffice binary file formats .sdc, .sda, .sdw	Parcial. Basic support	No
Digital signatures / Signature Line	Sí. Multiple signatures, including OOXML signatures. Visible signatures in Writer, Calc and Draw. Round-trip with MS Office problematic (tdf#58442, tdf#58476). Import/export of PDF signatures. Support of XAdES⁠ standard (XML Advanced Electronic Signatures) and OpenPGP keys. Support for ECDSA keys (on Linux and macOS). Support for OpenPGP-based document encryption. ODF Wholesome Encryption (AES-GCM).	Sí (OOXML/XML-DSig and XAdES signatures)
Convert SVG image to shapes / polygon	Sí. Conversion supported in LO Draw. Additionally opening SVG files directly as shapes is supported in LO Draw. (tdf#115571)	Sí
Enhanced list of recent files and folders	Sí (tdf#61174, tdf#60743). Option to clear list of recent documents. Selectively delete Recent Documents (in StartCenter). Option to show office module specific recent documents. Option in start center to set recent files as permanent	Sí (option to set recent files as permanent)
Custom colors in formula editor	Sí. Full support of HTML colors in Math (RGB colors, UI in element pane) (tdf#40436)	Sí
Third-party software dependencies	Parcial. Java runtime environment (JRE) installation required for certain - but not most - features of the software. Java is notably required for Base.	Sí. Not required
Shortcut keys for accented Latin characters	No (tdf#71176), workaround using Unicode conversion, see Unicode character input with Alt+X	Parcial. Limited support
Inserting audio / video / pictures from online sources	No (tdf#42246). Work-around: Download of online video and embed it in presentation (incl. Flash videos)	Parcial [45] Insert online videos (YouTube, Vimeo, SlideShare.net) to MS Word (not available on macOS). Insert online videos (YouTube, Vimeo, MS Stream, Flipgrid) to MS PowerPoint. Insert online pictures in Word, Excel, PowerPoint.
Collaboration with @mentions in comments	No	Sí, in PowerPoint, Excel, Word, and Outlook. [46]
Task assignment using @mentions	No	Sí. Create, assign and track tasks ([47])
Like (thumbs up) reaction to comments	No	Sí, support comments with a Like reaction available in MS Word and MS Powerpoint
Quick access to email attachments	No	Sí, "Shared with me" feature in PowerPoint, Excel, Word.
Streaming of office applications/office on demand	No (possible via third party services)	Sí ([48])
Ink drawings / annotations (e.g. on touch- and pen-enabled devices)	No (tdf#35092), (only support for import of existing ink annotations from MS Word file format)	Sí. Several pens, highlighters, colors and color effects, and pencils for inking to draw/annotate/highlight. Lasso Select (free-form tool for selecting ink). Ink replay feature
Recognition of shapes from ink drawings	No	Sí. [49] supported in MS Word, MS Excel, and MS PowerPoint
Recognition of text from ink drawings	No	Sí. [50] Conversion of ink to shapes in MS PowerPoint and MS Word (Not supported in MS Office 2021 sales versions)
Automatic background removal of a picture	No (tdf#103424)	Sí. Supported in MS Windows version (not supported in macOS version)
Live preview while formatting	No (tdf#37048)	Sí
Inserting a screenshot from within applications	No	Sí
Import of graphics formats: MEZ, PCZ	No	Sí
Export to XPS format⁠	No	Sí
Support for Touch Bar on Apple MacBook Pro	No (tdf#105803)	Sí (macOS only)

Desktop Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature Differences	LO Writer 24.8	MS Word 2024 / 365
Handling of captions for graphics or image boxes	Sí. Stable layout	No. Layout problems
Styles (page styles, frame styles)	Sí	No
Overlining of text	Sí	No, but complicated workaround
Master documents for longer texts	Sí. Master documents and Master document templates supported	No. Supported but deprecated because it causes file corruption
Redaction tool / sanitization of classified information	Sí. Supported. Redaction & Automatic redaction tool	No
Register-true feature / register accuracy (DTP-feature)	Sí	No
Business card wizard	Sí (release notes)	No
Text auto completion of words already used before	Sí. [51]	No
XForms documents creation	Sí	No
Mathematical calculations in tables	Sí. Complex calculations	No. Only basic arithmetic
DocBook import & export	Sí	No
Export to MediaWiki (Wikipedia) format	Sí	No
Export to XHTML	Sí	No
Export to EPUB⁠ e-book file format (.epub)	Sí	No
Export document as image(s)	Sí. Supported, image formats: .jpg, .png	No
Import of Apple Pages documents	Sí. Support for Pages v1-5 [52]	No
Working with large documents	Sí. Stable layout	Parcial. Some layout problems [53]
Extended label creation features (release notes)	Sí (generic database access, synchronise content)	Parcial
Frames	Sí. DTP-like features like text in multiple columns and text-wrap around graphics	Parcial. Concept of "horizontal frames" is more limited
DirectCursor (allows to enter text anywhere on a page)	Sí	Sí. Supported, under the name Click and type (advanced option)
Table styles	Parcial (release notes 5.3 and release notes 6.0) (tdf#34391).	Sí
PDF export of comments	Parcial. Export of comments according to PDF specification (via "File" > "Export as PDF"). PDF export of comments: inside the margin, at end of page, at end of document (activation complicated, only via: "Tools" > "Options" > "LibreOffice Writer" > "Print" (tdf#77650))	Parcial. Export only as comments inside margin
Grammar check	Sí. 4 languages with built-in grammar checker (English, Russian, Hungarian and Brazilian Portuguese). Grammar checker LanguageTool available as server-based grammar checker (remote or on local machine) or as extension: Languagetool for server-based checking and WritingTool LibreOffice extension (new repo for LibreOffice extension) for 31 languages plus 15 language variants (level of language support varies; 11 languages with more than 1000 rules). Other grammar checker extensions available: Grammalecte for French, CoGroo for Brazilian Portuguese	Sí. 21 languages (plus 1 language variant) were supported in MS Office 2013 with additional costs) ; no information on supported languages in MS Office 2016. Grammar check on macOS version limited to few languages.
Style sets (for paragraph styles) / document themes / document styles	Sí. Supported since LO 7.6. Other solutions: Templates provide this functionality, but more difficult to handle. Helpful extension: Template Changer (tdf#89286). Bugs on document themes: (tdf#90497)	Sí. Supported ("document themes")
Use of LaTeX syntax for formulas	No. Extension: TexMaths	Sí. Ability to type math using the LaTeX syntax (Not supported in macOS version)
Vertical alignment (top/center/bottom) of content on page	No (tdf#36117), workarounds via frame/table	Sí
Picture styles & additional effects	No (tdf#59906), but effects are preserved on import and export. Glow effect and soft edges supported	Sí
View changes in the margin in "track changes" mode	Parcial Option to show track changes (additions or deletions) in margin (Tools - Options - LibreOffice Writer - View - Enable Tracked deletions in margin). Implementation misses some features, see: tdf#137770 tdf#147169	Sí
Diagonal borders in tables	No (tdf#51665)	Sí
Extended reading mode of documents	No (tdf#55168)	Sí
Collapse and expand parts of a document	Sí (tdf#135310)	Sí
Instant messaging while collaborating on document	No	Sí ([54])
Track changes only for own changes (while collaborative editing)	No	Sí. Option to track one's own changes without forcing others to track theirs ([55]). (not supported in MS Office 2021 sales versions)
Reading aloud; Text-to-speech (TTS) ability	No. Extension Read Text.	Sí ([56])
Minor Feature Differences	LO Writer 24.8	MS Word 2024 / 365
Protected cells in tables (allows better creation of forms)	Sí	No
Open erroneous .doc files	Sí. Better recovery mode ([57],[58])	No. More frequently denies opening those files
Wizard to create personalized letter templates	Sí	No
Import & Export Unified Office Format text	Sí	No
Import & Export AportisDoc (Palm), PocketWord documents	Sí. Supported (requires Java)	No
Import of AbiWord files	Sí	No
Import of eBook formats: FictionBook 2.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm)	Sí	No
Import of legacy Mac OS word processing documents: MS Word for Mac (1-5.1), MS Works for Mac (1-4), ClarisWorks/​AppleWorks, Write Now, MacWriteII/​MacWritePro, DOCMaker 4, FullWrite Professional, HanMac Word-K/J, LightWayText for Mac 4.5, Mariner Write Mac Classic 1.6-3.5, MindWrite Document, Nisus Writer Mac Classic 3.4-6.5, TeachText/​SimpleText 1, Tex-Edit 2, WriterPlus, Z-Write 1.3, eDOC 2, Acta Mac Classic, BeagleWorks/​WordPerfect Works 1, GreatWorks, MacDoc 1, MoreMac 2-3, RagTime for Mac 2-3	Sí	No
Import of DOS/Windows legacy word processing documents: Microsoft Word for DOS, Microsoft WinWord 5, Microsoft Word 6.0 / 95, Microsoft Write, Hangul WP97, Text 602 (T602), Lotus WordPro	Sí	No
Logo toolbar and interpreter	Sí [59]	No
Format text of all comments in document	Sí	No
Comments in headers and footers	Sí	No
Text boxes allow multiple columns	Sí	No
Markdown feature to automatic format *bold*, /italic/, -strikeout- and _underline_	Sí. (How to switch on the feature). See also tdf#133023	No
PDF export preserves footnote/​endnote anchors	Sí. Links between anchors and footnotes or endnotes (even if not on the same page) are available in both direction.	No
Conditional text	Sí ([60], [61](PDF) [62])	Parcial ([63], [64])
Automatic replacement of Emojis	Sí. supported. Additional toolbar control to insert Emojis (experimental: tdf#100100)	Parcial. Manual creation of replacement lists
Number of columns per table in document	Sí. Unlimited columns	Parcial. Limited to 63 columns
Multi-line headings for chapters	Sí. Multi-line headings for chapters by allowing a line break as separator between a chapter number and its name (in Heading Numbering dialog)	Parcial. Only via work-around [65]
Maximum page size	Sí. 300cm x 300cm	Parcial. 55.87cm x 55.87cm
Bibliographic features	Parcial. Basic inbuilt support. Excellent free extensions: e.g. Zotero, JabRef as well as proprietary extensions. Work has been done to better integrate Zotero in LibreOffice [66]. DOI citation recognition (tdf#145925).	Sí. Inbuilt support. Excellent free extensions: e.g. Zotero as well as proprietary extensions.
Advanced find & replace / Special characters	Parcial (tdf#38261). See List of Regular Expressions. Extension: Alternative dialog Find & Replace for Writer	Sí
Complex Outline numbering / Multilevel list	Parcial. Different numerically equivalent format not supported (tdf#35217)	Sí
Default keyboard shortcuts	Parcial. Less default shortcuts ([67])	Sí. More default shortcuts ([68])
Add watermarks to pages	Parcial. Support for text watermarks. Workaround for picture watermarks via adding image to header/footer.	Parcial (text and picture watermarks). This is not possible on Chromebooks as there is no app, Word for the web cannot do watermarks
Outline view	Parcial Outline folding mode [69] (tdf#135310, alternative feature: Navigator > Content View to drag and promote/demote headings (see Improvements to Navigator in 7.0)	Sí
Complex/rich text formatting in comments (e.g. bullet points, text color, images, tables)	No. Some formatting features are supported, e.g. font type, font size, bold, italics, underline, text alignment (align, centered, justified). (tdf#81458)	Sí
Document/text translation	Sí Initial machine translation is available, backend by DeepL translate. Other extension: TradutorLibreText.	Sí ([70])
Decorative page borders	No (tdf#39270)	Sí
Horizontal split view of the same document	No (tdf#31481), workaround: Windows > New Window to clone document window.	Sí
Draft view	No (tdf#67698)	Sí
Upload to blog servers	No, extension: Sun Weblog Publisher (outdated).	Sí (MS SharePoint Blog, Telligent-Community, TypePad, WordPress, MetaWebLog API)
Digital pen usage / ink gestures	No	Sí. [71] (Not supported in MS Office 2021 sales version and not supported in macOS version)
Transform document into a Sway web page	No	Sí. supported in MS Word. (Not supported in MS Office 2021 sales version and not supported in macOS version)
Line by line reading of text	No	Sí. Line Focus (removes removes distractions) feature in MS Word.
'File name without extension' field	Sí. [72]	No. [73] [74]

Desktop Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences	LO Calc 24.8	MS Excel 2024 / 365
Spreadsheet functions (for details see Functions comparison of LibreOffice Calc and Excel)	Sí. 517 functions (30 functions unique to Calc) See an extensive description of Calc Functions	Sí. 492 functions (30 functions unique to Excel)
Unique Spreadsheet functions	Sí. ACTUAL; DIASENMES; DIASENAÑO; DDE; DOMINGOPASCUA; PRONOSTICO.ETS.MULT; PRONOSTICO.ETS.ESTADISTICA.MULT; PRONOSTICO.ETS.PI.MULT; FOURIER; VALORPRETENDIDO; ESAÑOBISIESTO; MESES; OPERACION.MULTIPLE; MULTIRANGO; MVALOR; NEG; OPT_BARRIER; OPT_PROB_HIT; OPT_PROB_INMONEY; OPT_TOUCH; ALEATORIO.NV; ALEATORIO.ENTRE.NV; RESTA.BRUTO; EXP.REG; ROT13; REDONDEAR.PRECISION; ESTILO; SEMANAS; SEMANASENAÑO; AÑOS. Extensions: Kanji to Phonetic provides PHONETIC function; Lox365: XLOOKUP for LibreOffice provides IMAGE, TEXTSPLIT, TOCOL.	Sí. CUBE­KPI­MEMBER, CUBE­MEMBER, CUBE­MEMBER­PROPERTY, CUBE­RANKED­MEMBER, CUBESET, CUBESET­COUNT, CUBEVALUE, RTD, DBCS, CALL, REGISTER.ID, PHONETIC; YEN; TEXTBEFORE (tdf#150864); TEXTAFTER (tdf#150865); TEXTSPLIT (tdf#150866); VSTACK (tdf#150867); HSTACK (tdf#150868); TOROW (tdf#150878), TOCOL (tdf#150879); WRAPROWS (tdf#150880); WRAPCOLS (tdf#150881); TAKE (tdf#150997); DROP (tdf#150998); CHOOSEROWS (tdf#150999); CHOOSECOLS (tdf#151000); EXPAND (tdf#151001); IMAGE (tdf#129129); the following functions are only available in MS Office 365 rental version, not in MS Office 2024: STOCKHISTORY GROUPBY (GroupBy), PIVOTBY (PivotBy), PERCENTOF (PercentOf) aggregation functions (tdf#161159).
Dynamic arrays	No (tdf#127808)	Sí. ([75]) Spilled range reference operator “#” (tdf#161399); Implicit intersection operator “@” (tdf#161470); Formulas that return more than one value but cannot populate all the adjacent cells will return error “#SPILL” (tdf#158620).
Dynamic charts (referencing dynamic arrays)	No	Sí([76])
Picture / image in a cell	No	Sí, via IMAGE function or via insert image ([77])
Comparison of two spreadsheet files	Sí	No
Page styles (in addition to cell styles)	Sí	No
Hyphenation of text in cells	Sí	No
AutoSpellcheck / Spelling as you type	Sí	No ([78])
Export to XHTML	Sí	No
Full-Sheet Previews: Possibility to export all pages on a sheet as one page in the PDF	Sí	No
Exporting of a single chart as image (e.g. jpg, png, svg, pdf)	Sí	Sí. [79]
OpenFormula standard	Sí. Largely supported	Parcial
Keep the copy of cells (usability of copy&paste)	Sí. (Copy of cells is kept for pasting, even if the user does other tasks like typing or inserting cells)	No ([80])
Import of Apple Numbers spreadsheet documents	Sí. Support for Numbers v1-3 [81], see also this comparison	No
Maximum number of columns per sheet	Sí. 16,384. Jumbo spreadsheets supported since LO 7.4, see: [82], tdf#133764.	Sí. 16,384 (256 in compatibility mode)
Declaration of variables to be used in formulas	Parcial. LET function (tdf#137543).	Sí. LET function; Recursive LAMBDA and ETA-LAMBDA (“eta reduced lambda”) hyperfunctions with BYCOL (ByCol), BYROW (ByRow), ISOMITTED (IsOmitted), MAKEARRAY (MakeArray), MAP, REDUCE, SCAN helper functions (tdf#138749) and aggregation functions (tdf#161159).
Table styles	Parcial. View ▸ Toolbars ▸ Tools ▸ Choose Themes as well as Format ▸ AutoFormat provide part of this functionality. (tdf#77569, tdf#44762, tdf#44763, tdf#66377)	Sí
Record a macro	Parcial. Limited support [83]	Sí
Insert a graphic into a spreadsheet header or footer	Parcial. Inserted image cannot be resized nor cropped, usability issues. (tdf#74146)	Sí
Statistical / Analysis toolkit	Parcial. Built-in Data Statistics Wizard with additional features: Chi2-test, Logarithmic regression, Power regression	Parcial. Add-on, not activated by default. Additional features: Histogram, Random number generation, Rank and percentiles, and some more detailed options.
Allow expressions with references in inline arrays, not only constants	No (tdf#105683, tdf#161841)	Sí
Chart styles	No (tdf#62925, tdf#62540, tdf#39097)	Parcial. Selection of some pre-set chart styles and layouts
Power Pivot⁠ features	No (tdf#96623 regarding DAX functions)	Sí
Additional chart types: Waterfall, Histogram, Pareto, Box & Whisker (Box plot), Treemap (Mosaic), Sunburst, Funnel	No (tdf#74665, tdf#81530, tdf#70361, tdf#72992, tdf#97832)	Sí
Relationships between tables, based on matching data in each table	No (work around: using function VLOOKUP)	Sí ([84])
Integration of external data sources	No. Extension: New Jaguar Calc add-in provides SQLREQUEST function and Queryconnector provides graphical interface.	Sí. Queries and data sources via "Power Query" and "Power BI" [85]. (SQL.REQUEST removed in favor of Power Query since MS Excel 2010)
Linked data types	No	Sí. Data types from online sources: geography, stocks, organization, location, zip code, university, space, satellite, element, chemistry, food, exercise, movie, characters, medical, body, media, nature, activities, other (Not available in MS Office 2021 sales versions) [86],[87]
Forecasting data to predict future trends	Sí. Extended set of forecast functions (based on exponential smoothing algorithm)	Sí. Forecast functions and forecast charts (based on exponential smoothing algorithm) (not supported in macOS version)
Import MS Access databases	Parcial. Via ODB file connected to database (needs MS Access installed on the system)	Sí
Multi-Core Processing / multithreading	Parcial. Multithreading works, but some bugs remain tdf#114159. Further information: Multi-threaded calculation [88]. Multi-threaded import of XLSX documents Parallel formula compiling on the CPU. OpenCL/GPU threading in Calc core ([89],[90]) Presentation 2016 "Exploiting concurrency", Presentation "Making Calc Calculate in Parallel".	Sí. Starting in Excel 2010, the following features use multi-core processors: saving a file, opening a file, refreshing a PivotTable (for external data sources, except OLAP and SharePoint), sorting a cell table, sorting a PivotTable, and auto-sizing a column. For operations that involve reading and loading or writing data, such as opening a file, saving a file or refreshing data, splitting the operation into two processes increases performance speed. The first process gets the data, and the second process loads the data into the appropriate structure in memory or writes the data to a file. In this way, as soon as the first process begins reading a portion of data, the second process can immediately start loading or writing that data, while the first process continues to read the next portion of data. Previously, the first process had to finish reading all the data in a certain section before the second process could load that section of the data into memory or write the data to a file. ([91], [92])
Data-linked creation of flowcharts	No	Sí. Flow charts and organizational charts (supported in rental version, not supported in MS Office 2021 sales versions)
Export generic XML	No	Sí
Customized sheet views (while collaborative editing)	No	Sí ([93])
Minor Feature Differences	LO Calc 24.8	MS Excel 2024 / 365
Flexible CSV export	Sí. Supported ([94], [95])	No
Advanced find & replace / regular expressions / special characters	Sí (List of Regular Expressions)	No
View clone of spreadsheet in new window	Sí. Independent window	No. Cannot be moved outside the application window
Median in PivotTable	Sí. tdf#61700	No. [96]
Chart type Stepped lines for XY (Scatter) graphs	Sí	No
Use English function names	Sí. Possibility to switch between function names in local language and English	No
Import & Export Unified Office Format spreadsheet	Sí	No
Import of DOS/Windows legacy spreadsheet formats: Lotus 1-2-3, Quattro Pro (v1-5.5 DOS; v1.0-6.0 Windows), Microsoft Works spreadsheet, Microsoft Multiplan (v1-3 DOS)	Sí	No
Import of Classic Mac OS legacy spreadsheet formats: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz, Microsoft Multiplan (v1.11)	Sí	No
Import & Export Pocket Excel	Sí. Supported (requires Java)	No
Ability to rotate entire chart	Sí	No
PDF export of comments	Sí. Export of comments according to PDF specification	No
Property mapping functionality for charts (conditional chart colors/borders)	Sí	No (Only available: Inverting colors for negative values)
Import from Gnumeric	Sí (not available on Windows, see tdf#94834)	No
Export cell range selection or a selected group of shapes (images) as .png or .jpg image	Sí	No
Export sheet/table as .png image	Sí	No
Formatting of cells	Sí. More detailed: Number formats: more flexible use of "Format Code" for custom adjustments, leading zeroes, language setting, percentages without percentage sign, thousands separator for percentages; Font: overligning of text, relief (embossed, engraved), outline, shadow, underline of individual words, spacing settings, kerning; Borders: shadow, spacing to contents; Protection: hide cells when printing.	Parcial. Less features
Additional cell format types	Sí. Number format "Boolean value". Engineering notation. Natural language number format (spelling out numbers in various languages, spell our number and currency formats in 7.5. Easy work around for missing US zip code and US phone number formats.	Parcial Engineering notation via custom formats.
Support negative year date (BCE)	Sí	Parcial Using work-arounds.
Conditional formatting: icon sets	Sí. 2 additional smilies icon sets.	Sí.
Advanced find & replace / Cell Format	Parcial (Styles supported, Cell Format not supported)	Sí
Formulae with entire columns or entire rows	Parcial (tdf#34094, tdf#92452, tdf#92453)	Sí
Default keyboard and/or mouse shortcuts [97]	Parcial. Less default shortcuts ([98], tdf#98259, tdf#92452, tdf#92453)	Sí. More default shortcuts ([99], [100], [101])
Sheet protection options (allow users certain actions in protected sheets)	Parcial. Supported for select protected/​unprotected cells and insert/delete rows/columns.	Sí for select protected/​unprotected cells, insert/delete rows/​columns, format cells/​columns/​rows, insert hyperlinks, sort, use AutoFilter/​Pivot Table reports, edit objects/​scenarios.
Timeline filter in PivotTable	No	Sí. [102]
Chart: Automatically vary colours by point	No (only manually)	Sí
Chart type: xyz / surface charts	No, basic workaround [103] (tdf#51670)	Sí
Map charts and 3D geospatial visualization tool	No (tdf#160398; via extension: GeOOo)	Sí. Map charts and "3D Maps".
Different chart types for different data series	No (tdf#35629)	Sí
Printing of selected chart only	No, workarounds [104], [105] (tdf#45893)	Sí
Chart data labels "Value as percentage"	Sí	No
Chart data labels "Value from cells"	No	Sí
Automatized analysis and visualization features	No	Sí. Quick analysis feature and visual summaries, trends, and patterns. [106], [107]. Some of these features ("Ideas in Excel") supported in rental version, not supported in MS Office 2021 sales versions; quick analysis feature not supported on macOS.
Flash fill	No (tdf#109003). Some (partial) workarounds suggested here tdf#109003#c1.	Sí
Chart recommenda­tions	No	Sí
'Publishing' spreadsheet for online team meetings	No	Sí
Sparklines (to give a quick overview of the trend in a data range)	Sí. [108]	Sí
Add points to a line, possibility to bend lines	No (tdf#36943)	Sí
Cell background options	Parcial. Background color (bugs regarding pattern tdf#31205 and gradient tdf#49177). Extension: Hatch Patterns for Cells	Sí. Background color, pattern, gradient
Insert data from screenshot or picture	No	SíOCR and recognize tables from screenshots or pictures [109] (Not available in MS Office 2021 sales versions and only available on macOS)
Automatic recalculation on file open when flag is set	No (tdf#144819)	Sí

Desktop Presentation software: LibreOffice Impress vs. Microsoft PowerPoint

Major Feature Differences	LO Impress 24.8	MS PowerPoint 2024 / 365
Hyphenation support	Sí	No
Export to XHTML	Sí	No
Export to HTML	Sí	No (removed feature since MS Office 2013)
Export to vector graphic formats: SVG, EPS	Sí	Parcial, to SVG (Supported in Windows rental version, not supported in MS Office sales versions.)
Presentation remote control for smartphones/​tablets	Sí. For Android smartphones/​tablets, iOS (iPhone/iPad), and Pebble smartwatches.	Parcial. For Android (smartphones only), but with additional features for Excel and Word. (Not supported in macOS version).
3D slide transitions	Sí. ​macOS, Linux, Windows	Parcial. ​macOS, Windows
Edit embedded videos	Parcial. Via external programs	Sí. Directly in the program
Comments and reply to comments	Parcial	Sí
Color/document themes	Parcial support of document themes in Impress: [110] [111]	Sí
Animated effects	Parcial. Supported, but problems with: spinning text (tdf#87958), pixelated (tdf#87959), wobble/​shake/​vibrate (tdf#87960), objects stuck (tdf#88196)	Sí
Trim embedded video or audio	Sí Impress now supports cropped video for media shapes.	Sí. Supported (Not supported in MS Office 2016 sales version)
Zooming features for presentations (Prezi inspired)	No (tdf#38263)	Sí. Supported (Not supported in macOS sales version) [112]
Slides editable during presentation	Sí. Live-mode slideshow editing, new in LibreOffice 24.8. Fixed: tdf#34965.	Sí
Include the camera input of the presenter in the slide show	No	Sí, it is possible to include the live camera feed directly on a slide. Feature only available if subscribed to the rental version ([113])
SmartArt diagrams	No (tdf#37932), solution: smArt extension	Sí
Save highlights and drawings during presentation	No (tdf#51928)	Sí
Compare presentations	No	Sí
Broadcast presentation on the Internet	No. Only via export to PDF or SWF	Sí. Additional support to publish to Microsoft Stream video-sharing site (Not supported in macOS version)
Animated diagrams	No	Sí
Record a slide show	No (tdf#34959)	Sí. ([114], [115]).
Slide design suggestions	No	Sí via PowerPoint "Designer" (not supported in MS Office 2021 sales versions)
Navigate presentation using a Bluetooth pen	No	Sí. Supported with Bluetooth pen or Surface pen. Using digital pen as a slide-show clicker (Not supported in macOS version)
Optimization of slides for screen readers	No	Sí. ([116]) (not available on macOS)
Minor Feature Differences	LO Impress 24.8	MS PowerPoint 2024 / 365
Number of slide layouts	Sí. 12	Parcial. 9
Physics based animations	Sí. [117]	No
Text background colour in text boxes	Sí	No
PDF export of comments	Sí. Export of comments according to PDF specification	No
Import & Export Unified Office Format presentation	Sí	No
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM	Sí	No
Import of Apple Keynote files	Sí. Support for Keynote v1-6 [118]	No
Embedding of fonts in presentation file	Sí	Parcial. Supported on Windows. No support for embedding fonts in PowerPoint on macOS, although displayed. No support for embedding OpenType CFF fonts. [119]
Maximum page size	Sí. 300cm x 300cm (Draw and Impress)	Parcial. 142.22cm x 142.22cm
Editing of master slides	Parcial. Limited editing, has been a GSOC 2013 project ([120]).	Sí. Powerful editing
Default keyboard shortcuts	Parcial. Less default shortcuts ([121])	Sí. More default shortcuts ([122], [123])
Closed captions or subtitles to media	No	Sí, to audio and video files in presentations ([124]).
Conversion of hand-drawn shapes into diagrams / recognition of ink equations	No	Sí. [125] Conversion of ink to shapes/​diagrams in MS PowerPoint; Ink equations (conversion of drawing to equation) in PowerPoint. (Not supported in MS Office 2021 sales versions and only available on Windows 10/11; not supported in macOS sales version).
Automatically suggesting presentation outline from online sources by entering subject	No	Sí. "QuickStarter feature (Not supported in MS Office 2016 sales version and not supported in Windows version)
"Morph" transition type	No	Sí. [126]
Creation of automatically starting presentations	No, extension: ImpressRunner	Sí
Export presentation to video formats	No (tdf#34959)	Sí. Supported to .mp4 and .wmv formats. Export up to 4K resolution.
Slide zoom and pan	No (tdf#150383)	Sí
Option to save as picture presentation	No (tdf#93589)	Sí
Using Surface Earbuds to control presentation	No	Sí[127]
Autogeneration of alt text for photos	No	Sí [128] (Supported in Windows rental version, not supported in MS Office sales versions; not supported on macOS)

Desktop Database program: LibreOffice Base vs. Microsoft Access

Major Feature Differences	LO Base 24.8	MS Access 2024 / 365
Available on all operating systems supported by the office suite	Sí	No. MS Access not available on macOS, online and mobile OS versions
SQL syntax highlighting	Sí	No
Native connectors for: MariaSQL, PostgreSQL, Novell GroupWise	Sí. Plus MySQL as extension. [129]	No, via ODBC
Integration of Mozilla Thunderbird address book, KDE address book, Evolution LDAP and storage, Windows system address book	Sí	No
Native JDBC driver	Sí	No
Connect to ODF spreadsheet (Calc) file format	Sí	No
Database engine	Sí. FirebirdSQL 3.0; HSQLDB 1.8.x (deprecated). In LibreOffice 6.2 FirebirdSQL is the default for new databases. Firebird Migration Assistant converts HSQLDB databases to FirebirdSQL	Parcial. Jet
Integration of MS Outlook address book	Parcial. Supported only on MS Windows. No support for Outlook (tdf#56903) and Outlook Express (tdf#56905) address book access in the native 64-bit Windows builds of LibreOffice.	Sí
Importing data sources (tables) from within the database application	Parcial. Either via drag & drop from Calc or via drag & drop from another Base window with the data source being open. ([130]) (tdf#51872)	Sí
Exporting tables to different file formats from within the database application:	Parcial. Only via drag&drop to LibreOffice Calc or via drag & drop from another Base window with the writable data source being open. ([131]) (tdf#73798)	Sí
Edit MS Access files	Parcial. via "Microsoft.ACE.​OLEDB.​12.0" with read/write access to MDB and ACCDB files (Editing MS Access through 64-bit ODBC doesn't work tdf#148367). Driver works on Windows only.	Sí
Native connector for: Microsoft SQL Server	No, via ODBC	Sí
Crosstab queries	No. Not supported but reproducible with Pivot Table with Calc (FAQ 142 )	Sí
"Linked tables" capability	No. Not supported but you can link text tables (FAQ 143) (tdf#56234)	Sí. Linked tables and Linked Tables Manager.
Imported table from spreadsheets - keep fields format	No	Sí
Import data from XML, HTML	No	Sí
Minor Feature Differences	LO Base 24.8	MS Access 2024 / 365
Native connector for: dBase databases	Sí	No. Not supported (removed feature since Office 2013)
Open LibreOffice Base (.odb) files	Sí	No
Open DOS/Windows legacy formats: Microsoft Works database	Sí	No
Native connector for: SharePoint lists	No	Sí
Link or import data from Salesforce and Dynamics 365	No	Sí
Web service data connection	No	Sí
Password protection of database	No (tdf#70638)	Sí
Cálculos en tablas de bases de datos	No (tdf#72787)	Sí

Extensiones más importantes de LibreOffice

LibreOffice tiene un ecosistema complejo de extensiones (más de 600 en extensions.libreoffice.org y más de 800 en extensions.openoffice.org). Además de las extensiones ya mencionadas en la tabla de comparación anterior, aquí hay una selección de algunas extensiones que agregan características valiosas a LibreOffice:

	Extensiones para LibreOffice
Paquete de oficina general: LibreOffice	Descripción general de las extensiones relacionadas con el idioma para LibreOffice (Ayudas para la escritura, diccionarios, revisión ortográfica, patrones de separación de sílabas, revisión gramática, ...) Barcode Permite insertar código de barras en documentos de LibreOffice OpenOffice.org2GoogleDocs exporta, actualiza e importa documentos hacia y desde los servidores de Google Docs, Zoho y WebDAV. TeamDrive permite compartir espacios en el software de colaboración TeamDrive. Wollmux es un complejo sistema centralizado de plantillas, formularios y membretes desarrollado por la ciudad de Munich (en alemán e inglés). Página web (alemán) -- Repositorio (inglés) eLAIX permite a los usuarios escribir y leer módulos de aprendizaje ILIAS sin conexión y exportarlos al formato de archivo de libro electrónico ePUB3. GUI de instalación de LibreOffice Server facilita las instalaciones paralelas y de servidor de LibreOffice. Shared Technical Terminology Thesaurus Tesauro de terminología técnica Leer texto. Lea la selección de texto con Calc, Draw, Impress, Web Writer y Writer utilizando síntesis de voz. Custom Palette Export (permite compartir fácilmente paletas de colores personalizadas) OOoLilyPond, use la notación musical LilyPond dentro de LibreOffice.
LibreOffice Writer	TexMaths agrega un editor de ecuaciones (Xe) LaTeX a LibreOffice [https://extensions.libreof fice.org/extensions/dmaths DMaths] agrega una completa caja de herramientas matemáticas a LibreOffice Writer Chemistry permite insertar fórmulas químicas como imagen de fórmula. Code Colorizer Formatter, Code Highlighter o COOoder proporcionan resaltado de sintaxis para LibreOffice Writer. AddPics crea un documento de Writer a partir de imágenes de páginas escaneadas. Writer's Tools es un conjunto de utilidades para escritores frecuentes. AltSearch Alternativa más completa para Buscar y reemplazar en Writer. Barra de herramientas de tipografía Corrige problemas tipográficos y usa las funciones avanzadas de la fuente inteligente Graphite. Generador de códigos QR Transcriber, herramienta de transcripción para archivos de audio. Organon, herramienta de organización y navegación para organizar textos largos (novelas, narraciones, trabajos científicos). Template Changer, permite cambiar la plantilla de un documento existente. Libre OCR permite convertir imágenes en documentos editables utilizando un servicio de OCR externo (basado en Tesseract OCR). Footswitch. Una herramienta de transcripción que funciona íntegramente dentro de LibreOffice Writer. TradutorLibreText. Herramienta para traducir textos en varios idiomas. Herramienta TAO Anaphraseus. Conjunto de macros para traducción asistida por ordenador similar al famoso Wordfast. Writer Rotation Tool, permite rotar una imagen en un documento de texto usando el mouse, como otros objetos gráficos. Filtros de formato de archivo Export Freemind permite exportar documentos de Writer a Freemind Mind Manager. Writer2LaTex permite exportar documentos de Writer a LaTex. Writer2ePub permite exportar a un ePub estándar de libro electrónico gratuito y abierto.
LibreOffice Calc	Power Detective mejora Detective / Trazar Precedentes y Trazar Dependientes. GeOOo permite crear mapas temáticos con LibreOffice. CorelPolyGUI: líneas de tendencia de gráfico mejoradas: línea de tendencia polinomial, intercepción forzada de la línea de tendencia y línea de tendencia de media móvil (la mayor parte de su funcionalidad está incluida en LibreOffice 4.2) PalOOCa OLAP Calc Extension: Conexión de Calc para acceder a servidores OLAP compatibles con Palo o XMLA. SMF extension: agregue funciones a Calc que permitan la recuperación de datos del mercado de valores. Mostrar fórmula y resultado (valor) simultáneamente Digitalizador de gráficos XY LibreWeb, una herramienta para llenar celdas de hojas de cálculo con datos de diferentes páginas web. Remove Duplicates, elimina rápidamente los duplicados en Calc. New Jaguar Calc add-in proporciona la función SQLREQUEST a Calc. Filtros de formato de archivo: Calc2LaTeX permite convertir tablas Calc a LaTeX.
LibreOffice Impress	Export as Images permite exportar todas las diapositivas de Impress o páginas de Draw como imágenes en formatos JPG, PNG, GIF, BMP y TIFF. OpenCards es un software gratuito de aprendizaje mediante de tarjetas de memoria (flashcards).
LibreOffice Draw	Barcode permite a LibreOffice agregar códigos de barras a los documentos. GeOOO permite la creación de mapas temáticos con LibreOffice Draw. Cadlo permite realizar dibujos técnicos en LibreOffice Draw. Filtros de formato de archivo: Importación de archivos GEDCOM para Draw. Importación de archivos Google Earth (kml) en Draw. Contenidos de Galería, formas y plantillas : Libre Symbols Galery -- Un conjunto de temas de galería para dibujar diagramas como diagrama de circuitos electrónicos. [https://extensions.libreoffice.org/extensions/vrt-network-equipment Formas de equipos de red para LibreOffice]. 1600 mapas, diagramas, gráficos, para geografía e historia. Todos los países, todos los estados, todas las regiones y todos los períodos históricos.
LibreOffice Base	Access2Base VBA para el emulador de MSAccess. (instalado de forma predeterminada en LibreOffice 6.2; disponible para descargar para versiones anteriores a 6.1) BaseDocumenter documentan completamente una aplicación de LibreOffice Base.
Extensiones de accesibilidad	odt2daisy, convierte OpenDocument Text (ODT) en libros parlantes digitales en formato DAISY (DAISY 2.02, DAISY 3.0 XML y Full DAISY 3.0) para síntesis de voz. Leer texto, utiliza un programa externo o un servicio web para leer texto. Lea la selección con Calc, Draw, Impress, Web Writer y Writer. AccessODF, ayuda a los autores a evaluar y reparar problemas de accesibilidad en OpenDocument Text y otros formatos de procesamiento de texto compatibles con Writer. odt2braille, permite a los autores imprimir documentos en una impresora Braille y exportar documentos como archivos Braille. La salida de Braille está bien formateada y es altamente personalizable.

Mobile office: Smartphones, Tablets

Mobile Office suite, general features: LibreOffice vs. Microsoft Office

The comparison table of mobile office is Work in Progress. Please feel free to improve it!

Major Feature Differences	Mobile: LibreOffice-based solutions	Mobile: MS Office 365
Integrated office architecture	Sí. Integrated office architecture: LibreOffice mobile shares the same processing engine, common to all modules, on all form factors (incl. desktop and online) [132].	No. Loose architecture differing between desktop (different between Windows and macOS), mobile and online office.
Versions of office suite for mobile operating systems (smartphones, tablets)	Sí. Mobile applications available as LibreOffice-based Collabora Office. LibreOffice viewer available for iOS/iPadOS and Android. Android: Collabora Office on Google Play available for smartphones and tablets, release announcement (2019-12-10). LibreOffice Viewer for Android available, with basic and experimental editing features. Information on new LibreOffice Android app: [133]. More information: Android port wiki, Commits , [134], [135]. iOS/iPadOS: Collabora Office for iPhone and iPad available: Collabora Office in the Apple AppStore. More information: Collabora press release, Adfinis press release, LibreOffice as an iOS app on the iPad; Announcement for iOS; Commits: [136], [137]. ChromeOS: ChromeOS support is available in both Android and/or Linux on ChromeOS. Option 1) Android version optimised for ChromeOS is available as Collabora Office on Google Play, more information, XDA News Portal. Option 2) The full LibreOffice desktop version can be installed in Linux on Chromebooks.	Parcial. Android and iOS for smartphones and tablets with restricted features set. No support for ChromeOS when offline. No support for ChromeOS on tablets. Professional users as well as users on tablets >10.1 inch are required to have an eligible Office 365 subscription at a monthly fee. Private users are allowed to view and print documents without registration private users, basic editing functionality requires registration. More comprehensive features require an eligible Office 365 subscription at a monthly fee.
Support of Right-to-left⁠ (RTL) languages (e.g. Arabic) and other complex scripts	No	Sí
Minor Feature Differences	Mobile: LibreOffice-based solutions	Mobile: MS Office 365
Run Microsoft Visual Basic Macros.	Sí. Support for a large portion of Microsoft Visual Basic Macros (via Collabora Office).	No

Mobile Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature Differences	Mobile: LibreOffice-based solutions: Writer	Mobile: MS Word 365
Open password protected documents	Sí. (via Collabora Office)	No
Minor Feature Differences	Mobile: LibreOffice-based solutions: Writer	Mobile: MS Word 365
XY	Parcial	Parcial.

Mobile Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences	Mobile: LibreOffice-based solutions: Calc	Mobile: MS Excel 365
XY	Parcial	Parcial.
Minor Feature Differences	Mobile: LibreOffice-based solutions: Calc	Mobile: MS Excel 365
XY	Parcial	Parcial.

Mobile Presentation software: LibreOffice Impress vs. Microsoft PowerPoint

Major Feature Differences	Mobile: LibreOffice-based solutions: Impress	Mobile: MS PowerPoint 365
XY	Parcial	Parcial.
Minor Feature Differences	Mobile: LibreOffice-based solutions: Impress	Mobile: MS PowerPoint 365
XY	Parcial	Parcial.

Online office: Web browser (and Chromebooks)

The comparison table of online office is Work in Progress. Please feel free to improve it!

Chromebooks are in this Online office suite section for several reasons: LibreOffice core software is available as a Chromebook App from Collabora Productivity by the name of Collabora Office, it is the same software as used in the Online suite with some optimisations for ChromeOS. In Sept 2021 Microsoft announced the discontinuation of their Chromebook App. By combining Online and Chromebook Apps in this table it enables the easy comparison of LibreOffice based office suites to Microsoft's Online when using a Chromebook.

Online Office suite, general features: LibreOffice Online vs. Microsoft Office for the web

Major Feature Differences	Online: LibreOffice-based Collabora Online 23.05 Chromebook App: Collabora Office	Online: MS Office for the web Chromebook App: Discontinued
Integrated office architecture	Sí. Integrated office architecture: Online LibreOffice shares the same processing engine, common to all modules, on all form factors (incl. mobile and desktop) [138].	No. Loose architecture differing between desktop (different between Windows and macOS), mobile and online office.
Online/cloud version of office suite	Sí. Libreoffice-based Collabora Online with full document support and rendering fidelity, as well as collaborative editing. Advanced but reduced editing functionality compared to the desktop version. Online version supports Vereign compatible authentication & document signing. [139], [140], [141], [142], [143], [144]. See also: LibreOffice Online port development.	Parcial. Office web apps, with reduced functionality when compared to the Word desktop version and Collabora Online. ([145])
Applications	Sí. Writer, Calc, Impress, (Draw publishing capabilities are built in to Writer).	Sí. Word, Excel, PowerPoint, Outlook, Teams
File format support equivalence to desktop	Sí. Supports opening file formats of many office suites and other applications with over 150 extensions supported. (LibreOffice supported file formats) (via Online and Chromebook App)	No
Integration of online office suite into (third-party) collaboration software and groupware / content management systems	Sí. Integration of LibreOffice Online in: OwnCloud and Nextcloud, Kolab, Pydio, Seafile, IceWarp, AG-I Solutions, Alinto, VNCLagoon, EGroupware, Univention App Center, Kopano Documents, Collabora Online, Corteza Community Server, Alfresco ([146]), Roove, Zimbra ([147]), Mastermost, Moodle, IServ Schulserver. MS SharePoint integration SharePoint 2016 Server. See also these lists: Collabora Online hosting partners, Collabora Online partners, Availability of LibreOffice Online.	Parcial. MS Office Online Server integration in MS SharePoint
Availability of online office suite in (third-party) online services / Free & commercial office cloud hosts	Sí. Variety of available service providers: UrBerri, eqipe, New Access, Arawa, Artistanbul, TransfertPro, Extensys, Rono-IT, SecuredStore, StudioStorti, united hoster, Option Service Télécom, AggreCost, Webo.hosting, FileCloud, Retention Range, Workman.net.au, OffiDocs, CiviHosting, ETES, Sunjun, opendsi, GMS, OpenLogic, SwissStash, iOffice Cloud, cloudplan, EGroupware, ZenTao, SwissVON, CQ Net, Mijncloudoffice, mentorITe, PowerFolder, GMX Online Office, Mail.com Online Office, Web.de Online Office, hostiso.com, Kolab Now, Crest Tech. See also these lists: Collabora Online hosting partners, Collabora Online partners, Availability of LibreOffice Online.	Parcial MS OneDrive
Synchronous collaborative editing	Sí. Supported in online versions of Writer, Calc and Impress. Editing in real-time and interactively with no extra lag or latency to see other users’ typing avoiding the need for paragraph locking and conflict resolution issues.	Parcial. Supported in MS Word, Excel and Powerpoint, it is not possible to edit in real-time and interactively without delays to see other users’ typing, and due to this there can be file conflicts that require investigation and resolution to avoid data loss.
Support of Right-to-left⁠ (RTL) languages (e.g. Arabic) and other complex scripts for all Document Types	Sí. Comprehensive support, based on HarfBuzz⁠ text shaping library (from Collabora Online release 21.11). (via Online)	No
Minor Feature Differences	Online: LibreOffice-based Collabora Online 23.05 Chromebook App: Collabora Office	Online: MS Office for the web Chromebook App: Discontinued
	Parcial	Parcial

Online Word processors: LibreOffice Online Writer vs. Microsoft Word for the web

Major Feature Differences	Online: LibreOffice-based Collabora Online Writer 23.05 Chromebook App: Collabora Office Writer	Online: MS Word for the web Chromebook App: Discontinued
WYSIWYG - Full Fidelity Editing, PDF generation, Printing	Sí. What You See Is What You Get. Any document being edited looks the same when saved as a PDF or when printed (via Online and Chromebook App)	No. Documents being edited do not look the same when saved as a PDF or when printed [148]
Set, change or delete document open Password Protected Files (encryption password)	Sí. (via Online and Chromebook App)	No. Word for the web can't encrypt a document with a password, and it can't open documents encrypted with a password[149]
Edit Password to Modify Documents	Sí. (via Online and Chromebook App)	No [150]
Adjust Table Sort Order	Sí. And additional options: Sort in multiple sequential columns or rows, and for each column or row choose alphanumeric or numeric, ascending or descending. Option to match case (via Online and Chromebook App)	No. Not possible to sort by column or row[151]
Format Table Cells	Sí. By Number, Percent, Currency, Date, Time, Scientific, Fraction, Boolean Value and Text. (via Online and Chromebook App)	No
Headers and Footers appear in the editable document	Sí. It is a WYSIWYG word processor. (via Online and Chromebook App)	No
Find and Replace with options as available on desktop	Sí. (via Online and Chromebook App)	No. Very Basic.
Clipboard (Copy and Paste)	Sí. Copying and pasting within the web app works with advanced document features. Pasting content copied from outside the web app is advanced (via Online)	Parcial. Copying and pasting within the web app is functional for basic features available in the app. Pasting content copied from outside the web app is limited, such as it cannot copy and paste a hyperlink without losing the link. [152]
Word processor file format support equivalence to desktop	Sí. Supports opening word processor files in OpenDocument Format, and other formats from products such as Abiword, AportisDoc, Apple Pages, AppleWorks, Hangul WP 97, Ichitaro 8/9/10/11, Lotus Word Pro, MacWrite 1.5, Microsoft Pocket/RTF/Word 4/5/6.0/95/97-2003/2003XML/2007-2021/for Mac/for Windows2.0/Write, PDF, Software602, StarOffice StarWriter 3/4/5, WordPerfect, WordPerfect Suite 2000/Office 1.0, WriteNow 4.0. And others: Adobe PageMaker, Microsoft Publisher, QuarkXPress 3–4, HTML (LibreOffice supported file formats) (via Online and Chromebook App)	No. It will edit docx, dotx and ods (OpenDocument Format). It will open doc but cannot save it back in the same format. It will open docm and dotm but the macros will not run. It will not open or edit other formats that are supported in the desktop versions for Windows and Mac. (Word supported file formats)
PDF & EPUB Export Options	Sí. Options available are the same or similar as in the LibreOffice desktop applications (via Online)	No.
Minor Feature Differences	Online: LibreOffice-based Collabora Online Writer 23.05 Chromebook App: Collabora Office Writer	Online: MS Word for the web Chromebook App: Discontinued
Templates, browse and start from professionally designed templates	Sí. (via Online)	No [153]
Save in Microsoft Word 97 - Word 2003 format (.doc)	Sí. (via Online and Chromebook App)	No [154]
Save in EPUB e-book format (.epub)	Sí. (via Online and Chromebook App)	No
Edit and Run Microsoft Visual Basic Macros, (docm, dotm)	Sí. Support a large portion of Microsoft Visual Basic Macros (via Online and Chromebook App)	No [155]
Title Page	Sí. With options for number of title pages, page to start at, title style, title numbering (via Online and Chromebook App)	No
Thesaurus	Sí. (via Online and Chromebook App)	No
Page Gutter Margins (book / thesis binding)	Sí. Gutter Margins can be positioned on the left or top (via Online)	No
Add and Edit Page Backgrounds	Sí. Colour, Gradients, Bitmap, Pattern and Hatch, options available for each of these are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	Parcial. Very Basic.
Add and Edit Page Transparency	Sí. Transparencies, options available are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No [156]
Add and Edit Page Borders	Sí. Borders, options available are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No [157]
Add and Edit Page Columns	Sí. Columns, options available are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No. [https://docs.microsoft.com/en-us/office365/servicedescriptions/office-online-service-description/office-online-service-description
Display Headers and Footers, Footnotes, Endnotes in-line in the document	Sí. A WYSIWYG word processor (via Online and Chromebook App)	No [158]
Add, Edit, View Charts	Sí. Full options as available in desktop (via Online and Chromebook App)	No. They appear as placeholders that you cannot edit, move or resize [159]
Add, Edit, View Shapes	Sí. Full options as available in desktop (via Online)	No. They appear as placeholders that you cannot edit, move or resize [160]
Add, Edit, View SmartArt and WordArt (aka Fontwork)	Sí. (via Online)	No. They appear as placeholders that you cannot edit, move or resize [161]
Watermarks	Sí. (via Online and Chromebook App)	No [162]
Bookmarks	Sí. (via Online and Chromebook App)	No [163]
Fields	Sí. (With options under sub-categories of Documents, Cross-references, Functions, DocInformation and variables (via Online) Chromebook App has a few less options	No [164]
Edit Cross References	Sí. (via Online and Chromebook App)	No. It is not possible to edit the destination [165]
Index	Sí. options available are the same or similar as in the LibreOffice desktop applications (via Online)	No [166]
Table: "Optimal Column Widths" and "Optimal Row Height"	Sí. (via Online)	No [167]
Full control of anchoring with visible anchor points for images etc.	Sí. WYSIWYG precision visible anchoring (via Online)	No
Text Box	Sí. With full desktop options including, size, anchors, protection, borders, rotation, corners, shading, etc. (via Online)	Parcial. Basic [168]
Citations and bibliography	Sí. (via Online)	No [169]
Rich Fields Support - tab through editable fields; skip protected sections	Sí. DOC and DOCX forms	No
PDF export extended options	Sí. PDF fillable forms created using content controls. (from Collabora Online 22.05), (the developer’s blog post). (via Online)	No
Table of contents	Sí. Options available are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	Parcial. Basic options. [170]
Page Sizes	Sí. Letter, Legal, A3, A4, A5, A6, B4 (ISO), B5 (ISO), B6 (ISO), Long Bond, Tabloid, B4 (JIS), B5 (JIS), B6 (JIS), 16 Kai, 32 Kai, Big 32 Kai, User, DL Envelope, C6 Envelope, C6/5 Envelope, C5 Envelope, C4 Envelope, #6 3/4 Envelope, #7 3/4 (Monarch) Envelope, #9 Envelope, #10 Envelope, #11 Envelope, #12 Envelope, Japanese Postcard. (via Online and Chromebook App)	Parcial. Letter, Legal, Executive, A4, A5, and custom size layouts [171]
Wrap text around images	Sí. Full options for wrapping text around images including: before, after, parallel, contour wrapping, in front and behind, precision visible anchoring (via Online)	Parcial. No effective wrapping, the text does not wrap around images.
Word count and character count	Sí. Accurate count of words and characters. (via Online and Chromebook App)	Parcial. A rough count of words. [172]
Keyboard shortcuts	Sí. Advanced: all users can use their own language’s keyboard shortcuts when editing a file collaboratively. Holding the ‘Alt’ key highlight shortcuts, tab sequence then works, options for learnability and improved accessability. (from Collabora Online release 23.05). (via Online)	Parcial. Less shortcuts, with no mention of whether the users own language is used for keyboard shortcuts when editing a file collaboratively. ([173])
Screen Reader	Sí. Using NVDA. [174] (via Online)	Parcial. Requires adjunct browser based screen reader.
Co-authoring between online and native app	No. For more information the see the row "Synchronous collaborative editing"	Sí. MS Office 2019 sales version on Windows introduced real-time co-authoring with Word for the web
Table Autoformat Styles to choose from	No (#4356)	Sí
Add-ins	No	Sí
Dictate	No	Sí
Emoji	No	Sí
Share as Embedded HTML	No	Sí
Reuse Files	No	Sí. Open another document in a preview enabling selection of paragraphs or images for insertion, or for adding a link to that document.
Catchup	No	Sí. View changes your collaborators have made to a file since you last opened it.
Insert Equations with Structures	No. (#4049)	Sí
Insert Image options	Parcial. Select by folder and file only. (via Online and Chromebook App)	Sí. Select by folder and file, also by previewing categorised images
Margins	Parcial. Custom options. (via Online and Chromebook App)	Sí. Custom options and 5 presets.
Captions	No	No [175]
Mail Merge	No	No [176]
Cover Pages	Sí. via Styles First Page	Sí. Includes samples [177]
Translate	Sí. (from Collabora Online release 22.05.7.3), (tdf#34058), (#4285). (via Online)	Sí. [178]
Bullets, Numbering, Outline, Images, Alignment	Sí. 79 bullets inc 71 resizable images, 8 numbering, 8 outline, comprehensive position alignment options. (via Online and Chromebook App)	Sí. 17 bullets inc 13 images*, 15 numbering, 3 outline, minimal position alignment options. *not resizable, but has option to define new bullet points from the Symbol library
Accessibility checker	Sí. (via Online)	Sí

Online Spreadsheet applications: LibreOffice Online Calc vs. Microsoft Excel for the web

Major Feature Differences	Online: LibreOffice-based Collabora Online Calc 23.05 Chromebook App: Collabora Office Calc	Online: MS Excel for the web Chromebook App: Discontinued
Spreadsheet file format support equivalence to desktop	Sí. Supports opening spreadsheet files in OpenDocument Format, and other formats from products such as Apple Numbers, Data Interchange Format, Gnumeric, Lotus 1-2-3, Microsoft Excel (4/5/6/2003XML/97-2003/2007-2021/Pocket), Quattro Pro 6.0, SYLK, StarOffice StarCalc 3/4/5 and other applications. (LibreOffice supported file formats) (via Online and Chromebook App)	No. It will edit xlsx, xlsb and ods (OpenDocument Format). It will open xls and csv but cannot save them back in the same format. It will not open or edit other formats that are supported in the desktop versions for Windows and Mac. (Excel supported file formats)
CSV support, (Comma Separated Value(s), .csv)	Sí. Opening a CSV shows an Import dialog (Define character set, language, define import starting row, specify separator options, edit string delimiter) and shows a Preview screen. It is possible to Download as CSV. (from any device, from CODE release 6.4.9). (via Online and Chromebook App)	Parcial. Opening a CSV converts it to .xlsx without an import dialog and without a preview. No option to download as CSV. (Excel CSV limitations)
Minor Feature Differences	Online: LibreOffice-based Collabora Online Calc 23.05 Chromebook App: Collabora Office Calc	Online: MS Excel for the web Chromebook App: Discontinued
Save in Microsoft Excel 97 - Excel 2003 (.xls) format	Sí. (via Online and Chromebook App).	No
Sparklines (to give a quick overview of the trend in a data range)	Sí. Full support (via Online)	No
Defining and managing Range Names	Sí. (from CODE release 6.4.3). (via Online and Chromebook App).	No
Line Borders	Sí. (via Online and Chromebook App).	Parcial. A subset of line borders used in the desktop application are supported

Online Presentation software: LibreOffice Online Impress vs. Microsoft PowerPoint for the web

Major Feature Differences	Online: LibreOffice-based Collabora Online Impress 23.05 Chromebook App: Collabora Office Impress	Online: MS PowerPoint for the web Chromebook App: Discontinued
Presentation file format support equivalence to desktop	Sí. Supports opening presentation files in OpenDocument Format, and other formats from products such as Apple Keynote, Microsoft Powerpoint97-2003/2007-2021, OpenOffice.org XML, Photo CD, StarOffice/StarImpress and others. (LibreOffice supported file formats) (via Online and Chromebook App)	No. It will edit pptx, ppsx and odp (OpenDocument Format). It will open ppt and pps but cannot save them back in the same format. It will not open or edit other formats that are supported in the desktop versions for Windows and Mac. (PowerPoint supported file formats)
Minor Feature Differences	Online: LibreOffice-based Collabora Online Impress 23.05 Chromebook App: Collabora Office Impress	Online: MS PowerPoint for the web Chromebook App: Discontinued
Save in Microsoft Powerpoint 97 - Powerpoint 2003 (.ppt) format	Sí. (via Online and Chromebook App).	No
Online Video	No (tdf#42246). Work-around: Download of online video and embed it in presentation (incl. Flash videos) (via Online)	Sí. With preview, supported video providers: YouTube, SlideShare, Vimeo, Stream, Flipgrid, TED

Véase también

• The Programming Languages Beacon: LibreOffice is written in C++, Java, Python; Microsoft Office is written in C++, C, (ASM).
• How LibreOffice Writer Tops MS Word: 12 Features, by Bruce Byfield (2012-04-10).
• LibreOffice vs. MS Office: Spreadsheets and Slide Shows, by Bruce Byfield (2012-06-06)
• How Microsoft Office Tops LibreOffice: 11 Features, by Bruce Byfield (2012-04-26).
• 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).
• Duell am Arbeitsplatz, by Ralf Nebelo and Dorothee Wiegand (c't 22/2008, German).