Comparativo de Características: LibreOffice - Microsoft Office

    From The Document Foundation Wiki
    This page is a translated version of the page Feature Comparison: LibreOffice - Microsoft Office and the translation is 7% complete.
    Outdated translations are marked like this.


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

    (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


    Note pin.svg

    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 20.05.2024


    Desktop office: Notebooks, Desktop computers

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

    Principales diferencias LibreOffice 24.2 MS Office 2021 / 365
    Disponibilidad multiplataforma (PC escritorio) Sí. 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 HarfBuzzWikipedia logo v3.svg
    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)Wikipedia logo v3.svg Sí. Soporte avanzado, ODF v1.3 extendido 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 protocolWikipedia logo v3.svg, 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 PAdESWikipedia logo v3.svg 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í, .svg files supported
    Import of Encapsulated PostScript (EPS) vector graphics (.eps) (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) No
    Import from raster graphics software: Adobe Photoshop (.psd) 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 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) 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. Collaborative editing in LibreOffice online versions. 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 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) 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]
    Minor Feature Differences LibreOffice 24.2 MS Office 2021 / 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 Parcial. Import only
    Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM 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 No
    Import of additional video and audio formats: CD Audio, Vivo Video. 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])
    Document metadata fields according to Dublin Core / XMP Sí. Since LO 24.2 (tdf#138792) No
    Document converter wizard No
    Euro currency converter wizard No
    Expert config to access a multitude of settings from UI No
    Support for multiple color palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc) (note: tdf#92354) No
    Import MathML formula from clipboard 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 XAdESWikipedia logo v3.svg standard (XML Advanced Electronic Signatures) and OpenPGP keys. Support for ECDSA keys (on Linux and macOS). Support for OpenPGP-based document encryption. (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)
    Enhanced list of recent files and folders Parcial (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 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)
    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])
    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)
    Inserting a screenshot from within applications No
    Import of graphics formats: MEZ, PCZ No
    Export to XPS formatWikipedia logo v3.svg No
    Support for Touch Bar on Apple MacBook Pro No (tdf#105803) (macOS only)


    Desktop Word processors: LibreOffice Writer vs. Microsoft Word

    Major Feature Differences LO Writer 24.2 MS Word 2021 / 365
    Handling of captions for graphics or image boxes Sí. Stable layout No. Layout problems
    Styles (page styles, frame styles) No
    Overlining of text 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) No
    Business card wizard (release notes) No
    Text auto completion of words already used before Sí. [51] No
    XForms documents creation No
    Mathematical calculations in tables Sí. Complex calculations No. Only basic arithmetic
    DocBook import & export No
    Export to MediaWiki (Wikipedia) format No
    Export to XHTML No
    Export to EPUBWikipedia logo v3.svg e-book file format (.epub) 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) (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í. Supported, under the name Click and type (advanced option)
    Table styles Parcial (release notes 5.3 and release notes 6.0) (tdf#34391).
    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 remote grammar checker or as extension: Languagetool for 30 languages plus 13 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
    Picture styles & additional effects No (tdf#59906), but effects are preserved on import and export. Glow effect and soft edges supported
    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
    Diagonal borders in tables No (tdf#51665)
    Extended reading mode of documents No (tdf#55168)
    Collapse and expand parts of a document Sí (tdf#135310)
    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.2 MS Word 2021 / 365
    Protected cells in tables (allows better creation of forms) No
    Open erroneous .doc files Sí. Better recovery mode ([57],[58]) No. More frequently denies opening those files
    Wizard to create personalized letter templates No
    Import & Export Unified Office Format text No
    Import & Export AportisDoc (Palm), PocketWord documents Sí. Supported (requires Java) No
    Import of AbiWord files No
    Import of eBook formats: FictionBook 2.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm) 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 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 No
    Logo toolbar and interpreter [59] No
    Format text of all comments in document No
    Comments in headers and footers No
    Text boxes allow multiple columns 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
    Complex Outline numbering / Multilevel list Parcial. Different numerically equivalent format not supported (tdf#35217)
    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)
    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)
    Document/text translation Initial machine translation is available, backend by DeepL translate. Other extension: TradutorLibreText. Sí ([70])
    Decorative page borders No (tdf#39270)
    Horizontal split view of the same document No (tdf#31481), workaround: Windows > New Window to clone document window.
    Draft view No (tdf#67698)
    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.2 MS Excel 2021 / 365
    Spreadsheet functions (for details see Functions comparison of LibreOffice Calc and Excel) Sí. 508 functions (29 functions unique to Calc) See an extensive description of Calc Functions Sí. 492 functions (38 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 FILTER, IMAGE, SORT, TEXTSPLIT, TOCOL, UNIQUE, XLOOKUP.

    Sí.

    CUBE­KPI­MEMBER, CUBE­MEMBER, CUBE­MEMBER­PROPERTY, CUBE­RANKED­MEMBER, CUBESET, CUBESET­COUNT, CUBEVALUE, RTD, DBCS, CALL, REGISTER.ID, PHONETIC; FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY (tdf#126573); LET (tdf#137543); STOCKHISTORY (Not available in MS Office 2021 sales versions); TEXTSPLIT (tdf#150866); XLOOKUP (tdf#127293); XMATCH (tdf#128425); YEN; the following functions are only available in MS Office 365 rental version, not in MS Office 2021: 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).

    Comparison of two spreadsheet files No
    Page styles (in addition to cell styles) No
    Hyphenation of text in cells No
    AutoSpellcheck / Spelling as you type No ([75])
    Export to XHTML No
    Full-Sheet Previews: Possibility to export all pages on a sheet as one page in the PDF No
    Exporting of a single chart as image (e.g. jpg, png, svg, pdf) Sí. [76]
    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 ([77])
    Import of Apple Numbers spreadsheet documents Sí. Support for Numbers v1-3 [78], see also this comparison No
    Maximum number of columns per sheet Sí. 16,384. Jumbo spreadsheets supported since LO 7.4, see: [79], tdf#133764. Sí. 16,384 (256 in compatibility mode)
    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)
    Record a macro Parcial. Limited support [80]
    Insert a graphic into a spreadsheet header or footer Parcial. Inserted image cannot be resized nor cropped, usability issues. (tdf#74146)
    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.
    Chart styles No (tdf#62925, tdf#62540, tdf#39097) Parcial. Selection of some pre-set chart styles and layouts
    Power PivotWikipedia logo v3.svg features No (tdf#96623 regarding DAX functions)
    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)
    Relationships between tables, based on matching data in each table No (work around: using function VLOOKUP) Sí ([81])
    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" [82]. (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) [83],[84]
    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)
    Multi-Core Processing / multithreading Parcial. Multi-threaded calculation [85]. Multi-threaded import of XLSX documents. Parallel formula compiling on the CPU. OpenCL/GPU threading in Calc core ([86],[87]). Multithreading is work in progress: tdf#65046, [88], 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. ([89], [90])

    Declaration of variables to be used in formulas No Sí. LET function (tdf#137543)
    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
    Customized sheet views (while collaborative editing) No Sí ([91])
    Minor Feature Differences LO Calc 24.2 MS Excel 2021 / 365
    Flexible CSV export Sí. Supported ([92], [93]) No
    Advanced find & replace / regular expressions / special characters (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. [94]
    Chart type Stepped lines for XY (Scatter) graphs No
    Use English function names Sí. Possibility to switch between function names in local language and English No
    Import & Export Unified Office Format spreadsheet 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) No
    Import of Classic Mac OS legacy spreadsheet formats: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz, Microsoft Multiplan (v1.11) No
    Import & Export Pocket Excel Sí. Supported (requires Java) No
    Ability to rotate entire chart No
    PDF export of comments Sí. Export of comments according to PDF specification No
    Property mapping functionality for charts (conditional chart colors/borders) No (Only available: Inverting colors for negative values)
    Import from Gnumeric (not available on Windows, see tdf#94834) No
    Export cell range selection or a selected group of shapes (images) as .png or .jpg image No
    Export sheet/table as .png image 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) Parcial Using work-arounds.
    Conditional formatting: icon sets Parcial. 2 additional smilies icon sets. No reverse icon order (tdf#61313). Parcial. Customization of icon sets, e.g. reverse icon order.
    Advanced find & replace / Cell Format Parcial (Styles supported, Cell Format not supported)
    Formulae with entire columns or entire rows Parcial (tdf#34094, tdf#92452, tdf#92453)
    Default keyboard and/or mouse shortcuts [95] Parcial. Less default shortcuts ([96], tdf#98259, tdf#92452, tdf#92453) Sí. More default shortcuts ([97], [98], [99])
    Sheet protection options (allow users certain actions in protected sheets) Parcial. Supported for select protected/​unprotected cells and insert/delete rows/columns. 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í. [100]
    Chart: Automatically vary colours by point No (only manually)
    Chart type: xyz / surface charts No, basic workaround [101] (tdf#51670)
    Chart type: pie of pie (bar of pie) No (tdf#50934)
    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)
    Printing of selected chart only No, workarounds [102], [103] (tdf#45893)
    Chart data labels "Value as percentage" No
    Chart data labels "Value from cells" No
    Automatized analysis and visualization features No Sí. Quick analysis feature and visual summaries, trends, and patterns. [104], [105]. 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.
    Chart recommenda­tions No
    'Publishing' spreadsheet for online team meetings No
    Sparklines (to give a quick overview of the trend in a data range) Sí. [106]
    Add points to a line, possibility to bend lines No (tdf#36943)
    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 [107] (Not available in MS Office 2021 sales versions and only available on macOS)


    Desktop Presentation software: LibreOffice Impress vs. Microsoft PowerPoint

    Major Feature Differences LO Impress 24.2 MS PowerPoint 2021 / 365
    Hyphenation support No
    Export to XHTML No
    Export to HTML No (removed feature since MS Office 2013)
    Export to vector graphic formats: SVG, EPS 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
    Color/document themes Parcial support of document themes in Impress: [108] [109]
    Animated effects Parcial. Supported, but problems with: spinning text (tdf#87958), pixelated (tdf#87959), wobble/​shake/​vibrate (tdf#87960), objects stuck (tdf#88196)
    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) [110]
    Slides editable during presentation No (tdf#34965)
    SmartArt diagrams No (tdf#37932), solution: smArt extension
    Save highlights and drawings during presentation No (tdf#51928)
    Compare presentations No
    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
    Record a slide show No (tdf#34959) Sí. [111] Some features only available in rental vesion ([112]).
    Slide design suggestions No 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í. ([113]) (not available on macOS)
    Minor Feature Differences LO Impress 24.2 MS PowerPoint 2021 / 365
    Number of slide layouts Sí. 12 Parcial. 9
    Physics based animations Sí. [114] No
    Text background colour in text boxes No
    PDF export of comments Sí. Export of comments according to PDF specification No
    Import & Export Unified Office Format presentation No
    Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM No
    Import of Apple Keynote files Sí. Support for Keynote v1-6 [115] No
    Embedding of fonts in presentation file Parcial. Supported on Windows. No support for embedding fonts in PowerPoint on macOS, although displayed. No support for embedding OpenType CFF fonts. [116]
    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 ([117]). Sí. Powerful editing
    Default keyboard shortcuts Parcial. Less default shortcuts ([118]) Sí. More default shortcuts ([119], [120])
    Conversion of hand-drawn shapes into diagrams / recognition of ink equations No Sí. [121] 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í. [122]
    Creation of automatically starting presentations No, extension: ImpressRunner
    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)
    Option to save as picture presentation No (tdf#93589)
    Using Surface Earbuds to control presentation No [123]
    Autogeneration of alt text for photos No [124] (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.2 MS Access 2021 / 365
    Available on all operating systems supported by the office suite No. MS Access not available on macOS, online and mobile OS versions
    SQL syntax highlighting No
    Native connectors for: MariaSQL, PostgreSQL, Novell GroupWise Sí. Plus MySQL as extension. [125] No, via ODBC
    Integration of Mozilla Thunderbird address book, KDE address book, Evolution LDAP and storage, Windows system address book No
    Native JDBC driver No
    Connect to ODF spreadsheet (Calc) file format 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.
    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. ([126]) (tdf#51872)
    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. ([127]) (tdf#73798)
    Edit MS Access files Parcial. Limited older driver "Microsoft.Jet.​OLEDB.​4.0" works fine for read/write, while "Microsoft.ACE.​OLEDB.​12.0" driver only reads; (tdf#43187). Driver only works on Windows.
    Native connector for: Microsoft SQL Server No, via ODBC
    Crosstab queries No. Not supported but reproducible with Pivot Table with Calc (FAQ 142 )
    "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
    Import data from XML, HTML No
    Minor Feature Differences LO Base 24.2 MS Access 2021 / 365
    Native connector for: dBase databases No. Not supported (removed feature since Office 2013)
    Open LibreOffice Base (.odb) files No
    Open DOS/Windows legacy formats: Microsoft Works database No
    Native connector for: SharePoint lists No
    Link or import data from Salesforce and Dynamics 365 No
    Web service data connection No
    Password protection of database No (tdf#70638)
    Cálculos en tablas de bases de datos No (tdf#72787)

    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
    LibreOffice Writer

    fice.org/extensions/dmaths DMaths] agrega una completa caja de herramientas matemáticas a LibreOffice 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
    • 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:
    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

    Formas de equipos de red para LibreOffice].

    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

    Note pin.svg

    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) [128]. 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, Android and Ubuntu Touch/UBPorts. 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: [129]. More information: Android port wiki, Commits

    , [130], [131].

    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: [132], [133].

    ChromeOS: Collabora Office on Google Play available, more information, XDA News Portal.

    Ubuntu Touch/UBPorts: The Document Viewer is powered by LibreOfficeKit (LibreOffice 5) and supports viewing most file types supported by LibreOffice.

    Parcial.

    Android and iOS for smartphones and tablets with restricted features set. 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-leftWikipedia logo v3.svg (RTL) languages (e.g. Arabic) and other complex scripts No
    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)


    Note pin.svg

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

    Note pin.svg

    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) [134]. 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. [135], [136], [137], [138], [139], [140]. See also: LibreOffice Online port development. Parcial. Office web apps, with reduced functionality when compared to the Word desktop version and Collabora Online. ([141])
    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 ([142]), Roove, Zimbra ([143]), 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-leftWikipedia logo v3.svg (RTL) languages (e.g. Arabic) and other complex scripts for all Document Types Sí. Comprehensive support, based on HarfBuzzWikipedia logo v3.svg 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 [144]
    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[145]
    Edit Password to Modify Documents Sí. (via Online and Chromebook App) No [146]
    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[147]
    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. [148]
    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 [149]
    Save in Microsoft Word 97 - Word 2003 format (.doc) Sí. (via Online and Chromebook App) No [150]
    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 [151]
    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 [152]
    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 [153]
    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 [154]
    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 [155]
    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 [156]
    Add, Edit, View SmartArt and WordArt (aka Fontwork) Sí. (via Online) No. They appear as placeholders that you cannot edit, move or resize [157]
    Watermarks Sí. (via Online and Chromebook App) No [158]
    Bookmarks Sí. (via Online and Chromebook App) No [159]
    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 [160]
    Edit Cross References Sí. (via Online and Chromebook App) No. It is not possible to edit the destination [161]
    Index Sí. options available are the same or similar as in the LibreOffice desktop applications (via Online) No [162]
    Table: "Optimal Column Widths" and "Optimal Row Height" Sí. (via Online) No [163]
    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 [164]
    Citations and bibliography Sí. (via Online) No [165]
    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. [166]
    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 [167]
    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. [168]
    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. ([169])
    Screen Reader Sí. Using NVDA. [170] (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)
    Add-ins No
    Dictate No
    Emoji No
    Share as Embedded HTML No
    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)
    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 [171]
    Mail Merge No No [172]
    Cover Pages Sí. via Styles First Page Sí. Includes samples [173]
    Translate Sí. (from Collabora Online release 22.05.7.3), (tdf#34058), (#4285). (via Online) Sí. [174]
    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)

    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