Feature Comparison: LibreOffice - SoftMaker Office
Work In Progress by Dennis Roczek (talk) 2018-09-25T14:16:50 (UTC) : see deeper for the roadmap
steps for this page
Copy 'n paste of the MS-comparison; doneremove the ms stuff; done- add boiler plates
- fill in the stuff / real content
- feel free to help!
Dennis Roczek (talk) 2018-09-25T14:09:48 (UTC)
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Introduction
This page compares the features of LibreOffice 24.8.3 (download) and SoftMaker Office 2018. It separates major and minor feature differences and also includes notes on LibreOffice extensions. The comparison highlights differences and therefore does not display any features which are present in both office suites.
 |
The feature comparison table is continuously being updated and is work in progress. |
General office suite: LibreOffice vs. SoftMaker Office
| Major Feature Differences | LibreOffice 6.1 | SM Office 2018 |
|---|---|---|
| Cross-platform availability (desktop) | Windows, macOS, Linux, FreeBSD, NetBSD, OpenBSD, and Haiku. (based on the same code base). | Windows, Linux and macOS. |
| Supported versions of MS Windows | Windows 7 SP1, 8, 8.1, 10, Server 2008, Server 2012, Server 2016. ([1]). Versions until LibreOffice 5.4 still also support Windows XP SP3, Vista. | Windows 7 SP1, 8, 8.1, 10.[1] |
| Supported versions of macOS | 10.9+ (Mavericks). ([2]). | 10.10+ (Yosemite)[3] |
| Open Source | Yes, licensed under MPLv2 and others. | No, proprietary and closed-source |
| Full integration of all office components | Supported. From within each office component, files of all other components can be opened and be newly created. Central StartCenter with access to office modules, recently used files and templates. | ? |
| Availability free of charge | Yes (download, donate) | Partly, proprietary software to purchase or rent, a limited version, called FreeOffice exists. |
| Extension availability | Complex ecosystem of extensions (over 600 on extensions.libreoffice.org and over 800 on extensions.openoffice.org), including automatic updates. | No, no extension system available |
| Localization | 115 languages (detailed list of languages supported by LibreOffice) | 29 languages [4] |
Support of Right-to-left (RTL) languages (e.g. Arabic) and other complex scripts
|
Comprehensive support, based on HarfBuzz text shaping library
|
? |
| Additional writing aids | Extended support (spell-check dictionaries, hyphenation patterns, thesaurus and grammar check, specialized dictionaries as extensions ([5], [6]). Detailed list of LibreOffice writing aids for over 150 languages. | Extended support, todo, see link above |
| Support of complex languages and special smart-font features (ligatures, true small caps, old style numbers, proportional or mono-spaced numbers, capital spacing, and true superscript/subscript) | Limited support: full support of SIL Graphite font technology ([7],[8]) and full support of OpenType optional features ([9],[10],[11]) by syntax, without UI: tdf#58941. See LibreOffice Smart Font HowTo. Interoperability: No support for optional OpenType features in OOXML, and ODF 1.2 don’t provide OpenType optional features support (support scheduled for ODF 1.3) | ? |
| Support of font variation | Limited support for font rendering on screen, no support for printing and PDF export. tdf#108497 | ? |
| Easy access to vector clip art | Yes via LO Gallery (clipart extensions ([12] or [13])). Extension for the integration of clipart from OpenClipart.org | ? |
| Macro scripting languages | Multiple languages, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell, and Python). Import and export of Visual Basic for Applications (VBA), see ([14] and the release notes). | ? |
| CMIS protocol support to access Document Management Systems | Support for Alfresco, Google GDrive, Nuxeo, MS SharePoint, MS OneDrive, IBM FileNet Lotus Live Files, Lotus Quickr Domino, OpenDataSpace, and OpenText ELS. (tdf#62437) | ? |
| Support of ISO standards OpenDocument Format (ODF)
|
Advanced support, ODF v1.2 extended | Only TextMaker |
| PDF export extended options | Multiple options (Additional options: Tagged PDF, Time stamp protocol, detailed image settings, Hybrid PDF, transition effects, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures, and PDF signatures according to PAdES standard). Support for font embedding of all font types (incl. OpenType .otf fonts).
|
? |
| Document classification | Document classification in Writer, Calc, and Impress according to TSCP-standards (also with multiple policies). See: [15] and [16]. | ? |
| Import of SVG vector graphics (.svg, .svgz) | Supported | ? |
| Import of Encapsulated PostScript (EPS) vector graphics (.eps) | Supported (with some rendering issues: tdf#81497, tdf#67464) | ? |
| Insert PDF as an image into documents | Supported ([17]) | ? |
| Creation of Hybrid PDFs (ODF file embedded in PDF for full editing) | Supported | Not supported |
| Import from raster graphics software: Adobe Photoshop (.psd) | Supported | ? |
| Import from vector graphics / DTP software: CorelDraw (v1-X7), Corel Presentation Exchange, Adobe/Macromedia Freehand (v3-11), Adobe PageMaker, Zoner/Callisto Draw (.zmf), QuarkXPress 3.1 to 4.1 | Supported | ? |
| Import of MS Visio files | Supported (Visio 2000-2013) | ? |
| Import of video and audio formats FLAC Audio (.flac), Flash Video (.flv), Matroska Media (.mkv), OGG Audio, Ogg Video, Quicktime Video, WebM Video, Real Audio (.ra), Real Media (.rm), Digital Video (.dv), Audio Codec (.ac3), and Ogg Opus (.opus) | Supported | ? |
| Drawing and vector graphics software | LibreOffice Draw, drawing and vector graphics software that supports pages (up to 300cm x 300cm), layers, numerous drawing tools and DTP features. | ? |
| PIM and email software | Not part of LibreOffice, referring to alternative PIM software such as Mozilla Thunderbird.
Mail Merge Wizard sends out emails directly from LibreOffice without email software. LibreOffice-wide access to address books via Base. |
No, SoftMaker produced a minimal modified version of Mozilla Thunderbird with mostly UI changes. Every change is realized by Addons.[18] |
| Desktop publishing (DTP) software | Partial. Writer supports many advanced DTP features (see section on Writer in this comparison table). Draw supports frame-based DTP features. Import of MS Publisher files (and from other DTP software) in Draw. | No |
| Integrated Development Environment (IDE) feature set | The BASIC Integrated Development Environment (IDE) does not have: 1. Refactoring facilities (Renaming affects dependencies/Extract Method/Extract interface etc.) (tdf#92251, tdf#94524, tdf#94526, tdf#94527, tdf#94528, tdf#94529, tdf#94530); 2. Intellisense (or any other code completion functionality) such as auto-code-completion and showing the properties and methods of an object (tdf#66185); 3. Error checking (the IDE actually knows its symbols). | ? |
| Import & Export of Microsoft OOXML files | Good support of real life OOXML files (e.g. .xlsx, .docx, .pptx) and standardized (transitional) OOXML files, as well as import of OOXML-strict files. | ? |
| PDF Import | Partial, into Draw and Writer with the limitation that text is imported line-based (tdf#32249). | ? |
| Versions of office suite for mobile operating systems (smartphones, tablets) | Ports for Android and iOS are in development, viewer for Ubuntu Touch. LibreOffice Viewer for Android available, which also contains basic and experimental editing features, more information: Android port wiki, [19], [20], [21], [22]. LibreOffice Light for iOS is in development [23]; more information on iOS port: [24]. The Document Viewer of Ubuntu Touch is powered by LibreOfficeKit and therefore supports viewing most file types supported by LibreOffice. | ? yes, have to be checked in detailed |
| Online/cloud version of office suite | Libreoffice Online 24.8.3 / Collabora Online 3.3.1 released with full document support and rendering fidelity, advanced but reduced editing functionality, collaborative editing. [25], [26], [27], [28], [29]. See also: LibreOffice Online port development. | No. |
| Integration of online office suite into (third-party) collaboration software and groupware / content management systems | Integration of LibreOffice Online in OwnCloud and Nextcloud, Kolab,Pydio, Seafile,IceWarp, AG-I Solutions, Alinto, VNCLagoon, EGroupware, Univention App Center. | ? |
| Availability of online office suite in (third-party) online services | Variety of available service providers: UrBerri, eqipe, New Access, Arawa, Artistanbul, TransfertPro, Extensys,Rono-IT, SecuredStore, StudioStorti,united hoster, Option Service Télécom, AggreCost, Webo.hosting, FileCloud, Retention Range, Workman.net.au, OffiDocs, CiviHosting, ETES, Sunjun, opendsi, GMS, OpenLogic, SwissStash, iOffice Cloud, cloudplan, EGroupware, ZenTao, SwissVON, CQ Net, Mijncloudoffice, mentorITe | No. |
| Synchronous collaborative editing | Partial. Collaborative editing in LibreOffice online version (Writer, Calc and Impress). Not available in the desktop applications (tdf#73831), see development information: Collaborative Editing and Track changes. | ? |
| User Interface approach | Highly customizable UI concept "MUFFIN" [30],[31]: Classic UI with multiple toolbars mode, single toolbar mode, and Sidebar panel. UI concept "NotebookBar" available in experimental mode ([32]) with variants "Contextual groups/single", "Tabbed", Groupedbar full/compact", and "Tabbed Compact". Customization possible: several icon themes available, Firefox themes. | ? |
| User interface improved to enable use on touch screen devices on desktop operating systems. | No (tdf#102015) | ? |
| Keyboard driven menu system (search function to better find features in office suite). | Not supported. Only via help system. On Ubuntu Unity support for Head-Up-Display (HUD) system. (tdf#91874) | ? |
| Accessibility checker | Not supported. Extension for text documents: AccessODF | ? |
| Chat with other authors (collaborative editing) | Not supported. | ? |
| Integration of instant Messaging (IM), voice, video, or screen sharing. | Not supported. | ? |
| Dictation / speech recognition | Not supported | ? |
| Inserting and editing 3D models | Not supported (previous support in Impress for glTF (.dae/.kmz) 3D models removed in version 6.0) | ? |
| Support of color fonts | Not supported | ? |
| Minor Feature Differences | LibreOffice 6.1 | SM Office 2018 |
| Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM | Supported | ? |
| Import of Classic Mac OS legacy vector and bitmap graphics formats: BeagleWorks, ClarisWorks, GreatWorks, MacPaint, MacWorks, SuperPaint, MacDraw, MacDraw II, RagTime for Mac 2-3, ClarisDraw, MacDraft | Supported | ? |
| Import of additional video and audio formats: CD Audio, Vivo Video. | Supported | ? |
| Drawing features: Arrow endings | Substantially wider selection, including Crow’s feet notation | ? |
| Document converter wizard | Supported | ? |
| Euro currency converter wizard | Supported | ? |
| Expert config to access a multitude of settings from UI | Supported | ? |
| Support for multiple color palette formats: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc) | Supported (note: tdf#92354) | ? |
| Import MathML formula from clipboard | Supported | ? |
| Import of StarOffice binary file formats .sdc, .sda and .sdw | Basic support | ? |
| Digital signatures / Signature Line | Multiple signatures, including OOXML signatures. Round-trip with MS Office problematic (tdf#58442, tdf#58476). Import/export of PDF signatures. Support of XAdES standard (XML Advanced Electronic Signatures) and OpenPGP keys. Additional support of ECDSA keys (on Linux and macOS). Additional (experimental) support for OpenPGP-based document encryption.
|
? |
| Convert SVG image to shapes / polygon | Conversion supported in LO Draw. Additionally opening SVG files directly as shapes is supported in LO Draw. (tdf#115571) | ? |
| Enhanced list of recent files and folders | Partial (tdf#61174, tdf#60743). Option to clear list of recent documents. Selectively delete Recent Documents (in StartCenter) | ? |
| Custom colours in formula editor | Set of 16 colours (tdf#40436) | ? |
| Third-party software dependencies | Java runtime environment (JRE) installation required for certain - but not most - features of the software. Java is notably required for Base. (tdf#34809) | ? |
| Shortcut keys for accented Latin characters | Not supported (tdf#71176), workaround using Unicode conversion, see Unicode character input with Alt+X | ? |
| Inserting audio / video from online sources | Not supported (tdf#42246). Work-around: Download of online video and embed it in presentation (incl. Flash videos) | ? |
| Quick access to email attachments | Not supported | ? |
| Streaming of office applications/office on demand | Not supported (possible via third party services) | ? |
| Ink drawings / annotations (e.g. on touch- and pen-enabled devices) | Not supported (tdf#35092), (only support for import of existing ink annotations from MS Word file format) | ? |
| Recognition of shapes from ink drawings | Not supported | ? |
| Automatic background removal of a picture | Not supported (tdf#103424) | ? |
| Live preview while formatting | Not supported (tdf#37048) | ? |
| Inserting a screenshot from within applications | Not supported | ? |
| Import of graphics formats: MEZ, EMZ, WMZ, PCZ | Not supported (tdf#103954) | ? |
| Export to XPS format
|
Not supported | ? |
| Support for Touch Bar on Apple MacBook Pro | Not supported (tdf#105803) | ? |
Included Applications
| Type | LibreOffice 6.1 | SoftMaker Office 2018 |
|---|---|---|
| Word processors | Writer | TextMaker |
| Spreadsheet application | Calc | PlanMaker |
| Presentation software | Impress | Presentations |
| Database program | Base | No, there was DataMaker 99, but is deprecated and was never part of the suite. |
| Math formulation program | Math | No |
| Drawing application | Draw | No |
Word processors: LibreOffice Writer vs. SoftMaker TextMaker
| Major Feature Differences | LO Writer 6.1 | SM TextMaker 2018 |
|---|---|---|
| Support of ISO standards OpenDocument Format (ODF)
|
Advanced support, ODF v1.2 extended | Todo: check for features |
| Handling of captions for graphics or image boxes | Stable layout | ? |
| Styles (page styles, frame styles, list styles) | Supported | ? |
| Overlining of text | Supported | ? |
| Master documents for longer texts | Master documents and Master document templates supported | ? |
| Register-true feature / register accuracy (DTP-feature) | Supported | ? |
| Business card wizard | Supported (release notes) | ? |
| Text auto completion of words already used before | Supported [33] | ? |
| XForms documents creation | Supported | ? |
| Mathematical calculations in tables | Complex calculations | ? |
| DocBook import & export | Supported | ? |
| Export to MediaWiki (Wikipedia) format | Supported | ? |
| Export to XHTML | Supported | ? |
| Export to EPUB e-book file format (.epub)
|
Supported | ? |
| Export document as image(s) | Supported, image formats: .jpg, .png | ? |
| Import of Apple Pages documents | Support for Pages v1-5 [34] | ? |
| Working with large documents | Stable layout | ? |
| Extended label creation features (release notes) | Supported (generic database access, synchronise content) | ? |
| Frames | DTP-like features like text in multiple columns and text-wrap around graphics | ? |
| DirectCursor (allows to enter text anywhere on a page) | Supported | ? |
| Table styles | Supported (release notes 5.3 and release notes 6.0) (tdf#34391). | ? |
| PDF export of comments | Export of comments according to PDF specification (via "File" > "Export as PDF"). PDF export of comments: inside the margin, at end of page, at end of document (activation complicated, only via: "Tools" > "Options" > "LibreOffice Writer" > "Print" (tdf#77650)) | ? |
| Grammar check | Out of the box only 4 languages (English, Russian, Hungarian and Brazilian Portuguese) extensions: e.g. Languagetool for 29 languages plus 14 language variants (level of language support varies; 7 languages with more than 1000 rules), Grammalecte for French, CoGroo for Brazilian Portuguese |
? |
| Style sets (for paragraph styles) | Different. Templates provide this functionality, but more difficult to handle. Helpful extension: Template Changer (tdf#89286). Experimental design themes: (tdf#45176, tdf#90497) | ? |
| Use of LaTeX syntax for formulas | Not supported. Extension: TexMaths | ? |
| Vertical alignment (top/center/bottom) of content on page | Not supported (tdf#36117), workarounds via frame/table | ? |
| Picture styles & additional effects | Not supported (tdf#59906), but effects are preserved on import and export. | ? |
| View changes in the right margin in "track changes" mode | Not supported (tdf#34355) | ? |
| Diagonal borders in tables | Not supported (tdf#51665) | ? |
| Extended reading mode of documents | Not supported (tdf#55168) | ? |
| Collapse and expand parts of a document | Not supported (tdf#47746) | ? |
| Instant messaging while collaborating on document | Not supported | ? |
| Minor Feature Differences | LO Writer 6.1 | SM TextMaker 2018 |
| Protected cells in tables (allows better creation of forms) | Supported | ? |
| Open erroneous .doc files | Better recovery mode ([35],[36]) | ? |
| Wizard to create personalized letter templates | Supported | ? |
| Import & Export Unified Office Format text | Supported | ? |
| Import & Export AportisDoc (Palm), PocketWord documents | Supported (requires Java) [37] | ? |
| Import of AbiWord files | Supported | ? |
| Import of eBook formats: FictionBook 2.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm) | Supported | ? |
| Import of legacy Mac OS word processing documents: MS Word for Mac (1-5.1), MS Works for Mac (1-4), ClarisWorks/AppleWorks, Write Now, MacWriteII/MacWritePro, DOCMaker 4, FullWrite Professional, HanMac Word-K/J, LightWayText for Mac 4.5, Mariner Write Mac Classic 1.6-3.5, MindWrite Document, Nisus Writer Mac Classic 3.4-6.5, TeachText/SimpleText 1, Tex-Edit 2, WriterPlus, Z-Write 1.3, eDOC 2, Acta Mac Classic, BeagleWorks/WordPerfect Works 1, GreatWorks, MacDoc 1, MoreMac 2-3, RagTime for Mac 2-3 | Supported | ? |
| Import of DOS/Windows legacy word processing documents: Microsoft Word for DOS, Microsoft WinWord 5, Microsoft Word 6.0 / 95, Microsoft Write, Hangul WP97 and Text 602 (T602), Lotus WordPro | Supported | ? |
| Logo toolbar and interpreter | supported | ? |
| Format text of all comments in document | Supported | ? |
| Conditional text | Supported ([38], [39](PDF) [40]) | ? |
| Automatic replacement of Emojis | supported. Additional toolbar control to insert Emojis (experimental: tdf#100100) | ? |
| Number of columns per table in document | Unlimited columns | ? |
| Multi-line headings for chapters | Multi-line headings for chapters by allowing a line break as separator between a chapter number and its name (in Chapter Numbering dialog) | ? |
| Maximum page size | 300cm x 300cm | ? |
| Bibliographic features | Basic inbuilt support. Excellent free extensions: e.g. Zotero, Bibus, JabRef as well as proprietary extensions. | ? |
| Advanced find & replace / Special characters | Partial (tdf#38261). See List of Regular Expressions. Extension: Alternative dialog Find & Replace for Writer | ? |
| Complex Outline numbering / Multilevel list | Different numerically equivalent format not supported (tdf#35217) | ? |
| Default keyboard shortcuts | Less default shortcuts ([41]) | ? |
| Add watermarks to pages | Support for text watermarks. Workaround for picture watermarks via adding image to header/footer. | ? |
| Complex/rich text formatting in comments (e.g. bullet points, text color, images, tables) | Not supported. Some formatting features are supported, e.g. font type, font size, bold, italics, underline, text alignment (align, centered, justified). (tdf#81458) | ? |
| Document/text translation | Not supported (tdf#34058), extension: TradutorLibreText. | ? |
| Decorative page borders | Not supported (tdf#39270) | ? |
| Horizontal split view of the same document | Not supported (tdf#31481), workaround: Windows > New Window to clone document window. | ? |
| Outline view | Not supported (tdf#38262), workaround: Navigator > Content View to drag and promote/demote headings | ? |
| Draft view | Not supported (tdf#67698) | ? |
| Upload to blog servers | Not supported, extension: Sun Weblog Publisher. | ? |
| Digital pen usage / ink gestures | Not supported | ? |
Spreadsheet applications: LibreOffice Calc vs. SoftMaker PlanMaker
| Major Feature Differences | LO Calc 6.1 | SM PlanMaker 2018 |
|---|---|---|
| Spreadsheet functions (for details see Functions comparison of LibreOffice Calc and PlanMaker) | 504 functions (? functions unique to Calc) | 346 functions (? functions unique to PlanMaker) |
| Unique Spreadsheet functions | ? - many | ? todo |
| Support of ISO standards OpenDocument Format (ODF)
|
Advanced support, ODF v1.2 extended | Not supported |
| Comparison of two spreadsheet files | Supported | ? |
| Page styles (in addition to cell styles) | Supported | ? |
| Hyphenation of text in cells | Supported | ? |
| AutoSpellcheck / Spelling as you type | Supported | ? |
| Export to XHTML | Supported | ? |
| Exporting of a single chart as image (e.g. jpg, png, svg, pdf) | Supported | ? |
| OpenFormula standard | Largely supported | ? |
| Keep the copy of cells (usability of copy&paste) | Supported. (Copy of cells is kept for pasting, even if the user does other tasks like typing or inserting cells) | ? |
| Import of Apple Numbers spreadsheet documents | Support for Numbers v1-3 [42], see also this comparison | ? |
| Maximum number of columns per sheet | 1,024 (tdf#50916) | ? |
| Table styles | ▸ ▸ ▸ as well as ▸ provide part of this functionality. (tdf#77569, tdf#44762,tdf#44763) | ? |
| Record a macro | Limited support [43] | ? |
| Insert a graphic into a spreadsheet header or footer | Partially supported; inserted image cannot be resized nor cropped, usability issues. (tdf#74146) | ? |
| Statistical / Analysis toolkit | Built-in Data Statistics Wizard with additional features: Chi2-test, Logarithmic regression, Power regression | ? |
| Chart styles | Not supported (tdf#62925, tdf#62540, tdf#39097) | ? |
| Power Pivot features
|
Not supported | ? |
| Additional chart types: Waterfall, Histogram, Pareto, Box & Whisker (Box plot), Treemap (Mosaic), Sunburst, Funnel | Not supported (tdf#74665, tdf#81530,tdf#70361,tdf#72992, tdf#97832) | ? |
| Relationships between tables, based on matching data in each table | Not supported (work around: using function VLOOKUP) | ? |
| Integration of external data sources | Not supported. Extension: New Jaguar Calc add-in provides SQLREQUEST function and Queryconnector provides graphical interface. | ? |
| Forecasting data to predict future trends | Supported. Extended set of forecast functions (based on exponential smoothing algorithm) | ? |
| Import MS Access databases | Via ODB file connected to database (needs MS Access installed on the system) | ? |
| Multi-Core Processing / multithreading | Parallel formula compiling on the CPU. OpenCL/GPU threading in Calc core ([44],[45]). Multithreading is work in progress: tdf#65046, [46], Presentation "Making Calc Calculate in Parallel". | ? |
| Export generic XML | Not supported | ? |
| Minor Feature Differences | LO Calc 6.1 | SM PlanMaker 2018 |
| Flexible CSV export | Supported ([47], [48]) | ? |
| Advanced find & replace / regular expressions / special characters | Supported (List of Regular Expressions) | ? |
| View clone of spreadsheet in new window | Independent window | ? |
| Median in PivotTable | Supported tdf#61700 | ? |
| Chart type Stepped lines for XY (Scatter) graphs | Supported | ? |
| Use English function names | Possibility to switch between function names in local language and English | ? |
| Import & Export Unified Office Format spreadsheet | Supported | ? |
| Import of DOS/Windows legacy spreadsheet formats: Lotus 1-2-3, Quattro Pro (v1-5.5 DOS; v1.0-6.0 Windows), Microsoft Works spreadsheet, Microsoft Multiplan (v1-3 DOS) | Supported | ? |
| Import of Classic Mac OS legacy spreadsheet formats: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz, Microsoft Multiplan (v1.11) | Supported | ? |
| Import & Export Pocket Excel | Supported (requires Java) [49] | ? |
| Ability to rotate entire chart | Supported | ? |
| PDF export of comments | Export of comments according to PDF specification | ? |
| Property mapping functionality for charts (conditional chart colors/borders) | Supported | ? |
| Import from Gnumeric | Supported (not available on Windows, see tdf#94834) | ? |
| Export cell range selection or a selected group of shapes (images) as .png or .jpg image | Supported | ? |
| Export sheet/table as .png image | Supported | ? |
| Formatting of cells | More detailed: Number formats: more flexible use of "Format Code" for custom adjustments, leading zeroes, language setting, percentages without percentage sign, thousands separator for percentages; Font: overligning of text, relief (embossed, engraved), outline, shadow, underline of individual words, spacing settings, kerning; Borders: shadow, spacing to contents; Protection: hide cells when printing. | ? |
| Additional cell format types | Number format "Boolean value". Engineering notation. Natural language number format (spelling out numbers in various languages. Easy work around for missing US zip code and US phone number formats. | ? |
| Support negative year date (BCE) | Supported. | ? |
| Conditional formatting: icon sets | 2 additional smilies icon sets. No reverse icon order (tdf#61313). | ? |
| Advanced find & replace / Cell Format | Partial (Styles supported, Cell Format not supported) | ? |
| Formulae with entire columns or entire rows | Partial (tdf#34094, tdf#92452, tdf#92453) | ? |
| Default keyboard and/or mouse shortcuts [50] | Less default shortcuts ([51], tdf#98259, tdf#92452, tdf#92453) | ? |
| Sheet protection options (allow users certain actions in protected sheets) | Supported for select protected/unprotected cells and insert/delete rows/columns. | ? |
| Chart: Automatically vary colours by point | Not supported (only manually) | ? |
| Chart type: xyz / surface charts | Not supported, basic workaround [52] (tdf#51670) | ? |
| Chart type: pie of pie (bar of pie) | Not supported (tdf#50934) | ? |
| Map charts and 3D geospatial visualization tool | Not supported (via extension GeOOo) | ? |
| Different chart types for different data series | Not supported (tdf#35629) | ? |
| Printing of selected chart only | Not supported, workarounds [53], [54] (tdf#45893) | ? |
| Quick analysis feature | Not supported | ? |
| Flash fill | Not supported (tdf#109003). Some (partial) workarounds suggested here tdf#109003#c1. | ? |
| Chart recommendations | Not supported | ? |
| 'Publishing' spreadsheet for online team meetings | Not supported | ? |
| Sparklines (to give a quick overview of the trend in a data range) | Not supported, extension: EuroOffice Sparkline | ? |
| Add points to a line, possibility to bend lines | Not supported (tdf#36943) | ? |
| Cell background options | Background color (bugs regarding pattern tdf#31205 and gradient tdf#49177). Extension: Hatch Patterns for Cells | ? |
| Copy only visible cells | Not supported (tdf#36466), extension: Copy only visible cells | ? |
Presentation software: LibreOffice Impress vs. SoftMaker Presentations
| Major Feature Differences | LO Impress 6.1 | SM Presentations 2018 |
|---|---|---|
| Support of ISO standards OpenDocument Format (ODF)
|
Advanced support, ODF v1.2 extended | Not supported |
| Hyphenation support | Supported | ? |
| Export to XHTML | Supported | ? |
| Export to HTML | Supported | ? |
| Export to Flash format (SWF) | Supported | ? |
| Export to vector graphic formats: SVG, EPS | Supported | ? |
| Presentation remote control for smartphones/tablets | For Android smartphones/tablets, iOS (iPhone/iPad), and Pebble smartwatches. | ? |
| 3D slide transitions | macOS, Linux, Windows | ? |
| Edit embedded videos | Via external programs | ? |
| Comments and reply to comments | Partial | ? |
| Animated effects | Supported, but problems with: spinning text (tdf#87958), pixelated (tdf#87959), wobble/shake/vibrate (tdf#87960), objects stuck (tdf#88196) | ? |
| Trim embedded video or audio | Not supported | ? |
| Zooming features for presentations (Prezi inspired) | Not supported (tdf#38263) | ? |
| Slides editable during presentation | Not supported (tdf#34965) | ? |
| SmartArt diagrams | Not supported (tdf#37932), solution: smArt extension | ? |
| Save highlights and drawings during presentation | Not supported (tdf#51928) | ? |
| Compare presentations | Not supported | ? |
| Broadcast presentation on the Internet | Only via export to PDF or SWF | ? |
| Animated diagrams | Not supported | ? |
| Record a slide show | Not supported (tdf#34959) | ? |
| Slide design suggestions | Not supported | ? |
| Navigate presentation using a Bluetooth pen | Not supported | ? |
| Minor Feature Differences | LO Impress 6.1 | SM Presentations 2018 |
| Number of slide layouts | 12 | ? |
| Text background colour in text boxes | Supported | ? |
| PDF export of comments | Export of comments according to PDF specification | ? |
| Import & Export Unified Office Format presentation | Supported | ? |
| Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM | Supported | ? |
| Import of Apple Keynote files | Support for Keynote v1-6 [55] | ? |
| Embedding of fonts in presentation file | Supported | ? |
| Maximum page size | 300cm x 300cm (Draw and Impress) | ? |
| Editing of master slides | Limited editing, has been a GSOC 2013 project ([56]). | ? |
| Default keyboard shortcuts | Less default shortcuts ([57]) | ? |
| Recognition of text from ink drawings | Not supported | ? |
| Automatically suggesting presentation outline from online sources by entering subject | Not supported | ? |
| "Morph" transition type | Not supported | ? |
| Creation of automatically starting presentations | Not supported, extension: ImpressRunner | ? |
| Export presentation to video formats | Not supported (tdf#34959) | ? |
| Slide zoom and pan | Not supported (tdf#38263) | ? |
| Option to save as picture presentation | Not supported (tdf#93589) | ? |
Extensions: LibreOffice extensions adding outstanding features to LibreOffice
LibreOffice has a complex eco-system of extensions (over 600 on extensions.libreoffice.org and over 800 on extensions.openoffice.org). Additionally to the extensions already mentioned in above comparison table, here is a selection of some extensions adding valuable features to LibreOffice:
| LibreOffice Extensions | |
|---|---|
| General office suite: LibreOffice |
|
| LibreOffice Writer |
|
| LibreOffice Calc |
|
| LibreOffice Impress |
|
| LibreOffice Draw |
|
| LibreOffice Base |
|
| Accessibility extensions |
|
See also
- c't 14/2018, S. 110 in archive.org