ONLYOFFICE Docs Developer Edition for Windows system requirements

Fixes

Document Editor

• Fixed data loss after opening a document reviewed by a user (Bug #48920) (DocumentServer issue #1159).
• Fixed the JS error while entering text after moving the mouse cursor (Bug #49090).
• Fixed opening the docx file with a chart in MS Office (Bug #49219).

Spreadsheet Editor

• Fixed copying from a document to a spreadsheet (Bug #49013).

Presentation Editor

• Fixed broken PPTX while opening in Microsoft PowerPoint (Bug #49258)(DocumentServer issue #1191).

Integration

• Fixed missing Plugins tab (Bug #49007).

New Features

All Editors

• Added the ability to manually set font size up to 300 pt (409 pt in the Spreadsheet Editor).
• Added the ability to switch between text field, combo box, list items in some dialog windows using the Tab/Shift+Tab keys.
• Added new interface languages: Belarusian, Catalan, Greek, Lao, Romanian. Added missing translations for mobile and embedded editors in Danish, Japanese, Norwegian.
• Changed loaders for long-running operations.

Document Editor

• Added the ability to insert and edit Table of Figures.

Spreadsheet Editor

• Improved formatted table autoexpansion.
• Added the ability to insert slicers for pivot tables.
• Added the Data Validation settings.
• Added the ability to create custom number formats.
• Added new functions: GROWTH, TREND, LOGEST, UNIQUE, MUNIT, RANDARRAY.

Presentation Editor

• Added the Autoformat as you type functionality in the proofing settings.
• Added the Increment/decrement font size buttons on the toolbar.

Fixes

• All components received countless fixes.

Server

• Updated nodehun.
• The user who clicked the forcesave button becomes an author of the intermediate version.

Fixes

All Editors

• Fixed application of the none value in the Display units field for charts (Bug #43017)
• Added a custom message for protected files.

Document Editor

• Fixed the JS error while clicking on a table in a specific docx file (Bug #47871).
• Fixed the JS error while pressing Escape after adding free form line (Bug #47958).
• Fixed an error when opening a specific file for Mail Merge(Bug #47747).

Spreadsheet Editor

• Fixed the JS error while clicking on a link in a shape (Bug #47864).
• Fixed translation for the Freeze Pane Shadows option (Bug #47739).

Mobile editors

• Fixed an error while showing a comment (Bug #47765).

Server

• Fixed missing /info page (Bug #47819).
• Fixed the ??? symbols in the Chinese fonts (Bug #47995)(DocumentServer issue #1099).

Installation

• Fixed a problem with database cleanup once again (onlyoffice-documentserver.postinst: 124: [: false: unexpected operator) (DocumentServer issue #1043) (DocumentServer issue #1088).

x2t

• Fixed a problem with detecting the fodt, fods, fodp files (Bug #47775).
• Fixed saving to odt when an image was added via a placeholder (Bug #47278).
• Fixed saving a file with the image caption to odt (Bug #47638).
• Fixed opening a link in a specific doc file (Bug #47574).

ePub

• Fixed the %20 symbol in some ePub files.

Plugins

• Fixed an issue with the custom width of the plugin tab on the left sidebar (Bug #47845).
• Fixed the translator plugin for IE11 (Bug #47773).
• Added new icons for the translator plugin.

New Features

All Editors

• Added support of the fb2 format for viewing. The html/epub/mht formats are now available for all platforms.
• Updated fill settings for autoshapes, cells, slides, TextArt: added a spinner for setting the picker position, buttons for adding and removing the current picker. Updated styles. When adding a new picker, the current appearance of the gradient does not change.
• Added the ability to set an arbitrary angle for a gradient fill.
• Added the ability to edit Math AutoCorrect options (remove or change existing entries, add new ones, restore default values).
• Added the Recognized functions functionality to the proofing settings.
• Added icons to context menus.
• Renewed the File panel: the Apply button is always visible.
• Added the ability to copy a comment from the left sidebar.

Document Editor

• Added the Line numbers functionality.
• Added the ability to insert, edit, and convert endnotes.
• Added the ability to create cross-references.
• Added the ability to differentiate review permissions by groups in the editor configuration file.
• Added the Autoformat as you type functionality to the proofing settings.
• Added the Select Data button in the Chart Editor window.

Spreadsheet Editor

• Added the Sheet view functionality (available only for the paid version).
• Added a button to insert a pivot table in the Insert tab.
• Added additional options for editing chart data (series and categories).
• Redone changing the cell editor height.
• Added a new cursor for column\row hover.
• Added the ability to display shadows for frozen areas.
• Added the Autoformat as you type functionality to the proofing settings.

Plugins

• Added the Help parameter for plugins - a link to the plugin description.
• Updated the Translator plugin. It uses Google Translate instead of Yandex.

Embedded mode

• Removed the Google+ icon from the sharing settings window.
• Added the Print option to the menu.

Fixes

• All components received countless fixes.

Backend

• ttf-mscorefonts-installer is now an optional dependency.

New Features

Integration Example

• The integration example now included in the open source version.

Fixes

All Editors

• Fixed a problem with inserting the BMP images in a document (Bug #47276).

Installation

• Fixed a problem with the database cleanup (onlyoffice-documentserver.postinst: 124: [: false: unexpected operator) (DocumentServer issue #1043).

Backend

• Fixed an issue with PostgreSQL before 9.5 (bug #45406).

Fixes

All Editors

• Actualized Help.

Document Editor

• Fixed losing comments added to the docx document (Bug #46770).

Spreadsheet Editor

• Fixed refreshing a pivot table in R1C1 (Bug #46052).

Convert

• Fixed an error while opening a specific xls file (Bug #46728)

Backend

• Fixed several vulnerabilities.
• Fixed Path Traversal vulnerability via the download as params.
• Fixed ER_DATA_TOO_LONG: Data too long for column 'callback' at row 1.
• Fixed a problem with generating a new presentation theme (Bug #46754).

Installation

• Fixed cluster mode setup.

New Features

All Editors

• Added the AutoFit settings for shapes.
• Added the ability to insert special characters. Hotkeys have been implemented in the Document Editor only.
• Added the Ctrl + 0 hotkey to reset zoom to 100%. A sequence fits a slide to workview in the Presentation Editor (Bug 45106).
• Changed a behaviour of hiding icons in tabs when reducing editor windows. They are hiding as needed now.
• Added the autorun settings for macros. If the Show Notification option is selected, a user will be notified about macros existence.
• Added the ability to select an image from the document manager for watermarks, shapes and slides fill (Bug 42913).
• Added the AutoCorrect list (Bug 44659) (DocumentServer issue #335).
• Redesigned the color selection component.
• Added the ability to change a position and size of chart elements (a title, an area, a legend and data labels).

Document Editor

• Added the ability to insert date and time (Bug 36585).
• Added the ability to print the selection in the view mode (Bug 44338).
• Added the ability to convert equations from old formats (Bug 44511), (DocumentServer issue #780).
• Changed a placeholder for content controls.
• Redone the algorithm of justifying a paragraph with condensing spaces (Bug 40851, Bug 44960, DocumentServer issue #956).
• Fixed an issue with an incorrect type of quotes for many localizations (Bug 45790, Bug 45591, DocumentServer issue #406, DocumentServer issue #898).
• Fixed an issue with ignoring the menu key when calling the context menu (Bug 45692, DocumentServer issue #937).
• Fixed an issue with replacing Chinese characters by digits in numbered lists (Bug 44723, DocumentServer issue #734).

Spreadsheet Editor

• Added full support of pivot tables (inserting and editing).
• Added the autofilter settings in pivot tables (by labels, by values, additional sort parameters).
• Added support of opening all conditions existing in a file for data bar conditional formatting.
• Added support of opening all gradients existing in a file for data bar conditional formatting.
• Added the Shift+F3 hotkey for a function insertion.
• Added full support of slicers for formatted tables (Bug 30397).
• Added the special paste settings (Bug 42544).
• Added the ability to move a sheet from one workbook to another.
• Added the ability to insert an internal link to a named range (Bug 44821).
• Added the ability to print titles (Bug 43869, DocumentServer issue #714).
• Added a component for cells selection.
• Added the Ctrl+Shift+= and Ctrl+Shift+- hotkeys for displaying the Insert Cells or Delete Cells dialogues (Bug 36285, DocumentServer issue #282).
• Added the status bar settings.
• Added the ability to remove duplicate values. Also available for formatted tables.
• Added the Ctrl+; and Ctrl+Shift+; hotkeys for date and time insertion (Bug 42876).
• Added the ability to insert function via the Function Arguments dialogue.
• Added the ability to get a hyperlink to an internal range and open the workbook with linking to it.
• Added the Wrap Text and Shrink to Fit settings in the right toolbar.
• Added the Vertical Text option in the text orientation settings.
• Combined the bulleted and numbered list settings. Added the ability to create lists from the List Settings dialogue.
• Added the delimiter settings for the Special Paste and Text to Columns dialogues.
• Added the ability to change the function in the Total Row for formatted tables.
• Added the ability to select the column or row of a formatted table or the whole table by one mouse click.
• Changed the cursor type for the column or row selection.
• Added the LINEST function (Bug 45534).
• Fixed an issue with calculating INDEX function if the row or column parameter is set to zero or omitted (Bug 45388, DocumentServer issue #955).
• Fixed an issue with calculating FORMULATEXT function if it uses an array formula (Bug 45387, DocumentServer issue #391).
• Fixed an issue with calculating DATE formula, if the month argument is set to zero or omitted (Bug 45533, DocumentServer issue #404).
• Fixed an issue with calculating HYPERLINK function in French localization (Bug 45690, DocumentServer issue #913).
• Fixed an issue with splitting pasted multiple lines of text to a few cells if it was copied from Microsoft Excel (Bug 15652, DocumentServer issue #750).
• Fixed an issue with replacing data in cells by hash characters with vertical layout (Bug 42134, DocumentServer issue #618, DocumentServer issue #253).

Presentation Editor

• Changed the interface for an internal link.
• Added the ability to print the selection in the view mode (Bug 44338).
• Combined the bulleted and numbered list settings. Added the ability to create lists from the List Settings dialogue.

Mobile Editors

• Added the ability to insert a comment.
• Added the ability to view, add and edit the comment via the context menu.
• Labels on tabs changed to the icons.
• Removed animation when switching tabs.
• Added the ability to edit comments in the Collaboration tab.
• Reworked the Review tab. Added icons. Moved the review changes panel to the bottom. Added descriptions for the Display Mode.
• Added the Text Orientation options in the Edit Cell settings.
• Added the autorun settings for macros. If the Show Notification option is selected, a user will be notified about macros existence.

Backend

• Check licensed number of editor connections for cluster.
• Do not start force save for encrypted files.
• Fixed insert jpeg images in encrypted files.

Fixes

• All components received countless fixes.

New Features

document-server-integration

• Uses Apache license instead of MIT.

Fixes

x2t

• Fixed SIGABRT on ODT color (Bug #46499)(DocumentServer issue #989).

Backend

• Fixed connecting Document Server with MySQL to Community Server.

Package

• Fixed package type in info.json for documentserver-ee and documentserver-ie.

Fixes

Convert

• Fixed several vulnerabilities in x2t (Bug #46348, Bug #46352, Bug #46353, Bug #46384, Bug #46434, Bug #46436).
• Fixed vulnerability in TXT converter (Bug #46437).

Fixes

Backend

• Fixed Path Traversal vulnerability via image upload params (Bug #46113).

Fixes

Backend

• Fixed Path Traversal vulnerability via savefile param (Bug #46037).

Fixes

Backend

• Fixed Path Traversal vulnerability via Convert Service param (Bug #45976).

Docker

• Fixed !=: unary operator expected while starting onlyoffice/documentserver (Bug #45985).

Fixes

All Editors

• Fixed problems with the Auto Color feature for shapes.
• Fixed problems with copying and pasting images.
• German, French, Italian, Portuguese and Russian translations improvements.

Document Editor

• Fixed a bug with opening a bookmark.
• Fixed a bug with resetting the comment GUID while opening.
• Fixed a wrong undo/redo state for the comparing mode.
• Fixed an issue with the auto color feature for graphical objects in some DOCX user files (Bug #45460).
• Fixed an issue with increasing the font size in some DOCX user files (Bug #44852).
• Fixed an incorrect display of some PDF user files (Bug #45336, Bug #39097, Bug #19078).
• Fixed an incorrect display of a watermark on CJK languages (Bug #45886).
• Fixed the export of some DOCX user files to PDF (Bug #45319).

Spreadsheet Editor

• Fixed an invalid icon in the cell border menu (Bug #45910).
• Fixed an error with copying and pasting a formatted table in some XLSX files (Bug #45731).
• Fixed an error with the formatted table creation in some XLSX files (Bug #45773).
• Fixed an error with entering big data in the last partially viewed cell (Bug #45653) (DocumentServer issue #903).

Presentation Editor

• Fixed the List Settings window in German (Bug #45417).

Mobile Editors

• Fixed an issue with the text selection on iOS devices (Bug #45844).
• Fixed an error while swiping presentation slides (Bug #42758) (DocumentServer issue #923).
• Fixed an appearance of the first slide created after the theme was changed (Bug #45610).

Backend

• Removed redis as a dependency for Community Edition (it was not used, but required to install).
• Fixed the logrotate command for Fedora-based Linux (DocumentServer issue #902).
• JWT: Fixed uploading an encrypted image.
• Fixed an issue with saving an intermediate version while the document is opened for viewing by another user (Bug #45406).
• Fixed unexpected commands in collaborative editing.
• Fixed sending Redis custom option (Commercial Version Only) (DocumentServer issue #764).
• Changed messages in the license exceeding windows (Bug #45819).
• Fixed a conversion error while opening the ePub and HTML files on CentOS 7 (Bug #31323).
• Fixed the deb package postinstall typo.
• Removed the unused Microsoft Visual C++ 2010 Redistributable dependency for Windows.

Plugins

• Fixed the GetCurrentContentControlPr method.

x2t

• Fixed missing page numbers for the RTF file converted into DOCX (Bug #45439).
• Fixed an issue with increasing font size in some RTF user files (Bug #45439).
• Fixed the table width for the RTF file converted into DOCX (Bug #45477).

New features

All Editors

• Added skeleton loader in embedded viewer.

Document Editor

• Added Mendeley and Zotero plugins.
• Adding several table rows/columns option is now available.

Backend

• Added JSON logger.
• New options: sslEnabled and s3ForcePathStyle.
• Added pgPoolExtraOptions (connection options).
• Reduced fonts cache size for AllFontsGen working.

Fixes

All Editors

• Fixed crash while writing a chart with equations in title/axis.
• Fixed an XSS injection in macros names.

Document Editor

• Fixed an editor crashing after adding new rows in table in collaborative editing.
• Fixed an editor crashing after searching and replacing in some DOCX files.
• Fixed displaying of some DOCX files.
• Fixed displaying of some RTF files.
• Fixed scrolling to bookmark in some corrupted DOCX files.

Spreadsheet Editor

• Data validation fixes and improvements.
• Fixed a crash on opening some XLSX files.
• Fixed filling cells with formula in R1C1 mode.
• Fixed recalculating formulas in some XLSX files.
• Fixed XSS injection in data validation tip.
• Fixed a crash with edit type of cells filling.
• Fix some missed icons.

Mobile Editors

• Font picker refactoring.

Backend

• Fixed missed require util in logger.
• Fixed wrong callbackUrl after updating Document Server without Data Base dropping.
• Fix security problem with JWT token when uploading image.

x2t

• Fixed an issue with wrong encode of some CSV files.
• Fixed converting some DOCX files.
• Fixed converting some RTF files.
• Fixed security issue with builder and working with local files.
• Fixed writing corrupted DOCX file with chart in group shape.

Package

• Use dropping tables instead drop databases database in deb postrm scrip.
• Replace wget with curl for prepare4shutdown.
• Fix security issues with accessing info page.

Plugins

• Add and fix translations in macros plugin.

New features

All Editors

• Added the instruction on how to build all products

Spreadsheet Editor

• Added support of reading drop-down lists.
• Added support of reading data validation.

Fixes

All Editors

• Fixed an issue with missing 1.5x icons (DocumentServer issue #812).
• Bulgarian, Chinese, Czech, German, French, Italian, Russian, Spanish, Turkish localizations improvements.
• Added support of Danish, Finnish, Hungarian, Indonesian, Norwegian, Swedish localizations.
• Fixed some security issues.
• Updated copyright year.
• Fixed some more issues with user files.

Document Editor

• Fixed an issue with the comment duplication after editing some DOCX files and opening them in other editors (bug #44689).

Spreadsheet Editor

• Better support of the TIME function (bug #44849).

x2t

• Fixed some security issues.
• Fixed issues with opening some DOC, RTF and XLSX files (bug #44756, bug #44934, bug #44840).
• Fixed corrupting the mime-type parameter after editing some DOCX files (bug #44957).

Server

• Reading the license file disabled in Community Edition.
• Fixed an issue with missing the license file in log files (DocumentServer issue #814, bug #44694).
• Fixed some database-related security issues.
• Fixed mariadb support.
• Database optimizations for better performance.
• Fixed an issue with disabling the Download As option after the client reconnection (bug #44757).
• Fixed PostgreSQL command for citus compatibility.

Docker

• Fix for grep for creating table, so it stops throwing a failure.

New features

All Editors

• Loading speed improvements.
• Symbol table now is a system component, not a plugin.
• Added a new button: Top Toolbar -> Collaboration -> Remove comments.
• The Default Size button in the image settings was replaced with the Actual Size one.

Document Editor

• Adding content controls is now available only for the paid version.
• Added the possibility to remove table cells.
• Added the possibility to insert several rows/columns into the table.
• Added the possibility to add captions for images, shapes, tables and equations.
• Added new content control types (Picture, Combo box, Drop-down list, Date, Checkbox).
• Added the possibility to compare documents (available only for the paid version).
• Added new options for bulleted and numbered lists.
• Added the possibility to draw and erase a table.
• Added the possibility to edit gutter and mirror margins.

Spreadsheet Editor

• Added the possibility to recalculate all formulas.
• Added new scale options.
• Added new options for cell fill.
• Added the possibility to set Cell Snapping for images, shapes and charts.
• Added the possibility to work with several sheets at once.
• Added the Hungarian localization to the regional settings.
• Added the bulleted and numbered list options to the context menu.
• Added the possibility to change the bullets marker.
• Added new spellchecker options.
• Added the possibility to sort by several columns/rows.
• Added a new option for setting separators.

Presentation Editor

• Added the possibility to add objects (tables, shapes, charts, images) to a slide template.
• Added the possibility to reset a slide.
• Added new list settings.
• Added the possibility to add objects (images, charts, tables) to a placeholder.

Mobile Editors

• Mobile editors are now available only for the paid version.
• Added the possibility to save custom colors.
• ONLYOFFICE logo was added to the header (with the possibility to customize it).

Package

• Removed nodejs dependency.

Docker

• Ubuntu 18.04 is now used as a base image.

Server

• Added the possibility to convert to PDF/A via the ConvertService.

Fixes

• All components received countless fixes.

New features

All Editors

• Renamed the web-apps-pro repository to web-apps.

Plugins

• Added plugin methods to move the cursor to the start/end of the document (MoveCursorToStart, MoveCursorToEnd) (bug #41521).

Backend

• Added custom public key support.

Fixes

Document Editor

• Fixed the problem with removing previously added text by other user in the review mode (bug #43183);
• Fixed the problem with moving text in the review mode (bug #43238);
• Fixed the problem of inserting a table over another table;
• Fixed the problem with reviewed numbering;
• Fixed some problems with watermarks;
• Fixed the license error while inserting a chart for the Document Server with a custom logo (bug #43314).

Plugins

• Fixed starting the Photo Editor plugin (bug #42473);
• Fixed issues with the YouTube plugin.

Embedded mode

• Fixed focus in the embedded mode;
• Fixed hiding the Download button and Settings menu.

Installation

• Fixed the issue with messages in cyrillic encoding for the Windows installation;
• Removed the unused installation dependency - boost-regex (or similar).

x2t

• Fixed the issue with the cell height when converting XLS to XLSX (bug #43072).

New features

Spreadsheet Editor

• Added the sv-SE locale to the number format list.

Presentation Editor

• Added the support for the theme thumbnail parameters.

document-server-integration

• Added the blockcontent mode.

Fixes

All editors

• Fixed the issue when adding the document info was not detected as the document change (bug #42717);
• Fixed the problem with the paste operation after the settings were opened;
• Fixed some issues with loading of translations;
• Fixed the issues with the font name being unreadable when the black theme is used (bug #42882).

Document Editor

• Fixed the problem with the content control selection (bug #42657);
• Fixed the problem with accepting/rejecting the changed in case the moved text is included into the selection (bug #42665);
• Fixed the problem with deleting the text that had been previously added by the same user (bug #41242);
• Fixed the No image uploaded error for the watermark background (bug #42832);
• Fixed the issue with the unit of measurements used for the rulers (bug #42608);
• Fixed the display of the style list in the Create New Style window when the window size is small (bug #42799);
• Fixed the issues with changing the display mode for the change tracking (without the Plugins tab).

Spreadsheet Editor

• Fixed the issue with opening certain files with pivot table without a pivot style;
• Fixed the JavaScript error in the SUBTOTAL function (bug #42833);
• Fixed the issues with the scale options occurring when printing (bug #34704);
• Fixed the issues with adding images from storages (bug #42789);
• Fixed the auto-sum symbol icon;
• Fixed the button icons (chat, comments).

Backend

• Fixed the core.zip URL for the development environment.

Plugins

• Fixed the Thesaurus plugin (sdkjs-plugins issue #78);
• Fixed the issue with the OCR plugin using remote scripts.

document-server-integration

• Fixed the issue with opening the file location when Document Server is used with a custom port (document-server-integration issue #63).

x2t

Common

• Fixed several font picker bugs;
• Fixed the support for the FLV format;
• Fixed the display of some UTF font names (bug #42926 and DocumentServer issue #651);
• Fixed the issue with GenerateGuid;
• Fixed the issue with the ICU compilation (DocumentServer issue #656).

doc

• Fixed the issue with the extended comments.

docx

• Fixed the issue with the bookmark saving inside a hyperlink.

xls

• Fixed the issues with the marker filters in certain XLS files (bug #42239);
• Fixed the issues with the image size when saving to XLS (bug #42618);
• Fixed the issues with the group data display (bug #42216).

xlsx

• Fixed the issues with the tooltip for data validation (bug #42667);
• Fixed the Excel recovery error for files with comments (bug #42968);
• Fixed the issues with the reply duplicates (bug #42969).

odf

• Fixed error in headers/footers;
• Fixed the issues with the print areas (bug #42654);
• Fixed the issues with the column width (bug #42790);
• Fixed the issues with the cell color (bug #42932);
• Fixed the issues with the link to the cells formatted as table (bug #42938).

rtf

• Fixed some issues with the files in RTF format.

Docker

• Fixed the issue with the token not working correctly when docker-compose is used (Docker-DocumentServer issue #175);
• Fixed the issues with the AMP SSL links (Docker-DocumentServer issue #183).

New features

All editors

• Added more options for Paragraph spacing;
• Added the possibility to set paragraph Outline level;
• Added the possibility to get current color scheme;
• Updated the Document Info page;
• Added better templates for tables and increased their number;
• Added the possibility to select languages using keyboard (bug #24317);
• Added the possibility to show a shadow for images and shapes;
• Added the possibility to use mentions in comments;
• Added the possibility to show multi-gradient fill in shapes (bug #40719);
• Added the onRequestSaveAs API event to save files to a storage;
• Added the onRequestInsertImage event and insertImage method to insert images from a storage.

Document Editor

• Added the possibility to create a new style with the next style being the same as previous one;
• Added the possibility to add watermarks;
• Added the possibility to print the selection;
• Added the possibility to save DOCX using the mode compatible with older versions;
• Added the tooltip for table styles;
• Added the onRequestMailMergeRecipients event and the setMailMergeRecipients method for mail merge.

Spreadsheet Editor

• Added the possibility to change look of chart elements;
• Added the possibility to set headers and footers;
• Added a new tab to work with formulas;
• Added the possibility to group data;
• Added the spellchecker;
• Added the support of print areas;
• Added the possibility to resize the autofilter window;
• Added the possibility to show the number of cells in autofilter window;
• Added the possibility to save 10 last used functions;
• Set default value for regional settings (bug #41549);
• Added support for asynchronous loading of formulas.

Presentation Editor

• Added new themes for slides;
• Added the support for the print selection option for slide;
• Added the possibility to set headers and footers;
• Added the possibility to insert the slide number;
• Added the possibility to insert date and time;
• Added the tooltip for table styles.

Plugins

• Added support for asynchronous loading of plugins.

All mobile editors

• Updated the Document Info page;
• Added the possibility to set a color scheme;
• Added the possibility to set units of measurement;
• Added the possibility to show comments;
• Added the possibility to show users currently editing the document.

Mobile Document Editor

• Added the possibility to view, accept, reject the review changes;
• Added the possibility to set the display mode for the review changes;
• Added the possibility to add footnotes;
• Added the possibility to download files to the RTF format;
• Added the possibility to merge and split table cells;
• Added the settings for non-printing characters;
• Added the settings for displaying comments.

Mobile Spreadsheet Editor

• Added the possibility to work with autofilters (bug #34113);
• Added the settings for displaying comments;
• Added regional settings;
• Added the possibility to set the R1C1 mode;
• Added the settings for formula language;
• Added the additional settings for the search in the spreadsheet;
• Added the settings for headings and gridlines;
• Added the layout settings (page size, orientation, margins);
• Added the possibility to freeze panes from the context menu.

Embedded viewers

• Added the translations for the embedded viewers (bug #31297).

Fixes

All editors

• Fixed a lot of bugs.

Deprecations

All editors

• Removed the ClipArt plugin (the third party openclipart.org service became unavailable).

New features

Plugins

• Added the translations for Photo Editor plugin.

Fixes

All editors

• Fixed the order of the spellchecker correction entries (Desktop Editors issue #224).

Document Editor

• Fixed the JavaScript error which occurred when undoing the previous insert action of an empty row into a table (bug #41995);
• Fixed the problem with adding an equation inside a hyperlink;
• Fixed the composite input in Firefox browser (Document Server issue #601);
• Fixed the issue when the files with math created by Aspose crashed when opened.

Presentation Editor

• Fixed the issue with the slide background color.

x2t

• Fixed the issue with decoding XLSX escaped chars (bugs #36575 and #41890).

Windows version

• Fixed a misprint on Redis configuration page.

Fixes

All editors

• Fixed more problems with SVG.

Document Editor

• Fixed the JavaScript error which occurred while scrolling in mail merge window (bug #41787);
• Fixed the JavaScript error which occurred while opening some specific DOCX files (bug #41847);
• Fixed the JavaScript error which occurred while using the final mode in review mode (bug #41846);
• Fixed the problem with updating positions in the inner classes within a paragraph (bug #41848);
• Fixed the issue when records were added to reviews with changes of the text properties if in fact there have been no changes (bug #41833);
• Fixed the critical bug on settting up the hideContentControlTrack property;
• Fixed the issue with showing the changes from the second user if the display of the changes was disabled (bug #41576);
• Fixed the problem with accepting/rejecting review changes.

Spreadsheet Editor

• Fixed the JavaScript error which occurred for Replace all in some cases (bug #41760);
• Fixed the column index error which occurred during insertion;
• Fixed the issue with adding the changes to the history on drawing sparklines.

Plugins Editor

• Fixed the logging error for plugins.

Backend

• Fixed several incorrect error messages;
• Fixed the error with the unknown issuer name which occurred while downloading via HTTPS.

New features

Document Editor

• Added the support for calculating tabs in Word 2013 style positioned to the right of the right margin.

Fixes

All editors

• Fixed a lot of bugs with drawings positioning;
• Fixed the compilation using the actual gcc version (Document Server issue #575).

Document Editor

• Fixed the JavaScript error which occurred while entering the text in content control in specific DOCX files (bug #41687);
• Fixed the problem with calculating the numbering value within merged cells (bug #41699);
• Fixed the JavaScript error which occurred while undoing the entered text in review mode (bug #41708);
• Fixed the issue with deleting the whole TOC field after selecting it (bug #41714);
• Fixed the issue with showing the numbering as changes for review in specific documents (bug #41518);
• Fixed the issue with the opening Modelling_scholarly_communication_report_final1.docx file (bug #41717);
• Fixed the crash which occurred when refreshing the recalculated data;
• Fixed the bug with moving object in group;
• Fixed the problem with rendering WMF files (bug #41495).

Spreadsheet Editor

• Fixed the issue with undoing the moved cell in print area (bug #41723).

Mobile web editors

• Fixed the issue with adding shapes to the table (bug #41676);
• Fixed the issue with inserting formulas on iOS;
• Fixed the issue with the application freeze after adding images by URL (bug #41677).

Document Builder

• Fixed the errors in Document Builder documentation.

Packages

• Fixed 1-click installation;
• Fixed the RPM update from version 5.2.8 to 5.3.0;
• Removed .m4 files from packages;
• Fixed the Document Server example startup after upgrading;
• Fixed the onlyoffice: ERROR (no such group) error;
• Fixed the update if a custom NGINX config is used.

Docker installation

• Fixed the docker compose startup error (Docker-Document Server issue #163);
• Fixed the issue when Document Builder returned "urls": {} if /var/lib/onlyoffice was mounted (Docker-Document Server issue #164).

New features

All editors

• Added the tabbed interface to the open-source version;
• Changed the placement for the Undo/Redo, Save and Print buttons in the top toolbar;
• Added about 250 document languages (mostly without a spellchecker);
• Completely rewritten the font engine, adding a better support of Chinese, Japanese and Korean fonts and much more;
• Added the possibility to flip and rotate shapes and images;
• Added the possibility to crop images;
• Adding a bookmark does not close the bookmark window;
• The comments are now shown in all editing and viewing modes;
• Added the new hotkeys on MacOS and their description in documentation;
• Added the new customization license flag;
• Added the possibility to load the images from a storage;
• Added options for objects alignment (align to page, margin, slide);
• Added new hints for shapes (bug #20091);
• Completely rewritten the photo editor plugin;
• Updated the interface translations to all the main languages available in the editors;
• Updated the documentation articles;
• Added Bulgarian and Hungarian as interface languages.

Document Editor

• Added formulas in tables;
• Added the possibility to save as DOTX, PDF-A, OTT;
• The review changes are now shown in view mode;
• Added the possibility to prevent deletion of the review changes of another user;
• Added the possibility to prevent deletion of the comments of another user;
• Added the description for moved text and move to changed text in review mode;
• Added the possibility to get link to bookmark;
• Added the possibility to automatically copy the selected text to the search window.

Spreadsheet Editor

• Added the bg-BG, sv-SE and sv-FI number formats;
• Translates the functions and their descriptions to Italian;
• Replaced the behavior of the mouse click for the links in cells;
• Added the ASC, BETAINV, HYPERLINK functions;
• Added the support of print areas;
• Added the possibility to set the exact text orientations in degrees;
• Added the text to column wizard;
• Added the paste text wizard;
• Added the possibility to save as XLTX, PDF-A, OTS;
• Added the support of the array formulas;
• Added the support for the gradient and texture cell fill;
• A hint is now shown with function and argument descriptions while typing;
• Added the support to show minimum and maximum values in the status bar;
• Added the possibility to distribute objects;
• Rewritten the cut cell process (cell is not removed after cutting).

Presentation Editor

• Added the possibility to save as POTX, PDF-A, OTP;
• Added the font rendering option;
• Added an option to search and replace the text;
• Added the possibility to enter the slide number manually for the internal hyperlinks.

Fixes

All editors

• A lot of bugfixes in all product modules.

New features

All editors

• Updated the copyright messages to 2019;
• Updated the Latvian address to the actual one;
• Updated the npm-shrinkwrap module to the actual version;
• Added the support for Chinese as a document language (without spellchecker) (Document Server issue #479);
• Updated the interface translations to all the main languages available in the editors.

Plugins

• Added the support for system plugins.

Backend

• Added the robots.txt handler.

x2t

• Added the default theme for XLS.

Fixes

All editors

• Fixed the issue with copying the charts containing no txPr elements.

Document Editor

• Fixed the display of the border in some DOCX files (bug #39461);
• Fixed the problem of correcting the anchor in selection;
• Fixed the issue with the color of content control border in preview (bug #40330).

Spreadsheet Editor

• Fixed the color change after conversion of a range as table template (bug #38747);
• Fixed the display of cell values in Safari (bug #39878), (Document Server issue #477), (Document Server issue #467);
• Fixed the issue with the display of a hidden column (bug #40352);
• Fixed the issue with creating a history point when adding a signatureLine;
• Fixed the issue with the display of values from the second sheet on the first sheet (bug #40038);
• Fixed the Maximum call stack error when copying documents or presentations;
• Fixed the cell scrolling in specific files (bug #40294);
• Fixed the JavaScript error occurring when opening some XLS files (bug #39529);
• Fixed the JavaScript error occurring when opening the settings;
• Fixed the issue with printing the file with a custom sheet size (bug #40275).

Presentation Editor

• Fixed the bug with resizing after fullscreen (view position detection);
• Fixed the problem with drawings;
• Fixed the issue with opening a presentation with an unused theme;
• Fixed the issue with the shape display in some PPTX files (bug #39169).

Backend

• Fixed the problem with JWT callback URL (Document Server issue #472).

x2t

• Fixed a lot of bugs in the files in all supported formats received from the users;
• Fixed the error which occurred when opening XLSX with an image in the header in MS Office (bug #40124);
• Fixed the issue with the font which occurred when opening specific XLS files (bug #40178).

New features

All editors

• Updated the documentation articles;
• Updated the nodehun to the latest version.

Spreadsheet Editor

• Added sv-SE and sv-FI regional settings.

Spreadsheet Viewer

• Added the possibility to change the row height or column width in view mode without saving changes.

Plugins

• Added the possibility to send parameters to plugin (user, document information);
• Added the possibility to translate plugins;
• Added Highlight Code and Thesaurus plugins.

Fixes

All editors

• Fixed the error which occurred when comparing solid fill;
• Fixed the translation to the German language.

Document Editor

• Fixed the problem with updating the current position when moving the table border;
• Fixed the problem with clearing the text properties;
• Fixed the problem with opening a specific DOCX file (bug #39941);
• Fixed the problem with deep table nesting (bug #39963);
• Fixed the JavaScript error which occurred when the header with a loading image was clicked (bug #39940);
• Fixed the problem with recalculating tables (bug #39945);
• Fixed the problem with recalculating a footnote in vertically merged cells;
• Fixed the bug when the changes were lost when moving a table;
• Fixed the bug with the selection marks when adding a table row;
• Fixed the bug when wrong selection boundaries were received when moving the border of the table;
• Fixed the bug with clearing the selection marks in a paragraph;
• Fixed the bug with recalculating nested tables;
• Fixed the problem of using End/Home buttons in a paragraph which had not yet been recalculated;
• Fixed the bug with copy/paste when selecting a numbered list;
• Fixed the bug with the header/footer entry;
• Fixed the bug with adding extra rows when inserting a table content;
• Fixed the problem with copying the table cell properties.

Spreadsheet Editor

• Fixed blocking the save button when opening a chart frame (bug #39827);
• Fixed the problem with copy/paste hidden range containing functions (bug #40017);
• Fixed the issue with the incorrect calculation of SUMPRODUCT function (bug #40109);
• Fixed the problem with recalculating formulas in hidden filter area;
• Fixed the problem with application of the autofilter to empty column by right-click menu;
• Fixed the problem in conditional formatting with calculating the gradient without the distance set (bug #40160).

Presentation Editor

• Fixed the error in copying the slide notes.

Spreadsheet Viewer

• Fixed the bug with YouTube video playback (bug #40174).

Plugins

• Fixed the problem with duplicate URL in the YouTube plugin (bug #36103).

x2t

• Fixed the error with showing a marked list in some PPT files (bug #39929);
• Fixed the issue with the watermark border in some files (bug #39935);
• Fixed the issues which occurred with some ODF files received from users;
• Fixed the problem with the shape and cell text layout in some XLS (bug #39961);
• Fixed the issue with missing text format in specific ODP files (bug #39983);
• Fixed the incorrect numbering in ODP files (bug #39976);
• Fixed the issue when the list in notes was lost in PPT files (bug #39929);
• Fixed the problems with conversion of some XLS files (bug #40065);
• Fixed the issue with the shape rotation in specific ODP files (bug #39979);
• Fixed the issue with showing cell values of Time format in ODS files (bug #40106);
• Fixed the issues with some shapes in PPT files (bug #40115);
• Fixed the issues with shapes without the fill in PPT (bug #40116);
• Fixed the problems with opening an XLSX file with an image in the header (bug #40124);
• Fixed the issues which occurred with some files received from users.

Fixes

Document Editor

• Fixed the issue which occurred when moving a table containing a nested one (bug #40096).

New features

All editors

• Enabled text/HTML drag'n'dropping to the editors;
• Added the possibility to set custom logo without a link (bug #39696);
• Update sdkjs npm requirements.

Spreadsheet Editor

• Added support of R1C1 references style.

Document Builder

• Added the AddComment method to the ApiRange class.

Plugins

• Added the translation for plugin names and descriptions.

x2t

• Added the possibility to write table parts to the OdfFormatReader.

Fixes

All editors

• Fixed the bug with the unLockDocument, isSaveLock sequence;
• Fixed the issue occurring when a source for custom publisher name with quotes was built;
• Fixed the issue with special paste icon when inserting ClipArt (bug #39462);
• Added the display of conversion error in case a PDF had been renamed to DOCX;
• Fixed the bug with a solid fill without a color;
• Fixed the issue when the logo was not shown in Mozilla Firefox and MS Internet Explorer;
• Fixed the issue with opening the presenter view on ownCloud\Nextcloud (bug #39559);
• Fixed the bug when a new font was applied (current font name and new name are empty);
• Fixed the bug with opening the document language dialog when the document language is Spanish (Argentina) (doc.lang = es-AR).

Document Editor

• Fixed the error which occurred after the selection of the font name in combo box was discarded;
• Fixed the inputs for Korean, Chinese and Japanese characters in content control (bug #39724);
• Fixed the problem with recalculating large tables in a document;
• Fixed the problem with accepting/rejecting uncalculated revision changes;
• Fixed the problem with checking CanUpdateTarget parameter for a table;
• Fixed the bug with recalculating a document when a section was deleted;
• Fixed the problem which occurred when complex fields in selection were checked;
• Fixed the problem with updating cursor position in collaborative editing;
• Fixed the bug with moving cursor through a table;
• Fixed the problem with moving an image inside a large table;
• Fixed the problem with updating the current position in table after accepting changes;
• Fixed the bug with special paste of paragraph with numbering.

Spreadsheet Editor

• Fixed the issues with scrolling in some files (bug #39395);
• Fixed the issue with data loss in the second table sheet (bug #39511);
• Fixed the issue when the editor was freezing after consequent use of cut and paste for several columns (bug #37965);
• Fixed the incorrect sum function for the copied sheet (bug #39548);
• Fixed the JavaScript error which occurred when more data than cell width is entered (bug #39623);
• Fixed the incorrect digit counting when using the Decrease Decimal option (bug #39661);
• Fixed the issue with opening file with si and formula parameters used without ref;
• Fixed the issue which occurred when some files with chart are opened (bug #39902);
• Fixed the JavaScript error which occurred when specific sheet was copied to file during co-editing (bug #39921);
• Fix the Simplified Chinese translation for the textPoweredBy field (web-apps issue #142).

Presentation Editor

• Fixed the issue with opening some PPT files (bug #39901).

Document viewer

• Fixed the issue which occurred when translator plugin was used with with PDF and XPS files (bug #36645).

Mobile web editors

• Fixed the SecurityError: Blocked a frame with origin from accessing a cross-origin frame error on Apple devices;
• Fixed bug with setting the active tab when it is not visible in Spreadsheet Editor.

Backend

• Fixed the error occurring in case the changesError command was received without docId;
• Fixed the issue when access_log off; was ingnored.

x2t

• Fixed the loss of grouped autoshapes in ODT (bug #39467);
• Fixed the issue with conversion of some WMF files (bug #39533);
• Fixed the issue with conversion of some XLS files (bug #39541);
• Fixed the issue with conversion of some VML files with drawing_ml markup;
• Fixed the issues with opening some specifiс PPTX files (bug #39747, bug #39745);
• Fixed the bug with metadata in UTF-16 format;
• Refactoring of auto shapes for OdfFormat;
• Fixed the issues for DocFormat after testing.

Docker installation

• Fixed the Docker-compose 503 Service Unavailable error (Docker-Document Server issue #133);
• Fixed the DB_NAME issue (Docker-Document Server issue #134);
• Fixed the logging issue.

New features

All editors

• Updated the interface translations to all the main languages available in the editors.

Spreadsheet Editor

• Enhanced the application due to the completely rewritten scroll.

Document Builder

• Added the new setLocale and getLocale functions.

Server

• Added logging for SaveLock;
• Added the possibility to copy the changes and files with browser error to a special directory.

x2t

• Performed refactoring for conversion of WordArts from ODF to OOXML and vice versa;
• Performed refactoring for conversion of form controls in spreadsheets (for ODF files);
• Added conversion for bookmarks for OdfFormatwriter component.

Fixes

All editors

• Fixed the bug with CFF fonts (glyph loader);
• Added the display of LoadingScriptError error in case of sdk-all.js loading faiure;
• Fixed the Cannot read property '$icon' of undefined error when using the Ctrl+S keyboard shortcut in chart editor (bug #39254);
• Removed the Command+H keyboard shortcut used for Mac OS.

Document Editor

• Fixed the issue with opening a DOCX file with track changes and calculations created by Aspose;
• Fixed the problem with reading the ID of a content control;
• Fixed the crash in CNumberingLvlLegacy.ReadFromBinary;
• Fixed the problem with table selection;
• Fixed the problem with replacing a misspelled word with another;
• Fixed the bug with pressing the TAB key;
• Fixed the critical issue which occurred when the document had been locked on the undo in the Fast collaboration mode;
• Fixed the missing Hide Degree menu entry for equations (bug #39135);
• Fixed the problem which occurred when recalculations were made in co-editing;
• Fixed the problem with processing the pageDown button in co-editing;
• Fixed the Cannot read property 'eb' of nul error which occurred when a table column was deleted (bug #39252);
• Fixed the problem with rendering which occurred when replacing the text (bug #39269);
• Fixed the Cannot read property 'length' of null error which occurred when some files were opened (bug #39210);
• Fixed the problem with saving/loading the table state on undo/redo;
• Fixed the issue with displaying the chart added with macros (bug #39304);
• Fixed the problem with calculating large tables separated by columns.

Spreadsheet Editor

• Fixed the crash which occurred when a file was built with comment changes;
• Fixed the issue when an incorrect chart was added to the area with autofilter (bug #39168);
• Fixed the issue with the incorrectly selected cells when a formula was changed using the keyboard (bug #39181);
• Fixed the issue when the browser hung on some files with formulas (bug #39190);
• Fixed the incorrect display of doughnut chart with autofilter (bug #39200);
• Fixed the incorrect IF function values (bug #39233);
• Fixed the problem with the number of replacements made (bug #39273);
• Fixed the Cannot read property 'Zb' of null which occurred when trying to copy a shape deleted by another user (bug #39312);
• Fixed the Maximum call stack size exceeded which occurred when the application was switched to fullscreen (bug #38972);
• Fixed the this.dPc is not a function which occurred during the data sorting (bug #39397);
• Fixed the issues with undo applied to the filter in specific files (bug #39402);
• Fixed the scroll to end of the table issue (bug #21946);
• Fixed the issue with sorting of the first row in some files (bug #39397);
• Fixed the issue with the sorting range if filtered data was present in it (bug #39410);
• Fixed the double columns borders display issue (bug #39392);
• Fixed the issue with rendering of the last rows in some files (bug #39394);
• Disabled the cell settings when editor is disconnected;
• Fixed the issues with printing and calculation; sped up cache preparation.

Presentation Editor

• Fixed the Cannot read property 'Ia' of null error which occurred when some PPTX files were opened (bug #39191);
• Fixed the problem with negative spacing;
• Fixed the Cannot read property 'W' of undefined error which occurred when copying a table (bug #39264).

Embedded viewer

• The viewer now shows an error when trying to open password protected files (bug #39251);
• Fixed the JavaScript error which occurred when opening TXT files (bug #39250).

Server

• Fixed the license endDate information for trial version;
• Fixed the Cannot read property 'time' of null error;
• Changed the logrotate configuration directory.

x2t

• Fixed the issue when an empty RTF file was opened (bug #39172);
• Fixed the problems with opening of some ODS files (bug #39192);
• Fixed the conversion to raster for graphiscs on linux without set fonts;
• Fixed the binary conversion of mathType version over 3.0 with PptxFormat component;
• Fixed the problems with the document structure for specific files (bug #39236);
• Fixed the issue which occurred when opening in some resulting files in MS Word (bug #39216);
• Fixed the problems with opening specific DOCX files (bug #39248);
• Fixed the problems with the user files in XlsFormatReader component;
• Fixed the problems with the user files in PptFormatReader component;
• Fixed the problems with some user files in PptxFormat component;
• Fixed the problems in OdfFormat and OdfFormatWriter components;
• Disabled truetype fonts conversion in HTML viewer;
• Fixed the problems with opening of some RTF files (bug #39315);
• Fixed the row selection issue in PDF files (bug #39214);
• Fixed the issue when only the last ConditionalFormatting was written from the Editor.bin (bug #39391).

Docker installation

• Fixed the ‘/var/run/rabbitmq’: Permission denied issue on container restart (Docker-Document Server issue #92);
• Fixed the startup on minishift removing the /etc/onlyoffice;
• Setup the correct logrotate configuration rights.

Fixes

RPM

• Fixed the DS_PORT problem which occurred during the installation of ONLYOFFICE Enterprise Edition.

New features

All editors

• Added the possibility to customize the initial zoom for the embedded editors;
• Added the possibility to customize availability of help in the editor;
• Added the display of the File and Plugins tabs for viewers;
• The username is now highlihgted by color in the comments, review changes, chat messages;
• Prevented the duplication of online users in the left chat panel;
• Added the possibility to sort comments in the popover by ascending creation time.

Document Editor

• Added the possibility to work with bookmarks;
• Added the possibility to add/change hyperlinks anchored to bookmarks/headings;
• Added the possibility to change numbering value, start/continue numbering;
• Added settings for content controls (highlighting and appearance);
• Review changes and comments are now displayed in the combined window;
• Added presets for А0, А1, А2, А6 page size (bug #36583);
• Changed the encoding format for the TXT files (bug #36998);
• Added the mode for filling forms;
• Enabled closing the chart dialog while loading (bug #36870);
• Enabled closing the window when saving to TXT format;
• Enabled inserting shapes when a shape is selected;
• The new revisions are now checked in the Fast co-editing mode.

Spreadsheet Editor

• Added the possibility to set options when saving to PDF format (bug #34914);
• Added the cell settings in the right panel;
• Added the Layout tab;
• Added the hint for autofilters;
• Added the possibility to change the encoding format for CSV files (bug #36998);
• Enabled closing the window when saving to CSV;
• Enabled saving page options to a file before printing;
• Added the possibility to view combo charts.

Presentation Editors

• Added hints to presentation themes (bug #21362);
• Added the presenter preview in the viewer (bug #37499);
• Enabled closing the chart dialog while loading (bug #36870).

Mobile web editors

• Added the sheet renaming option in the mobile editor (bug #37701).

Server

• Added the savefile request handler;
• Renamed crypted into encrypted, transferred replyStr to saveUrl handler;
• Added useridoriginal parameter to all messages in chat;
• userId parameter is now used instead of sessionId in locks (server issue #91);
• Added the PDFA file type;
• Added the spawnOptions config parameter for X2T;
• The title parameter is now used in ConvertService.ashx;
• The forked statsd is now used to support Ubuntu 18.04;
• The branding parameter is now set to int instead of string and boolean for older versions;
• A new plugins key is now used instead of branding (reverted to boolean);
• Added the reSave parameter to mark saving of the repeated changes;
• Added the info/json handler for license;
• Added the /info page (available only from localhost).

Packages

• The package version is now used to disable cache prefix;
• The package version in server URLs are now used instead of date;
• The custom port setup is added to the example URL in IIS;
• The configs in local.json have been redesigned;
• Added the support of logrotate;
• Added the libcurl3-gnutls dependency for the DEB package;
• The license has been updated.

Plugins

• Added the display of a message when an error has occurred (in ClipArt).

Docker installation

• Node.js has been updated to version 8;
• Added output logs to console and correct support of docker logs;
• The interactive flag to start container is no longer required.

Document Builder

• Added the following API functions: GetRows, GetCols, GetCount, GetHidden, SetHidden, GetColumnWidth, SetColumnWidth, GetRowHeight, SetRowHeight, GetWpar, SetOffset, GetAdress, SetLeftMargin, GetLeftMargin, SetRightMargin, GetRightMargin, SetTopMargin, GetTopMargin, SetBottomMargin, GetBottomMargin, SetPageOrientation, GetPageOrientation, GetSelection;
• Added the following API properties: Rows, Cols, Count, Hidden, ColumnWidth, Width, RowHeight, Height, MergeArea, WrapText, LeftMargin, Orientation, PrintHeadings, PrintGridlines, Selection.

Fixes

All editors

• Fixed the issue when comments from other users were missing (bug #37570);
• Fixed the issues which occurred when opening some files received from users.

Document Editor

• Disabled bookmarks in the document headers (bug #38957);
• Fixed XML parsing error in Firefox (bug #36960).

Spreadsheet Editor

• Fixed the issue which occurred when the active cell in selection across merge was merged;
• Fixed the issue with the selection which occurred when selecting a row/column/all;
• The options for hiding headings, gridlines, freeze panes are hidden in the viewer (bug #38033).

Server

• Fixed the maximum file size for conversion value (bug #37559);
• Fixed the installation on any linux system by using useradd (server issue #89);
• Fixed the fillForms mode;
• Fixed the healthcheck service behavior in case of disconnected Redis or RabbitMQ;
• Now the authorization header is not reduced if the inBody option is used;
• Improved the average calculation at server start;
• The SVG image file format pasting is now not allowed.

Packages

• Updated the innodependencyinstaller to fix the requirements detection.

Plugins

• Fixed the issue with ClipArt being of zero size;
• Fixed the error which occurred when adding macros (bug #38408).

Document Server integration examples

• Fixed the issues which occurred when several files were added at once (bug #37017);
• Fixed the issues with uploading big files;
• Fixed the comment mode available for Spreadsheet Editor only;
• Java example: fixed the encoding space and path problems;
• PHP example: fixed a lot of problems with URLs.

x2t

• Fixed the issues which occurred when opening some files received from users.

New features

Backend

• Added the logging and warning for the errors concerning license connections and user limit, as well as the appropriate settings to the configuration file.

Fixes

All editors

• Updated the interface translations to all the main languages available in the editors;
• Fixed the JavaScript error which occurred when the autoshape connector was changed (bug #37788);
• Fixed the error which occurred when the default tab in a shape was changed (bug #38084);
• Fixed the issues with opening a custom color for shapes (bug #37841).

Spreadsheet Editor

• Fixed the issues with comment deleting (bug #37772);
• Fixed the issues with opening XLSX files received from users (bug #38113);
• Fixed the hyphen position for Сhinese symbols with wrapping;
• Fixed the missing translation for the functions into French and Spanish;
• Fixed the missing region formats;
• Disabled the table settings when the cell is edited.

Presentation Editor

• Fixed the issue with copying and pasting the text into the 'Slide Title' placeholder in Fast co-editing mode (bug #37922);
• Fixed the bug with copying and pasting a slide containing a picture (bug #37928);
• Fixed the issue with placeholder titles in Chinese (bug #37927) (onlyoffice-owncloud issue #189).

Mobile web editors

• Fixed the browser hangup which occurred when shapes were added (bug #37601);
• Fixed the JavaScript error which occurred in specific XLSX files (bug #37824) (Document Server issue #311);
• Fixed the incorrect caption used for the document loading (bug #37687);
• Fixed the issue with document closing which occurred when the 'Back' button was tapped (bug #37649);
• Fixed the placement of the Settings icon (bug #37738).

PDF viewer

• Fixed the browser hangup occurring on some specific PDF files (bug #37466).

Docker installation

• Fixed the issue with the recursive GZIP appearing on the container restart (Document Server issue #317).

Conversion services

• Fixed the issue with opening some XPS files (bug #37565);
• Fixed the issue with clipping of a shape in header/footer (bug #36423);
• Fixed the bug with calculating an inverse matrix in PDF.

x2t

• Fixed the position of shapes in XLS (Document Server issue #308);
• Fixed the issue with the comments being lost after reopening an XLSX file (bug #37892) (Document Server issue #316);
• Fixed the issue with opening a file with an unknown image format.

ODF

• Fixed table width in ODT format files (bug #37832);
• Fixed the issues which occurred when opening some files received from users.

RTF

• Fixed the issues with reading comments in RTF format files;
• Fixed the bug with opening a file containing image in a shape (bug #37902);
• Fixed the issue with plugin data not being saved (bug #34747);
• Fixed the issues which occurred when opening some files received from users.

XLS

• Fixed problems with files containing combo charts (bug #37945, #37946);
• Fixed the issues which occurred when opening some files received from users.

New features

All editors

• Added a warning when opening a file protected with password;
• The resolved comments are now not shown by default in Document Editor and Spreadsheet Editor.

Backend

• Added the openProtectedFile option to disable opening password-protected files.

DEB and RPM

• Removed the upper version dependency for Node.js;
• Removed the librabbitmq-tools dependency.

x2t

• Updated the compatibilityMode setting now preventing opening the files in MS Word 2016 compatibility mode;
• Added the long file name support for MS Windows.

Fixes

All editors

• Updated the interface translations to all the main languages available in the editors;
• Fixed the z-index value for tooltip synchronization;
• Fixed the position for the zoom buttons in the toolbar;
• Fixed the File tab which had lost active state when the inner panels had been clicked;
• Fixed the Replace image by URL context menu option (bug #37651);
• Fixed the possibility to copy the comments from the comment balloon (bug #37666, #35896);
• Fixed the footnote dialog layout (bug #37660);
• Fixed the layout for the changes review dialog.

Document Editor

• Fixed getting the parent cell in blocklevelstd;
• Fixed the chinese text justification (bug #37659, Document Server issue #293);
• Fixed the problem with the navigation sidebar focus in Firefox (bug #37460);
• Fixed the setting for the Real-time collaboration changes option when View All is selected;
• Fixed the window layout issue with a protected document (bug #37658).

Spreadsheet Editor

• Fixed the issue with entering the functions with the arrow keys and scrolling;
• Fixed the multiselect autofit column width, now autofit will affect existing columns only (bug #37555);
• Fixed the function dependency and file generation after copying with drag and drop;
• Fixed the Out of memory error when inserting rows to the file with many columns;
• Fixed the error occurring for chart with an empty dataset (bug #37762).

Presentation Editor

• Fixed the issue with deleting the placholder text in strict co-editing mode (bug #37712);
• Fixed the issue with the comment duplication in exported PPTX (bug #37698);
• Fixed the JavaScript error occurring when opening an empty presentation in the comment mode (bug #37679).

Mobile web editors

• Disabled the edit button during the document load;
• Fixed the function descriptions (bug #37691);
• Fixed the round corners for modal windows (bug #37700).

Backend

• Removed the payload field from JWT when the inBody option is on;
• Performed the refactoring for the install/uninstall shared libraries.

DEB

• Fixed the DS_COUNT: command not found uninstall error;
• Fixed the uninstallation error with the documentserver-prepare4shutdown.sh script;
• Fixed the libcurl dependency for Ubuntu 18.04.

x2t

• Fixed the issues which occurred when opening some DOC, RTF and XLS files received from users;
• Fixed the export of the current list from XLSX to CSV (bug #37579);
• Fixed the issues which occurred when opening specific PPTX files (bug #37589);
• Fixed the issues which occurred when opening specific RTF files (bug #37500);
• Fixed the issue with saving comments for presentation;
• Fixed the issues with slide themes when exporting to ODT (bug #37740);
• Fixed the issues with chart legend in ODS files (bug #37746);
• Downgraded the ICU dependency version to 5.8.2 (which is compatible with MS Windows XP and Windows Vista).

New features

All editors

• Added the new View Settings menu option at the top right corner of the editor window;
• Added the possibility to replace the image via context menu (bug #11493);
• Added the possibility to customize the initial zoom for the embedded editors.

Document Editor

• Implemented the East Asian script and line break in hieroglyphs support (sdkjs issue #300);
• Added the Ctrl+Shift+Num8 hotkey to show/hide nonprinting characters;
• Added the possibility to export documents to the RTF format.

Spreadsheet Editor

• Added the translation of functions into French;
• Added the possibility to select the cell format via context menu (bug #16272);
• Added the new selector for link type.

Presentation Editor

• Added hints for presentation themes (bug #21362);
• Added the new selector for link type.

Document Builder

• Added the GetColumnWidth method which allows to get the width of the current column (sdkjs issue #315).

Backend

• Updated the ICU dependency version from 5.5 to 6.0.

Mobile web editors

• Added the possibility to switch to the editing mode from toolbar (web-apps issue #135).

Integration example

• Added the support for OTT, OTS and OTP formats.

Fixes

All editors

• Improved the compatibility with Microsoft Internet Explorer 11 (sdkjs issue #302 and sdkjs issue #317);
• Fixed the bug with downloading some DOCX files (bug #37454) (sdkjs issue #300);
• Fixed the crash on opening the files with empty pie charts (sdkjs issue #318).

Document Editor

• Fixed the issue with the table display after HTML conversion (bug #37472);
• Fixed the bug which occurred when a comment was added to the whole document (bug #37425, Document Server issue #287, sdkjs issue #319);
• Fixed the issue with copying the Rich Text Content from a table (bug #37546) (sdkjs issue #320).

Spreadsheet Editor

• Fixed the issues with the function dependencies and file assembly after adding a column or row (sdkjs issue #312);
• Fixed the issues with opening some XSLX files (bug #37515) (sdkjs issue #316).

Mobile Document Editor

• Fixed the issues with replacing the text which occurred when a new paragraph was created (bug #37456).

Mobile Spreadsheet Editor

• Fixed the bug with scrolling;

x2t

• Fixed the issues which occurred in some user files containing tables (core issue #71);
• Fixed the issues with opening DOCX, PPTX, RTF, and ODF files received from users (core issue #75 and core issue #76).

New features

Document Editor

• Added the support of multiple comments display in the comment balloon (bug #37422).

Documentation

• Updated the documentation articles describing the 5.1 version new features.

Fixes

All editors

• Fixed the crash occurring when a document was loaded in Safari 11.1;
• Fixed the undo error occurring after copy/paste in co-editing (bug #37424);
• Fix problems with some Thai symbols (bug #37446) (sdkjs issue #297).

Document Editor

• Replaced the content control GetTag method used with the GetLabel one (sdkjs issue #296);
• Fixed the crash occurring when PDF file is reconnected or checked if idle (sdkjs issue #291);
• Fixed the issue with searching the text in drawings (sdkjs issue #292);
• Fixed the problem with loading a PDF file which has been renamed to DOCX (sdkjs issue #295).

Spreadsheet Editor

• Fixed the copy/paste error occurring in the open source version menu (bug #37426);
• Fixed the translations for functions into Spanish;
• Fixed the issue with opening the pivot tables which contain VALUES (sdkjs issue #298).

Presentation Editor

• Fixed the issues with the reporter mode in Safari.

Backend

• Fixed the problem which led to the file corruption caused by the restored connection when the file version is assembled (server issue #80).

x2t

• Fixed the Mac OS related build problems;
• Fixed the shape geometry occurring in PPT files from the latest MS Office versions.

New features

All editors

• Updated the interface translations to all the main languages available in Document Server.

Spreadsheet Editor

• Added the CONVERT, FTEST, HYPGEOM.DIST functions;
• Added the translation of functions and their descriptions into Spanish.

Backend

• Added the reconnection.attempts and reconnection.delay options to the configuration file; these options are applicable for the editor-server connection;
• Added the fonts folder to the static content;
• Added the sockjs config section for testing purposes.

Documentation

• New documentation articles describing the 5.1 version new features.

Fixes

All editors

• The fonts with the zero width of the glyphs are now hidden from the font picker;
• The changes for undo/redo are not saved in server build mode;
• Changed the size of the images pasted from HTML;
• Fixed the problem with the text selection when using the Shift key;
• Fixed the redundant symbol appearing in cells after undo-redo operation (bug #37343);
• Fixed the error with the repeated reconnection;
• Fixed the problems with the icons of some buttons;
• Fixed the synchronization of the co-editing mode between the top toolbar button and the menu (bug #37377).

Document Editor

• Fixed the right-mouse button menu for the table of contents (bug #37241);
• The images in Text Art objects are not clipped;
• Added the vertical clip for drawing the inline objects;
• Fixed the problems with drawing the inline objects;
• Fixed the bug with wrong calculation of the text clip rectangle;
• Fixed the issue when the B8a property with the null value could not be read in some files (bug #37378);

Spreadsheet Editor

• Fixed the right mouse button error (bug #37330);
• Fixed the issue occurring when hieroglyphs from the text editor were inserted (bug #37356);
• Fixed the bug occurring when autocomplete did not work for functions if the point character is present in function name (bug #37300);
• Fixed the bug occurring when autocomplete did not work for functions if the _ or \ character are used in the named range (bug #37354);
• Fixed the bug occurring when autocomplete did not work for functions if Chinese numbers were used;
• Fixed the Cannot read property 'toLocaleString' error in some files (bug #37343);
• Fixed the Cannot read property '4' error in some files (bug #37376);
• Fixed the issues with sheet context menu visibility (bug #37307);
• Fixed the translations for functions;
• Fixed the problems with inserting the function into the cell which is opened for editing (bug #37348).

Presentation Editor

• Fixed the problem with hieroglyphs in chart title (bug #37293);
• Fixed the chart title focusing problem during co-editing (bug #37295);
• Fixed the object selection problem during co-editing (bug #37336);
• Removed the console.log for End_CollaborationEditing;
• Fixed the bug with clearing the cached canvas;
• Fixed the bug with calculation of slide layout bounds;
• Fixed the Cannot read property 'Ec' of null error in some files (bug #37386).

Backend

• Fixed the font generation;
• Fixed the inconsistent database status after the files assemble and the open/close connection is too fast.

x2t

• Fixed the issue which occurred when reopening files containing macros (bug #37323);
• Fixed the issues which occurred when opening some DOCX and XLS files received from users.

Desktop Editors

• Fixed the bug with the gradient;
• Fixed the issue with printing the cell borders (bug #35367).

New features

All editors

• Added the new no-squares font engine, which finds the best replacement font for the □ characters;
• Added the possibility to distribute the data in tables;
• Added the new fonts to the default font set;
• Completely rewritten the composite input for characters;
• Added the new header and background color;
• Added the support of shape side panel for images;
• Added the support for changing the table size using drag'n'drop;
• Added the new bullet list marker: –;
• Rewritten the connection of the second user to document in the Strict mode;
• Increased the document supported size (without media content);
• Added Korean and Latvian as interface languages.

Document Editor

• Added the support for the Table of Contents;
• Added the possibility to set the Tab leading symbols;
• Added the new Navigation left sidebar item;
• Added the new References tab;
• Renamed the Review tab to Collaboration;
• Renamed the Display Modes entries for Track Changes option;
• Fixed the issue when version history could not be saved if the second user joined the co-editing in the Strict mode; now it is saved if the first user has autosaving disabled;
• Changed the behavior of the Go to documents option, it now opens a new tab;
• Added the possibility to set negative values for the top and bottom page margins;
• Copying the paragraph style will not overwrite the custom set style;
• Added the special paste of tables.

Spreadsheet Editor

• Custom user cell styles are now placed before the default ones;
• Added the new functions: F.TEST, FORECAST.ETS, FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, FORMULATEXT, IFS, PDURATION;
• Added the new None table template;
• Added the new editing tools for the pivot tables;
• Added the new regional presets: Deutsch (Schweiz), Español (México), Nederlands (Nederland), Slovenčina (Slovenská republika);
• Added the new date formats: yy/m/d, yy/mm/dd, yyyy/m/d;
• Added the preview for the CSV files before opening them.

Presentation Editor

• Added the special paste;
• Added the presentation level comments.

Plugins

• Added the Macros plugin;
• Fixed the plugin autostart problem.

x2t

• Added the support for a lot of features for XLS format (macros, controls, etc.);
• 5-10% speedup of opening OOXML files;
• Better compatibility with OpenFormat and RTF;
• Fixed a lot of bugs in the files in all supported formats received from the users.

Document Builder

• Added the Format, GetSheet, GetSheets methods for the Api class;
• Added the ForEach, GetValue methods for the ApiRange class;
• Added the GetCells, GetIndex, GetName, GetRowHeight, GetUsedRange, GetVisible, SetVisible methods for the ApiWorksheet class.

Documentation

• Added the translation of the documentation for Document Editor and Presentation Editor into French, Spanish, German, for Spreadsheet Editor into French;
• Added search in the documentation pages.

Fixes

All editors

• Fixed a lot of bugs;
• Fixed the toolbar icons problems;
• Fixed the editing issues occurring when connecting a document with numerous changes.

New features

Licensing

• Added the new license type: licensing by the unique user IDs and access period.

Document Builder

• Added a lot of getters and setters to the methods for the Spreadsheet Editor;
• Added the new AddSheet method.

Spreadsheet Editor

• Added strikeout, superscript and subscript options to the top toolbar (bug #26581).

Documentation

• Added the documentation about the program interface.

Fixes

All editors

• Updated the translations into main editor languages;
• Set focus out of the editor frame in MS Internet Explorer/Edge browsers.

Document Editor

• Fixed the issue with opening DOCX file containing formula in MS Word (bug #36490);
• Fixed the JavaScript error which occurred while inserting a spreadsheet cell with comment (bug #36506);
• Fixed the bug with inserting the content control into a math equation;
• Fixed the selection from object in header/footer not being reset after keyboard move.

Spreadsheet Editor

• Fixed the wrong dependence in some functions with references to other sheets which occurred after a sheet was removed;
• Fixed the issue with opening an ODT file containing a chart;
• Fixed the issue with calculating a sparkline in some cases (bug #36603);
• Fixed the issue with printing an image outside of the printing range (bug #36573).

Presentation Editor

• Fixed the issue with blocking the shape for the users co-editing in different modes (bug #36435);
• Fixed the issue with the Constant proportions chart button working only once (bug #36494);
• Fixed the JavaScript error which occurred while inserting a page number from Document Editor (bug #36508);
• Fixed the JavaScript error which occurred while undoing a table (bug #36515).

Backend

• Fixed the IIS URL Rewrite issue which occurred when uploading an image;
• Fixed the issue with the TTF fonts not being gzipped.

Integration example

• Removed the Integration Edition caption from the logo.

x2t

• Fixed the issues with some DOCX, DOC, RTF files from the users;
• Fixed the issues with MathType equations in some DOCX files (bug #36524).

New features

Licensing

• Added the new license type: licensing by the number of unique users.

Fixes

Document Editor

• Fixed the JavaScript error which occurred when inserting an empty cell to the chart title (bug #36441);
• Temporarily removed the non-actual Rich Text Content control documentation files;
• Fixed the bug with the ClipArt plugin window not hiding if version history is opened (bug #36464).

Backend

• Reduced the long outgoing authorization request headers (bug #36202).

Windows version

• Fixed enabling the JWT in Document Server example.

New features

Desktop editors

• Added two types of restrictions for the document editing - OnlySignatures and View.

Fixes

All editors

• Fixed the red cross issue with the images in some situations.

Spreadsheet Editor

• Fixed the a.Se is not a function error while opening some files (bug #36344);
• Fixed the error with merged table colors;
• Fixed the cell merging after a table template is applied (bug #36405).

Presentation Editor

• Fixed the issue with the button layout in the reporter mode;
• Disabled the scroll to target function in selectwheel (when the selection is empty);
• Fixed applying the image as a background for several slides (bug #36399);
• Fixed the mouse slide scroll without the zoom change (bug #28096).

Plugins

• Fixed calling the plugins in the non-tabbed interface (Docker-Document Server issue #84);
• Fixed crashes when resizing an unknown OLE object;
• Added the progress bar the the Yandex.Translate plugin.

x2t

• Fixed the colors schemes for table cells (bug #36322);
• Fixed the problem with the images in footnote (bug #36380).

Backend

• Fixed the connection calculation so that the users viewing the document were exclueded from the total connection number value.

DEB

• Fixed the Node.js dependency (forced Node.js 6 LTS).

Document Builder

• Reduced the service key size to 20 characters;
• Changed HTTP error code from 403 to 402 in case of incorrect license.

Fixes

All editors

• Refactoring: removed some unused code;
• Fixed the Polish language bug (AltGr + X/AltGr + C when using Mozilla Firefox/MS Edge);
• Fixed the bug with image paths.

Document Editor

• Fixed the bug with removing and adding items from the listview;
• Fixed the bug with the synchronization of data from several dialog windows;
• Fixed the line ending in thumbnails;
• Fixed the issues with pasting the simple text to equations;
• Fixed the issue with opening the version history.

Spreadsheet Editor

• Fixed the JavaScript error for some pivot table styles (bug #36290);
• Checked the xfIndexNumber when merging styles to avoid the errors with column styles;
• Fixed the conditional formatting while changing cell values (bug #36253).

Presentation Editor

• Fixed disabling the Previous/Next buttons during the slide demonstration;
• Fixed the presentation demonstration issue appearing when starting from the beginning;
• Fixed the issue with scrolling the notes;
• Fixed the text insert operation duration (bug #36208);
• Fixed the browser zoom problem with the pointer.

Backend

• Fixed the issue with the conversion task being lost when entering and leaving the editor quickly (endless opening);
• Fixed the timeout error appearing when the first user does not perform saving.

New features

Distribution

• Renamed the onlyoffice-documentserver-integration distribution package to onlyoffice-documentserver-ie;
• Added the new distribution package for developers: onlyoffice-documentserver-de.

All editors

• Updated the messages about the version limitations;
• Added Sogou Pinyin input in Google Chrome;
• Added the support for FODS, FODT, FODP formats.

Plugins

• Added the new plugin scheme (system & parallel work).

Windows version

• Added the Accept license dialog window to the installation.

Fixes

All editors

• Fixed the button outlines in Mozilla Firefox;
• Fixed the Developer Mode caption rotation in Microsoft IE11 (bug #36076).

Document Editor

• Fixed the JS error occurring when the Text Art was added using the Enter button (bug #36134);
• Fixed the cursor issues with object rotation (bug #36114).

Presentation Editor

• Fixed the reporter mode resizing in Microsoft IE;
• Fixed the bug with positioning the hyperlink and slide number tooltips;
• Fixed the slide resizing bug;
• Fixed the issue with the text search in a placeholder (bug #36133);
• Fixed the layout problem in the reporter mode;
• Fixed the JavaScript error in Tables_test.pptx file (bug #17147).

Embedded viewer

• Fixed the Error code -23 issue (bug #36122).

Backend

• Fixed the error when the view mode was determined without taking into consideration the permissions.comment settings.

RPM

• Fixed the SELinux usage with custom ports.

Plugins

• Fixed the bug with the resize cursor in the plugin window;
• Fixed the JavaScript error which occurred when running the PhotoEditor (bug #36050);
• Fixed the problems with scrolling.

New feature

Backend

• Added the Document Builder service.

Plugins

• Added the possibility to automatically start the plugins.

Fixes

All editors

• Updated the interface translations.

Document Editor

• Fixed the issue with sending the mail in the mail merge (bug #36007).

Spreadsheet Editor

• Fixed the issue with loading the table styles.

Presentation Editor

• Fixed the bugs in the Reporter mode;
• Fixed the issue which occurred when the slide was moved (bug #36031).

New feature

Integration example

• Added support for the OpenDocument Flat Document file type.

Fixes

All editors

• Updated the translations and help files;
• Fixed the rebranding logo (bug #35860);
• Fixed the click on the logo;
• Fixed the text input after copying the comment (bug #35851).

Spreadsheet Editor

• Fixed the following hotkey issues: Ctrl+L (bug #35854), Alt+H (Firefox problem - bug #35857), Ctrl+= (Firefox problem - bug #35853);
• Fixed the issue with recalculating the absolute formulas (bug #28388);
• Fixed the issue with replacing the text in pivot tables (bug #35858);
• Fixed the issue with incorrect characters after copy-paste within a shape (bug #35913);
• Fixed the issue with sorting in some XLSX files (bug #35904);
• Fixed the issue with sorting the table header (bug #35950).

Presentation Editor

• Fixed the controls in the slide preview mode (bug #35440);
• Fixed the bugs with copying the notes;
• Fixed the connector connection problem (bug #35867);
• Fixed the connector problem with copy-paste operations (bug #35024).

Plugins

• Fixed the issue with opening the Character Table (bug #35875);
• Fixed the problem with hotkeys in the Character Table (bug #35890).

Conversion

• Fixed the issue with saving changes in HTML files.

RPM

• Fixed the problem while working with SELinux enabled.

Windows

• Migration to 64-bit Node.js.

New features

Spreadsheet Editor

• Added the support for opening pivot tables;
• Added the support for 69 new functions: AGGREGATE, BESSELI, BESSELJ, BESSELK, BESSELY, BINOM.DIST.RANGE, BITAND, BITLSHIFT, BITRSHIFT, BITOR, BITXOR, CHITEST, CHISQ.TEST, COVARIANCE.P, COVARIANCE.S, DAVERAGE, DAYS, DCOUNT, DCOUNTA, DGET, DMAX, DPRODUCT, DSTDEV, DSUM, DVAR, ECMA.CEILING, ERFC.PRECISE, FORECAST.LINEAR, ISFORMULA, ISOWEEKNUM, MAXIFS, MINIFS, MINIFS, MODE.MULT, MODE.SNGL, NEGBINOM.DIST, NETWORKDAYS.INTL, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, QUARTILE.INC, QUARTILE.EXC, PERMUTATIONA, POISSON.DIST, PHI, RRI, SKEW.P, SHEET, SHEETS, STDEV.P, STDEV.S, SWITCH, T.TEST, TEXTJOIN, TRIMMEAN, TTEST, UNICODE, VAR.P, VAR.S, WEIBULL, WEIBULL.DIST, WORKDAY.INTL, Z.TEST, ZTEST.

Presentation Editor

• Added the ability to add, open and save presentation notes;
• Added the support for opening and saving the videos.

Back-end

• Database optimization, faster opening of large files;
• Added the ability to rebuild not built, forgotten files.

x2t

• Added the support for reading of OOXML and XLS files containing macros;
• Added the support for audio and video files to all the document formats;
• Added the support for pivot tables to XLS format files.

Fixes

Document Editor

• Fixed a large number of various bugs.

Spreadsheet Viewer

• Fixed the issue with the keys not working in IE11 (Document Server issue #107);
• Fixed the issue when the COUNTIF function ignored TRUE and FALSE parameter (Document Server issue #151);
• Fixed the conditional formatting bugs.

x2t

• Fixed a lot of bugs based on user sent files;
• Fixed functions for ODS format files.

Windows-only release

Fixes

• Fixed the log folder creation in silent and verysilent setup mode.

Fixes

Document Editor

• Fixed issues with opening some DOCX files (bug #35307);
• Fixed the issue with the chart legend being blocked during co-editing (bug #35492).

Spreadsheet Editor

• Fixed the issue with the shape size not changing with the help of yellow markers (bug #35451);
• Fixed the VLOOKUP and HLOOKUP functions being case sensitive (bug #35528, Document Server issue #140).

Presentation Editor

• Fixed the comment bug (bug #35408);
• Fixed the bug with drag-and-dropping the chart into a title.

New features

Spreadsheet Editor

• Added support for more new options in sparklines (bug #35296).

Fixes

Document Editor

• Fixed issues when the tab was set several times (bug #34923);
• Fixed printing in Microsoft Edge (bug #35323);
• Fixed the documentation on moving the shape by a pixel (bug #34983);
• Fixed the special paste in fast co-editing mode (bug #35310);
• Fixed issues with duplicates in strict co-editing mode after the special paste (bug #35312);
• Fixed bug with moving the cursor to the beginning of the document after removing the content control;
• Fixed minor problems with co-editing in real time (bugs #35398, #35399, #35400);
• A lot of fixes in the existing translations (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Spreadsheet Editor

• Fixed the Show empty cells as box in Russian (bug #35299);
• Fixed the sparkline type in the settings window (bug #35296);
• Hid the functions which have not yet been implemented: CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE (bug #35314);
• Fixed the JavaScript error in the conditional formatting with the function and offset (duplicate variable) (bug #35334);
• Fixed the JavaScript error in SEARCH function (bug #35340);
• Fixed the freeze pane shadow which had not been hiding (bug #35359);
• Fixed showing the hidden objects;
• Fixed the VLOOKUP cell format;
• A lot of fixes in the existing translations (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Presentation Editor

• Fixed changing the presentation language if no shape was selected (bug #35231);
• Fixed the columns in the placeholder (bug #35074);
• Fixed the connector losing shape when moving shapes in a group (bug #35317);
• Fixed disconnecting the connector after ungrouping (bug #35316);
• Fixed the hidden markers for the connector on a chart and an image (bug #35300);
• Fixed the cell link reference issue after the copy-paste operation (bug #35362, Document Server issue #122);
• A lot of fixes in the existing translations (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Mobile Document Editor

• Removed saving for the show snap lines option.

Mobile Presentation Editor

• Removed saving for the show snap lines option.

x2t

ODT

• Fixed saving some files to ODT (bug #35389).

TXT

• Fixed the empty TXT on opening (bug #35396).

XLS

• Fixed the custom shape for the connectors.

ODS

• Fixed the issue with margins;
• Fixed the converted named range with the formulas.

PPTX

• Fixed the audio WAV files;
• Fixed the old OLE standard.

PPT

• Fixed the previous user pictures;
• Fixed the picture read stream.

Document Builder

• Fixed the problems with printing and saving to PDF.

New features

Document Editor

• Added the Special Paste feature;
• Added the rich text content support;
• Added translations for the paragraph styles;
• Added the comments display in the view mode;
• Added the option to hide the resolved comments;
• Added the option to specify custom columns.

Spreadsheet Editor

• Added the support for the functions with conditional formatting;
• Added the possibility to specify a custom delimiter for the CSV file import/export;
• Added support for the ACOT, ACOTH, ARABIC, BASE, BETA.DIST, BETA.INV, BETADIST, BINOM.DIST, BINOM.INV, CEILING.MATH, CEILING.PRECISE, CHIDIST, CHIINV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, COMBINA, CONCAT, CONFIDENCE.NORM, CONFIDENCE.T, COT, COTH, CSC, CSCH, DECIMAL, EXPON.DIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, FDIST, FINV, FLOOR.MATH, FLOOR.PRECISE, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN.PRECISE, GAMMADIST, GAMMAINV, GAUSS, IFNA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, ISO.CEILING, LOGNORM.DIST, LOGNORM.INV, NUMBERVALUE, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, RANK, RANK.AVG, RANK.EQ, SEC, SECH, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, TDIST, TINV, XOR functions;
• The hidden rows are now excluded from copying, autofilling, formatting etc.;
• Updated the active cell color;
• Changed the frozen pane display: now it has shadow;
• Added translations for the cell styles;
• Added the possibility to search and replace using the data from the selection;
• Added the option to hide the resolved comments;
• Added the possibitity to specify bullets and numbering for the text within a shape;
• Added the possibility to specify columns for the text areas;
• Added the possibility to add the connectors for the shapes;
• Added the support for Shift+Delete, Ctrl+Insert and Shift+Insert keyboard shortcuts for cut/paste operations.

Presentation Editor

• Added the possibility to connect shapes using the lines;
• Added the possibility to specify columns for the text areas;
• Added the possibitity to specify bullets and numbering for the text within a shape;
• Added the spellchecker;
• Added the possibitity to download the file as ODP.

Plugins

• Added the new plugin window type (without borders, shadows, buttons).

x2t

• Dramatically increased the speed for opening the OOXML files: 200% faster in Windows, 20% faster in Linux;
• Enhanced the conversion from/to RTF format;
• Enhanced support for password protected OOXML and binary Microsoft files (DOC, XLS);
• Added support for password protected PPT files.

Fixes

Spreadsheet Editor

• Fixed duplicate text appearing after the carriage return (Document Server issue #109).

Fixes

Rebranding

• Fixed the problems with the white-label logos.

New features

Document Editor

• Added the showReviewChanges option to the configuration, which automatically opens the review changes panel.

Fixes

Document Editor

• Disabled the version history for PDF, DJVU and XPS files;
• Fixed the problem with DropCap fonts.

Spreadsheet Editor

• Limited the number of cell styles to 1000 (bug #113);
• Fixed adding spacing when copying data from MS Excel;
• Fixed the chart axis position.

Back-end

• Fixed crash on Windows Server 2008 R2.

Fixes

All editors

• Fixed the opening error when the SDK loads before the fonts;
• Fixed the error of the shape display without the gradient angle (bug #34887);
• Editors now show correct limited functionality notification for IE 9 and IE 10.

Back-end

• Fixed the error with user data from JWT usage;
• Added logs for the spellchecker checkHealth.

New features

Document Editor

• Added the Kazakh language for the spellchecker.

Docker installation

• Added the possibility to use PostgreSQL storage as a volume.

Fixes

Document Editor

• Fixed the aligning of the Footnotes setting in Firefox (bug #34840);
• Fixed the colors for shapes (bug #34785);
• Fixed the problem with the shapes inside a table.

New features

Plugins

• New plugins: Photo Editor and Document Templates.

Fixes

All editors

• Minor updates to the existing translations;
• Fixed the Plugins icon at the @2x resolution (bug #34681).

Document Editor

• Fixed moving the image to another page header (bug #34637);
• Fixed removing a shape if undo of grouping operation is performed (bug #34654).

Spreadsheet Editor

• Fixed the decreasing size of a 3D chart (bug #34685);
• Fixed the problem which appeared when a formula was pasted;
• Fixed the tooltip position at the @2x resolution (bug #34678);
• Fixed the problem with shrink to fit (bug #34758).

Presentation Editor

• Fixed the problem appearing when a comment was removed (bug #34773).

Mobile web editors

• Fixed the problem with opening the viewer in the open source version.

Back-end

• Fixed the infinite loop with URI.parse (bug #34716);
• Fixed the connection leak on healthCheck.

DOCX

• Fixed the issue with the DOCX file damaged when a chart was copied inside a shape (bug #34695).

document-server-integration

• Fixed the problem with the Go Back button.

Windows installation

• Fixed the problem with downloading the binaries from SourceForge.

Fixes

Spreadsheet Editor

• Fixed the error when the files got broken if you tried to change the style of an unsupported chart (bug #34650);
• Fixed the stack error while copying a big array of formula data;
• Fixed the error of rendering a 3D diagram in a small area (bug #34632);
• Fixed the error when chart range was changed while applying a preset.

New features

All editors

• Added full support of high-DPI monitors;
• Added the possibility to set alternative text for shapes.

Document Editor

• Added the undo option for the Fast co-editing mode;
• Added the All changes saved caption in the bottom toolbar;
• Added an option to add and edit footnotes;
• Added new languages for spellchecker (43 in total).

Spreadsheet Editor

• Added support for the AVERAGEIFS, COUNTIFS, SUMIFS functions;
• Refactoring and improvements for formulas;
• Added a totally new Cell Format window with more options;
• Added the possibility to use sort options window while sorting ranges;
• Added the sorting direction for the filter buttons;
• Added the filter condition at statistical information;
• Added the special paste feature;
• Added the support for the surface chart;
• Added the new cell border styles (11 in total).

Presentation Editor

• Added the undo option for the Fast co-editing mode.

Mobile web editors

• Completely new mobile web editors.

Back-end

• Added the possibility to run documentserver on a custom port;
• Added the possibility to check for and drop idle users;
• Added the possibility to perform forced save (by timeout and using the button).

x2t

• Optimization and speed-up;
• Better support for all formats, including (but not limited to) the ones listed below:

  DOC

  • Support for the page backgrounds.

  XLS

  • Support for data validation;
  • Support for decryption.

  ODF

  • Support for global document settings;
  • SVG refactoring;
  • Support for the page backgrounds (image, pattern, gradient);
  • Support for the smart art conversion;
  • Support for sheet/workbook views;
  • Support OLE and other embedded objects conversion.

  RTF

  • Added hyperlink text replacement generation if it is absent;
  • Added support for office digital signatures;
  • Added extended drawings;
  • Added custom shapes;
  • Added support for the text when drawing shapes.

Plugins

• A lot of new plugin features.

Fixes

Document Editor

• Fixed the issue with drag'n'dropping a table inside a footnote (bug #33548);
• Fixed the issue with cropping of shape group (bug #33110).

Spreadsheet Editor

• Fixed the issue with the absolute reference when inserting a new row (ONLYOFFICE/DocumentServer#41);
• Fixed the issue with the onDocumentStateChange event (ONLYOFFICE/DocumentServer#88);
• Fixed the issue with the formula translations (ONLYOFFICE/DesktopEditors#23);
• Fixed the issue with the password-protected XLSX (ONLYOFFICE/DesktopEditors#24);
• Fixed the issue with a non-breaking space (ONLYOFFICE/DesktopEditors#26);
• Fixed the issue with the AVERAGEA function which has text format;
• Fixed the issue with the broken workbook after copying the list (bug #33588);
• Fixed the issue with the formula recalculation by F4 hotkey (bug #32901);
• Fixed the issue with SUMIFS function (bug #33602);
• Fixed the issue with the image size when inserting (bug #33604);
• Fixed the issue with the sparkline zero values (bug #33612);
• Fixed the issue with changing the number format when changing the regional format (bug #31395);
• Fixed the issue with replacing the formula delimiters (bug #33608);
• Fixed the issue with cell size while drag'n'dropping (bug #33607);
• Fixed the issue with the cursor size in @2x resolution (bug #33606);
• Many other minor and major bugfixes.

New features

Editors

• Added the possibility to completely hide About and the left toolbar (available to the licensed users only).

Fixes

Back-end

• Fixed the issue when the JWT token without the permissions field crashes downloadAs.

Fixes

Embedded viewers

• Fixed the default top position for the toolbar.

Licensing

• Fixed the availability of the chat and comments buttons for the editors without the license file.

Back-end

• Fixed the problem with JWT access tokens.

New Features

Spreadsheet Editor

• The Polish language translations for functions.

Fixes

Spreadsheet Editor

• Fixed the wrong order of elements in equations (bug #34029).

Fixes

Spreadsheet Editor

• Fixed entering the characters with diacritical symbols (bug #33908)
• Fixed the horizontal scroll when using a trackpad (bug #27197)

Plugins

• Allowed the interface customization using the plugins.

Back-end

• Minor fixes for logging and status codes.

Fixes

All Editors

• Prevent editors from performing the save operation if there are no changes to save.

Spreadsheet Editor

• Fixed error occurring when assembling files with Ranges in some rare cases.

Document conversion

• Fixed errors occurring when converting from the XLSX to the CSV format.

Back-end

• Fixed server compilation if the PRODUCT_VERSION and BUILD_NUMBER variables are not defined.

Fixes

All Editors

• Fixed a rare problem occurring when saving a file with a specific chart type.

Presentation Editor

• Fixed a problem occurring when saving a file with the notes copied from Document Editor;
• Fixed a problem occurring when saving a file with a chart copied from Presentation Editor.

Back-end

• Fixed a problem occurring when opened connection was not closed with close command received while performing some asynchronous actions.

Fixes

Document Editor

• Fixed the problem with the changes missing when several users enter the text at the same time (bug #33726)
• Fixed the bug with the cursor positioning after the InsertContent function is used.

Spreadsheet Editor

• Fixed the Match formula return value in some cases (bug #33735).

Back-end

• Fixed the missing Asana-Math font in the default installation, needed for equations.

Fixes

Spreadsheet Editor

• Fixed the usage of functions with references to the other sheets.

Presentation Editor

• Fixed the timeout error appearing while printing some PPTX files.

Document conversion

• Fixed the problem with conversion to PDF format when only the first document page was converted.

Licensing

• Without a valid license file the chat and comment buttons are unavailable, as well as editing the customer information and the logo image at the editor header is not allowed.

Fixes

Presentation Editor

• Fixed the problem with opening password-protected presentations.

Fixes

Document Editor

• Fixed the broken Insert number of page button;
• Fixed the problem with the last hieroglyph duplicate;
• Fixed the problem with changing the chart type from 2D to 3D (bug #33284).

Spreadsheet Editor

• Fixed JavaScript error when adding a chart in IE and Edge (bug #33597);
• Fixed the problem with an empty cell when changing sparklines (bug #33598).

x2t

• Improved compatibility with the DOC format.

New Features

All Editors

• Added the possibility to set a dash type for shapes;
• Redesigned the embedded viewers;
• Better support of HiDPI systems;
• Update bootstrap to version 3.3.7.

Document Editor

• Added the possibility to set Fit to Page or Fit to Width as a default zoom value;
• Ability to insert number of pages into the document;
• Added the possibility to open and edit footnotes;
• Remade version history. Added the possibility to hide minor features.

Spreadsheet Editor

• Added the possibility to insert equations in Spreadsheet Editor;
• Added the possibility to open and edit sparklines;
• Added a new SUMIFS function;
• Added the possibility to select data from the drop-down menu in the context menu;
• Added a multiselection support;
• Added the rotation of 3D charts;
• Updated and improved the visual styles for all chart types;
• Brought back the Freeze Panes option in the View Settings menu;
• Added the new algorithm for calculating a cell height.

Presentation Editor

• Added the possibility to set Fit to Width as a default zoom value;
• Added the possibility to insert equations in Presentation Editor.

Back-end

• Updated Node.js from version 4.2.0 to the current LTS release: 6.9.1.

Fixes

Spreadsheet Editor

• Fixed Document Server issue #63.

x2t

• Fixed Document Server issue #55.

Fixes

License

• Minor fix for a better license compatibility with the Hide Menu functionality.

Fixes

Editors

• Fixed a JavaScript error when opening a document in IE 9 and IE 10.

New Features

Editors

• Added the possibility to hide the menu bars in the editors using the config.

Fixes

Editors

• Fixed copy-paste on MacOS Sierra.

Plugins

• Fixed the image load and OLE problems;
• Viewers do not show plugins any more.

Fixes

Back-end

• ipfilter can use dns to lookup.

New Features

Plugins

• Sample plugins are enabled by default.

New Features

Back-end

• Switched to using PostgreSQL instead of MySQL on back-end;
• Added the possibility to filter users using ipfilter.

Editors

• Added whole new code handling text input. Better support for languages which use hieroglyphs;
• Added whole new copy-paste which is better compatible with external sources.

Changes

• Improvements in opening of all supported formats.

Fixes

• A lot of small bugfixes in all product modules.

Changes

• Added the possibility to use full-toolbar mode in the editors with a standard license. Previously the users of standard license were forced to use compact toolbar only.

Fixes

Spreadsheet Editor

• Fixed losing comments on second and subsequent worksheets (bug #32895);
• Fixed losing empty values of data with format different from General in the autofilter (bug #32805).

document-server-integration

• Minor fixes.