How To Change Edit Color Libre Officec

Wiki Home
Development
Pattern
QA
Events
Documentation
Website
Localization
Accessibility
Marketing
Variety
Wiki Help

Documentation Home
Official Publications
Other Resources
FAQ
HowTo
Macros
Docs Development

This page compares the features of LibreOffice and Microsoft Office in several form factors. The comparisons divide major and pocket-size feature differences and as well includes notes on LibreOffice extensions. The comparison highlights differences and therefore does not display any features which are present in both function suites.

In that location are separate comparison tables available for:

Desktop (notebooks, desktop computers): LibreOffice 7.3.ii (download) vs. Microsoft Office 2021 / 365
Mobile (smartphones, tablets): LibreOffice-based mobile solutions (download) vs. Microsoft Office 365 mobile apps
Online (web browser-based office): LibreOffice-based Collabora Online ([1] [two]) vs. Microsoft Office for the web). This section also includes the LibreOffice-based Chromebook App (Collabora Office 6.4.14 download [3]) for reasons explained in the department.

The characteristic comparison table is continuously being updated and is work in progress.
Information technology is a compilation by users and not an official document past the Certificate Foundation.
Please feel free to improve this page. Last update to this tabular array was made at sixteen.04.2022

Desktop function: Notebooks, Desktop computers

Desktop Function suite, full general features: LibreOffice vs. Microsoft Office

Major Feature Differences	LibreOffice vii.3	MS Office 2021 / 365
Cantankerous-platform availability (desktop)	Yep. Windows, macOS, Linux, FreeBSD, NetBSD, OpenBSD, and Haiku. (based on the aforementioned lawmaking base). Chrome OS via Collabora Office. Integrated office architecture: LibreOffice for the desktop shares the same processing engine, common to all modules, on all form factors (incl. mobile and online) [4].	Partial. Windows and macOS. Windows and macOS versions have some document format compatibility issues, somewhat dissimilar characteristic sets and differences in the user interface; macOS version does not include the database application MS Admission, does not include MS Publisher, and also lacks a number of other features (see beneath). Feature inconsistencies/differences in Windows versions, between "MS Office 2021" sales version and the "Role 365" rental version: some features are being after included only in the rental version (newly added features also differ betwixt macOS and MS Windows) leading to inconsistencies in the feature set up (run across below).
Supported versions of MS Windows	Yes. Windows 7 SP1, 8, viii.i, x, 11, Windows Server 2008, 2012, 2016, 2019, 2022. ([5]). Version LibreOffice 5.4 still supported Windows XP SP3, Vista.	Yeah. MS Office 2021 sales version: Windows ten, 11; Server 2019, 2022. MS Role 365 rental version: Windows 8.1, 10, 11, Windows Server 2016, 2019 ([6]).
Supported versions of macOS	Aye. 10.12+ (Sierra). Intel and Apple Silicon. ([seven]).	Yeah. The newest 3 versions (every bit of Feb 2022: x.15+ (Catalina)). Intel and Apple Silicon. ([viii])
Portable version that runs on USB flash disks (without installation)	Aye (download)	No
Open Source	Yes, licensed under MPLv2 and others.	No, proprietary and closed-source
Full integration of all role components	Yes. From within each part component, files of all other components tin can be opened and exist newly created. Primal StartCenter with access to function modules, recently used files and templates.	No
Availability gratis of charge	Yes (download, donate)	No, proprietary software to buy or rent. When subscription for the rental version ends, applications enter read-only mode (view or print) and no new documents tin exist created. The purchase-version is a perpetual license. One-calendar month trial version available for the rental version (only not for the 1-time purchase version).
Extension availability	Yep. Circuitous ecosystem of extensions (over 390 on extensions.libreoffice.org and over 800 on extensions.openoffice.org), including automatic updates. Extensions and templates can be installed from within LibreOffice ("Additions dialog").	Fractional. Partly, no centralized extension organisation for add-ons and macros. Microsoft AppSource for Function 365. [9] Office Apps not supported on macOS.
Localization	Yes. 119 languages (detailed list of languages supported by LibreOffice)	Partial. 91 languages in Windows version, 27 languages in macOS version (display linguistic communication for (some) office applications)[10], [11], [12]
Back up of Right-to-left⁠ (RTL) languages (e.m. Arabic) and other complex scripts	Yes. Comprehensive support, based on HarfBuzz⁠ text shaping library	Yeah
Additional writing aids	Yes. Extended support (spell-check dictionaries, hyphenation patterns, thesaurus and grammar bank check, specialized dictionaries as extensions ([13], [14]). Detailed list of LibreOffice writing aids for over 150 languages.	Fractional. More limited, "proofing tools" for 92 languages in Windows version, 58 in macOS version [15], [xvi],[17]
Language technology	Yep. Comprehensive support, based on the most popular spellchecking library Hunspell LibreOffice Linguistic communication Technology – News & Best practices, YouTube, Hunspell 1.seven, LibreOffice vs MS Office, Meliorate coverage: words, Unicode, morphology, iii imitation alarms in Word, zero in Writer	Partial. Limited
Back up of complex languages and special smart-font features (ligatures, true minor caps, old manner numbers, proportional or mono-spaced numbers, majuscule spacing, and true superscript/subscript)	Partial. Full support of SIL Graphite font technology ([18],[19]) and full support of OpenType optional features ([20],[21],[22]) past syntax and UI (tdf#58941). See as well LibreOffice Smart Font HowTo. Support for Apple Advanced Typography (AAT) available on all platforms. Interoperability: No support for optional OpenType features in OOXML, and ODF i.2 doesn't provide OpenType optional features support (support scheduled for ODF later on)	Partial. Express via OpenType supporting ligatures, stylistic sets, number spacing options, number forms, and contextual alternates. [23] Support for optional OpenType features in OOXML.
Support of font variation	Partial. Limited support for font rendering on screen, no support for printing and PDF consign. tdf#108497	Partial. Limited support for font rendering on screen, no support for printing and PDF export.
Piece of cake access to vector clip art	Yeah . via LO Gallery (clipart extensions ([24] or [25])). Extension for the integration of clipart from OpenClipart.org. Additional toolbar control to insert Emojis (experimental: tdf#100100)	Partial. Selection of clip art is asking for search with Bing in Online Pictures. Extended selection of "icons". Access to stock photos and icons.
Macro scripting languages	Yes. Multiple languages, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell, and Python). ScriptForge libraries as extensible and robust collection of macro scripting resources for Basic and Python. Import and consign of Visual Basic for Applications (VBA), see ([26] and the release notes).	Partial. Single linguistic communication, back up for Visual Basic for Applications (VBA). Indirectly also Visual Bones or Visual C# past using automation.
CMIS protocol support to access Document Direction Systems	Yes. Support for Google Bulldoze, MS OneDrive, Alfresco, IBM FileNet, IBM Connections Deject, Lotus Quickr Domino, Nuxeo, OpenDataSpace, OpenText ELS, MS Sharepoint, WebDAV, FTP, SSH, Windows share. (tdf#62437)	Partial. Inbuilt support simply for MS SharePoint and MS OneDrive
Back up of ISO standards OpenDocument Format (ODF)⁠	Yes. Avant-garde back up, ODF v1.iii extended	Fractional. Express back up, ODF v1.3, in MS Windows sales and rental version, and online version. Support of OpenDocument (ODF v1.3) in macOS version and mobile versions (Android, iOS) are more limited and require the apply of an online file format conversion service. [27] [28] [29]
PDF export extended options	Yes. Multiple options (Additional options: Tagged PDF, Time stamp protocol⁠ , detailed image settings, Hybrid PDF, transition furnishings, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures, and PDF signatures according to PAdES⁠ standard). Back up for font embedding of all font types (incl. OpenType CFF fonts (.otf)). Back up for PDF/A-1, PDF/A-two (archiving) and PDF/UA (universal accessibility) standards.	Partial. Loftier or low quality PDF, page and markup to print in Access, Word, Excel, and PowerPoint [xxx]; pictures resolution and non-printing informations in Publisher. No back up for font embedding of OpenType CFF fonts in PDF export [31].
Certificate nomenclature	Yes. Document classification in Writer, Calc, and Impress according to TSCP-standards (besides with multiple policies). See: [32] and [33].	Partial. No inbuilt document nomenclature arrangement, merely Data Rights Management (IRM) supported
Import of SVG vector graphics (.svg, .svgz)	Yep	Yes, .svg files supported
Import of Encapsulated PostScript (EPS) vector graphics (.eps)	Yes (with some rendering issues: tdf#81497, tdf#67464)	No. Support for .eps images entirely removed in Role 2019 and rental version ([34]. In Office 2016 sales version, it was [35]) turned off by default due to security bug, simply could be manually enabled via Windows registry. There were general rendering issues of .eps files in PDF consign ([36]).
Insert PDF as an image into documents	Aye ([37])	No
Cosmos of Hybrid PDFs (ODF file embedded in PDF for full editing)	Yes	No
Import from raster graphics software: Adobe Photoshop (.psd)	Yes	No
Import from vector graphics / DTP software: CorelDraw (v1-X7), Corel Presentation Exchange, Adobe/Macromedia Freehand (v3-11), Adobe PageMaker, Zoner/Callisto Depict (.zmf), QuarkXPress 3.one to 4.one	Aye	No
Import of MS Visio files	Yes. Supported (Visio 2000-2013)	No (only via MS Visio which is not office of MS Part)
Import of video and audio formats FLAC Audio (.flac), Wink 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)	Yep	No
Drawing and vector graphics software	Yes. LibreOffice Draw, cartoon and vector graphics software that supports pages (up to 300cm ten 300cm), layers, numerous drawing tools and DTP features.	Partial. MS Powerpoint provides some features of a cartoon software.
PIM and e-mail software	No. Not role of LibreOffice, referring to alternative PIM software such as Mozilla Thunderbird. Meet the comparison on this wiki: Mozilla Thunderbird vs. Microsoft Outlook. Mail Merge Magician sends out emails directly from LibreOffice without email software. LibreOffice-wide access to address books via Base.	Yes. MS Outlook
Desktop publishing (DTP) software	Partial. Writer supports many avant-garde DTP features (see section on Writer in this comparison tabular array). Draw supports frame-based DTP features. Import of MS Publisher files (and from other DTP software) in Draw.	Yes. MS Publisher
Integrated Development Environment (IDE) feature set	Partial. The BASIC Integrated Development Surroundings (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 whatever 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).	Yes. Supported with Visual Bones for Applications and/or additional purchase of Role Programmer Tools for Visual Studio (Windows-only). macOS version only supports a simplified Visual Bones Editor.
Import & Consign of Microsoft OOXML files	Partial. Good and extended support of real life OOXML files (e.grand. .xlsx, .docx, .pptx), standardized (transitional) OOXML files, equally well as import of OOXML-strict files. [38]	Yes. Avant-garde support of transitional (default) and strict OOXML files
PDF Import	Fractional, into Draw and Author with the limitation that text is imported line-based (tdf#32249).	Aye, into MS Word
Synchronous collaborative editing	No. Not available in the desktop applications (tdf#133984), run across development data: Collaborative Editing and Track changes. Collaborative editing in LibreOffice online versions.	Yes. Support in desktop applications via MS OneDrive, MS Sharepoint or MS Teams. Back up in desktop applications varies: Existent-time "co-authoring" in MS Word, Powerpoint, and MS Excel (merely via AutoSave) [39] (MS Powerpoint 2021 sales version only allows for co-authoring (via AutoSave). Simplified "sharing" of part 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 organisation, or SharePoint Online. Supported in MS Part online versions. Collaboration with online versions is possible.
User Interface arroyo	Yes. Highly customizable UI concept "MUFFIN" [xl],[41]: Available user interfaces: (1) Classic UI with multiple toolbars style, and Sidebar console. (2) Single Toolbar mode, and Sidebar console. (3) Notebookbar Tabbed UI. (four) Notebookbar Grouped Meaty UI. (five) Notebookbar Tabbed Compact UI. (6) Notebookbar Contextual Single UI (Writer and Draw). Customization possible: Several icon themes available (Karasa Jaga, Breeze, Cakewalk Dark, New Colibre, Simple, Sifr, Sifr Night, Sukapura, Tango). Colour themes "Normal" and "Dark" via Tools ▸ Options ▸ LibreOffice ▸ Application Colors.	Partial. Ribbon UI; Color themes ([42]) on MS Windows: Colorful, Dark Gray, Black, White, Dark way. On macOS: Colorful, Classic, Dark mode.
User interface improved to enable use on touch screen devices on desktop operating systems.	No (tdf#102015)	Fractional. Slightly adjusted user interface for impact screen devices, but no redesign.
Keyboard driven menu system (search function to better find features in function suite), Head-Up-Brandish (HUD).	Yeah. It tin be invoked with the menu Assist ▸ Serch Commands or the shortcut `⇧ Shift` +`Esc`. tdf#91874 blog	Yep. Tell Me search bar. Search with vox (supported in Windows rental version, not supported in MS Role 2021 sales versions; not available on macOS)
Accessibility checker	Yes. Accessibility checker and support for PDF/UA. Accessibility improvements [43]. Extension for text documents: AccessODF.	Yes [44], [45].
Chat with other authors (collaborative editing)	No	Yes. In-app conversation with co-authors for shared files on SharePoint Online or OneDrive for Business. Not supported for OneDrive Consumer or any other storage location. Not-persistent chat (history not preserved; new users run across just newly incoming messages). (Not supported in MS Office 2019 sales version; non supported on Android and iOS).
Integration of instant Messaging (IM), vox, video, or screen sharing.	No	Yes. Skype integration (non supported in macOS version).
Dictation / speech recognition	No	Yes in MS Word, MS Powerpoint, MS Outlook [46]. Voice audio is sent to Microsoft cloud servers and returned equally text. (Not supported in MS Office 2021 sales versions)
Inserting and editing 3D models	No (previous support in Print for glTF (.dae/.kmz) 3D models removed in version 6.0)	Yes in Powerpoint, Discussion, and Excel. Insert animated 3D graphics in Powerpoint, Word, and Excel (Supported in Windows rental version, non supported in MS Role sales versions.)
Support of color fonts	No	Yes [47]
Support of math fonts	No (tdf#103680), workaround using TexMaths extension with XeLaTeX compiler. [48]	Yes
Modest Characteristic Differences	LibreOffice 7.3	MS Part 2021 / 365
Generation of QR codes and barcodes	Aye. QR codes and 1-dimensional barcodes. In Impress, Draw, Writer and Calc	No
Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM	Yes	No
Import of Classic Mac Bone legacy vector and bitmap graphics formats: BeagleWorks, ClarisWorks, GreatWorks, MacPaint, MacWorks, SuperPaint, MacDraw, MacDraw II, RagTime for Mac ii-3, ClarisDraw, MacDraft	Yes	No
Import of additional video and audio formats: CD Audio, Vivo Video.	Yes	No
Drawing features: Pointer endings	Yep. Substantially wider selection, including Crow's feet notation	No. Less supported arrow endings
Cartoon features: Point Eraser, Lasso, Sketched outline mode.	No	Yep. ([49]) (not available on macOS). ([50])
Document converter wizard	Yes	No
Euro currency converter wizard	Yep	No
Expert config to access a multitude of settings from UI	Yes	No
Support for multiple color palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc)	Yep (note: tdf#92354)	No
Import MathML formula from clipboard	Yes	No
Import of StarOffice binary file formats .sdc, .sda, .sdw	Fractional. Basic back up	No
Digital signatures / Signature Line	Aye. Multiple signatures, including OOXML signatures. Visible signatures in Writer, Calc and Draw. Round-trip with MS Function problematic (tdf#58442, tdf#58476). Import/consign of PDF signatures. Support of XAdES⁠ standard (XML Advanced Electronic Signatures) and OpenPGP keys. Support for ECDSA keys (on Linux and macOS). Back up for OpenPGP-based certificate encryption.	Yes (OOXML/XML-DSig and XAdES signatures)
Convert SVG paradigm to shapes / polygon	Yes. Conversion supported in LO Draw. Additionally opening SVG files direct every bit shapes is supported in LO Draw. (tdf#115571)	Yes
Enhanced list of contempo files and folders	Partial (tdf#61174, tdf#60743). Option to clear list of recent documents. Selectively delete Recent Documents (in StartCenter)	Yes (option to gear up contempo files as permanent)
Custom colors in formula editor	Aye. Full support of HTML colors in Math (RGB colors, UI in element pane) (tdf#40436)	Yes
Third-party software dependencies	Partial. Java runtime environment (JRE) installation required for certain - merely non most - features of the software. Java is notably required for Base.	Yes. Not required
Shortcut keys for accented Latin characters	No (tdf#71176), workaround using Unicode conversion, see Unicode character input with Alt+Ten	Fractional. Express 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)	Fractional [51] Insert online videos (Youtube, Vimeo, Slideshare.net) to MS Word (not bachelor 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	Yes, in PowerPoint, Excel, Word, and Outlook. [52]
Quick access to email attachments	No	Yes, "Shared with me" characteristic in PowerPoint, Excel, Word.
Streaming of office applications/function on need	No (possible via tertiary party services)	Yes ([53])
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)	Yep. Several pens, highlighters, colors and color effects, and pencils for inking to draw/annotate/highlight. Lasso Select (free-course tool for selecting ink). Ink replay feature
Recognition of shapes from ink drawings	No	Yes. [54] supported in MS Word, MS Excel, and MS Powerpoint
Recognition of text from ink drawings	No	Aye. [55] Conversion of ink to shapes in MS Powerpoint and MS Give-and-take (Not supported in MS Role 2021 sales versions)
Automated background removal of a moving-picture show	No (tdf#103424)	Yep. Supported in MS Windows version (not supported in macOS version)
Alive preview while formatting	No (tdf#37048)	Yes
Inserting a screenshot from inside applications	No	Yep
Import of graphics formats: MEZ, EMZ, WMZ, PCZ	No (tdf#103954)	Yes
Export to XPS format⁠	No	Yes
Support for Touch Bar on Apple MacBook Pro	No (tdf#105803)	Aye (macOS only)

Desktop Word processors: LibreOffice Author vs. Microsoft Give-and-take

Major Feature Differences	LO Writer 7.3	MS Word 2021 / 365
Handling of captions for graphics or image boxes	Aye. Stable layout	No. Layout problems
Styles (folio styles, frame styles)	Yes	No
Overlining of text	Yes	No. No, just complicated workaround
Master documents for longer texts	Yes. Chief documents and Master document templates supported	No. Supported but deprecated because it causes file corruption
Redaction tool / sanitization of classified information	Yes. Supported. Redaction & Automatic redaction tool	No
Register-truthful characteristic / register accuracy (DTP-feature)	Yes	No
Business card wizard	Yes (release notes)	No
Text auto completion of words already used earlier	Yeah [56]	No
XForms documents creation	Yes	No
Mathematical calculations in tables	Yep. Complex calculations	No. Only basic arithmetic
DocBook import & export	Yes	No
Export to MediaWiki (Wikipedia) format	Aye	No
Export to XHTML	Yes	No
Consign to EPUB⁠ e-volume file format (.epub)	Yes	No
Consign document as epitome(southward)	Yes. Supported, image formats: .jpg, .png	No
Import of Apple Pages documents	Yes. Support for Pages v1-5 [57]	No
Working with big documents	Yeah. Stable layout	Partial. Some layout problems [58]
Extended label creation features (release notes)	Yes (generic database access, synchronise content)	Partial
Frames	Yep. DTP-similar features like text in multiple columns and text-wrap around graphics	Partial. Concept of "horizontal frames" is more limited
DirectCursor (allows to enter text anywhere on a page)	Aye	Yes. Supported, under the name Click and blazon (advanced option)
Table styles	Partial (release notes 5.3 and release notes 6.0) (tdf#34391).	Yes
PDF export of comments	Partial. Export of comments according to PDF specification (via "File" > "Export equally PDF"). PDF export of comments: inside the margin, at stop of page, at end of document (activation complicated, only via: "Tools" > "Options" > "LibreOffice Writer" > "Print" (tdf#77650))	Partial. Export just equally comments inside margin
Grammer bank check	Fractional. out of the box simply four languages (English, Russian, Hungarian and Brazilian Portuguese) extensions: e.g. Languagetool for thirty languages plus thirteen linguistic communication variants (level of language back up varies; eleven languages with more 1000 rules), Grammalecte for French, CoGroo for Brazilian Portuguese	Yes. 21 languages (plus ane language variant) were supported in MS Function 2013 with additional costs) ; no information on supported languages in MS Office 2016. Grammar bank check on macOS version limited to few languages.
Style sets (for paragraph styles)	Partial. Different. Templates provide this functionality, but more than difficult to handle. Helpful extension: Template Changer (tdf#89286). Experimental design themes: (tdf#45176, tdf#90497)	Yes. Supported ("document themes")
Use of LaTeX syntax for formulas	No. Extension: TexMaths	Yep. Power to type math using the LaTeX syntax (Non supported in macOS version)
Vertical alignment (pinnacle/center/lesser) of content on page	No (tdf#36117), workarounds via frame/table	Yes
Picture styles & additional effects	No (tdf#59906), just effects are preserved on import and consign. Glow upshot and soft edges supported	Aye
View changes in the margin in "track changes" manner	Partial Option to bear witness track changes (additions or deletions) in margin (Tools - Options - LibreOffice Writer - View - Enable Tracked deletions in margin). Implementation misses some features, come across: tdf#137770 tdf#147169	Yes
Diagonal borders in tables	No (tdf#51665)	Yes
Extended reading mode of documents	No (tdf#55168)	Yes
Plummet and aggrandize parts of a document	Available as experimental characteristic [59]. (tdf#47746)	Yes
Instant messaging while collaborating on document	No	Yes ([60])
Track changes only for ain changes (while collaborative editing)	No	Aye. Option to track one's own changes without forcing others to track theirs ([61]). (not supported in MS Role 2021 sales versions)
Reading aloud; Text-to-speech (TTS) ability	No. Extension Read Text.	Yes ([62])
Minor Characteristic Differences	LO Author seven.3	MS Discussion 2021 / 365
Protected cells in tables (allows better creation of forms)	Yeah	No
Open erroneous .doc files	Yes. Better recovery mode ([63],[64])	No. More oft denies opening those files
Wizard to create personalized alphabetic character templates	Yes	No
Import & Export Unified Function Format text	Yes	No
Import & Export AportisDoc (Palm), PocketWord documents	Yep. Supported (requires Coffee)	No
Import of AbiWord files	Yes	No
Import of eBook formats: FictionBook 2.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm)	Yes	No
Import of legacy Mac Bone 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 person, HanMac Word-Grand/J, LightWayText for Mac iv.5, Mariner Write Mac Archetype ane.6-3.5, MindWrite Document, Nisus Author Mac Classic iii.4-6.five, TeachText/SimpleText 1, Tex-Edit 2, WriterPlus, Z-Write 1.3, eDOC ii, Acta Mac Classic, BeagleWorks/WordPerfect Works i, GreatWorks, MacDoc 1, MoreMac two-3, RagTime for Mac ii-3	Aye	No
Import of DOS/Windows legacy word processing documents: Microsoft Discussion for DOS, Microsoft WinWord 5, Microsoft Word 6.0 / 95, Microsoft Write, Hangul WP97, Text 602 (T602), Lotus WordPro	Yes	No
Logo toolbar and interpreter	Yes [65]	No
Format text of all comments in document	Yes	No
Comments in headers and footers	Aye	No
Text boxes allow multiple columns	Yes	No
Markdown characteristic to automatic format assuming, /italic/, -strikeout- and _underline_	Yep. (How to switch on the feature). Run into likewise tdf#133023	No
PDF export preserves footnote/endnote anchors	Yes. Links between anchors and footnotes or endnotes (even if non on the same page) are available in both direction.	No
Conditional text	Yep ([66], [67](PDF) [68])	Partial ([69], [70])
Automated replacement of Emojis	Yep. supported. Additional toolbar control to insert Emojis (experimental: tdf#100100)	Partial. Manual creation of replacement lists
Number of columns per tabular array in document	Yes. Unlimited columns	Partial. Express to 63 columns
Multi-line headings for chapters	Yes. Multi-line headings for capacity by assuasive a line break as separator betwixt a affiliate number and its name (in Chapter Numbering dialog)	Partial. Only via piece of work-effectually [71]
Maximum page size	Yep. 300cm 10 300cm	Fractional. 55.87cm ten 55.87cm
Bibliographic features	Partial. Basic inbuilt back up. Fantabulous free extensions: e.yard. Zotero, JabRef likewise as proprietary extensions.	Yes. Inbuilt back up. Splendid gratuitous extensions: eastward.g. Zotero as well as proprietary extensions.
Advanced find & replace / Special characters	Partial (tdf#38261). Come across List of Regular Expressions. Extension: Alternative dialog Find & Replace for Writer	Yes
Complex Outline numbering / Multilevel listing	Fractional. Different numerically equivalent format not supported (tdf#35217)	Yep
Default keyboard shortcuts	Fractional. Less default shortcuts ([72])	Yes. More default shortcuts ([73])
Add together watermarks to pages	Partial. Support for text watermarks. Workaround for motion picture watermarks via adding image to header/footer.	Partial (text and film watermarks). This is not possible on Chromebooks as at that place is no app, Word for the web cannot exercise watermarks
Outline view	Partial Outline folding mode (equally experimental characteristic) [74] (tdf#38262 tdf#38093), workaround: Navigator > Content View to elevate and promote/demote headings (see Improvements to Navigator in 7.0)	Yep
Complex/rich text formatting in comments (due east.grand. bullet points, text color, images, tables)	No. Some formatting features are supported, east.yard. font type, font size, assuming, italics, underline, text alignment (align, centered, justified). (tdf#81458)	Yes
Certificate/text translation	No (tdf#34058), extension: TradutorLibreText.	Yes ([75])
Decorative page borders	No (tdf#39270)	Yes
Horizontal divide view of the aforementioned document	No (tdf#31481), workaround: Windows > New Window to clone certificate window.	Yes
Draft view	No (tdf#67698)	Yes
Upload to blog servers	No, extension: Sun Web log Publisher (outdated).	Yes (MS Sharepoint Web log, Telligent-Community, TypePad, WordPress, MetaWebLog API)
Digital pen usage / ink gestures	No	Yep [76]. (Non supported in MS Function 2021 sales version and not supported in macOS version)
Transform certificate into a Sway web page	No	Yes. supported in MS Word. (Not supported in MS Function 2021 sales version and not supported in macOS version)
Line by line reading of text	No	Yes. Line Focus (removes removes distractions) feature in MS Give-and-take.
'File name without extension' field	Aye [77]	No [78] [79]

Desktop Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences	LO Calc 7.3	MS Excel 2021 / 365
Spreadsheet functions (for details meet Functions comparison of LibreOffice Calc and Excel)	Yes. 508 functions (29 functions unique to Calc) See an extensive description of Calc Functions	Yep. 477 functions (23 functions unique to Excel)
Unique Spreadsheet functions	Aye. Electric current, DDE, MONTHS, OPT_BARRIER, OPT_PROB_HIT, OPT_PROB_INMONEY, OPT_TOUCH, Mode, EASTERSUNDAY, YEARS, DAYSINMONTH, DAYSINYEAR, GOALSEEK, ISLEAPYEAR, MULTIPLE.OPERATIONS, MULTIRANGE, MVALUE, NEG, ROT13, WEEKS, WEEKSINYEAR, FORECAST.ETS.MULT, FORECAST.ETS.PI.MULT, FORECAST.ETS.STAT.MULT, RAWSUBTRACT, REGEX, ROUNDSIG, FOURIER, RAND.NV, RANDBETWEEN.NV. Extension: Kanji to Phonetic provides PHONETIC office.	Yes. CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, RTD, DBCS, Phone call, Annals.ID, PHONETIC, YEN, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY (tdf#126573), LET, XLOOKUP (tdf#127293), XMATCH (tdf#128425). STOCKHISTORY (Not available in MS Part 2021 sales versions)
Comparison of two spreadsheet files	Yes	No
Page styles (in addition to cell styles)	Yeah	No
Hyphenation of text in cells	Yes	No
AutoSpellcheck / Spelling as you type	Yes	No ([80])
Export to XHTML	Yes	No
Full-Sheet Previews: Possibility to export all pages on a sheet as one folio in the PDF	Yes	No
Exporting of a single nautical chart as paradigm (e.g. jpg, png, svg, pdf)	Yes	Yes [81]
OpenFormula standard	Yes. Largely supported	Partial
Keep the copy of cells (usability of copy&paste)	Yep. (Re-create of cells is kept for pasting, even if the user does other tasks similar typing or inserting cells)	No ([82])
Import of Apple Numbers spreadsheet documents	Yes. Support for Numbers v1-3 [83], see also this comparison	No
Maximum number of columns per sheet	No. 1,024. Jumbo spreadsheets up to 16,384 columns are (highly) experimental, see: tdf#50916 tdf#133764 tdf#133619.	Yeah. 16,384 (256 in compatibility mode)
Tabular array styles	Partial. View ▸ Toolbars ▸ Tools ▸ Cull Themes besides as Format ▸ AutoFormat provide role of this functionality. (tdf#77569, tdf#44762,tdf#44763)	Yes
Tape a macro	Partial. Limited support [84]	Yep
Insert a graphic into a spreadsheet header or footer	Fractional. Inserted image cannot be resized nor cropped, usability bug. (tdf#74146)	Yes
Statistical / Analysis toolkit	Fractional. Built-in Data Statistics Wizard with additional features: Chi2-test, Logarithmic regression, Power regression	Partial. Add-on, not activated past default. Boosted features: Histogram, Random number generation, Rank and percentiles, and some more than detailed options.
Nautical chart styles	No (tdf#62925, tdf#62540, tdf#39097)	Fractional. Option of some pre-set chart styles and layouts
Power Pivot⁠ features	No (tdf#96623 regarding DAX functions)	Yes
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)	Yes
Relationships between tables, based on matching data in each table	No (work effectually: using role VLOOKUP)	Yes ([85])
Integration of external information sources	No. Extension: New Jaguar Calc add-in provides SQLREQUEST function and Queryconnector provides graphical interface.	Yes. Queries and data sources via "Power Query" and "Ability BI" [86]. (SQL.REQUEST removed in favor of Power Query since MS Excel 2010)
Linked information types	No	Aye. Data types from online sources: geography, stocks, organization, location, nada code, university, space, satellite, element, chemistry, food, exercise, movie, characters, medical, body, media, nature, activities, other (Not bachelor in MS Office 2021 sales versions) [87],[88]
Forecasting data to predict future trends	Yes. Extended set up of forecast functions (based on exponential smoothing algorithm)	Yep. Forecast functions and forecast charts (based on exponential smoothing algorithm) (non supported in macOS version)
Import MS Access databases	Fractional. Via ODB file connected to database (needs MS Admission installed on the organisation)	Yes
Multi-Core Processing / multithreading	Partial. Multi-threaded calculation [89]. Multi-threaded import of XLSX documents. Parallel formula compiling on the CPU. OpenCL/GPU threading in Calc core ([90],[91]). Multithreading is work in progress: tdf#65046, [92], Presentation "Making Calc Summate in Parallel".	Yeah. Starting in Excel 2010, the post-obit features employ 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 functioning speed. The first procedure gets the data, and the 2nd procedure loads the information into the advisable structure in retentiveness or writes the data to a file. In this style, as soon as the first procedure begins reading a portion of data, the 2d process can immediately start loading or writing that information, while the showtime procedure continues to read the next portion of information. Previously, the beginning procedure had to terminate reading all the information in a certain section before the second process could load that section of the data into retentivity or write the information to a file. ([93], [94])
Declaration of variables to exist used in formulas	No	Yeah. LET function
Data-linked creation of flowcharts	No	Yes Menses charts and organizational charts (supported in rental version, not supported in MS Office 2021 sales versions)
Export generic XML	No	Yes
Customized canvas views (while collaborative editing)	No	Yes ([95])
Pocket-sized Characteristic Differences	LO Calc seven.3	MS Excel 2021 / 365
Flexible CSV export	Yes. Supported ([96], [97])	No
Advanced observe & replace / regular expressions / special characters	Yeah (List of Regular Expressions)	No
View clone of spreadsheet in new window	Yes. Independent window	No. Cannot be moved outside the application window
Median in PivotTable	Yes tdf#61700	No [98]
Chart type Stepped lines for XY (Scatter) graphs	Yes	No
Use English part names	Yes. Possibility to switch betwixt office names in local linguistic communication and English language	No
Import & Consign Unified Office Format spreadsheet	Yes	No
Import of DOS/Windows legacy spreadsheet formats: Lotus ane-2-iii, Quattro Pro (v1-5.5 DOS; v1.0-6.0 Windows), Microsoft Works spreadsheet, Microsoft Multiplan (v1-3 DOS)	Yes	No
Import of Archetype Mac OS legacy spreadsheet formats: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz, Microsoft Multiplan (v1.11)	Aye	No
Import & Export Pocket Excel	Yes. Supported (requires Java)	No
Ability to rotate entire chart	Yes	No
PDF export of comments	Aye. Consign of comments according to PDF specification	No
Belongings mapping functionality for charts (conditional nautical chart colors/borders)	Yes	No (Only available: Inverting colors for negative values)
Import from Gnumeric	Yes (not available on Windows, run across tdf#94834)	No
Export cell range pick or a selected group of shapes (images) as .png or .jpg image	Yes	No
Export canvas/table every bit .png image	Yep	No
Formatting of cells	Yep. 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 private words, spacing settings, kerning; Borders: shadow, spacing to contents; Protection: hibernate cells when printing.	Partial. Less features
Additional cell format types	Yes. Number format "Boolean value". Engineering notation. Natural language number format (spelling out numbers in various languages. Easy work effectually for missing U.s. zip code and US phone number formats.	Fractional Engineering annotation via custom formats.
Support negative twelvemonth date (BCE)	Yes	Partial Using piece of work-arounds.
Provisional formatting: icon sets	Partial. 2 additional smilies icon sets. No reverse icon order (tdf#61313).	Partial. Customization of icon sets, east.m. contrary icon society.
Advanced discover & replace / Cell Format	Partial (Styles supported, Cell Format not supported)	Yes
Formulae with unabridged columns or entire rows	Partial (tdf#34094, tdf#92452, tdf#92453)	Yeah
Default keyboard and/or mouse shortcuts [99]	Partial. Less default shortcuts ([100], tdf#98259, tdf#92452, tdf#92453)	Yes. More than default shortcuts ([101], [102], [103])
Sheet protection options (allow users certain actions in protected sheets)	Partial. Supported for select protected/unprotected cells and insert/delete rows/columns.	Yes for select protected/unprotected cells, insert/delete rows/columns, format cells/columns/rows, insert hyperlinks, sort, employ AutoFilter/Pivot Tabular array reports, edit objects/scenarios.
Timeline filter in PivotTable	No	Yes [104]
Chart: Automatically vary colours by betoken	No (only manually)	Yes
Nautical chart type: xyz / surface charts	No, basic workaround [105] (tdf#51670)	Yes
Chart type: pie of pie (bar of pie)	No (tdf#50934)	Yeah
Map charts and 3D geospatial visualization tool	No (via extension GeOOo)	Aye. Map charts and "3D Maps".
Dissimilar nautical chart types for different data series	No (tdf#35629)	Yes
Printing of selected chart only	No, workarounds [106], [107] (tdf#45893)	Yes
Nautical chart data labels "Value equally percent"	Aye	No
Chart data labels "Value from cells"	No	Yes
Automatized analysis and visualization features	No	Yes Quick analysis characteristic and visual summaries, trends, and patterns. [108], [109]. Some of these features ("Ideas in Excel") supported in rental version, not supported in MS Function 2021 sales versions; quick analysis feature not supported on macOS.
Flash fill	No (tdf#109003). Some (fractional) workarounds suggested here tdf#109003#c1.	Aye
Nautical chart recommendations	No	Yep
'Publishing' spreadsheet for online squad meetings	No	Yeah
Sparklines (to give a quick overview of the trend in a information range)	No, extension: EuroOffice Sparkline	Yes
Add points to a line, possibility to curve lines	No (tdf#36943)	Yes
Prison cell background options	Fractional. Background color (bugs regarding pattern tdf#31205 and gradient tdf#49177). Extension: Hatch Patterns for Cells	Yep. Groundwork color, pattern, gradient
Insert data from screenshot or film	No	YesOCR and recognize tables from screenshots or pictures [110] (Not available in MS Function 2021 sales versions and only bachelor on macOS)

Desktop Presentation software: LibreOffice Impress vs. Microsoft PowerPoint

Major Feature Differences	LO Impress 7.iii	MS PowerPoint 2021 / 365
Hyphenation back up	Aye	No
Export to XHTML	Yes	No
Consign to HTML	Yes	No (removed feature since MS Function 2013)
Consign to vector graphic formats: SVG, EPS	Yes	Partial, to SVG (Supported in Windows rental version, not supported in MS Office sales versions.)
Presentation remote control for smartphones/tablets	Yep. For Android smartphones/tablets, iOS (iPhone/iPad), and Pebble smartwatches.	Partial. For Android (smartphones just), but with boosted features for Excel and Word. (Not supported in macOS version).
3D slide transitions	Yes. macOS, Linux, Windows	Partial. macOS, Windows
Edit embedded videos	Fractional. Via external programs	Yes. Directly in the program
Comments and reply to comments	Fractional	Yes
Animated effects	Partial. Supported, merely problems with: spinning text (tdf#87958), pixelated (tdf#87959), wobble/shake/vibrate (tdf#87960), objects stuck (tdf#88196)	Yeah
Trim embedded video or audio	No	Yes. Supported (Not supported in MS Office 2016 sales version)
Zooming features for presentations (Prezi inspired)	No (tdf#38263)	Yep. Supported (Non supported in macOS sales version) [111]
Slides editable during presentation	No (tdf#34965)	Yes
SmartArt diagrams	No (tdf#37932), solution: smArt extension	Yep
Salve highlights and drawings during presentation	No (tdf#51928)	Yes
Compare presentations	No	Yes
Broadcast presentation on the Internet	No. Only via consign to PDF or SWF	Yes. Additional support to publish to Microsoft Stream video-sharing site (Not supported in macOS version)
Animated diagrams	No	Yes
Record a slide show	No (tdf#34959)	Yes [112]. Some features just available in rental vesion ([113]).
Slide pattern suggestions	No	Yes via Powerpoint "Designer" (not supported in MS Role 2021 sales versions)
Navigate presentation using a Bluetooth pen	No	Yes. Supported with Bluetooth pen or Surface pen. Using digital pen as a slide-bear witness clicker (Not supported in macOS version)
Optimization of slides for screen readers	No	Yes. ([114]) (not available on macOS)
Minor Characteristic Differences	LO Impress 7.3	MS PowerPoint 2021 / 365
Number of slide layouts	Yes. 12	Partial. 9
Physics based animations	Yes [115]	No
Text background colour in text boxes	Yes	No
PDF consign of comments	Yes. Export of comments co-ordinate to PDF specification	No
Import & Export Unified Office Format presentation	Yes	No
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM	Yes	No
Import of Apple Keynote files	Yes. Support for Keynote v1-6 [116]	No
Embedding of fonts in presentation file	Yes	Partial. Supported on Windows. No support for embedding fonts in PowerPoint on macOS, although displayed. No back up for embedding OpenType CFF fonts. [117]
Maximum folio size	Yes. 300cm x 300cm (Draw and Impress)	Partial. 142.22cm x 142.22cm
Editing of master slides	Partial. Limited editing, has been a GSOC 2013 projection ([118]).	Yes. Powerful editing
Default keyboard shortcuts	Partial. Less default shortcuts ([119])	Yeah. More default shortcuts ([120], [121])
Conversion of hand-drawn shapes into diagrams / recognition of ink equations	No	Yes [122] Conversion of ink to shapes/diagrams in MS Powerpoint; Ink equations (conversion of drawing to equation) in Powerpoint. (Not supported in MS Role 2021 sales versions and only available on Windows x/xi; non supported in macOS sales version).
Automatically suggesting presentation outline from online sources by inbound subject	No	Yes. "QuickStarter feature (Non supported in MS Function 2016 sales version and not supported in Windows version)
"Morph" transition type	No	Yes [123]
Creation of automatically starting presentations	No, extension: ImpressRunner	Yes
Export presentation to video formats	No (tdf#34959)	Yes. Supported to .mp4 and .wmv formats. Export up to 4K resolution.
Slide zoom and pan	No (tdf#38263)	Yep
Option to save every bit picture presentation	No (tdf#93589)	Yes
Using Surface Earbuds to control presentation	No	Yes[124]
Autogeneration of alt text for photos	No	Yes [125] (Supported in Windows rental version, not supported in MS Role sales versions; not supported on macOS)

Desktop Database program: LibreOffice Base vs. Microsoft Admission

Major Feature Differences	LO Base 7.3	MS Access 2021 / 365
Available on all operating systems supported by the office suite	Yep	No. MS Access not available on macOS, online and mobile OS versions
SQL syntax highlighting	Yes	No
Native connectors for: MariaSQL, PostgreSQL, Novell GroupWise	Yes. Plus MySQL as extension.[126]	No. No, via ODBC
Integration of Mozilla Thunderbird accost volume, KDE accost book, Evolution LDAP and storage, Windows system address volume	Aye	No
Native JDBC commuter	Yes	No
Connect to ODF spreadsheet (Calc) file format	Yeah	No
Database engine	Yes. FirebirdSQL three.0; HSQLDB 1.viii.10 (deprecated). In LibreOffice 6.2 FirebirdSQL is the default for new databases. Firebird Migration Assistant converts HSQLDB databases to FirebirdSQL	Partial. Jet
Integration of MS Outlook address book	Partial. Supported only on MS Windows. No support for Outlook (tdf#56903) and Outlook Express (tdf#56905) address book admission in the native 64-flake Windows builds of LibreOffice.	Yep
Importing data sources (tables) from within the database application	Partial. Either via drag & driblet from Calc or via drag & drop from some other Base window with the data source beingness open up. ([127]) (tdf#51872)	Yep
Exporting tables to different file formats from within the database application:	Fractional. Simply via drag&drop to LibreOffice Calc or via drag & drop from another Base window with the writable data source beingness open. ([128]) (tdf#73798)	Yep
Edit MS Access files	Partial. Limited older commuter "Microsoft.Jet.OLEDB.iv.0" works fine for read/write, while "Microsoft.ACE.OLEDB.12.0" driver only reads; (tdf#43187). Driver only works on Windows.	Yep
Native connector for: Microsoft SQL Server	No. No, via ODBC	Yes
Crosstab queries	No. Not supported but reproducible with Pivot Table with Calc (FAQ 142 )	Yes
"Linked tables" capability	No. Not supported simply you can link text tables (FAQ 143) (tdf#56234)	Aye. Linked tables and Linked Tables Manager.
Imported table from spreadsheets - keep fields format	No	Aye
Import information from XML, HTML	No	Yep
Pocket-sized Characteristic Differences	LO Base of operations 7.3	MS Access 2021 / 365
Native connector for: dBase databases	Yes	No. Not supported (removed feature since Office 2013)
Open LibreOffice Base (.odb) files	Aye	No
Open DOS/Windows legacy formats: Microsoft Works database	Yes	No
Native connector for: SharePoint lists	No	Aye
Link or import information from Salesforce and Dynamics 365	No	Aye
Spider web service data connectedness	No	Yes
Password protection of database	No (tdf#70638)	Yes
Calculations in database tables	No (tdf#72787)	Yes

Near important extensions for desktop LibreOffice

LibreOffice has a complex eco-system of extensions (over 390 on extensions.libreoffice.org and over 800 on extensions.openoffice.org). Additionally to the extensions already mentioned in above comparison tabular array, here is a choice of some extensions adding valuable features to LibreOffice:

	LibreOffice Extensions
Full general office suite: LibreOffice	Overview of language-related extensions for LibreOffice (Writing aids, spell-cheque dictionaries, hyphenation patterns, Grammar cheque,...) OpenOffice.org2GoogleDocs exports, updates and imports documents to and from Google Docs, Zoho and WebDAV servers. TeamDrive allows to shared spaces in the TeamDrive collaboration software. Wollmux is a circuitous centralized system for templates, forms and letter heads adult past the city of Munich (in German and English linguistic communication). eLAIX allows users to write and read ILIAS learning modules offline and to export to ePUB3 due east-book file format. LibreOffice Server Installation GUI facilitates parallel and server installations of LibreOffice. Shared Technical Terminology Thesaurus Read Text. Read pick of text with Calc, Draw, Impress, Web Author and Author using oral communication synthesis. Custom Palette Export (allows to easily share custom color palettes) OOoLilyPond, use LilyPond musical notation inside LibreOffice.
LibreOffice Writer	TexMaths adds an (Xe)LaTeX equation editor to LibreOffice DMaths adds a comprehensive mathematical tool box to LibreOffice Writer Chemistry allows to insert chemistry formulas every bit image from formula. Code Colorizer Formatter, Code Highlighter or COOoder provide syntax highlighting for LibreOffice Writer. AddPics creates a Author document from pictures of scanned pages. Author'due south Tools is a set of utilities for frequent writers. Alternative find & supercede dialog for Writer. Typography toolbar for advanced apply of Graphite smart font features. QR code Generator Transcriber, transcription tool for sound files. Organon, organisation and navigation tool to organize long texts (novels, narrations, scientific works). Template Changer, allows to change the template for an existing document. Footswitch. A transcription tool working wholly within LibreOffice Author. TradutorLibreText. Tool to interpret texts in several languages. Anaphraseus True cat tool. Macro ready for Computer Aided Translation similar to famous Wordfast. Writer Rotation Tool, allows to rotate an image in a text document using the mouse, like others graphical objects. File format filters Export Freemind allows to consign Writer documents to Freemind mind manager. Writer2LaTex allows to export Writer documents to LaTex. Writer2ePub allows to export to the a gratuitous and open up e-book standard ePub.
LibreOffice Calc	Ability Detective enhances Detective/Trace Precedents and Trace Dependents. GeOOo allows to create thematic maps with LibreOffice. CorelPolyGUI: Nautical chart tendency lines improved: polynomial trend line, force intercept of tendency line and moving boilerplate trend line (most of its functionality is included in LibreOffice 4.2) PalOOCa OLAP Calc Extension: Connecting Calc to access Palo or XMLA capable OLAP servers. Display Formula and Consequence (Value) simultaneously Digitizer of XY chart LibreWeb, a tool to fill spreadsheet cells with data from different web pages. Remove Duplicates, quickly remove duplicates in Calc. New Jaguar Calc add-in provides SQLREQUEST function. File format filters: Calc2LaTeX allows to convert Calc tables to LaTeX.
LibreOffice Impress	Export as Images allows to consign all the Impress slides or Depict pages equally images in JPG, PNG, GIF, BMP and TIFF formats. OpenCards is a free award-winning flashcard learning software.
LibreOffice Draw	Barcode enables LibreOffice to add barcodes to documents. GeOOO allows the creations of thematic maps with LibreOffice. Cadlo makes it possible to make technical drawings in LibreOffice Draw. File format filters: GEDCOM import filter for Draw. Import Google World files (kml) in Draw. Gallery contents, shapes & stencils: A ready of gallery themes to describe diagrams like excursion diagram. Network equipment shapes for LibreOffice. 1600 maps, diagrams, graphs, for geography and history. All countries, all states, all regions and all historical periods.
LibreOffice Base	Access2Base VBA for MSAccess emulator. (installed by default in LibreOffice vi.ii; available for download for older versions than 6.one) BaseDocumenter fully document a LibreOffice Base application.
Accessibility extensions	odt2daisy, converts OpenDocument Text (ODT) to digital talking books in the DAISY format (DAISY 2.02, DAISY 3.0 XML and Total DAISY 3.0) for speech synthesis. Read Text, it uses an external program or a web service to read text. Read the selection with Calc, Draw, Impress, Web Author and Author. odt2braille, enables authors to print documents to a Braille embosser and to export documents as Braille files. The Braille output is well-formatted and highly customizable.

Mobile role: Smartphones, Tablets

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

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

Major Feature Differences	Mobile: LibreOffice-based solutions	Mobile: MS Part 365
Integrated office architecture	Yeah. Integrated office architecture: LibreOffice mobile shares the same processing engine, common to all modules, on all form factors (incl. desktop and online) [129].	No. Loose compages differing between desktop (dissimilar between Windows and macOS), mobile and online function.
Versions of office suite for mobile operating systems (smartphones, tablets)	Yes. Mobile applications bachelor every bit LibreOffice-based Collabora Office. LibreOffice viewer bachelor for iOS/iPadOS, Android and Ubuntu Touch on/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: [130]. More than information: Android port wiki, Commits, [131], [132]. iOS/iPadOS: Collabora Part for iPhone and iPad available: Collabora Role in the Apple tree AppStore. More than data: Collabora press release, Adfinis press release, LibreOffice equally an iOS app on the iPad; Declaration for iOS; Commits: [133], [134]. Chrome Bone: Collabora Role on Google Play available, more information, XDA News Portal. Ubuntu Touch/UBPorts: The Document Viewer is powered by LibreOfficeKit (LibreOffice five) and supports viewing virtually file types supported by LibreOffice.	Fractional. Android and iOS for smartphones and tablets with restricted features fix. No back up for Chrome Bone on tablets. Professional person users as well equally users on tablets >10.1 inch are required to have an eligible Office 365 subscription at a monthly fee. Private users are immune to view and print documents without registration individual users, bones editing functionality requires registration. More comprehensive features require an eligible Office 365 subscription at a monthly fee.
Support of Right-to-left⁠ (RTL) languages (eastward.g. Arabic) and other complex scripts	No	Yep
Pocket-size Feature Differences	Mobile: LibreOffice-based solutions	Mobile: MS Function 365
Run Microsoft Visual Basic Macros.	Yes. Support for a big portion of Microsoft Visual Basic Macros (via Collabora Role).	No

Mobile Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature Differences	Mobile: LibreOffice-based solutions: Author	Mobile: MS Word 365
Open password protected documents	Yes. (via Collabora Office)	No
Small Feature Differences	Mobile: LibreOffice-based solutions: Writer	Mobile: MS Word 365
XY	Partial	Partial.

Mobile Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences	Mobile: LibreOffice-based solutions: Calc	Mobile: MS Excel 365
XY	Partial	Partial.
Small Feature Differences	Mobile: LibreOffice-based solutions: Calc	Mobile: MS Excel 365
XY	Fractional	Partial.

Mobile Presentation software: LibreOffice Print vs. Microsoft PowerPoint

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

Online role: Web browser (and Chromebooks)

The comparison table of online office is Work in Progress.
Please experience 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, information technology is the aforementioned software as used in the Online suite with some optimisations for Chrome Os. In Sept 2021 Microsoft announced the discontinuation of their Chromebook App. By combining Online and Chromebook Apps in this tabular array it enables the easy comparing of LibreOffice based office suites to Microsoft's Online when using a Chromebook.

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

Major Feature Differences	Online: LibreOffice-based Collabora Online Chromebook App: Collabora Role vi.iv.xiv	Online: MS Function for the web Chromebook App: Discontinued
Integrated office architecture	Yes. Integrated office compages: Online LibreOffice shares the same processing engine, common to all modules, on all form factors (incl. mobile and desktop) [135].	No. Loose architecture differing between desktop (different betwixt Windows and macOS), mobile and online part.
Online/cloud version of office suite	Yes. Libreoffice-based Collabora Online 6.4.xiv with full document support and rendering fidelity, likewise equally collaborative editing. Avant-garde but reduced editing functionality compared to the desktop version. Online version supports Vereign uniform authentication & document signing. [136], [137], [138], [139], [140], [141]. See also: LibreOffice Online port development.	Partial. Role spider web apps, with reduced functionality when compared to the Discussion desktop version and Collabora Online. ([142])
Applications	Yes. Online: Author, Calc, Print, Draw. Chromebook Apps: Writer, Calc, Impress	Yes. Give-and-take, Excel, PowerPoint, OneNote, Outlook
Integration of online office suite into (third-party) collaboration software and groupware / content management systems	Yes. Integration of LibreOffice Online in: OwnCloud and Nextcloud, Kolab,Pydio, Seafile,IceWarp, AG-I Solutions, Alinto, VNCLagoon, EGroupware, Univention App Heart, Kopano Documents, LibreOffice Online powered by CIB, Collabora Online, Corteza Community Server, Alfresco [143], Roove, Zimbra ([144]), Mastermost, Moodle, IServ Schulserver. MS SharePoint integration [145]. Run across also this listing: Availability of LibreOffice Online.	Partial. MS Role Online Server integration in MS SharePoint
Availability of online part suite in (third-party) online services / Gratuitous & commercial role cloud hosts	Fractional. Variety of available service providers: UrBerri, eqipe, New Admission, Arawa, Artistanbul, TransfertPro, Extensys,Rono-It, SecuredStore, StudioStorti,united hoster, Choice 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 Cyberspace, Mijncloudoffice, mentorITe, PowerFolder, GMX Online Office, Postal service.com Online Office, Web.de Online Office, hostiso.com, Kolab At present, Crest Tech. See too this listing: Availability of LibreOffice Online.	Partial MS OneDrive
Synchronous collaborative editing	Yes. Supported in online versions of Writer, Calc, Print and Depict (Online merely).No support of collaborative editing in desktop versions.	Yes. Supported in online versions of MS Give-and-take, Excel and Powerpoint. Collaborative editing betwixt online and desktop versions
Support of Right-to-left⁠ (RTL) languages (e.g. Arabic) and other complex scripts	Yes. Comprehensive support, based on HarfBuzz⁠ text shaping library	Yes
Pocket-size Feature Differences	Online: LibreOffice-based Collabora Online Chromebook App: Collabora Office vi.4.xiv	Online: MS Office for the spider web Chromebook App: Discontinued
	Partial	Fractional

Online Give-and-take processors: LibreOffice Online Writer vs. Microsoft Word for the web

Major Feature Differences	Online: LibreOffice-based Collabora Online Writer Chromebook App: Collabora Part Writer 6.4.14	Online: MS Word for the web Chromebook App: Discontinued
WYSIWYG - Full Fidelity Editing, PDF generation, Printing	Yes. What You See Is What You Get. Any certificate being edited looks the aforementioned when saved equally a PDF or when printed (via Online and Chromebook App)	No. Documents being edited do not look the aforementioned when saved equally a PDF or when printed [146]
Open and edit Password Protected Files	Yep. (via Online and Chromebook App)	No. [147]
Edit Password to Modify Documents	Yes. (via Online and Chromebook App)	No [148]
Suit Table Sort Order	Aye. And boosted 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 [149]
Format Table Cells	Yes. By Number, Per centum, Currency, Engagement, Time, Scientific, Fraction, Boolean Value and Text. (via Online and Chromebook App)	No
Headers and Footers appear in the editable certificate	Yes. It is a WYSIWYG give-and-take processor. (via Online and Chromebook App)	No
Find and Replace with options as available on desktop	Yes (via Online and Chromebook App)	No. Very Basic.
Clipboard (Copy and Paste)	Aye. Copying and pasting within the spider web app works with avant-garde document features. Pasting content copied from outside the web app is advanced (via Online)	Partial. Copying and pasting within the spider web app is functional for basic features bachelor 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. [150]
Minor Feature Differences	Online: LibreOffice-based Collabora Online Writer Chromebook App: Collabora Role Writer 6.iv.14	Online: MS Word for the web Chromebook App: Discontinued
Templates, browse and start from professionally designed templates	Aye. (via Online)	No [151]
Salve in Microsoft Word 97 - Word 2003 format (.dr.)	Yes. (via Online and Chromebook App)	No [152]
Save in EPUB e-book format (.epub)	Yes. (via Online and Chromebook App)	No
Run Microsoft Visual Basic Macros, (docm, dotm)	Yes. Back up a large portion of Microsoft Visual Bones Macros (via Online and Chromebook App)	No [153]
Title Folio	Yes. With options for number of title pages, page to start at, title style, title numbering (via Online and Chromebook App)	No
Thesaurus	Aye. (via Online and Chromebook App)	No
Page Gutter Margins (book / thesis binding)	Yep. Gutter Margins can be positioned on the left or top (via Online)	No
Add and Edit Page Backgrounds	Yes. Colour, Gradients, Bitmap, Pattern and Hatch, options bachelor for each of these are the aforementioned or like as in the LibreOffice desktop applications (via Online and Chromebook App)	No [154]
Add and Edit Folio Transparency	Yes. Transparencies, options available are the same or like as in the LibreOffice desktop applications (via Online and Chromebook App)	No [155]
Add and Edit Page Borders	Yes. Borders, options available are the aforementioned or like as in the LibreOffice desktop applications (via Online and Chromebook App)	No [156]
Add and Edit Page Columns	Yes. 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/role-online-service-clarification
Display Headers and Footers, Footnotes, Endnotes in-line in the document	Yes. A WYSIWYG give-and-take processor (via Online and Chromebook App)	No [157]
Add together, Edit, View Charts	Yes. Full options as available in desktop (via Online and Chromebook App)	No. They appear as placeholders that you cannot edit, move or resize [158]
Add, Edit, View Shapes	Yeah. Full options as available in desktop (via Online)	No. They appear equally placeholders that you cannot edit, move or resize [159]
Add, Edit, View SmartArt and WordArt (aka Fontwork)	Yes (via Online)	No. They appear as placeholders that you lot cannot edit, move or resize [160]
Watermarks	Yep (via Online and Chromebook App)	No [161]
Bookmarks	Yes (via Online and Chromebook App)	No [162]
Fields	Yes (With options under sub-categories of Documents, Cross-references, Functions, DocInformation and variables (via Online) Chromebook App has a few less options	No [163]
Edit Cross References	Yes (via Online and Chromebook App)	No. Information technology is non possible to edit the destination [164]
Index	Yes, options available are the same or similar every bit in the LibreOffice desktop applications (via Online)	No [165]
Tabular array: "Optimal Column Widths" and "Optimal Row Height"	Yep (via Online)	No [166]
Full control of anchoring with visible anchor points for images etc.	Yep. WYSIWYG precision visible anchoring (via Online)	No
Text Box	Yes. With full desktop options including, size, anchors, protection, borders, rotation, corners, shading, etc. (via Online)	No. They appear as placeholders that yous cannot edit, motion or resize [167]
Citations and bibliography	Aye (via Online)	No [168]
Rich Fields Support - tab through editable fields; skip protected sections	Yes. Dr. and DOCX forms	No
Table of contents	Yes. Options available are the same or similar equally in the LibreOffice desktop applications (via Online and Chromebook App)	Partial. Bones options. [169]
Page Sizes	Yes. Alphabetic character, Legal, A3, A4, A5, A6, B4 (ISO), B5 (ISO), B6 (ISO), Long Bail, 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, #six 3/four Envelope, #7 3/four (Monarch) Envelope, #ix Envelope, #x Envelope, #11 Envelope, #12 Envelope, Japanese Postcard. (via Online and Chromebook App)	Partial. Letter, Legal, Executive, A4, A5, and custom size layouts [170]
Wrap text around images	Yes. Full options for wrapping text around images including: before, after, parallel, contour wrapping, in front and behind, precision visible anchoring (via Online)	Fractional. No constructive wrapping, the text does not wrap around images.
Give-and-take count and character count	Yep. Accurate count of words and characters. (via Online and Chromebook App)	Partial. A rough count of words. [171]
Table: "Distribute Columns Evenly" and "Distribute Rows Evenly"	No (#3329)	Aye. Called "Distribute Columns" and "Distribute Rows"
Co-authoring between online and native app	No. For more information the meet the row "Synchronous collaborative editing"	Yes. 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)	Yes
Cover Pages	No	Yes. [172]
Add-ins	No	Yes
Dictate	No	Yep
Emoji	No	Yes
Online Video	No	Yep. With preview, supported video providers: YouTube, SlideShare, Vimeo, Stream, Flipgrid, TED
Share as Embedded HTML	No	Yes
Interpret	No. (tdf#34058, #4285)	Aye [173]
Reuse Files	No	Yeah. Open another document in a preview enabling choice of paragraphs or images for insertion, or for adding a link to that document.
Catchup	No	Yes. View changes your collaborators take made to a file since you last opened it.
Insert Equations with Structures	No. (#4049)	Aye
Insert Image options	Partial. Select by binder and file simply. (via Online and Chromebook App)	Yes. Select by binder and file, too by previewing categorised images
Margins	Fractional. Custom options. (via Online and Chromebook App)	Yes. Custom options and 5 presets.
Captions	No	No [174]
Post Merge	No	No [175]
Bullets, Numbering, Outline, Images, Alignment	Yes. 79 bullets inc 71 resizable images, 8 numbering, 8 outline, comprehensive position alignment options. (via Online and Chromebook App)	Yes. 17 bullets inc 13 images, xv numbering, 3 outline, minimal position alignment options. not resizable, merely has option to define new bullet points from the Symbol library
Accessibility checker	Yes (via Online)	Yes

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

Major Feature Differences	Online: LibreOffice-based Collabora Online Calc Chromebook App: Collabora Office Calc 6.4.14	Online: MS Excel for the spider web Chromebook App: Discontinued
XY	Partial	Partial.
Pocket-sized Characteristic Differences	Online: LibreOffice-based Collabora Online Calc Chromebook App: Collabora Function Calc half-dozen.4.14	Online: MS Excel for the web Chromebook App: Discontinued
Save in Microsoft Excel 97 - Excel 2003 (.xls) format	Aye (via Online and Chromebook App).	No
Line Borders	Yes (via Online and Chromebook App).	Partial. 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 Characteristic Differences	Online: LibreOffice-based Collabora Online Print Chromebook App: Collabora Function Impress six.iv.14	Online: MS PowerPoint for the spider web Chromebook App: Discontinued
XY	Partial	Partial
Minor Characteristic Differences	Online: LibreOffice-based Collabora Online Print Chromebook App: Collabora Office Impress six.4.fourteen	Online: MS PowerPoint for the spider web Chromebook App: Discontinued
Salvage in Microsoft Powerpoint 97 - Powerpoint 2003 (.ppt) format	Yes (via Online and Chromebook App).	No
XY	Partial	Partial