Uninstall default plugins from the server editors

Version 6.3.1

Release date: 06/08/2021

New Features

Backend

Added the 'license' command to CommandService.ashx

Fixes

All Editors

Fixed fonts in Help entries (Bug #50473)
Fixed several issues related to the Dark Theme (Bugs #50284, #50416, #50459, #50656).

Document Editor

Fixed opening files with the broken en-ZA dictionary (Bug #50471).
Fixed hieroglyph rotation in 150% zoom (Bug #50482).
Fixed file password reset for Mail Merge (Bug #50474).
Fixed applying changes in a specific file (Bug #50604).
Fixed the parser error for files with the continuous space in a name (Bug #50466).
Fixed opening documents with deleting a password (Bug #50481).
Fixed printing documents after adding a password (Bug #49716).

Spreadsheet Editor

Fixed the JS error while opening the xlsx file (Bug #50509).
Fixed the Format as Table option in a specific file (Bug #50489).
Fixed inserting a line in a specific file (Bug #50521).
Fixed unnecessary memory consumption in pivot tables.
Fixed incorrect calculation of the IF formula (Bug #50549).
Fixed the JS error while changing zoom while editing a cell (Bug #50642).
Escaping a sheet name for regexp on changing the sheet name or on deleting sheets.
Fixed losses of ole-objects on opening.

Presentation Editor

Fixed table templates preview on different scales (Bug #50446).
Fixed the JS error while changing a specific shape (Bug #50607).
Fixed theme preview for small size windows (Bug #50578).

build_tools

Fixed build on Debian 10 and all actual versions of Ubuntu.
Fixed config location and the port for running compiled DocumentServer.

x2t

Fixed ppt => pptx conversion (Bug #50383).
Fixed cell color for xls => xlsx conversion (Bug #46852).
Fixed missing data in xls (Bug #50426).
Fixed an empty rtf file (Bug #50434).

Plugins

Adapted the Macros plugin for dark theme (Bug #49768).

Version 6.3

Release date: 05/20/2021

New Features

All Editors

Added the Dark and Light themes, modified the Classic Light theme.
Added the ability to add/edit/delete passwords in the online version.
Added the ability to set 150% scaling.
Added the button to add files to the Favorites folder.
Added new types for line and scatter charts.
Added combo chart settings.
Added hints on creating macros.
Added new scheme for the spellchecker (local work).
Added the ability to enter names for anonymous users.

Document Editor

Added the option to change wrapping settings on the top toolbar (Layout tab).
Added the ability to change indent in the paragraph settings on the right panel.
Added the ability to change text case.
Added the ability to change list levels.
Fixed color set in the color picker for content controls.
Added the ability to save Track Changes status to file.
Added the ability to download files as/save as FB2, EPUB.
Added the ability to open the XML files.

Spreadsheet Editor

Added the XLOOKUP function.
Added new cell formats: mm/dd, mm/dd/yyyy, mm/dd/yy.
Added a new currency for cell format - Croatian kuna.
Added the ability to group/ungroup data in pivot tables.

Presentation Editor

Added the Transparency setting to slide properties in the right panel.
Added the Column setting for text in a shape on the toolbar.
Added buttons for changing text case and highlighting text with color.
Added the ability to preserve animations already added to the presentation.

Version 6.2.2

Release date: 04/19/2021

Fixes

Server

Removed the ability to execute DocumentBuilder scripts from Editors.
Fixed the vulnerability with inserting images from URL and comparing documents from URL.

x2t

Fixed conversion time for a specific document (Bug #49434)
Fixed the broken pptx file after opening in the Presentation Editor (Bug #49429, #49202)

Docker

Fixed instructions for using Let's Encrypt (Docker-DocumentServer issue #349).

Version 6.2.1

Release date: 03/31/2021

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).

Version 6.2

Release date: 03/01/2021

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.

Version 6.1.1

Release date: 01/28/2021

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.

Version 6.1

Release date: 12/02/2020

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.

Version 6.0.2

Release date: 11/12/2020

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).

Version 6.0.1

Release date: 10/28/2020

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.

Version 6.0

Release date: 10/14/2020

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.

Version 5.6.5

Release date: 09/21/2020

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.

Version 5.6.4

Release date: 09/08/2020

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).

Version 5.6.3

Release date: 08/17/2020

Fixes

Backend

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

Version 5.6.2

Release date: 08/07/2020

Fixes

Backend

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

Version 5.6.1

Release date: 08/05/2020

Fixes

Backend

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

Docker

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

Version 5.6.0

Release date: 07/29/2020

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).

Version 5.5.3

Release date: 05/22/2020

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.

Version 5.5.1

Release date: 04/09/2020

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.

Version 5.5.0

Release date: 03/05/2020

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.

Version 5.4.2

Release date: 11/27/2019

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).

Version 5.4.1

Release date: 10/02/2019

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).

Version 5.4.0

Release date: 09/03/2019

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).

Version 5.3.4

Release date: 07/16/2019

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.

Version 5.3.2

Release date: 06/24/2019

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.

Version 5.3.1

Release date: 06/06/2019

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).

Version 5.3.0

Release date: 05/28/2019

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.

Version 5.2.8

Release date: 02/05/2019

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).

Version 5.2.7

Release date: 01/16/2019

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.

Version 5.2.6

Release date: 12/25/2018

Fixes

Document Editor

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

Version 5.2.4

Release date: 12/12/2018

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.

Version 5.2.3

Release date: 10/31/2018

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.

Version 5.2.2

Release date: 10/05/2018

Fixes

RPM

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

Version 5.2.0

Release date: 09/28/2018

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.

Version 5.1.5

Release date: 07/18/2018

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.

Version 5.1.4

Release date: 05/24/2018

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).

Version 5.1.3

Release date: 04/27/2018

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).

Version 5.1.2

Release date: 04/11/2018

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.

Version 5.1.1

Release date: 04/05/2018

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).

Version 5.1.0

Release date: 03/28/2018

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.

Version 5.0.7

Release date: 01/16/2018

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).

Version 5.0.6

Release date: 12/11/2017

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.

Version 5.0.5

Release date: 11/28/2017

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.

Version 5.0.4

Release date: 11/14/2017

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.

Version 5.0.3

Release date: 11/02/2017

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.

Version 5.0.2 SaaS only

Release date: 10/13/2017

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).

Version 5.0.1 SaaS only

Release date: 10/05/2017

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.

Version 5.0.0 SaaS only

Release date: 09/23/2017

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.

Version 4.4.4

Release date: 09/13/2017

Windows-only release

Fixes

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

Version 4.4.3

Release date: 08/14/2017

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.

Version 4.4.2

Release date: 07/24/2017

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.

Version 4.4.1

Release date: 07/05/2017

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).

Version 4.3.6

Release date: 06/14/2017

Fixes

Rebranding

Fixed the problems with the white-label logos.

Version 4.3.5

Release date: 06/05/2017

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.

Version 4.3.4

Release date: 05/16/2017

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.

Version 4.3.3

Release date: 04/28/2017

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.

Version 4.3.2

Release date: 04/17/2017

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.

Version 4.3.1

Release date: 04/06/2017

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.

Version 4.3

Release date: 04/03/2017

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.

Version 4.2.11

Release date: 03/13/2017

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.

Version 4.2.10

Release date: 02/20/2017

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.

Version 4.2.9

Release date: 02/14/2017

New Features

Spreadsheet Editor

The Polish language translations for functions.

Fixes

Spreadsheet Editor

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

Version 4.2.8

Release date: 02/06/2017

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.

Version 4.2.7

Release date: 02/01/2017

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.

Version 4.2.5

Release date: 01/16/2017

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.

Version 4.2.4

Release date: 01/09/2017

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.

Version 4.2.3

Release date: 12/23/2016

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.

Version 4.2.2

Release date: 12/21/2016

Fixes

Presentation Editor

Fixed the problem with opening password-protected presentations.

Version 4.2.1

Release date: 12/06/2016

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.

Version 4.2.0

Release date: 12/01/2016

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.

Version 4.1.8

Release date: 11/03/2016

Fixes

License

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

Version 4.1.7

Release date: 11/01/2016

Fixes

Editors

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

Version 4.1.6

Release date: 10/26/2016

New Features

Editors

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

Version 4.1.5

Release date: 10/13/2016

Fixes

Editors

Fixed copy-paste on MacOS Sierra.

Plugins

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

Version 4.1.4

Release date: 10/07/2016

Fixes

Back-end

ipfilter can use dns to lookup.

Version 4.1.3

Release date: 09/28/2016

New Features

Plugins

Sample plugins are enabled by default.

Version 4.1.2

Release date: 09/22/2016

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.

Version 4.0.3

Release date: 08/04/2016

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.

Version 4.0.2

Release date: 08/03/2016

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.

Plugin	GUID
`Highlight code`	{BE5CBF95-C0AD-4842-B157-AC40FEDD9841}
`Mendeley`	{BE5CBF95-C0AD-4842-B157-AC40FEDD9441}
`OCR`	{440EBF13-9B19-4BD8-8621-05200E58140B}
`Photo editor`	{07FD8DFA-DFE0-4089-AL24-0730933CC80A}
`Speech`	{D71C2EF0-F15B-47C7-80E9-86D671F9C595}
`Thesaurus`	{BE5CBF95-C0AD-4842-B157-AC40FEDD9840}
`Translator`	{7327FC95-16DA-41D9-9AF2-0E7F449F6800}
`YouTube`	{38E022EA-AD92-45FC-B22B-49DF39746DB4}
`Zotero`	{BFC5D5C6-89DE-4168-9565-ABD8D1E48711}

Artikel zum Thema:

Changelog

Hilfe-Center

ONLYOFFICE Docs

Uninstall default plugins from the server editors

Uninstall default plugins from the server editors

Default plugins GUIDs