How To Split Screen In Libre Office Excel

Wiki Dwelling house
Development
Pattern
QA
Events
Documentation
Website
Localization
Accessibility
Marketing
Diversity
Wiki Assistance

Documentation Home
Official Publications
Other Resources
FAQ
HowTo
Macros
Docs Development

This page compares the features of LibreOffice and Microsoft Office in several course factors. The comparisons separate major and minor characteristic differences and too includes notes on LibreOffice extensions. The comparison highlights differences and therefore does non display any features which are present in both function suites.

At that place are split up comparison tables available for:

Desktop (notebooks, desktop computers): LibreOffice 7.three.ane (download) vs. Microsoft Office 2021 / 365
Mobile (smartphones, tablets): LibreOffice-based mobile solutions (download) vs. Microsoft Office 365 mobile apps
Online (web browser-based role): LibreOffice-based Collabora Online ([1] [two]) vs. Microsoft Office for the web). This section also includes the LibreOffice-based Chromebook App (Collabora Part vi.4.13 download [3]) for reasons explained in the section.

The feature comparison table is continuously beingness updated and is work in progress.
It is a compilation by users and not an official document by the Document Foundation.
Please feel free to amend this page. Last update to this table was made at 8.03.2022

Desktop office: Notebooks, Desktop computers

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

Major Feature Differences	LibreOffice 7.3	MS Office 2021 / 365
Cantankerous-platform availability (desktop)	Yes. Windows, macOS, Linux, FreeBSD, NetBSD, OpenBSD, and Haiku. (based on the same code base). Chrome Os via Collabora Function. Integrated office architecture: LibreOffice for the desktop shares the same processing engine, mutual 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 problems, somewhat different feature sets and differences in the user interface; macOS version does not include the database application MS Access, does not include MS Publisher, and also lacks a number of other features (see beneath). Characteristic inconsistencies/differences in Windows versions, between "MS Office 2021" sales version and the "Function 365" rental version: some features are being subsequently included merely in the rental version (newly added features too differ between macOS and MS Windows) leading to inconsistencies in the feature set (encounter below).
Supported versions of MS Windows	Yes. Windows seven SP1, eight, 8.1, 10, 11, Windows Server 2008, 2012, 2016, 2019, 2022. ([five]). Version LibreOffice 5.four even so supported Windows XP SP3, Vista.	Yeah. MS Role 2021 sales version: Windows 10, 11; Server 2019, 2022. MS Office 365 rental version: Windows 8.1, 10, eleven, Windows Server 2016, 2019 ([6]).
Supported versions of macOS	Yep. ten.12+ (Sierra). Intel and Apple Silicon. ([7]).	Yeah. The newest three versions (as of Feb 2022: 10.15+ (Catalina)). Intel and Apple Silicon. ([8])
Portable version that runs on USB flash disks (without installation)	Yeah (download)	No
Open Source	Yes, licensed under MPLv2 and others.	No, proprietary and airtight-source
Total integration of all function components	Yes. From within each part component, files of all other components tin exist opened and exist newly created. Key StartCenter with access to office modules, recently used files and templates.	No
Availability complimentary of charge	Yep (download, donate)	No, proprietary software to purchase or rent. When subscription for the rental version ends, applications enter read-only style (view or impress) and no new documents can exist created. The purchase-version is a perpetual license. One-month trial version bachelor for the rental version (but not for the one-time purchase version).
Extension availability	Yes. Complex 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").	Partial. Partly, no centralized extension system for add-ons and macros. Microsoft AppSource for Office 365. [ix] Office Apps not supported on macOS.
Localization	Aye. 119 languages (detailed list of languages supported by LibreOffice)	Fractional. 91 languages in Windows version, 27 languages in macOS version (display language for (some) office applications)[10], [11], [12]
Support of Right-to-left⁠ (RTL) languages (east.g. Arabic) and other complex scripts	Yes. Comprehensive support, based on HarfBuzz⁠ text shaping library	Yes
Additional writing aids	Yep. Extended back up (spell-cheque dictionaries, hyphenation patterns, thesaurus and grammer check, specialized dictionaries as extensions ([13], [fourteen]). Detailed listing of LibreOffice writing aids for over 150 languages.	Partial. More limited, "proofing tools" for 92 languages in Windows version, 58 in macOS version [xv], [xvi],[17]
Linguistic communication technology	Aye. Comprehensive support, based on the about popular spellchecking library Hunspell LibreOffice Linguistic communication Engineering – News & Best practices, YouTube, Hunspell ane.7, LibreOffice vs MS Role, Better coverage: words, Unicode, morphology, 3 false alarms in Word, zero in Writer	Partial. Limited
Support of complex languages and special smart-font features (ligatures, truthful minor caps, old style numbers, proportional or mono-spaced numbers, capital spacing, and true superscript/subscript)	Fractional. Full support of SIL Graphite font engineering science ([18],[19]) and total support of OpenType optional features ([20],[21],[22]) by syntax and UI (tdf#58941). Come across also LibreOffice Smart Font HowTo. Support for Apple Advanced Typography (AAT) available on all platforms. Interoperability: No back up for optional OpenType features in OOXML, and ODF 1.2 doesn't provide OpenType optional features support (support scheduled for ODF later)	Partial. Limited via OpenType supporting ligatures, stylistic sets, number spacing options, number forms, and contextual alternates. [23] Back up for optional OpenType features in OOXML.
Support of font variation	Partial. Limited support for font rendering on screen, no back up for printing and PDF export. tdf#108497	Partial. Limited support for font rendering on screen, no back up for printing and PDF export.
Easy access to vector clip fine art	Yes . 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 fine 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 Bones, JavaScript, BeanShell, and Python). ScriptForge libraries as extensible and robust collection of macro scripting resources for Basic and Python. Import and export of Visual Basic for Applications (VBA), encounter ([26] and the release notes).	Partial. Single language, support for Visual Basic for Applications (VBA). Indirectly also Visual Bones or Visual C# by using automation.
CMIS protocol support to access Document Management Systems	Yes. Support for Google Drive, MS OneDrive, Alfresco, IBM FileNet, IBM Connections Cloud, Lotus Quickr Domino, Nuxeo, OpenDataSpace, OpenText ELS, MS Sharepoint, WebDAV, FTP, SSH, Windows share. (tdf#62437)	Fractional. Inbuilt support simply for MS SharePoint and MS OneDrive
Back up of ISO standards OpenDocument Format (ODF)⁠	Yes. Advanced support, ODF v1.3 extended	Partial. Express support, 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 crave the use 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 epitome settings, Hybrid PDF, transition effects, extended security and permission options, PDF forms, initial view settings, extended treatment of URLs, digital signatures, and PDF signatures according to PAdES⁠ standard). Support for font embedding of all font types (incl. OpenType CFF fonts (.otf)). Support for PDF/A-1, PDF/A-2 (archiving) and PDF/UA (universal accessibility) standards.	Partial. High or low quality PDF, page and markup to print in Admission, Word, Excel, and PowerPoint [30]; pictures resolution and not-press informations in Publisher. No support for font embedding of OpenType CFF fonts in PDF export [31].
Document nomenclature	Yes. Document classification in Writer, Calc, and Impress according to TSCP-standards (likewise with multiple policies). Run across: [32] and [33].	Partial. No inbuilt document classification system, but Information Rights Direction (IRM) supported
Import of SVG vector graphics (.svg, .svgz)	Aye	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 issues, but could exist manually enabled via Windows registry. There were general rendering bug of .eps files in PDF consign ([36]).
Insert PDF as an image into documents	Yeah ([37])	No
Creation of Hybrid PDFs (ODF file embedded in PDF for full editing)	Yeah	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 Draw (.zmf), QuarkXPress 3.1 to four.1	Yeah	No
Import of MS Visio files	Yes. Supported (Visio 2000-2013)	No (just via MS Visio which is non part of MS Role)
Import of video and audio formats FLAC Sound (.flac), Flash Video (.flv), Matroska Media (.mkv), OGG Audio, Ogg Video, Quicktime Video, WebM Video, Real Audio (.ra), Existent Media (.rm), Digital Video (.dv), Audio Codec (.ac3), and Ogg Opus (.opus)	Yep	No
Drawing and vector graphics software	Yep. LibreOffice Draw, cartoon and vector graphics software that supports pages (upwards to 300cm 10 300cm), layers, numerous drawing tools and DTP features.	Partial. MS Powerpoint provides some features of a cartoon software.
PIM and email software	No. Non part of LibreOffice, referring to alternative PIM software such equally Mozilla Thunderbird. See the comparison on this wiki: Mozilla Thunderbird vs. Microsoft Outlook. Mail Merge Wizard sends out emails directly from LibreOffice without electronic mail software. LibreOffice-broad admission to address books via Base.	Yes. MS Outlook
Desktop publishing (DTP) software	Fractional. Writer supports many advanced DTP features (run into section on Writer in this comparing table). Draw supports frame-based DTP features. Import of MS Publisher files (and from other DTP software) in Draw.	Aye. MS Publisher
Integrated Evolution Environment (IDE) feature ready	Partial. The BASIC Integrated Evolution Surroundings (IDE) does not accept: 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 every bit auto-lawmaking-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 Basic for Applications and/or boosted purchase of Office Programmer Tools for Visual Studio (Windows-merely). macOS version only supports a simplified Visual Basic Editor.
Import & Export of Microsoft OOXML files	Partial. Practiced and extended support of real life OOXML files (e.g. .xlsx, .docx, .pptx), standardized (transitional) OOXML files, besides as import of OOXML-strict files. [38]	Yes. Advanced support of transitional (default) and strict OOXML files
PDF Import	Partial, into Draw and Writer with the limitation that text is imported line-based (tdf#32249).	Yes, into MS Word
Synchronous collaborative editing	No. Not available in the desktop applications (tdf#133984), meet development information: Collaborative Editing and Rails changes. Collaborative editing in LibreOffice online versions.	Yes. Back up in desktop applications via MS OneDrive, MS Sharepoint or MS Teams. Support in desktop applications varies: Real-fourth dimension "co-authoring" in MS Word, Powerpoint, and MS Excel (only via AutoSave) [39] (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 characteristic, which automatically saves every few seconds, is supported in MS Discussion, 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	Yes. Highly customizable UI concept "MUFFIN" [40],[41]: Available user interfaces: (1) Archetype UI with multiple toolbars mode, and Sidebar panel. (2) Single Toolbar style, and Sidebar console. (3) Notebookbar Tabbed UI. (iv) Notebookbar Grouped Compact UI. (5) Notebookbar Tabbed Meaty UI. (vi) Notebookbar Contextual Unmarried UI (Writer and Draw). Customization possible: Several icon themes available (Karasa Jaga, Breeze, Breeze Nighttime, New Colibre, Uncomplicated, Sifr, Sifr Dark, Sukapura, Tango). Color themes "Normal" and "Night" via Tools ▸ Options ▸ LibreOffice ▸ Application Colors.	Partial. Ribbon UI; Colour themes ([42]) on MS Windows: Colorful, Dark Grayness, Black, White, Night mode. On macOS: Colorful, Classic, Dark manner.
User interface improved to enable utilise on bear upon screen devices on desktop operating systems.	No (tdf#102015)	Partial. 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-Upwards-Display (HUD).	Yes. Information technology can be invoked with the bill of fare Help ▸ Serch Commands or the shortcut `⇧ Shift`+`Esc`. tdf#91874 blog	Yes. Tell Me search bar. Search with voice (supported in Windows rental version, not supported in MS Office 2021 sales versions; not bachelor 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. Non-persistent chat (history not preserved; new users see but newly incoming messages). (Not supported in MS Office 2019 sales version; non supported on Android and iOS).
Integration of instant Messaging (IM), voice, video, or screen sharing.	No	Aye. Skype integration (not supported in macOS version).
Dictation / voice communication recognition	No	Yep in MS Word, MS Powerpoint, MS Outlook [46]. Vox audio is sent to Microsoft deject servers and returned equally text. (Not supported in MS Function 2021 sales versions)
Inserting and editing 3D models	No (previous support in Impress for glTF (.dae/.kmz) 3D models removed in version 6.0)	Yeah 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	No	Yes [47]
Support of math fonts	No (tdf#103680), workaround using TexMaths extension with XeLaTeX compiler. [48]	Yes
Minor Feature Differences	LibreOffice seven.3	MS Office 2021 / 365
Generation of QR codes and barcodes	Yes. 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	Yeah	No
Import of Archetype Mac Bone legacy vector and bitmap graphics formats: BeagleWorks, ClarisWorks, GreatWorks, MacPaint, MacWorks, SuperPaint, MacDraw, MacDraw 2, RagTime for Mac 2-3, ClarisDraw, MacDraft	Yes	No
Import of additional video and audio formats: CD Audio, Vivo Video.	Yes	No
Drawing features: Pointer endings	Yes. Essentially wider selection, including Crow's feet notation	No. Less supported arrow endings
Cartoon features: Point Eraser, Lasso, Sketched outline manner.	No	Yep. ([49]) (not available on macOS). ([50])
Certificate converter wizard	Yes	No
Euro currency converter wizard	Yep	No
Skilful config to admission a multitude of settings from UI	Yes	No
Support for multiple colour palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc)	Yeah (annotation: tdf#92354)	No
Import MathML formula from clipboard	Aye	No
Import of StarOffice binary file formats .sdc, .sda, .sdw	Partial. 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 Role problematic (tdf#58442, tdf#58476). Import/export of PDF signatures. Back up of XAdES⁠ standard (XML Advanced Electronic Signatures) and OpenPGP keys. Support for ECDSA keys (on Linux and macOS). Support for OpenPGP-based document encryption.	Aye (OOXML/XML-DSig and XAdES signatures)
Convert SVG image to shapes / polygon	Yeah. Conversion supported in LO Draw. Additionally opening SVG files directly as shapes is supported in LO Draw. (tdf#115571)	Yes
Enhanced list of recent files and folders	Partial (tdf#61174, tdf#60743). Option to clear list of recent documents. Selectively delete Contempo Documents (in StartCenter)	Yes (option to ready recent files as permanent)
Custom colors in formula editor	Aye. Full support of HTML colors in Math (RGB colors, UI in element pane) (tdf#40436)	Aye
Third-political party software dependencies	Partial. Java runtime surround (JRE) installation required for certain - but 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, run across Unicode character input with Alt+X	Partial. 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)	Fractional [51] Insert online videos (Youtube, Vimeo, Slideshare.net) to MS Give-and-take (non available on macOS). Insert online videos (Youtube, Vimeo, MS Stream, Flipgrid) to MS Powerpoint. Insert online pictures in Discussion, Excel, Powerpoint.
Collaboration with @mentions in comments	No	Yes, in PowerPoint, Excel, Give-and-take, and Outlook. [52]
Quick access to email attachments	No	Aye, "Shared with me" feature in PowerPoint, Excel, Word.
Streaming of office applications/office 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)	Yeah. Several pens, highlighters, colors and color furnishings, and pencils for inking to draw/annotate/highlight. Lasso Select (costless-form tool for selecting ink). Ink replay characteristic
Recognition of shapes from ink drawings	No	Aye. [54] supported in MS Discussion, MS Excel, and MS Powerpoint
Recognition of text from ink drawings	No	Yeah. [55] Conversion of ink to shapes in MS Powerpoint and MS Discussion (Not supported in MS Office 2021 sales versions)
Automatic groundwork removal of a moving-picture show	No (tdf#103424)	Aye. Supported in MS Windows version (not supported in macOS version)
Live preview while formatting	No (tdf#37048)	Yes
Inserting a screenshot from inside applications	No	Yes
Import of graphics formats: MEZ, EMZ, WMZ, PCZ	No (tdf#103954)	Yes
Export to XPS format⁠	No	Aye
Support for Touch Bar on Apple MacBook Pro	No (tdf#105803)	Yes (macOS just)

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

Major Feature Differences	LO Writer 7.3	MS Word 2021 / 365
Treatment of captions for graphics or image boxes	Yep. Stable layout	No. Layout bug
Styles (page styles, frame styles)	Yes	No
Overlining of text	Yeah	No. No, only complicated workaround
Master documents for longer texts	Yes. Main documents and Primary certificate templates supported	No. Supported just deprecated because information technology causes file corruption
Redaction tool / sanitization of classified information	Yes. Supported. Redaction & Automatic redaction tool	No
Register-true feature / register accurateness (DTP-feature)	Yes	No
Business bill of fare wizard	Aye (release notes)	No
Text motorcar completion of words already used earlier	Yeah [56]	No
XForms documents creation	Yes	No
Mathematical calculations in tables	Aye. Complex calculations	No. Just basic arithmetic
DocBook import & consign	Yep	No
Export to MediaWiki (Wikipedia) format	Yes	No
Consign to XHTML	Yes	No
Export to EPUB⁠ due east-book file format (.epub)	Aye	No
Export document as prototype(due south)	Yes. Supported, prototype formats: .jpg, .png	No
Import of Apple Pages documents	Yes. Back up for Pages v1-5 [57]	No
Working with large documents	Yes. Stable layout	Fractional. Some layout problems [58]
Extended characterization creation features (release notes)	Yes (generic database access, synchronise content)	Fractional
Frames	Yes. 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)	Yes	Aye. Supported, under the proper name Click and blazon (advanced option)
Tabular array styles	Partial (release notes 5.iii and release notes 6.0) (tdf#34391).	Yes
PDF export of comments	Partial. Export of comments according to PDF specification (via "File" > "Export as PDF"). PDF export of comments: inside the margin, at cease of page, at stop of certificate (activation complicated, only via: "Tools" > "Options" > "LibreOffice Writer" > "Print" (tdf#77650))	Partial. Export only as comments inside margin
Grammar bank check	Partial. out of the box simply 4 languages (English, Russian, Hungarian and Brazilian Portuguese) extensions: e.g. Languagetool for 30 languages plus thirteen language variants (level of language support varies; 11 languages with more g rules), Grammalecte for French, CoGroo for Brazilian Portuguese	Yes. 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)	Partial. Different. Templates provide this functionality, merely more difficult to handle. Helpful extension: Template Changer (tdf#89286). Experimental design themes: (tdf#45176, tdf#90497)	Yep. Supported ("certificate themes")
Employ of LaTeX syntax for formulas	No. Extension: TexMaths	Aye. Ability to type math using the LaTeX syntax (Not supported in macOS version)
Vertical alignment (pinnacle/center/bottom) of content on folio	No (tdf#36117), workarounds via frame/table	Yeah
Picture styles & additional effects	No (tdf#59906), but effects are preserved on import and export. Glow effect and soft edges supported	Yes
View changes in the margin in "track changes" fashion	Fractional Selection 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	Yes
Diagonal borders in tables	No (tdf#51665)	Yes
Extended reading fashion of documents	No (tdf#55168)	Aye
Plummet and expand parts of a document	Available as experimental characteristic [59]. (tdf#47746)	Aye
Instant messaging while collaborating on document	No	Yes ([sixty])
Rail changes only for own changes (while collaborative editing)	No	Yeah. Option to rails one's own changes without forcing others to rails theirs ([61]). (not supported in MS Office 2021 sales versions)
Reading aloud; Text-to-spoken language (TTS) ability	No. Extension Read Text.	Yes ([62])
Small-scale Characteristic Differences	LO Writer 7.3	MS Word 2021 / 365
Protected cells in tables (allows better creation of forms)	Yep	No
Open up erroneous .doc files	Yeah. Better recovery way ([63],[64])	No. More frequently denies opening those files
Magician to create personalized letter of the alphabet templates	Yes	No
Import & Consign Unified Office Format text	Yes	No
Import & Export AportisDoc (Palm), PocketWord documents	Yes. Supported (requires Java)	No
Import of AbiWord files	Yes	No
Import of eBook formats: FictionBook two.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm)	Yes	No
Import of legacy Mac OS word processing documents: MS Word for Mac (i-5.1), MS Works for Mac (ane-iv), ClarisWorks/AppleWorks, Write Now, MacWriteII/MacWritePro, DOCMaker 4, FullWrite Professional, HanMac Word-K/J, LightWayText for Mac 4.v, Mariner Write Mac Classic i.half-dozen-3.five, MindWrite Document, Nisus Writer Mac Classic 3.four-vi.5, TeachText/SimpleText 1, Tex-Edit 2, WriterPlus, Z-Write 1.3, eDOC 2, Acta Mac Archetype, BeagleWorks/WordPerfect Works 1, GreatWorks, MacDoc 1, MoreMac 2-three, RagTime for Mac 2-3	Yes	No
Import of DOS/Windows legacy discussion processing documents: Microsoft Word for DOS, Microsoft WinWord 5, Microsoft Word half-dozen.0 / 95, Microsoft Write, Hangul WP97, Text 602 (T602), Lotus WordPro	Yeah	No
Logo toolbar and interpreter	Aye [65]	No
Format text of all comments in document	Yeah	No
Text boxes let multiple columns	Yes	No
Markdown feature to automated format assuming, /italic/, -strikeout- and _underline_	Aye. (How to switch on the characteristic). See besides tdf#133023	No
PDF export preserves footnote/endnote anchors	Yeah. 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], [seventy])
Automated replacement of Emojis	Yes. supported. Additional toolbar control to insert Emojis (experimental: tdf#100100)	Fractional. Manual creation of replacement lists
Number of columns per table in certificate	Yes. Unlimited columns	Partial. Limited to 63 columns
Multi-line headings for chapters	Aye. Multi-line headings for chapters past allowing a line intermission as separator between a chapter number and its proper noun (in Affiliate Numbering dialog)	Partial. Only via work-effectually [71]
Maximum page size	Yes. 300cm x 300cm	Partial. 55.87cm x 55.87cm
Bibliographic features	Partial. Basic inbuilt support. Excellent free extensions: e.yard. Zotero, JabRef also as proprietary extensions.	Yes. Inbuilt support. Fantabulous gratuitous extensions: e.1000. Zotero as well as proprietary extensions.
Advanced find & replace / Special characters	Fractional (tdf#38261). Come across List of Regular Expressions. Extension: Culling dialog Observe & Replace for Writer	Aye
Complex Outline numbering / Multilevel list	Partial. Different numerically equivalent format not supported (tdf#35217)	Yes
Default keyboard shortcuts	Partial. Less default shortcuts ([72])	Yeah. More than default shortcuts ([73])
Add together watermarks to pages	Partial. Support for text watermarks. Workaround for picture show watermarks via calculation paradigm to header/footer.	Partial (text and picture watermarks). This is not possible on Chromebooks equally in that location is no app, Give-and-take for the web cannot do watermarks
Outline view	Partial Outline folding mode (as experimental feature) [74] (tdf#38262 tdf#38093), workaround: Navigator > Content View to elevate and promote/bench headings (see Improvements to Navigator in 7.0)	Yep
Circuitous/rich text formatting in comments (e.g. bullet points, text color, images, tables)	No. Some formatting features are supported, east.g. font type, font size, bold, italics, underline, text alignment (marshal, centered, justified). (tdf#81458)	Yep
Document/text translation	No (tdf#34058), extension: TradutorLibreText.	Yes ([75])
Decorative folio borders	No (tdf#39270)	Yes
Horizontal divide view of the same document	No (tdf#31481), workaround: Windows > New Window to clone document window.	Yes
Draft view	No (tdf#67698)	Yes
Upload to blog servers	No, extension: Lord's day Weblog Publisher (outdated).	Yes (MS Sharepoint Blog, Telligent-Community, TypePad, WordPress, MetaWebLog API)
Digital pen usage / ink gestures	No	Yes [76]. (Not supported in MS Role 2021 sales version and non supported in macOS version)
Transform document into a Sway web page	No	Yeah. 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	Aye. Line Focus (removes removes distractions) characteristic in MS Give-and-take.
'File proper name without extension' field	Yeah [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 run into Functions comparison of LibreOffice Calc and Excel)	Yes. 508 functions (29 functions unique to Calc)	Yeah. 477 functions (23 functions unique to Excel)
Unique Spreadsheet functions	Yes. Electric current, DDE, MONTHS, OPT_BARRIER, OPT_PROB_HIT, OPT_PROB_INMONEY, OPT_TOUCH, Manner, 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 function.	Yes. CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, RTD, DBCS, Telephone call, Register.ID, PHONETIC, YEN, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY (tdf#126573), Let, XLOOKUP (tdf#127293), XMATCH (tdf#128425). STOCKHISTORY (Not available in MS Role 2021 sales versions)
Comparison of two spreadsheet files	Yes	No
Folio styles (in addition to cell styles)	Yep	No
Hyphenation of text in cells	Yes	No
AutoSpellcheck / Spelling as you type	Yes	No ([80])
Export to XHTML	Yep	No
Total-Sheet Previews: Possibility to export all pages on a sheet equally one page in the PDF	Yes	No
Exporting of a single chart as image (eastward.1000. jpg, png, svg, pdf)	Yep	Yes [81]
OpenFormula standard	Yes. Largely supported	Partial
Proceed the re-create of cells (usability of re-create&paste)	Yep. (Copy of cells is kept for pasting, even if the user does other tasks like 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 sail	No. 1,024. Jumbo spreadsheets upwardly to sixteen,384 columns are (highly) experimental, see: tdf#50916 tdf#133764 tdf#133619.	Yes. 16,384 (256 in compatibility mode)
Table styles	Partial. View ▸ Toolbars ▸ Tools ▸ Cull Themes as well equally Format ▸ AutoFormat provide part of this functionality. (tdf#77569, tdf#44762,tdf#44763)	Yes
Tape a macro	Partial. Limited support [84]	Yes
Insert a graphic into a spreadsheet header or footer	Partial. Inserted image cannot be resized nor cropped, usability bug. (tdf#74146)	Aye
Statistical / Analysis toolkit	Fractional. Built-in Data Statistics Wizard with additional features: Chi2-test, Logarithmic regression, Power regression	Partial. Add together-on, not activated by default. Additional features: Histogram, Random number generation, Rank and percentiles, and some more detailed options.
Nautical chart styles	No (tdf#62925, tdf#62540, tdf#39097)	Fractional. Selection 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 around: using function VLOOKUP)	Yes ([85])
Integration of external data sources	No. Extension: New Jaguar Calc add-in provides SQLREQUEST function and Queryconnector provides graphical interface.	Aye. Queries and data sources via "Power Query" and "Power BI" [86]. (SQL.Request removed in favor of Power Query since MS Excel 2010)
Linked information types	No	Yeah. Data types from online sources: geography, stocks, organization, location, cipher code, academy, space, satellite, element, chemistry, food, exercise, film, characters, medical, body, media, nature, activities, other (Non available in MS Role 2021 sales versions) [87],[88]
Forecasting information to predict time to come trends	Yes. Extended set of forecast functions (based on exponential smoothing algorithm)	Aye. Forecast functions and forecast charts (based on exponential smoothing algorithm) (not supported in macOS version)
Import MS Access databases	Partial. Via ODB file connected to database (needs MS Admission installed on the system)	Aye
Multi-Cadre Processing / multithreading	Fractional. 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 Calculate in Parallel".	Yes. Starting in Excel 2010, the following features apply multi-cadre 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 machine-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 performance into two processes increases performance speed. The first procedure gets the data, and the 2d procedure loads the data into the appropriate construction in memory or writes the data to a file. In this mode, equally soon every bit the outset process begins reading a portion of data, the 2d process can immediately kickoff loading or writing that data, while the first process continues to read the adjacent portion of information. Previously, the offset process had to finish reading all the data in a certain section before the second procedure could load that department of the data into memory or write the information to a file. ([93], [94])
Declaration of variables to be used in formulas	No	Yeah. LET function
Information-linked cosmos of flowcharts	No	Yes Flow charts and organizational charts (supported in rental version, not supported in MS Function 2021 sales versions)
Consign generic XML	No	Yeah
Customized sheet views (while collaborative editing)	No	Yep ([95])
Minor Feature Differences	LO Calc 7.iii	MS Excel 2021 / 365
Flexible CSV export	Yes. Supported ([96], [97])	No
Advanced find & replace / regular expressions / special characters	Yes (List of Regular Expressions)	No
View clone of spreadsheet in new window	Yes. Contained 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
Utilize English language function names	Yes. Possibility to switch between function names in local language and English	No
Import & Consign Unified Role Format spreadsheet	Aye	No
Import of DOS/Windows legacy spreadsheet formats: Lotus 1-two-3, Quattro Pro (v1-5.5 DOS; v1.0-vi.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)	Yes	No
Import & Consign Pocket Excel	Aye. Supported (requires Coffee)	No
Ability to rotate entire nautical chart	Yes	No
PDF consign of comments	Yep. Consign of comments according to PDF specification	No
Property mapping functionality for charts (conditional chart colors/borders)	Aye	No (Only available: Inverting colors for negative values)
Import from Gnumeric	Yeah (non bachelor on Windows, see tdf#94834)	No
Export cell range selection or a selected group of shapes (images) as .png or .jpg epitome	Yes	No
Export sheet/tabular array as .png image	Yes	No
Formatting of cells	Yes. More detailed: Number formats: more flexible employ of "Format Code" for custom adjustments, leading zeroes, language setting, percentages without percent 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: hibernate cells when printing.	Partial. Less features
Boosted cell format types	Yep. Number format "Boolean value". Engineering note. Natural language number format (spelling out numbers in various languages. Piece of cake work around for missing US zippo code and US phone number formats.	Partial Engineering notation via custom formats.
Support negative year date (BCE)	Yes	Partial Using work-arounds.
Provisional formatting: icon sets	Partial. 2 additional smilies icon sets. No reverse icon order (tdf#61313).	Partial. Customization of icon sets, e.g. reverse icon order.
Advanced find & supersede / Prison cell Format	Partial (Styles supported, Cell Format not supported)	Yep
Formulae with entire columns or entire rows	Fractional (tdf#34094, tdf#92452, tdf#92453)	Yep
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 deportment in protected sheets)	Partial. Supported for select protected/unprotected cells and insert/delete rows/columns.	Aye for select protected/unprotected cells, insert/delete rows/columns, format cells/columns/rows, insert hyperlinks, sort, employ AutoFilter/Pivot Table reports, edit objects/scenarios.
Timeline filter in PivotTable	No	Yes [104]
Chart: Automatically vary colours past signal	No (only manually)	Yes
Nautical chart type: xyz / surface charts	No, bones workaround [105] (tdf#51670)	Yep
Chart type: pie of pie (bar of pie)	No (tdf#50934)	Yeah
Map charts and 3D geospatial visualization tool	No (via extension GeOOo)	Yes. Map charts and "3D Maps".
Different nautical chart types for different data series	No (tdf#35629)	Yes
Press of selected nautical chart but	No, workarounds [106], [107] (tdf#45893)	Yes
Chart data labels "Value as percent"	Yes	No
Chart data labels "Value from cells"	No	Yeah
Automatized analysis and visualization features	No	Yes Quick assay feature and visual summaries, trends, and patterns. [108], [109]. Some of these features ("Ideas in Excel") supported in rental version, not supported in MS Role 2021 sales versions; quick analysis feature not supported on macOS.
Flash make full	No (tdf#109003). Some (fractional) workarounds suggested hither tdf#109003#c1.	Yes
Chart recommendations	No	Yes
'Publishing' spreadsheet for online team meetings	No	Yeah
Sparklines (to give a quick overview of the trend in a data range)	No, extension: EuroOffice Sparkline	Yep
Add points to a line, possibility to bend lines	No (tdf#36943)	Yes
Prison cell groundwork options	Partial. Background color (bugs regarding pattern tdf#31205 and slope tdf#49177). Extension: Hatch Patterns for Cells	Yes. Groundwork color, pattern, slope
Insert information from screenshot or movie	No	YesOCR and recognize tables from screenshots or pictures [110] (Not bachelor in MS Role 2021 sales versions and only available on macOS)

Desktop Presentation software: LibreOffice Print vs. Microsoft PowerPoint

Major Feature Differences	LO Print 7.3	MS PowerPoint 2021 / 365
Hyphenation support	Yeah	No
Export to XHTML	Yes	No
Consign to HTML	Yes	No (removed feature since MS Office 2013)
Export to vector graphic formats: SVG, EPS	Yes	Fractional, to SVG (Supported in Windows rental version, non supported in MS Office sales versions.)
Presentation remote control for smartphones/tablets	Aye. For Android smartphones/tablets, iOS (iPhone/iPad), and Pebble smartwatches.	Fractional. For Android (smartphones merely), but with additional features for Excel and Word. (Not supported in macOS version).
3D slide transitions	Yeah. macOS, Linux, Windows	Partial. macOS, Windows
Edit embedded videos	Partial. Via external programs	Yes. Directly in the program
Comments and respond to comments	Partial	Yeah
Animated effects	Partial. Supported, but problems with: spinning text (tdf#87958), pixelated (tdf#87959), wobble/shake/vibrate (tdf#87960), objects stuck (tdf#88196)	Yes
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)	Yeah
SmartArt diagrams	No (tdf#37932), solution: smArt extension	Yes
Save highlights and drawings during presentation	No (tdf#51928)	Yes
Compare presentations	No	Yes
Broadcast presentation on the Internet	No. Only via export 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)	Aye [112]. Some features only available in rental vesion ([113]).
Slide design suggestions	No	Yes via Powerpoint "Designer" (not supported in MS Function 2021 sales versions)
Navigate presentation using a Bluetooth pen	No	Yes. 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	Yeah. ([114]) (not bachelor on macOS)
Modest Feature Differences	LO Print seven.3	MS PowerPoint 2021 / 365
Number of slide layouts	Yep. 12	Partial. 9
Physics based animations	Yep [115]	No
Text groundwork colour in text boxes	Yes	No
PDF export of comments	Yes. Export of comments according to PDF specification	No
Import & Consign Unified Part Format presentation	Yes	No
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM	Yes	No
Import of Apple Keynote files	Yep. Back up for Keynote v1-six [116]	No
Embedding of fonts in presentation file	Yeah	Partial. Supported on Windows. No support for embedding fonts in PowerPoint on macOS, although displayed. No support for embedding OpenType CFF fonts. [117]
Maximum page size	Aye. 300cm ten 300cm (Draw and Impress)	Partial. 142.22cm x 142.22cm
Editing of master slides	Partial. Express editing, has been a GSOC 2013 projection ([118]).	Aye. Powerful editing
Default keyboard shortcuts	Partial. Less default shortcuts ([119])	Yep. More default shortcuts ([120], [121])
Conversion of manus-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. (Non 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 past entering subject field	No	Yeah. "QuickStarter feature (Not 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 upwards to 4K resolution.
Slide zoom and pan	No (tdf#38263)	Yes
Option to save equally pic presentation	No (tdf#93589)	Aye
Using Surface Earbuds to control presentation	No	Aye[124]
Autogeneration of alt text for photos	No	Yes [125] (Supported in Windows rental version, non supported in MS Function sales versions; non supported on macOS)

Desktop Database programme: LibreOffice Base of operations vs. Microsoft Access

Major Feature Differences	LO Base of operations 7.3	MS Access 2021 / 365
Available on all operating systems supported past the office suite	Yes	No. MS Admission not available on macOS, online and mobile Bone versions
SQL syntax highlighting	Yes	No
Native connectors for: MariaSQL, PostgreSQL, Novell GroupWise	Yes. Plus MySQL every bit extension.[126]	No. No, via ODBC
Integration of Mozilla Thunderbird address book, KDE accost book, Evolution LDAP and storage, Windows system address book	Yes	No
Native JDBC driver	Aye	No
Connect to ODF spreadsheet (Calc) file format	Yes	No
Database engine	Yes. FirebirdSQL three.0; HSQLDB ane.8.10 (deprecated). In LibreOffice 6.two FirebirdSQL is the default for new databases. Firebird Migration Banana converts HSQLDB databases to FirebirdSQL	Partial. Jet
Integration of MS Outlook accost book	Partial. Supported only on MS Windows. No support for Outlook (tdf#56903) and Outlook Express (tdf#56905) address volume access in the native 64-chip Windows builds of LibreOffice.	Yes
Importing data sources (tables) from within the database application	Partial. Either via drag & drib from Calc or via drag & drop from another Base window with the data source being open. ([127]) (tdf#51872)	Yes
Exporting tables to different file formats from within the database awarding:	Partial. Just via drag&drop to LibreOffice Calc or via drag & drop from some other Base window with the writable data source being open. ([128]) (tdf#73798)	Aye
Edit MS Access files	Partial. Express older driver "Microsoft.Jet.OLEDB.4.0" works fine for read/write, while "Microsoft.ACE.OLEDB.12.0" commuter only reads; (tdf#43187). Driver merely works on Windows.	Yes
Native connector for: Microsoft SQL Server	No. No, via ODBC	Yes
Crosstab queries	No. Non supported only reproducible with Pivot Tabular array with Calc (FAQ 142 )	Yep
"Linked tables" adequacy	No. Not supported but you can link text tables (FAQ 143) (tdf#56234)	Yes. Linked tables and Linked Tables Director.
Imported table from spreadsheets - keep fields format	No	Yep
Import information from XML, HTML	No	Yes
Minor Feature Differences	LO Base of operations 7.3	MS Access 2021 / 365
Native connector for: dBase databases	Yeah	No. Non supported (removed feature since Office 2013)
Open LibreOffice Base of operations (.odb) files	Yes	No
Open DOS/Windows legacy formats: Microsoft Works database	Yeah	No
Native connector for: SharePoint lists	No	Yes
Link or import data from Salesforce and Dynamics 365	No	Yes
Web service information connexion	No	Yeah
Password protection of database	No (tdf#70638)	Yes
Calculations in database tables	No (tdf#72787)	Aye

Most important extensions for desktop LibreOffice

LibreOffice has a circuitous eco-organisation 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 selection of some extensions adding valuable features to LibreOffice:

	LibreOffice Extensions
General office suite: LibreOffice	Overview of language-related extensions for LibreOffice (Writing aids, spell-check 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 complex centralized organization for templates, forms and letter heads developed by the urban center of Munich (in German and English language language). eLAIX allows users to write and read ILIAS learning modules offline and to export to ePUB3 e-book file format. LibreOffice Server Installation GUI facilitates parallel and server installations of LibreOffice. Shared Technical Terminology Thesaurus Read Text. Read option of text with Calc, Draw, Print, Web Writer and Writer using speech synthesis. Custom Palette Consign (allows to hands share custom color palettes) OOoLilyPond, apply LilyPond musical note within LibreOffice.
LibreOffice Writer	TexMaths adds an (Xe)LaTeX equation editor to LibreOffice DMaths adds a comprehensive mathematical tool box to LibreOffice Author Chemistry allows to insert chemistry formulas equally epitome from formula. Lawmaking Colorizer Formatter, Code Highlighter or COOoder provide syntax highlighting for LibreOffice Writer. AddPics creates a Author document from pictures of scanned pages. Writer's Tools is a set of utilities for frequent writers. Alternative find & replace dialog for Author. Typography toolbar for advanced use of Graphite smart font features. QR code Generator Transcriber, transcription tool for sound files. Organon, system 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 translate texts in several languages. Anaphraseus Cat tool. Macro set for Estimator Aided Translation similar to famous Wordfast. Writer Rotation Tool, allows to rotate an image in a text certificate 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 free and open 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, forcefulness intercept of trend line and moving boilerplate trend line (most of its functionality is included in LibreOffice four.2) PalOOCa OLAP Calc Extension: Connecting Calc to access Palo or XMLA capable OLAP servers. Display Formula and Effect (Value) simultaneously Digitizer of XY nautical chart LibreWeb, a tool to fill spreadsheet cells with data from different spider web pages. Remove Duplicates, apace 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	Consign 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 brand technical drawings in LibreOffice Draw. File format filters: GEDCOM import filter for Depict. Import Google Earth files (kml) in Draw. Gallery contents, shapes & stencils: A set up of gallery themes to draw diagrams like circuit 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.2; available for download for older versions than 6.1) BaseDocumenter fully document a LibreOffice Base awarding.
Accessibility extensions	odt2daisy, converts OpenDocument Text (ODT) to digital talking books in the DAISY format (DAISY ii.02, DAISY three.0 XML and Full DAISY 3.0) for speech communication synthesis. Read Text, it uses an external program or a web service to read text. Read the choice with Calc, Draw, Impress, Web Author and Author. odt2braille, enables authors to print documents to a Braille embosser and to consign documents every bit Braille files. The Braille output is well-formatted and highly customizable.

Mobile office: Smartphones, Tablets

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

The comparing table of mobile office is Piece of work in Progress.
Delight feel complimentary to meliorate information technology!

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 architecture differing betwixt desktop (different between Windows and macOS), mobile and online function.
Versions of office suite for mobile operating systems (smartphones, tablets)	Yes. Mobile applications available as LibreOffice-based Collabora Role. 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 bones and experimental editing features. Information on new LibreOffice Android app: [130]. More information: Android port wiki, Commits, [131], [132]. 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; Annunciation for iOS; Commits: [133], [134]. Chrome OS: Collabora Office on Google Play available, more information, XDA News Portal. Ubuntu Affect/UBPorts: The Certificate Viewer is powered past LibreOfficeKit (LibreOffice 5) and supports viewing nigh file types supported by LibreOffice.	Partial. Android and iOS for smartphones and tablets with restricted features ready. No support for Chrome Os on tablets. Professional users as well as users on tablets >10.1 inch are required to take 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 Part 365 subscription at a monthly fee.
Support of Right-to-left⁠ (RTL) languages (due east.thousand. Arabic) and other complex scripts	No	Yep
Pocket-size Characteristic Differences	Mobile: LibreOffice-based solutions	Mobile: MS Function 365
Run Microsoft Visual Basic Macros.	Aye. 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	Yes. (via Collabora Role)	No
Minor 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	Fractional.
Pocket-sized 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: Print	Mobile: MS PowerPoint 365
XY	Fractional	Partial.
Minor Characteristic Differences	Mobile: LibreOffice-based solutions: Print	Mobile: MS PowerPoint 365
XY	Partial	Partial.

Online office: Web browser (and Chromebooks)

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

Chromebooks are in this Online office suite section for several reasons:
LibreOffice core software is bachelor as a Chromebook App from Collabora Productivity by the name of Collabora Function, it is the aforementioned software every bit 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 table it enables the easy comparison of LibreOffice based office suites to Microsoft's Online when using a Chromebook.

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

Major Feature Differences	Online: LibreOffice-based Collabora Online Chromebook App: Collabora Part 6.4	Online: MS Office 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 grade factors (incl. mobile and desktop) [135].	No. Loose compages differing betwixt desktop (different between Windows and macOS), mobile and online function.
Online/cloud version of role suite	Yes. Libreoffice-based Collabora Online 6.4.ten with full document support and rendering fidelity, as well as collaborative editing. Avant-garde but reduced editing functionality compared to the desktop version. Online version supports Vereign compatible hallmark & document signing. [136], [137], [138], [139], [140], [141]. Encounter as well: LibreOffice Online port development.	Partial. Role web apps, with reduced functionality when compared to the Word desktop version and Collabora Online. ([142])
Applications	Yep. Online: Writer, Calc, Impress, Draw. Chromebook Apps: Writer, Calc, Impress	Yes. Give-and-take, Excel, PowerPoint, OneNote, Outlook
Integration of online office suite into (3rd-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 Center, 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 list: Availability of LibreOffice Online.	Partial. MS Role Online Server integration in MS SharePoint
Availability of online office suite in (tertiary-party) online services / Gratuitous & commercial office deject hosts	Partial. 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 Deject, cloudplan, EGroupware, ZenTao, SwissVON, CQ Net, Mijncloudoffice, mentorITe, PowerFolder, GMX Online Office, Mail.com Online Part, Web.de Online Function, hostiso.com, Kolab Now, Crest Tech. See also this list: Availability of LibreOffice Online.	Partial MS OneDrive
Synchronous collaborative editing	Yeah. Supported in online versions of Writer, Calc, Impress and Draw (Online only).No support of collaborative editing in desktop versions.	Yes. Supported in online versions of MS Word, Excel and Powerpoint. Collaborative editing between online and desktop versions
Support of Right-to-left⁠ (RTL) languages (e.yard. Arabic) and other complex scripts	Aye. Comprehensive back up, based on HarfBuzz⁠ text shaping library	Yeah
Minor Feature Differences	Online: LibreOffice-based Collabora Online Chromebook App: Collabora Office half dozen.4	Online: MS Role for the web Chromebook App: Discontinued
	Fractional	Partial

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

Major Feature Differences	Online: LibreOffice-based Collabora Online Writer Chromebook App: Collabora Part Author six.4	Online: MS Give-and-take for the web Chromebook App: Discontinued
WYSIWYG - Total Fidelity Editing, PDF generation, Printing	Yep. 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 practise not look the aforementioned when saved as a PDF or when printed [146]
Open and edit Password Protected Files	Yeah. (via Online and Chromebook App)	No. [147]
Edit Password to Change Documents	Yeah. (via Online and Chromebook App)	No [148]
Conform Table Sort Lodge	Yep. And additional options: Sort in multiple sequential columns or rows, and for each column or row choose alphanumeric or numeric, ascending or descending. Selection to match instance (via Online and Chromebook App)	No [149]
Format Table Cells	Yes. By Number, Per centum, Currency, Appointment, Time, Scientific, Fraction, Boolean Value and Text. (via Online and Chromebook App)	No
Headers and Footers appear in the editable document	Yes. It is a WYSIWYG word processor.	No
Find and Replace with options as bachelor on desktop	Yes.	No. Very Basic.
Clipboard (Re-create and Paste)	Yes. Copying and pasting inside the web app works with advanced document features. Pasting content copied from outside the web app is avant-garde	Partial. Copying and pasting within the web app is functional for basic features bachelor in the app. Pasting content copied from exterior the spider web app is limited, such every bit it cannot copy and paste a hyperlink without losing the link. [150]
Pocket-sized Feature Differences	Online: LibreOffice-based Collabora Online Writer Chromebook App: Collabora Office Writer six.4	Online: MS Discussion for the web Chromebook App: Discontinued
Templates, browse and start from professionally designed templates	Yes	No [151]
Save in Microsoft Word 97 - Give-and-take 2003 format (.physician)	Yes. (via Online and Chromebook App)	No [152]
Salve in EPUB e-volume format (.epub)	Yes. (via Online and Chromebook App)	No
Run Microsoft Visual Basic Macros, (docm, dotm)	Aye. Back up a large portion of Microsoft Visual Bones Macros (via Online and Chromebook App)	No [153]
Title Page	Yep. With options for number of title pages, folio to first at, title stlye, title numbering	No
Thesaurus	Yes. (via Online and Chromebook App)	No
Page Gutter Margins	Yeah. Gutter Margins can be positioned on the left or peak (via Online)	No
Add together and Edit Page Backgrounds	Yes. Colour, Gradients, Bitmap, Pattern and Hatch, options available for each of these are the aforementioned or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No [154]
Add and Edit Page Transparency	Yep. Transparencies, options bachelor are the aforementioned or like as in the LibreOffice desktop applications (via Online and Chromebook App)	No [155]
Add and Edit Folio Borders	Yes. Borders, options bachelor are the same or like every bit in the LibreOffice desktop applications (via Online and Chromebook App)	No [156]
Add and Edit Page Columns	Aye. Columns, options bachelor are the aforementioned or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No. [https://docs.microsoft.com/en-united states of america/office365/servicedescriptions/role-online-service-clarification/office-online-service-description
Display Headers and Footers, Footnotes, Endnotes in-line in the document	Aye (via Online and Chromebook App)	No [157]
Add, Edit, View Charts	Yes. Full options every bit available in desktop (via Online and Chromebook App)	No. They appear equally placeholders that you cannot edit, motion or resize [158]
Add, Edit, View Shapes	Yes. Full options as bachelor in desktop (via Online and Chromebook App)	No. They appear as placeholders that you cannot edit, move or resize [159]
Add, Edit, View SmartArt and WordArt (aka Fontwork)	Yes (via Online and Chromebook App)	No. They appear as placeholders that you cannot edit, move or resize [160]
Watermarks	Aye (via Online and Chromebook App)	No [161]
Bookmarks	Yeah (via Online and Chromebook App)	No [162]
Fields	Aye (With options under sub-categories of Documents, Cross-references, Functions, DocInformation and variables (via Online and Chromebook App)	No [163]
Edit Cross References	Yes (via Online and Chromebook App)	No. It is not possible to edit the destination [164]
Index	Aye, options bachelor are the same or similar as in the LibreOffice desktop applications (via Online and Chromebook App)	No [165]
Table: "Optimal Column Widths" and "Optimal Row Height"	Yep (via Online)	No [166]
Total control of anchoring with visible anchor points for images etc.	Yes. WYSIWYG precision visible anchoring (via Online and Chromebook App)	No
Text Box	Yes. With full desktop options including, size, anchors, protection, borders, rotation, corners, shading, etc. (via Online and Chromebook App)	No. They appear equally placeholders that y'all cannot edit, motility or resize [167]
Citations and bibliography	Yep	No [168]
Table of contents	Yeah. 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. 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/five Envelope, C5 Envelope, C4 Envelope, #6 3/4 Envelope, #seven iii/4 (Monarch) Envelope, #9 Envelope, #10 Envelope, #eleven Envelope, #12 Envelope, Japanese Postcard. (via Online and Chromebook App)	Partial. Alphabetic character, Legal, Executive, A4, A5, and custom size layouts [170]
Wrap text around images	Yes. Total options for wrapping text around images including: earlier, subsequently, parallel, contour wrapping, in front and behind, precision visible anchoring (via Online and Chromebook App)	Partial. No effective wrapping, the text does not wrap around images.
Word count and grapheme count	Yes. Accurate count of words and characters.	Fractional. A rough count of words. [171]
Table: "Distribute Columns Evenly" and "Distribute Rows Evenly"	No (#3329)	Yes. Chosen "Distribute Columns" and "Distribute Rows"
Co-authoring between online and native app	No. For more information the encounter the row "Synchronous collaborative editing"	Yep. MS Office 2019 sales version on Windows introduced real-time co-authoring with Word for the web
Table Autoformat Styles to cull from	No (#4356)	Yes
Cover Pages	No	Yes. [172]
Add-ins	No	Yes
Dictate	No	Yeah
Emoji	No	Yes
Online Video	No	Yes. With preview, supported video providers: YouTube, SlideShare, Vimeo, Stream, Flipgrid, TED
Share as Embedded HTML	No	Yes
Translate	No. (tdf#34058, #4285)	Yep [173]
Reuse Files	No	Yes. Open up some other document in a preview enabling selection of paragraphs or images for insertion, or for adding a link to that certificate.
Catchup	No	Aye. View changes your collaborators have made to a file since yous last opened information technology.
Insert Equations with Structures	No. (#4049)	Yeah
Insert Prototype options	Fractional. Select past folder and file just	Yes. Select by binder and file, also by previewing categorised images
Margins	Partial. Custom options	Yeah. Custom options and 5 presets.
Captions	No	No [174]
Mail Merge	No	No [175]
Bullets, Numbering, Outline, Images, Alignment	Yes. 79 bullets inc 71 resizable images, viii numbering, viii outline, comprehensive position alignment options. (via Online and Chromebook App)	Yes. 17 bullets inc 13 images, 15 numbering, iii outline, minimal position alignment options. not resizable, but has option to define new bullet points from the Symbol library
Accessibility checker	Yes	Yes

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

Major Feature Differences	Online: LibreOffice-based Collabora Online Calc Chromebook App: Collabora Part Calc 6.4	Online: MS Excel for the spider web Chromebook App: Discontinued
XY	Partial	Partial.
Minor Characteristic Differences	Online: LibreOffice-based Collabora Online Calc Chromebook App: Collabora Office Calc half dozen.four	Online: MS Excel for the web Chromebook App: Discontinued
Save in Microsoft Excel 97 - Excel 2003 (.xls) format	Yes (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 Print vs. Microsoft PowerPoint for the web

Major Characteristic Differences	Online: LibreOffice-based Collabora Online Impress Chromebook App: Collabora Function Print 6.iv	Online: MS PowerPoint for the spider web Chromebook App: Discontinued
XY	Fractional	Partial
Minor Feature Differences	Online: LibreOffice-based Collabora Online Print Chromebook App: Collabora Function Impress half-dozen.4	Online: MS PowerPoint for the web Chromebook App: Discontinued
Save in Microsoft Powerpoint 97 - Powerpoint 2003 (.ppt) format	Yes (via Online and Chromebook App).	No
XY	Partial	Partial

Encounter likewise

The Programming Languages Buoy: LibreOffice is written in C++, Java, Python; Microsoft Office is written in C++, C, (ASM).
How LibreOffice Writer Tops MS Word: 12 Features, by Bruce Byfield (2012-04-ten).
LibreOffice vs. MS Office: Spreadsheets and Slide Shows, by Bruce Byfield (2012-06-06)
How Microsoft Office Tops LibreOffice: 11 Features, by Bruce Byfield (2012-04-26).
Microsoft Role vs. OpenOffice.org - Idealware does a caput-to-head comparison of the ii office suites, by Brett Bonfield and Laura Southward. Quinn (2010-07-02).
Duell am Arbeitsplatz, by Ralf Nebelo and Dorothee Wiegand (c't 22/2008, German language).

Source: https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office

Posted by: baileywarailut.blogspot.com