功能比较:LibreOffice - Microsoft Office

From The Document Foundation Wiki
Jump to: navigation, search

介绍

这个页面比较 LibreOffice 6.1.1 (下载) 和 Microsoft Office 2016. 这里包含主要和次要功能的不同,同时它还包含了LibreOffice扩展的说明。这些比较将不同地方高亮显示,当然这里不显示两个套件都有的功能。

Im-jabber.svg

这个功能比较表格还在不停的更新
这个比较是由用户编辑更新而不是 TDF 官方文档
请自由地增强这个页面,最后一次更新是在2018年06月19日

普通办公套件:LibreOffice 和 Microsoft Office

主要功能的差异 LibreOffice 6 MS Office 2016
跨平台性能(桌面版) Windows, macOS, Linux,FreeBSD, NetBSD 和 OpenBSD, (基于相同的代码库)。 Windows 和 macOS (基于不同的代码库,因此存在一些格式兼容问题,不同的功能特性、用户界面。macOS 版 Office 2016 没有数据库应用程序,包含一些新的功能,但缺少另外一些功能)
Windows 支持版本 Windows 7 SP1, 8, 8.1 ,10,Server 2008, Server 2012.(1)*LibreOffice 5.4 仍支持Windows XP, Vista, 7 Windows 7, 8, 8.1, 10, Server 2008 R2, Server 2012。 Windows RT在MS Office 2013之后版本中不再提供支持。 (在那个版本功能缺失, 没有 MS Access 也不支持Metro风格)
macOS 支持版本 10.9+ (非官方版本 10.5 PPC 可以提供支持)([1]) 10.10+ (Yosemite)
在 USB 闪存盘运行的便携版(不用安装) 没有 (已放弃的 MS Office 2010 入门版可以在 USB 闪存盘运行)
开源 是, 通过MPLv2 等认证许可. 否, 源代码专有且封闭
集成所有办公组件 支持.包含每一个办公组件,能打开、新建其他所有组件文档。启动中心可以访问办公模块,最近使用的文件和模板。 不支持
是否免费 否, 专业版语言包也需要付费。可试用30天。
是否有扩展系统 LibreOffcie 有复杂、实用的扩展系统(在extensions.libreoffice.org有超过380个扩展,extensions.services.openoffice.org有800多个扩展)(包括自动更新) 有部分扩展, 加载项和宏没有集中的扩展系统。Office 应用商店为 Office 2013提供扩展。
本地化 111 种语言(LibreOffice 支持的详细语言列表 96种语言(52种主要语言包需要购买, 超过44种语言(总共60种)可以免费下载)
离线状态更改用户界面语言 支持 支持, 但语言包需要额外付费
附带书写辅助 扩展支持(拼写检查字典,连字符,词组和语法检查,拓展性专业词典(1, 2, 3))。150多种语言的 LibreOffice 书写辅助详细列表 有限制, 语言包需要额外付费
支援复杂语言和特殊字体(连字、真小型大写字母、老式数字、比例或等宽数字、大写字母间距、真上标/下标)) 综合 支持 SIL Graphite 字体技术 (不支持 macOS)。支持 OpenType 可选功能:本土化字形(locl标签)(tdf#58941). 仅限于 OpenType 连字、样式集、数字间距、数字形式、上下文变体
轻松获取矢量图形 Yes 使用 LO Gallery (clipart extensions (1 or 2)). Extension for the integration of cliparts from OpenClipart.org Selection more limited
Macro scripting languages Multiple languages, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell and Python). Single language, support for Visual Basic for Applications (VBA). Indirectly also Visual Basic or Visual C# by using automation.
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. Inbuilt support only for MS SharePoint and MS OneDrive
支持 ISO 标准化的 OpenDocument (ODF) 格式 高度支持, v. 1.2 扩展 有限支持 (Windows), v. 1.2, macOS上不支持
PDF扩展功能 Multiple options (Additional options: detailed image settings, watermarks, HybridPDF, transition effects, tagged pdf, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures) High or low quality PDF, page and markup to print in Access, Word, Excel and PowerPoint 1; pictures resolution and non-printing informations in Publisher.
Creation of HybridPDFs (ODF file embedded in PDF for full editing) 支持 不支持
导入图形格式: SVG 矢量图(.svg, .svgz), Adobe Photoshop (.psd) 支持 部分支持macOS 租用和零售版可用;Windows版本不可
从矢量图型软件(包括桌面排版软件)导入: CorelDraw (v1-X7), Corel Presentation Exchange, Adobe/Macromedia Freehand, Adobe PageMaker 支持 不支持
导入微软 Visio 文件 支持 (Visio 2000-2013) 不支持 (只能使用微软 Visio - 并非微软 Office成员)
Import of video and audio formats FLAC Audio flac, Flash Video (flv), Matroska Media (mkv), OGG Audio, Ogg Video, Quicktime Video, WebM Video, Real Audio (.ra), Real Media (.rm), Digital Video (.dv), Audio Codec (.ac3), and Ogg Opus (.opus) 支持 不支持
制图软件 LibreOffice Draw
个人信息管理和Email程序 不属于套件内 参照 Mozilla Thunderbird 以及 Mozilla Lightning邮件助手直接从LibreOffice 发送email。 MS Outlook
导入和导出Microsoft OOXML文件 良好支持日常 OOXML 文件 (比如 .xlsx, .docx, .pptx) 以及标准化的过渡OOXML文件,以及导入严格OOXML文件 高度支持过渡(默认)和严格OOXML文件
PDF导入 部分 导入到 Writer和 Draw,限制为成行的文字(tdf#32249). 支持 到 Word
用户界面 Muffin定制UI; Muffin 是高度可定制用户界面概念:用传统界面配合侧边栏;类似于Ribbon UI的"NotebookBar" 目前处在实验性功能 ([42])几种图标主题可选,火狐浏览器主题可用Firefox 主题 Ribbon UI; 主题色彩
用户界面为触控设备或触控桌面系统改进 简单适应触摸屏
Versions of office suite for mobile operating systems No, ports for Android and iOS in development. (1, 2, 3,4, for details see page for Android port development). Beta version of the LibreOffice viewer on Google play. Mobile versions restricted to smartphones (not on tablets) for iOS, Android, WindowsPhone 8 with heavily restricted feature set, good viewing but very limited editing capabilities; after registration private users are allowed to view and edit at no cost, while professional users are required to have an eligible Office 365 subscription at a monthly fee. A more comprehensive version is available for the iPad, after registration document viewing at no cost, while editing requires an eligible Office 365 subscription at a monthly fee.
在线/云 LibreOffice 6.04/Collabora Online 3.1 Office网端 功能削弱(1)
同步协作编辑 部分 可用于在线版本,桌面版本尚不可以 支持
小功能差异 LibreOffice 6.0 MS Office 2016
导入图像格式 DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM 支持 不支持
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 支持 不支持
导入额外的音视频格式: CD 音乐, Vivo 视频 支持 不支持
绘制功能,箭头 更多选项,如乌鸦足迹 更少的选项
文档转换助手 支持 不支持
欧元转换助手 支持 不支持
Expert config to access a multitude of settings from UI 支持 不支持
支持多种色盘格式: Gimp (.gpl), Adobe Swatch Exchange (.ase), LibreOffice/Apache OpenOffice (.soc) 支持 (note: tdf#92354) 不支持
从剪切板导入 MathML 公式 支持 不支持
导入 StarOffice二进制格式 .sdc, .sda, .sdw 基础支持 不支持
数字签名 / 签名行 Multiple signatures, including OOXML signatures. Round-trip with MS Office problematic (tdf#58442, tdf#58476). Import/export of PDF signatures. Support of XAdES⁠Wikipedia logo v3.svg 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. 支持 (OOXML/XML-DSig and XAdES signatures)
将SVG转化成 图形/多边形 LO Draw转化 (tdf#115571) 支持 (租借版本和 Mac [2]可用, 不支持 Office 2016 Windows版本)
最近文档/文件夹功能 部分 (tdf#61174, tdf#60743) 清除列表;选择性删除近期文件(启动中心) 支持 (将最近的文件设为永久)
公式编辑器里自定义色彩 Set of 16 colours (tdf#40436) 支持
第三方软件依赖 Java runtime environment (JRE) installation required for certain - but not most - features of the software. Java is notably required for Base. (tdf#34809) 不需要
插入网上的音视频 不支持 (tdf#42246) (Work-around: Download of online video and embed it in presentation (incl. Flash videos)) Windows版本支持 ([3]). 不支持macOS.
快速获取Email附件 不支持 支持, "和我分享" PowerPoint, Excel, Word.
Streaming of office applications/office on demand 不支持 (possible via third party services) 支持 ([4])
触控、笔触绘制 不支持 (tdf#35092), (only support for import of existing ink annotations from MS Word file format) 支持. Several pens, highlighters, colors and color effects, and pencils for inking to draw/annotate/highlight. Ink replay feature (不支持 in MS Office 2016 sales version and 不支持 in macOS version)
笔画图形识别 不支持 supported in MS Word and MS Excel (不支持 MS Office 2016零售版和 macOS版 )
自动移除图像背景 不支持 (tdf#103424) Supported in MS Windows version (不支持 macOS版)
格式实时预览 不支持 (tdf#37048) 支持
直接插入屏幕截图 不支持 支持
导入图像格式: MEZ, EMZ, WMZ, PCZ 不支持 (tdf#103954) 支持
导出到 XPS格式⁠Wikipedia logo v3.svg 不支持 支持
支持Apple MacBook Pro 的 Touch Bar 不支持 (tdf#105803) 支持 (仅macOS)

Word processors: LibreOffice Writer vs. Microsoft Word

Major Feature Differences LO Writer 6.0 MS Word 2016
Handling of captions for graphics or image boxes Stable layout Layout problems
Styles (page styles, frame styles, list styles) Supported Not supported
Overlining of text Supported No, but complicated workaround
Master documents for longer texts Master documents and Master document templates supported Supported but deprecated because it causes file corruption
Register-true feature / register accuracy (DTP-feature) Supported Not supported
Business card wizard Supported (release notes) Not supported
Text auto completion of words already used before Supported [5] Not supported
XForms documents creation Supported Not supported
Mathematical calculations in tables Complex calculations Only basic arithmetic
DocBook import & export Supported Not supported
Export to MediaWiki (Wikipedia) format Supported Not supported
Export to XHTML Supported Not supported
Export to EPUB⁠Wikipedia logo v3.svg e-book file format (.epub) Supported Not supported
Export document as image(s) Supported, image formats: .jpg, .png Not supported
Import of Apple Pages documents Support for Pages v1-4 Not supported
Working with large documents Stable layout Some layout problems [6]
Extended label creation features (release notes) Supported (generic database access, synchronise content) Partial
Frames DTP-like features like text in multiple columns and text-wrap around graphics Concept of "horizontal frames" is more limited
DirectCursor (allows to enter text anywhere on a page) Supported Supported, under the name Click and type (advanced option)
Table styles Supported (release notes 5.3 and release notes 6.0) (tdf#34391). Supported
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)) Export only as comments inside margin
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), Grammalecte for French, CoGroo for Brazilian Portuguese

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) Different. Templates provide this functionality, but more difficult to handle. Helpful extension: Template Changer (tdf#89286). Experimental design themes: (tdf#45176, tdf#90497) Supported ("document themes")
Use of LaTeX syntax for formulas Not supported. Extension: TexMaths Supported. Ability to type math using the LaTeX syntax (Not supported in MS Office 2016 sales version and not supported in macOS version)
Vertical alignment (top/center/bottom) of content on page Not supported (tdf#36117), workarounds via frame/table Supported
Picture styles & additional effects Not supported (tdf#59906), but effects are preserved on import and export. Supported
View changes in the right margin in "track changes" mode Not supported (tdf#34355) Supported
Diagonal borders in tables Not supported (tdf#51665) Supported
Extended reading mode of documents Not supported (tdf#55168) Supported
Collapse and expand parts of a document Not supported (tdf#47746) Supported
Instant messaging while collaborating on document Not supported Supported ([7])
Minor Feature Differences LO Writer 6.0 MS Word 2016
Protected cells in tables (allows better creation of forms) Supported Not supported
Open erroneous .doc files Better recovery mode ([8],[9]) More frequently denies opening those files
Wizard to create personalized letter templates Supported Not supported
Import & Export Unified Office Format text Supported Not supported
Import & Export AportisDoc (Palm), PocketWord documents Supported (requires Java) [10] Not supported
Import of AbiWord files Supported Not supported
Import of eBook formats: FictionBook 2.0, BroadBand, Plucker (Palm), eReader (Palm), zTXT (Palm), TealDoc (Palm), PalmDoc (Palm) Supported Not 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 Not 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 Not supported
Logo toolbar and interpreter supported Not supported
Format text of all comments in document Supported Not supported
Conditional text Supported ([11], [12](PDF) [13]) Partially supported ([14], [15])
Automatic replacement of Emojis supported. Additional toolbar control to insert Emojis (experimental: tdf#100100) Manual creation of replacement lists
Number of columns per table in document Unlimited columns Limited to 63 columns
Maximum page size 300cm x 300cm 55.87cm x 55.87cm
Bibliographic features Basic inbuilt support. Excellent free extensions: e.g. Zotero, Bibus, JabRef as well as proprietary extensions. Inbuilt support. Excellent free extensions: e.g. Zotero 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 Supported
Complex Outline numbering / Multilevel list Different numerically equivalent format not supported (tdf#35217) Supported
Default keyboard shortcuts Less default shortcuts ([16]) More default shortcuts ([17])
Add watermarks to pages Support for text watermarks. Workaround for picture watermarks via adding image to header/footer. Supported (text and picture watermarks)
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) Supported
Document/text translation Not supported (tdf#34058), extension: TradutorLibreText. Supported ([18])
Decorative page borders Not supported (tdf#39270) Supported
Horizontal split view of the same document Not supported (tdf#31481), workaround: Windows > New Window to clone document window. Supported
Outline view Not supported (tdf#38262), workaround: Navigator > Content View to drag and promote/demote headings Supported
Draft view Not supported (tdf#67698) Supported
Upload to blog servers Not supported, extension: Sun Weblog Publisher. Supported (Sharepoint Blog, Wordpress, Blogger, Windows Live Spaces, Community Server, TypePad, MetaWebLog API)
Digital pen usage / gestures Not supported Supported [19]. (Not supported in MS Office 2016 sales version and not supported in macOS version)

Spreadsheet applications: LibreOffice Calc vs. Microsoft Excel

Major Feature Differences LO Calc 4.4 MS Excel 2013
Spreadsheet functions (detailed comparison) 466 functions (22 functions unique to Calc: CURRENT, DDE, EFFECTIVE, MONTHS, OPT_BARRIER, OPT_PROB_HIT, OPT_PROB_INMONEY, OPT_TOUCH, STYLE, EASTERSUNDAY, YEARS, DAYSINMONTH, DAYSINYEAR, GOALSEEK, ISLEAPYEAR, MULTIPLE.OPERATIONS, MULTIRANGE, MVALUE, NEG, ROT13, WEEKS, WEEKSINYEAR). 461 functions (17 functions unique to Excel: ISOWEEKNUM, CEILING.MATH, FLOOR.MATH, CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, RTD, DBCS, CALL, REGISTER.ID, SQL.REQUEST, PHONETIC, ERROR.TYPE). ERROR.TYPE will be in Calc 5.0. The functions ISOWEEKNUM, CEILING.MATH and FLOOR.MATH are currently being reviewed for Calc 5.0.
Comparison of two spreadsheet files Supported Not supported
Page styles (in addition to cell styles) Supported Not supported
Hyphenation of text in cells Supported Not supported
AutoSpellcheck / Spelling as you type Supported Not supported (1)
Export to XHTML Supported Not supported
Exporting of a single chart as image (e.g. jpg, png, svg, pdf) Supported Not supported
OpenFormula standard Largely supported Partial
Number of columns per sheet Max. 1024 columns (tdf#50916) Up to 16384 columns
Table styles "View" > "Toolbars" > "Tools" > "Choose Themes" as well as "Format" > "AutoFormat" provide part of this functionality. (tdf#77569, tdf#44762,tdf#44763) Supported
Chart styles Not supported (tdf#62925, tdf#62540, tdf#39097) Selection of some pre-set chart styles and layouts
Interactive diagrams / PivotChart Not supported Supported
Relationships between tables, based on matching data in each table Not supported (work around: using function VLOOKUP) Supported (1)
Import Access databases Not supported directly but possible via a .odb connected to the database Supported
Export generic XML Not supported Supported
Minor Feature Differences LO Calc 4.4 MS Excel 2013
Flexible CSV export Supported (1, 2) Not supported
View clone of spreadsheet in new window Independent window Cannot be moved outside the application window
Chart type Stepped lines for XY (Scatter) graphs Supported Not supported
Import & Export Unified Office Format spreadsheet Supported Not supported
Import of DOS/Windows legacy spreadsheet formats: Lotus 1-2-3, Quattro Pro 6, Microsoft Works spreadsheet Supported Not supported
Import of MacOS legacy spreadsheet formats: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz Supported Not supported
Import & Export Pocket Excel Supported (requires Java installed) [1] Not supported
Ability to rotate entire chart Supported Not supported
PDF export of comments Export of comments according to PDF specification Not supported
Property mapping functionality for charts (conditional chart colors/borders) Supported Not supported (Only available: Inverting colors for negative values)
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, number format "boolean value"; 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. Easy work around for missing US zip code and US phone number formats. Less features
Conditional formatting: icon sets 2 additional smilies icon sets. No reverse icon order (tdf#61313) and missing icon sets (tdf#69095) 3 additional icon sets: "5 boxes", "3 symbols uncircled", "3 triangles". Customization of icon sets, e.g. reverse icon order.
Advanced find & replace / Cell Format Partial (Styles supported, Cell Format not supported) Supported
Import from Gnumeric Partial (experimental) support Not supported
Chart: Automatically vary colours by point Not supported (only manually) Supported
Chart type: xyz / surface charts Not supported, basic workaround 1 (tdf#51670) Supported
Printing of selected chart only Not supported, workarounds 1, 2 (tdf#45893) Supported
Quick analysis feature Not supported Supported
Flash fill Not supported Supported
Chart recommendations Not supported Supported
'Publishing' spreadsheet for online team meetings Not supported Supported
Sparklines (to give a quick overview of the trend in a data range) Not supported, extension: EuroOffice Sparkline Supported
Add points to a line, possibility to bend lines Not supported (tdf#36943) Supported
Cell background options Background color (bugs regarding pattern tdf#31205 and gradient tdf#49177) Background color, pattern, gradient
Copy only visible cells Not supported, extension: Copy only visible cells Supported

Presentation software: LibreOffice Impress vs. Microsoft Powerpoint

Major Feature Differences LO Impress 4.4 MS Powerpoint 2013
Hyphenation support Supported Not supported
Export to XHTML Supported Not supported
Export to HTML Supported Not supported (removed feature since MS Office 2013)
Export to Flash format (SWF) Supported Not supported
Export to vector graphic formats: SVG, EPS Supported Not supported
Inserting 3D models GlTF files, partial support for .dae and .kmz files) (Windows/Linux) Not supported
Presentation remote control for smartphones/tablets For Android smartphones/tablets and iOS (iPhone/iPad). For WindowsPhone 8 (smartphones only, no Office 2013 RT), but with additional features for Excel and Word
3D slide transitions MacOS, Linux, Windows ("OpenGL transitions for Impress" on Windows need to be activated during installation as optional feature. Activated by default in upcoming version 5.0, see: tdf#89135) MacOS, Windows
Edit embedded videos Via external programs Directly in the program
Comments and reply to comments Partial Supported
SmartArt diagrams Not supported (tdf#37932), solution: smArt extension Supported
Save highlights and drawings during presentation Not supported (tdf#51928) Supported
Compare presentations Not supported, extension ODFDiff Supported
Broadcast presentation on the Internet Only via export to PDF or SWF Supported
Collaboration features. Several people working on same presentation Not supported Supported
Animated diagrams Not supported Supported
Record a slide show Not supported (tdf#34959) Supported
Minor Feature Differences LO Impress 4.4 MS Powerpoint 2013
Number of slide layouts 12 9
PDF export of comments Export of comments according to PDF specification Not supported
Import & Export Unified Office Format presentation Supported Not supported
Export to graphics formats: MET, PBM, PICT, PGM, PPM, RAS, XPM, PWP Supported Not supported
Import of Apple Keynote files Supported Not supported
Embedding of fonts in presentation file Supported Supported on Windows. No support for embedding fonts in Powerpoint on macOS
Maximum page size 300cm x 300cm (Draw and Impress) 142.22cm x 142.22cm
Editing of master slides Limited editing, has been a GSOC 2013 project (1). Powerful editing
Creation of automatically starting presentations Not supported, extension: ImpressRunner Supported
Export presentation to video formats Not supported (tdf#34959) Supported (only to .wmv format)
Slide zoom and pan Not supported (tdf#38263) Supported

Database program: LibreOffice Base vs. Microsoft Access

Major Feature Differences LO Base 4.4 MS Access 2013
Available on all operating systems supported by the office suite Yes MS Access not available on macOS, Windows RT and other mobile OS
SQL syntax highlighting Supported Not supported
Native connectors for: MySQL/MariaSQL, PostgreSQL, Novell GroupWise Supported No, via ODBC
Integration of Mozilla Thunderbird address book, KDE address book, Evolution LDAP and storage, Windows system address book Supported (TB address books not on macOS (tdf#38397) Not supported
Native JDBC driver Supported Not supported
Connect to ODF spreadsheet (Calc) file format Supported Not supported
Database engine HSQLDB 1.8.x, FirebirdSQL (experimental) Jet
Importing data sources (tables) from within the database application Either via drag & drop from Calc or via drag & drop from another Base window with the data source being open. (1) (tdf#51872) Supported
Exporting tables to different file formats from within the database application: Only via drag&drop to LibreOffice Calc or via drag & drop from another Base window with the writable data source being open. (1) (tdf#73798) Supported
Edit MS Access files Limited olders driver "Microsoft.Jet.OLEDB.4.0" works fine for read/write, while "Microsoft.ACE.OLEDB.12.0" driver only reads; (tdf#43187). Driver only works on Windows. Supported
Native connector for: Microsoft SQL Server No, via ODBC Supported
Search & replace in tables Search feature, but no search&replace (tdf#32506) Supported
Crosstab queries Not supported but reproducible with Pivot Table with Calc (FAQ 142) Supported
"Linked tables" capability Not supported but you can link text tables (FAQ 143) (tdf#56234) Supported
Imported table from spreadsheets - keep fields format Not supported Supported
Import data from XML, HTML Not supported Supported
Minor Feature Differences LO Base 4.4 MS Access 2013
Native connector for: dBase databases Supported Not supported (removed feature since Office 2013)
Open LibreOffice Base (.odb) files Supported Not supported
Open DOS/Windows legacy formats: Microsoft Works database Supported Not supported
Native connector for: SharePoint lists Not supported Supported
Web service data connection Not supported Supported
Password protection of database Not supported (tdf#70638) Supported
Calculations in database tables Not supported (tdf#72787) Supported

Extensions: LibreOffice extensions adding outstanding features to LibreOffice

LibreOffice has a complex eco-system of extensions (over 380 on extensions.libreoffice.org and over 800 on extensions.services.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
  • TexMaths adds an LaTex equation editor to LibreOffice
  • DMaths adds a comprehensive mathematical tool box to LibreOffice Writer
  • Chemistry allows to insert chemistry formulas as image from formula.
  • COOoder provides syntax highlighting for LibreOffice Writer.
  • AddPics creates a Writer document from pictures of scanned pages.
  • Writer's Tools is a set of utilities for frequent writers.
  • Alternative find & replace dialog for Writer.
  • Typography toolbar for advanced use of Graphite smart font features.
  • QR code Generator
  • Transcriber, transcription tool for audio files.
  • Organon, organisation and navigation tool to organize long texts (novels, narrations, scientific works).
  • Template Changer, allows to change the template for an existing document.
  • File format filters
    • Export-Freemind allows to export 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
LibreOffice Impress
  • Export as Images allows to export all the Impress slides or Draw pages as images of JPG, PNG, GIF, BMP and TIFF format.
  • OpenCards is a free award-winning flashcard learning software.
LibreOffice Draw
LibreOffice Base

See also