General portal changes

• Restored the mail migration functionality hidden in the version 11.5.0.
• Added the text about resetting users' passwords on the Restore settings page, added an email notification about the successful completion of the restoring process.

Documents module

• Added the ability to select the archiving type in the settings: zip (by default) or tar.gz.

CRM module

• Moved queue settings to the configuration. 2 streams are allocated for data export.

General portal changes

• Added the Zendesk chat display on the Payments page in the SaaS version.
• Updated the Payments page in the SaaS version. Prices are based on a number of users. The free Startup and paid Business (+trial) payment plans are available.
• Added the welcome dialog window for the portal owner on the main portal page. The dialog is displayed only once when the owner first enters the portal.
• Removed the limitation on the amount of portal data when creating a backup.
• When storing backups to a third party service, chunk loading is now used.
• The Restore feature is available in the SaaS version if the pricing plan includes this option. In the SaaS version, only the hashed backup file can be restored, i.e. the backup file created in the version 11.5 and later. Removing temporary files when starting a backup.
• Filter: a tip on the search is enabled in all modules, excepting People and Sample.
• Fixed calculating the total\current number of full-text search indexes.
• The full-text search feature is available in the SaaS version if the pricing plan includes this option. Updated ElasticSearch to the version 7.9.
• Reworked the receipt of data from the payment system for authorized requests in the SaaS version.
• The LDAP feature is available in the SaaS version if the pricing plan includes this option.
• Added the temp setting to specify a path for creating temporary files instead of the system Path.GetTempFileName() one, so that the system disk does not overflow.
• Changed email notifications for the SaaS version and messages about changing an email.
• Changed the assembly for archiving backup.
• Reworked the mechanism for working with resource files.
• All the available languages are enabled in the Personal cloud, reworked the drop-down list of available languages on the start page.
• The SSO feature is available in the SaaS version if the pricing plan includes this option. The ssoauth service moved from the control panel to portals.
• Updated the Yandex icons on the user profile page, authorization page and third party service connection settings.
• Added a checkpoint to the migration page and changed the email notification about the successful completion of the migration.

Documents module

• Removed the support of the version 5.3 of the editors.
• Updated the Google Drive icons.
• Fixed calculating a quote when downloading several files in an archive.
• Removed transferring the anonymous name to the editor for using the renaming functionality in the versions 6.2, 6.3 of the editors.
• Added the ability to convert the fb2 files.
• Files can be shared with guests for viewing only.
• Removed the button to share a file with a group in the Private Room.
• Transferring the favorite status of a file to the version 6.3 of the editors. Changing the favorite status from the editors.
• Signing in JWT the callbackUrl of the editor initialization configuration.
• Video and audio files are added to start samples in all languages.
• Archiving and compressing via tar.gz instead of zip when downloading several files.
• Removed the limitation on the size of files when downloading several files in an archive.
• The EasyBib and WordPress plugins are not available in the free version of the editors.

Mail module

• Added the ability to get the connection settings for connecting a mailbox to third-party mail clients and the ability to change passwords for mailboxes created on the Mail Server in the SaaS version.

Calendar

• Fixed bugs.

General portal changes

• ASC.Web.Studio: the onlyoffice_logo folder renamed to logo.
• Added a banner for the ONLYOFFICE Projects app in the App Store.
• Removed the button for downloading a paid invoice on the Payments page (11.0.2).
• Defining work from the Desktop on the server via userAgent (starting from version 6.1).

Documents module

• Added Thumbnails view. Thumbnails are not generated for video. Thumbnails are not generated in third-party storages.

General portal changes

• Using global recaptcha.
• Removed collection of analytics from the installation.
• Disabled mini chat.

Bug fixes

• Bug Fixes & Performance Improvements.

General portal changes

• Added the possibility to receive portal notifications via Telegram;
• Added the possibility to make an addon (Mail, Chat, Calendar) a default portal page;
• Added the additional license check when replacing ONLYOFFICE in the About this program window;
• Added the vsyscall check to the installation scripts when installing Mail Server on Debian with kernel 4.18.0 and later;
• Updated copirights in the source files;
• Added the possibility to connect the Mail.ru, VK and Yandex applications for authorization;
• Added new icons and texts in the welcome placeholders of the empty modules;
• Added icons to context menus;
• Added two scrolling areas on the page: navigation and content;
• Reworked the mechanics for displaying messages on the authorization page;
• Updated Elasticsearch to v.7.4. Added the possibility to rebuild the index.
• Updated Mono to v.6.8, updated builds, improved performance;
• Added the file encryption at rest feature for server versions;
• When requesting the password recovery, it's not possible to check if an email address is used on the portal;
• It is prohibited to specify the current password when changing a password;
• Updated minimal password length to 8 characters;
• The password complexity check is now performed in the client-side browser;
• Added password hashing with the PBKDF2 algorithm when transmitting passwords to the server;
• Added the Sign in to domain option on the authorization page for the portals where the LDAP Authentication is enabled;
• Added a request for subscription to newsletters in the free Community version installation wizard;
• Control Panel is available in the free Community version with all settings excepting the editors logo replacement;
• Removed the link to the forum;
• Added data cleaning before restoring backup;
• When the license expires, Document Server updates are blocked in the installation;
• Portals with an expired license and Enterprise portals with a free default license are not blocked;
• In the free Community version, a block with a proposal to install Enterprise Edition is added;
• The Payment page redirects to the Control Panel (if it is installed);
• Added the -it, --installation_type parameter to the installation scripts. The possible values are GROUPS | WORKSPACE | WORKSPACE_ENTERPRISE.

Documents module

• Changed the note about the mention in the comment pop-up window depending on the ability to provide access to the document;
• Added the support for the .webp images;
• Using a new MailMerge API for the editors;
• Opening the default portal page when clicking to the logo in the upper left corner of the editors interface;
• Added the possibility to connect kDrive via WebDav;
• Added the Favorites section, added the ability to add files to favorites via context menu;
• Added the Recent section;
• Added translations for the EasyBib and WordPress plugins;
• Added the possibility to provide the Custom Filter access rights for spreadsheets;
• Replaced an empty tab with a static page containing the logo when creating a new file;
• If the DocuSign service is not connected, the instructions are displayed when clicking the Sign with DocuSign context menu option;
• Added a new Private Room section for the server version only;
• If an administrator disabled the Allow users to connect third-party storages option, he/she also cannot connect third-party clouds;
• Added a separate section for quick access to admin settings on the left panel;
• Added links to download desktop and mobile apps.
• Added empty files for creation in Japanese (ja-JP).

CRM module

• Added the Make a VoIP call action in the contact context menu;
• Removed the unnecessary Quantity field when creating a new invoice item;
• Added the possibility to enter decimal fractions with two decimal places in the Discount field when creating an invoice.

Mail module

• Added a new scroll mechanism for the screen width greater than 1200 px.

Talk

• Removed the third-party messengers integration due to the necessity to store user passwords in the explicit form which is not secure.

Control Panel

• Control Panel is available in the free Community version with all settings excepting the editors logo replacement;
• Added the vsyscall check to the installation scripts when installing Mail Server on Debian with kernel 4.18.0 and later;
• Redesign of the navigation menu: added Common and Portal settings sections, added icons to menu items;
• Added the advanced rebranding page in the Common Settings;
• Added the possibility to reindex the full-text search;
• Updated node.js, updated packages (transition to samlify for SSO);
• Added the Encryption at rest block in the Storage section;
• Added the Private Room section for the server version only;
• Added the upgrade page with a proposal to upgrade to Enterprise Edition;
• Added the activate page with a possibility to upload a license file;
• Added the HideAuthPage option to the SSO settings to hide the authorization page. When the HideAuthPage option is enabled, an automatic redirect from the authorization page to the SSO service will occur.

LDAP

• Added the Sign in to domain option on the authorization page.

Single Sign-on

• Transition to the new samlify library;
• Added the HideAuthPage option to the SSO settings to hide the authorization page. When the HideAuthPage option is enabled, an automatic redirect from the authorization page to the SSO service will occur.

Calendar

• Improved the Calendar API security;
• Reworked the authorization method for the CalDAV calendars;
• Reworked the Radicale plugins for the new version 3.0.

General portal changes

• Added new mail messages for portals;
• Docker installation in the install.sh script is now performed using the script by Docker developers;
• Added scripts for the installation from DigitalOcean Marketplace;
• Added the reCAPTCHA verification after N failed attempts to sign in;
• Sending only 200 emails per day to non-activated email addresses for a SaaS portal during the trial period;
• Fixed the issue when downloading large files from a Storage, e.g. backup files.

Documents module

New features

• Added the possibility to open the version and revision history when clicking on the Preview file version icon;
• Added the possibility to open a file at the position of the previously added bookmark;
• Added a notification about the conversion when uploading a file that must be converted before it can be opened;
• Added support for the conversion of the password protected files: the password is now required to open a file that that must be converted before it can be opened;
• Added the possibility to rename files using the F2 hotkey;
• Added the possibility for administrators to adjust intermediate revision settings;
• Added the possibility for users to save intermediate revisions when editing a document by using Ctrl+S or the Save button;
• Added the button that allows to upload a folder;
• Added the possibility to mention portal users when adding a comment in an editor. The mentioned user will automatically be granted with read-only access to the file and will receive a notification.

Viewers

• Redesigned image/video Viewers;
• Playback of the avi, mpg and mpeg files up to 100 Mb is now performed by means of the intermediate conversion into the .mp4 format.

Encryption mode

• When connecting to the portal via the desktop editors interface with the encryption mode enabled, uploading folders as well as uploading with the drag-and-drop method is not available; OOXML documents (.docx, .xlsx, .pptx) become encrypted when they are uploaded to the portal or created.

Various changes

• Minor changes in the file history display.

Bug fixes

• Fixed the issue when downloading a lot of files added to an archive.

Projects module

New features

• Added the button that allows to upload a folder;
• Added the possibility to delete several projects at once.

Tasks/milestones

• Added the possibility to create custom task statuses.

Various changes

• Removed the Back button from the interface;
• Projects are now removed without refreshing the page;
• The Follow button is now moved to the Actions menu;
• A complete name is now displayed in the entity profile.

CRM module

• The png and jpg formats are only available for the CRM contact avatars.

Mail module

• Added the new email Templates functionality;
• Added the possibility to Download all attachments as a single archive;
• Added the possibility to display the last quoted message in a conversation;
• Added the indication of the mailbox deletion process.

Mail Server

• Opened the following ports in Dockerfile: 465(SMTPS), 993(IMAPS), 995(POP3S);
• Disabled the redundant DKIM generation;
• Removed the reject_unverified_sender key in the Postfix config.

Control Panel

New features

• Redesigned the Backup module;
• Added the section that displays all Online Users at the Login History tab;
• Added the Storage module.

LDAP

• Added the possibility to send invitation messages containing the button that allows to go to the portal sign in page and the email activation link when adding users to the portal.

Calendar

New features

• Added the synchronization option for calendars from the Other Calendars section.

Various changes

• Optimized the page display when there are a large number of events in the calendar.

General portal changes

• The Mono version used is updated to 6.0;
• The sample module (see the documentation here) is now present in the portal and can be enabled in the portal settings;
• Fixed various bugs.

Documents module

• Added the possibility to view AVI, MPEG and MPG files;
• If the portal has HTTPS enabled, the address of the editors is also checked for the presense of the secure HTTPS connection alternative.

People module

• Added the restriction for the number of all users (both active and guests) on the portal.

Mail Server

New features

• Added permanent Fail2Ban ignoreip section for docker containers and its gateway;
• Added the possibility to create sieve rules for users inside /var/vmail/sieve/;
• Added new extension to sieve: sieve_extensions -> editheader;
• Exposed port 4190 for ManageSieve service;
• Added the possibility to run an external script from the /var/vmail/external.sh or /app/onlyoffice/MailServer/data/external.sh path;
• Changed the default FIRST_DOMAIN parameter;
• Replaced the hard-coded password used for the first mailbox with a random one;
• Removed old useless descriptions for iRedMail administrator console path;
• Added backticks to the 'CREATE DATABASE' commands;
• Added the possibility to send mail messages from alias_domain, alias_address and full alias;
• Added the imapsync command;
• Added the new Python scripts allowing to create mailboxes, change password and run imapsync batch in /usr/src/iRedMail/tools/scripts folder inside the onlyoffice-mail-server container;
• Added the Python PIP manager and installation requirements.

Bug fixes

• Fixed the bug with mailbox not being removed when using third level domain (issue: wrong domain regex);
• Fixed the bug with the Cannot load 1024-bit DH parameters from file /etc/pki/tls/dhparams.pem warning;
• Fixed the bug with the No such file or directory being shown in many cases;
• Fixed the bug with the ECHO_INFO: command not found warning.

General portal changes

For all users

• Added two-factor authentication using the authentication applications for code generation;
• Added the page with the list of links for mobile and desktop editor installations.

For administrators

• Added the possibility to create administrators for the Mail module;
• Removed SMTP settings from the CRM module and added them to SaaS installations;
• Added the possibility to connect third-party providers for static data storage and CDN;
• Added the possibility to backup/restore from the local folder;
• Added the possibility to backup/restore using mysqldump (for server installations only).

Backend

• Replaced sphinx with Elasticsearch, adding the possibility to search by content in documents, mail and chat messages;
• Added analytics to the periodic SaaS mail messages;
• Added the generation of the unique machinekey when installing the Docker containers using script; the key is stored in the /app/onlyoffice/CommunityServer/data/.private hidden folder;
• Enabled caching using Redis;
• The thumbnail generation is done via a new service;
• Added Bearer authentication;
• Most icons are replaced with SVG format images to enhance their display on high DPI screens;
• Removed lots of outdated limitations for mobile devices.

Documents module

Sorting and filtering

• Added sorting of files in all sections, including Shared with me and Project documents;
• Added descending sorting by modification date by default;
• The search and sorting results are taken into account when opening images for preview;
• Added the filtering by media file formats.

Sharing options

• Added the possibility to share documents for commenting only;
• Added the possibility to share DOCX files for form filling only;
• Added the shortening of the link to the people outside portal in the sharing dialog window by user request only;
• Removed the possibility to rename files and add comments for guests.

Various changes

• Added support for the new request signing to the document editing service (with JWT in request body);
• Updated the file/folder selection and moving using the mouse;
• Added the viewers for video and audio files;
• Added the display of the date in the file name when opening not the latest file version for viewing;
• When sending the file by mail from the Documents module, a draft is created with the file attached.

Upcoming changes (will be available with the release of Document Server v5.3)

• Added the possibility to Save as the documents to the portal from editors;
• Added the possibility to insert the images from the document manager to the editors;

Server installations

• Added the search by the document title and content;
• Enhanced the checks of the connection to the editors settings;
• Added the possibility to upload the license file after the support and updates period end.

Projects module

Tasks/milestones

• When creating a milestone the project manager is selected by default instead of the first person on the list;
• Added the loader when performing the group actions;
• Added a separate filter for the No milestone tasks;
• Added the milestone icon and deadline date for the tasks with no deadline belonging to a milestone;
• Fixed the display of the number of project team in the common list;
• Replaced the autosuggest input with the advancedSelector for the project creation dialog;
• The order of tasks/milestones is now saved when creating a project.

Reports

• Added the report generation using document builder service;
• Added the setting to select the report storage place;
• Added the page with the list of the generated reports.

Discussions

• Added the possibility to edit the documents when editing discussions;
• Added the possibility to attach documents when creating discussions;
• Updated the dialog with file selection to attach it to the task or discussion.

CRM module

• The list export uses a separate thread with progress display.

People module

• Updated the user avatar generation;
• Optimized the work with user list for a large number of users;
• Added the wizard for the mass user import;
• Updated the loading and parsing of CSV file, added the possibility to map the user fields manually;
• Updated the user editing interface available before adding them to the portal;
• Added the counters of the users ready for importing and import progress;
• Added the possibility to import files previously exported from various sources (Google, Yahoo or Thunderbird) as a CSV file;
• Added the possibility to create the email address at the domain connected to the Mail Server;
• Added the possibility to set the temporary password for portal access manually.

Mail module

User folders

• Added a separate page to create, edit and move/delete the user folders;
• Added the link for faster user folder creation;
• Added the modal window to create/edit user folders with the possibility to select their nesting within each other;
• Added drag'n'drop for mail messages and folders;
• Added the new Move to button to move mail messages to folders;
• Added the possibility to quickly select several mail messages using the mouse;
• Added the indication for the unread mail messages in the user folders;
• When the folder is deleted all the mail messages from it will be moved to the trash.

Tags

• Changed the tags popup, now it is optimized for tablet devices.

User filters/rules

• Added the new user filters/rules option for faster actions with mail messages;
• Added the new page for filters display, where it is possible to change the filter order, enable and disable them, apply to existing messages, edit/delete the filters;
• Added the new page for filter creation and editing, where it is possible to add filter name and trigger rules and actions, list the messages fitting the filter, apply the filter to existing messages.

Notification request

• Added the request for delivery/read notification option when creating a mail message.

Backend

• Updated the file selection dialog when attaching the file to the mail message;
• Server code refactoring and optimization;
• Replaced the Log4net logging system with NLog;
• Replaced the sanitizer with the third-party DOMPurify XSS sanitizer;
• Fixed a lot of bugs.

Mail Server

• Code refactoring and optimization to speed up the Mail Server settings page opening;
• Redesigned the wizard for domain connection in installations (four steps instead of five);
• Added the possibility to connect third-party clients (for server installations only);
• Added new Connection settings context menu option to show common connections settings (for server installations only);
• Added new Change password context menu option to change password by administrator (for server installations only);
• Added the possibility for the user to change the password and see the connection settings for the Mail Server mailbox (for server installations only);
• Added the possibility to send the mail messages when creating boxes on Mail Server and when changing passwords (for server installations only);
• Redesigned modal windows and lists in them;
• Added the warning when the server uses self-signed certificates.

Calendar

• Redesigned the calendar;
• Added the possibility to create, delete, edit tasks from the list and from the calendar grid;
• Updated Ical.Net to the latest version;
• Added the possibility to sync new calendars via CalDAV protocol (for the calendars from My calendars section added after update to Community Server version 10.0 only);
• Fixed the problem with daylight saving.

Talk

• Removed the possibility to set a status;
• Fixed the problem with reconnections of several chat tabs open;
• Added the reconnection when the connection is lost, when exiting the sleep mode;
• Added the restoring of the previously opened chat tabs;
• Added the restoring and display of the unread messages when opening the chat;
• In web version only opened chat tabs are marked read, this is done to allow reading the unread messages on other devices.

Control Panel

LDAP

• Added more fields mapped for the users loaded via LDAP: user photo, birthday, contacts, primary phone number;
• Added the setting to autosync LDAP on schedule;
• Added the possibility to give administrator rights to the user group at the portal via LDAP;
• Updated the rules for LDAP users.

General portal changes

• Now the user skin is used when the portals are opened from desktop;
• Fixed opening the authentication page (including personal.onlyoffice.com) from desktop.

Documents module

• Development of the file encryption based on the blockchain technology.

General portal changes

• Added the More languages option which appears at the bottom of the available languages list; when clicked it will trigger the popup with the invitation to take part in the translation;
• Added the new advertisement for Twilio.

Mail module

• Fixed the mechanism of mail service logging rotation.

Backend

• Fixed the God service hanging due to the previous logging updates.

General portal changes

• Twilio service is now used by default for the portal two-factor authentication instead of clickatel;
• Added the possibility to subscribe to and unsubscribe from email messages and phone calls;
• ONLYOFFICE Personal now allows to delete accounts;
• Added limit to 2 GB storage space for ONLYOFFICE Personal;
• New users loaded using LDAP/SSO now must confirm their email addresses by default.

Documents module

• Fixed the bug with the plugin opening in the OpenSource editor versions;
• Fixed the issue with the file opening if it was copied or moved overwriting the existing one.

Backend

• Changes concerning Google Analytics service.

General portal changes

• Fixed the issue with the portal notifications not sent with the selected SMTP settings via the installed ONLYOFFICE Mail Server under Mono (the problem with the self-signed certificates);
• When entering the phone number +1 characters now detect US and +7 detect Russia;
• Two-factor authentication is now enabled when the portal is created (even for the trial period).

Documents module

• Fixed the issue with downloading the file shared with the people outside the portal;
• Fixed the issue with moving the file with the help of the context menu.

Control Panel

LDAP

• Fixed the Server internal error error when using the groups enclosed inside each other in the AD (bug #37414).

Single Sign-on

• Fixed the issue when the user data between the Service Provider and the portal was transferred via HTTP only, even when HTTPS was enabled.

General portal changes

• Added the progress and notification to the portal administrator when reassigning or deleting the data for the disabled users;
• Added the text message sending to the Americas for the two-factor authentication;
• Added the authentication verification when opening the links to the SaaS files;
• Replaced the service.teamlab.com with the service.onlyoffice.com domain when authorizing via social networks.

Documents module

• Added the Document Server connection option using two addresses: for the internal and external requests;
• Document editing status is now obtained via the SocketIO service;
• Added the option to remove the confirmation for moving the elements to the recycle bin;
• Fixed the error which occurred when trying to open files and folders with non-Latin characters in their names using WebDav in Chrome v.63;
• Added the plugin to publish the documents in WordPress;
• Added the plugin to create bibliographic lists with the help of EasyBib.

Mail module

• Sped up opening the list of unread messages clicking the icon in the portal header;
• Fixed the bug when Office 365 account could not be connected to the Mail module (bug #36820).

Talk

• Fixed the incorrect text field display when using smiley (bug #36548).

Control Panel

LDAP

• Fixed the bug when the account of the user added via LDAP could not be connected in third-party clients (bug #26073);
• Fixed the bug when users which are members of the groups with not allowed characters could not pass LDAP authorization (bug #36891);
• Fixed the Internal Server Error error when updating the users having NULL values in their location or title fields.

Backend

• Optimized the work with database: dramatically reduced the number of the created connections.

General portal changes

• Fixed the bug with the display of the logo at the authorization and white labeling pages;
• Fixed the link to the support for the Latvian language.

Control Panel

Single Sign-on

• Fixed the Invalid ssoConfig error which occurred when the link to the IdP contained the question mark '?', e.g.: IdP Single Sign-On Endpoint URL: https://accounts.google.com/o/saml2/idp?idpid=777777;
• Fixed the Invalid authentication token error which prevented from adding a user to the portal using the AD FS, in case the + or - characters were present when sending the encrypted data.

General portal changes

• Fixed the request to get the mail messages from the Mail module when making a backup.

Projects module

• Fixed the bug with the reports and the reassignment of the closed subtasks.

Mail module

• Fixed the deletion of the mail data when deleting a user.

Control Panel

LDAP

• Fixed the bug occurring in the enclosed groups, when the users were displayed not in all groups.

General portal changes

• Edited the notification message received by the administrator in six months after trial starts;
• Added the tip for the Remember field for the portal authorization;
• Added the CustomNavigation setting to allow inserting own links to the portal navigation.

CRM module

• Fixed the bug when the reports were generated in the portal language, not the user selected one;
• Fixed the bug with currency settings, so that all the currencies were shown not only the convertable ones;
• Added the currency to the report headings, number format for the currencies;
• Added the possibility to set the fractional values for the taxes.

Mail module

• Added the possibility to migrate data from MS Exchange to ONLYOFFICE;
• Added links to the articles describing the migration from MS Exchange to ONLYOFFICE (available in Docker version only).

Control Panel

General

• Added the changelog for Control Panel and link to it;
• Fixed the bug when JWT parameters were not sent when updating Document Server(bug #36270);
• Fixed the bug when Audit Trail heading was present at the login history page (bug #36026);
• The current machine is now checked for being linked with the domain name for multiple portals.

LDAP

• Fixed the bug with the LDAP Domain not found error which occurred if the DN record had no DC records (the users with Sun/Oracle DS were affected); now if the LDAP domain could not be specified, the LDAP domain will acquire the unknown value or the ldap.domain value from the web.appsettings.config configuration file;
• Fixed the bug with the Sizelimit Exceeded error when trying to get more than 1000 users from the Active Directory;
• Increased the login speed with the Group Membership setting enabled;
• Added additional logging;
• Fixed the bug with LDAP operation hanging when using Mono v5.2.0 and older;
• Fixed the bug with the error when trying to login using the email address entered in the fields different from the Mail Attribute.

Talk

• Fixed the bug when the file removal window could be closed on the second try only (bug #36492);
• Fixed the bug with the new message counter in the portal header being updated with the whole page reloading only (bug #36144).

Backend

General

• Fixed the domain parameter sending when getting promotions;
• Renamed the CookieSettings setting and set the default value to 1 day;
• The session cookie is now set only if the CookieSettings is disabled.

Installation script

• Added different installation scenarios for Docker under Debian for Wheezy, Jessie and Stretch releases;
• Added the apt-get update command before installing curl;
• Added the access right change for the onlyoffice.cnf file.

General portal changes

• Added the contact import from the third-party services;
• Added the option to connect your Yahoo application for the contact import;
• Added the option to connect your Clickatell, SMSC applications to enable the SMS on the portals, Twilio service is now also used to send SMS;
• Added the disk statistics used by the Talk module;
• Added data reassigment (tasks, projects, contacts, documents) from the disabled user to others;
• Added the possibility to delete the data (mail messages, mailboxes, documents) when deleting the disabled user;
• Added new tips to all modules.

Documents module

• The connection of OneDrive file storage is now using the official SDK, not the outdated SharpBox library;
• Fixed the error with the filter not cleared when changing the folder.

Projects module

• Added an option to set access rights to the team when creating a private project;
• The Gantt Chart button is moved to the menu;
• Added the tag display on the project description page;
• The notifications are now sent for the active projects only;
• Added the possibility to give all the users the rights to create projects (disabled by default);
• Added the possibility to select the start section for every user (Tasks by default);
• Added the possibility to hide the contents of the paused projects (enabled by default);
• Added the group Delete, Close and Move actions for the tasks, the group Delete action for milestones;
• Added the possibility to select the filtered list items using checkbox.

CRM module

• Added the CRM Reports section;
• Changed the settings item for the default currency;
• Added the settings item for the currency exchange rate;
• Fixed the CRM SMTP work on port 465 (due to the MailKit use).

Control Panel

General

• Added the documentserver-prepare4shutdown.sh launch when updating the document-server for the correct edited document saving.

LDAP

• Dramatically changed LDAP integration, migrated to the single library for the work with LDAP (Novell.Directory.Ldap.NETStandard, Nuget, MIT);
• Login and email are now split into two separate fields;
• Added the support for big data;
• Increased the work speed via the LDAP protocol (the connection to the server and receiving the data is now made once per session, added the limits when only a certain number of results is necessary, fixed the slow login for bit data, removed the sorting out used to find the SID parameter);
• Fixed the user re-creation issue;
• Fixed the duplicate username issue;
• Fixed the already existing email issue;
• Replaced the LDAP user deletion with account deactivation (for further data migration and data safety);
• Instead of re-creating a user with an unknown SID but an existing email the data is updated;
• Added the attempt to save the correct UserName/Login in case a similar one is already taken on the portal.

Single Sign-on

• Added the AD FS support;
• Replaced the Single Sign-on link at the authorization page with the customizable button, added the button customization to the SSO setting of the Control Panel.

Talk

• Added the option to delete the uploaded files;
• Changed the Talk interface design.

Backend

• Replaced Unity with Autofac;
• Replaced SignalR with SocketIO, enabled mini-chat, VoIP and counter updates;
• Updated the ckeditor version to 4.7.2;
• Replaced the portal warmup with precompiling.

Documents module

• Changed the group selection mechanism when selecting folder elements with mouse cursor;
• Optimized My Documents, Project Documents folders and generally optimized all requests.

Control Panel

• Added the support of letsencrypt service for the domain certificate generation;
• Added the new sso.auth service (written in Node.js) and the new SSO settings page; now SSO supports Shibboleth.

Talk

• Interface redesign;
• Added the notifications about the incoming Talk messages when its window is closed.

Backend

• Portals migrated to Microsoft .NET Framework 4.6.2.

General portal changes

• Updated the authorization keys page for the third-party services connection;
• Allow to add administrator to the People module;
• Added the possibility to make payment page visible to portal administrators only.

Documents module

• Changed work with DropBox so that it used official SDK instead of SharpBox;
• Added the option to change the file author using the context menu or the sharing dialog window;
• Added the possibility to get the notification about mail merge end to the Talk;
• Added the possibility to subscribe to/unsubscribe from the notification about mail merge end;
• Changed the order of and grouped the actions in the context menu;
• Added the possibility to overwrite, create copy or skip files when copying or moving them creates conflict situation;
• Added the possibility to use the @#$%&;' characters in the file name;
• When creating a new file, a blank file is used as the first revision;
• Added the user profile display when hovering the cursor over the user name in the sharing dialog window and in the file history;
• Added the option to restore the file revisions or editing changes when watching the history within the editors;
• Added the possibility to rename the file when editing it withing the editors;
• Added the integration with DocuSign;
• Fixed the sharing button highlighting when it was shared by other user;
• Redesigned the sharing menu and dialog window.

Projects module

• Added the possibility to create the task copy and move it;
• Added the possibility to create the subtask copy;
• Now the task list is opened automatically if there is at least one open task in it;
• Redesigned the page with the tasks and discussions description;
• Some pages are visited without the page reload;
• Many controls were moved to templates;
• General optimizition and refactoring of the Projects module.

CRM module

• Added IP-telephony integration based on Twilio.

Mail module

• Added the new General Settings option in the module settings which allows to set the messages grouping, always display images from all users, cache the unread messages in the Inbox folder and go to the next unread message after moving/deleting the current message;
• Added the Cancel button (the cross in the upper right corner) to the mail composition form;
• The module work is fixed and sped up when working with big data.

Backend

• jQuery was updated to use version 3.1;
• The support for IE 8 and earlier versions is discontinued;
• Added ApiSystem service fuctionality for the hosted solutions;
• Some scripts (jQuery, jQuery.BlockUI, Magnific.Popap, jquery.mousewheel) are not included into the project and are loaded from nuget;
• Fixed authorization problems with Twitter;
• Copying to buffer now uses HTML5;
• Added the mechanism for the preliminary bundle assembly;
• Added gzip-compression for the client script and the bundle saved to the disk.

Portal settings & Control Panel

LDAP

• Added LDAP synchronization for users and groups when saving the settings, after login and using the Sync button;
• Changed email formation for LDAP users;
• Fixed the problem of creation of users with invalid emails;
• Fixed the problem of duplicate users;
• Added icons and hints to the users in the list for the admin;
• Blocked for editing the user profile fields imported using LDAP;
• Added the real LDAP password saving to the database during login in case LDAP Auth is disabled, now the LDAP users will become common portal users when LDAP Auth is disabled;
• Added new API Settings method - Sync LDAP;
• Added new translations;
• Bug fixes.

Control Panel for Windows

• Made changes at the Update page for the Control Panel for Windows;
• Updates are performed using the downloaded installation packages for each module.
• The current installed component version numbers are obtained via API request to the Community Server.
• The new versions available for download are obtained via the request to the https://download.onlyoffice.com/install/windows/updates.txt file, where all the latest component version numbers and links for their download are stored in the JSON format.

Documents module

• Added support for the history of changes which has a new format in document editing service (Document Server versions later than 4.1.5);
• Added support for plugin connection.

Mail Server

Connection Settings

• Added page to the Settings for the integration of Community Server with Mail Server.

Installation Script

• Fixed the error shown if the mail domain is not specified, now Mail Server will not be installed if this is the case;
• Fixed the installation of the latest Docker version;
• Removed chmod 777 to the created folders;
• Added hardware checks (40Gb HDD space, ~6Gb RAM, 2 Core Processor) and 6Gb swap creation;
• The components are installed via network by default;

General portal changes

• New mail notification templates;
• Changed old SaaS notification mail texts and added new mail messages;
• Added new mail messages for Enterprise Edition;
• Fixed mail notification placeholders for the whitelabel texts;
• Added the currency selector at the pricing page;
• Enabled browser spellcheck in ckeditor

Documents module

• Disabled support for Document Server with version earlier than 3.0.
• If the Upload the documents in original format as well option is disabled, the uploaded converted file is placed not as a separate new file, but as a new revision of the original file;
• Box storage service is connected using secure connection with oAuth 2.0 authorization.
• Added sharing of documents in DOCX format for review.

Calendar module

• Changes to the quick event creation window;
• Added event details window;
• Added the page for the event advanced creation/editing;
• Added selection of event organizer;
• Event guests emails are checked for correctness, the CRM contacts, address book contacts and portal user list are used to autosearch guests;
• Added email notifications to the event guests when event is created or changed;
• Added event export into .ics format.

Mail module

Address book

• Added new address book, which includes contacts from portal users, CRM and user personal contacts.

Mail and Calendar modules integration

• Added integration of Mail module with Calendar module using the iCalendar open source format as described in RFC 5545 specification;
• The mail messages containing iCalendar format are detected automatically with the ASC.Mail.Aggregator service, can be added to custom filters;
• Details of the event found in mail can be viewed, added to the Calendar module automatically or manually;
• Added the possibility to send invitations to the events from the Calendar module, reply to the invitations sent from third-party calendar software, notify the event guests about the changes or cancellation of events.

Mail autoreply

• Added mail autoreplying option with the settings in the Mail module at the Account page;
• Mail autoreply can be quickly set up and disabled/enabled on demand.

Mail address control

• Updated the control to enter mail addresses to enable the email and contact search among People, CRM, user personal contacts, mail accounts and frequently contacted recepients;
• Added keyboard shortcut support and better interaction with mouse and keyboard.

Mail and CRM and Documents modules integration

• Added an option to create a CRM contact directly from the mail message linking the current mail thread to the new contact history;
• Added a new contect menu allowing to select a folder in the Documents module to save the message attachment.

Mail Server settings

• Redesigned Mail Server settings page.

General portal changes

• Added white label options for paid portals;
• Added the possibility to resize left menu panel in all portal modules.

Documents module

• Added version history view in the editors;
• The search is conducted both in the folder and all subfolders.

Mail module

• Added the possibility to print mail messages;
• Added the possibility to select the mail box on own domain to send notifications inside portal;
• Various code optimizations.

Portal backup

• Changed the archive format from .zip to .tar.gz;
• Removed limitations for the backup file from the Community Server installation, the SaaS version now has the limit of 10 GB for backups.

General portal changes

• News, unread chat messages and mail messages counters are now updated without the page reloading in all the tabs (via Signalr);
• Changed pricing plans at the pricing page.

Documents module

• Added support for the folder upload via drag-n-drop in Google Chrome retaining the whole folder inner structure.

Mail module

Mail Server

• Mail Server first release, now the mail boxes can be created for the onlyoffice.com, onlyoffice.eu and onlyoffice.sg domains.

Mail client

• Better synchronization of the client using SignalR (folder state update, message list update, sending notifications, tab synchronization);
• Updated the recepients list filtering;
• Added the selection for the default mail box, which is now offered as first mail address when writing a mail message;
• Added the possibility to add links to the portal documents as mail attachments;
• Optimized work of mail aggregator and stability of work under Mono;
• Optimized styles for filter, dashboard and popups.

Talk

• (Server version only) Added the support of the web.max-upload-size parameter to the configuration file, which allows to set the limit for the size of the files uploaded to Talk (1 MB by default).

General portal changes

• Public portals are available now for trial and nonprofit portals.

Documents module

• Added new supported third-party document storages (OneDrive for Business via SharePoint connection, Yandex.Disk, OwnCloud and other third-party services which use WebDav protocol for connection);
• Updated work with GoogleDrive, now the connection is made via OAuth 2.0 protocol and work with Google API is performed via GoogleDrive SDK;
• When portal administrator enters the Documents module, the window offering to select the document editors version (2.5 or 3.0) is shown, if this has not been done before.

Mail module

• Mail Server is out for beta testing in EU region.

Backup

• A temporary storage for backup files is selected by default;
• Added the possibility of automatic backup creation;
• Added the possibility to backup Mail module data.

General portal changes

Redesign

• TeamLab is now officially rebranded to ONLYOFFICE;
• Redesigned menus, added loaders and page views for the modules without any content.

Public portals

• When using a free of charge portal a new option is available in Settings > Security > Portal Access > Portal Access Settings allowing to make the portal available to the people who are not registered there.

Unregistered users

• Added access rights for the unregistered portal users.

Videos

• Link to the videos is moved from the top menu to the left navigation menu;
• Removed videos from the welcome page.

Documents module

• Added integration with OneDrive for Business.

Projects module

• Added the possibility to select a project template at the project creation page;
• Added the possibility to add milestones and tasks during the project creation.

Community module

• Changes to the dashboard empty page.

Backup/restore

• Added the possibility to select the storage for the created backup (temporary storage is selected by default);
• Added the possibility to select the backup which will be used to restore the portal.

Server

HTTPS

• Added the possibility to upload a certificate in the .pfx format with the required password at the settings page.

Monitoring

• Added the new page to the portal settings, which has the following options: Alerts (showing the ports necessary for TeamLab Office correct work), Services (displaying the list of Windows services necessary for the Feed and Mail module work), Logs (allowing to collect all the server logs in a single .zip archive file which can be sent to our support), and the button allowing to reset all cache and rebuild script files, if necessary.

General portal changes

• Mini-chat embedded into the left panel is displayed on all portal pages;
• Added integration with LDAP/Active Directory;
• Added two factor authentication option using SMS service;
• Old controls were replaced by new ones in People, Projects, CRM modules and the portal Settings;
• Replaced old loaders, icons, information panels everywhere on the portals.

Documents module

• Added revisions to the document version history with the possibility to add comments to each revision;
• Added the possibility to block the document file for changes;
• Made SharePoint as a third-party provider to access Box, DropBox, GoogleDrive and Skydrive storages;
• Added possibility to share several files at once selecting them simultaneously and using the corresponding context menu option.

Projects module

• Updated the Gantt charts to version 2.0 adding the possibility to display several projects at the same chart and allowing to select the options to be displayed on the chart;
• Removed reloading the page when switching among the Projects module main tabs (Projects, Tasks, Milestones, Discussions, and Time tracking);
• Added pagination ot the time tracking tab;
• The errors and some successful actions are no notified via toaster.

CRM module

• Added invoicing to the CRM module;
• Removed reloading the page when switching among the CRM module main tabs (Contacts, Tasks, Opportunities, etc).

Mail module

• Added the possibility to automatically attach signature templates to mail messages;
• Added the option to save attachments to the selected folder in the Documents module;
• Added the possibility to send CRM module invoices via Mail module, attaching them to the mail message;
• Changes to the mail thread detection;
• Fixed work with non-latin characters in attachment name;
• Fixed work with images and files embedded into the mail message body;
• Enhanced work with the context menu;
• Enhanced collapsing the quotation in the reply message;
• The Mail module interface was redesigned to follow the other module guidelines.

General portal changes

Portal redesign

• Portal minimal width changed to 1024 pixels;
• Added the new setting to change the portal color scheme.

Portal transfer to another region

• Changed the work of the portal transfer to another region mechanism;
• Added the possibility to fill the portal with demo content.

Documents module

• If the user has full access rights to the document, the sharing button will be present at the document information tab.

Projects module

• Added the possibility to use Gantt charts with the Projects module.

CRM module

• Changed the available sorting list depending on the filter used;
• Removed the Set permissions group action from the contact list;
• Added the Create new task group action to the contact list;
• The contact types are renamed into Contact warmth;
• Added new Contact type option;
• Changed the way the the contact manager is appointed;
• Added the possibility to change Contact warmth and add tags to a group of contacts;
• Added the pagination instead of the Show more button;
• Improved integration with the Mail module;
• Enhanced automatization and refactoring.

General portal changes

• When a user joins the portal via an invitation link, the email address used to do that will not be activated automatically and will require conscious actions from the user side;
• The email address used for registration on the portal will be automatically activated only when registering via social networks.

Documents module

• A portal guest can only open the document for viewing if the document author gave such access rights to him/her.

CRM module

• Added sorting by date to CRM module.

General portal changes

• Added the possibility to move the portal to another region, which will be closer to the portal users location;
• Added tips when the user accesses the portal for the first time;
• Added the icon for video guides in the header menu;
• Added the links to the support to the left side menu.

Documents module

• Updated the document loader in the Documents module and the Project documents section of the Projects module.

Projects module

• Added new statuses in the time tracking section;
• Added the new task start time field, the time will be also displayed at the task detail page;
• Added the possibility to sort the tasks by the start time;
• Added the setting to manage access rights to the contacts of a private project;
• Updated the filter of the task responsible users;
• Removed the outdated styles from the reports;
• Changed the way the blocked users are displayed in the project team;
• No project access rights are displayed for the disabled users in private projects;
• Changed the list of available options in the menu for all users;
• The guests do not have any access to the project team.

People module

• Added a new user role - guest users (users with limited access and content creation rights);
• Added new filters by user role (user, guest) and by status (active, disabled and pending);
• Added group operations with users (changing the roles for several users at once);
• Added a birthday icon;
• Changed the user profile and subscriptions page (moved it to a separate page, added the possibility to change photo, display the user status, birthday icon).

Community module

• Moved user birthdays to a separate page;
• Now all the users will be subscribed to other users birthdays by default;
• Guest user birthdays are neither displayed or generate notifications about.

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

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.

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Integration

• Fixed missing Plugins tab (Bug #49007).

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Fixes

• All components received countless fixes.

Server

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

Fixes

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Mobile editors

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

Server

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

Installation

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

x2t

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

ePub

• Fixed the %20 symbol in some ePub files.

Plugins

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

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Plugins

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

Embedded mode

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

Fixes

• All components received countless fixes.

Backend

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

New Features

Integration Example

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

Fixes

All Editors

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

Installation

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

Backend

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

Fixes

All Editors

• Actualized Help.

Document Editor

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

Spreadsheet Editor

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

Convert

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

Backend

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

Installation

• Fixed cluster mode setup.

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Editors

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

Backend

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

Fixes

• All components received countless fixes.

New Features

document-server-integration

• Uses Apache license instead of MIT.

Fixes

x2t

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

Backend

• Fixed connecting Document Server with MySQL to Community Server.

Package

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

Fixes

Convert

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

Fixes

Backend

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

Fixes

Backend

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

Fixes

Backend

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

Docker

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

Fixes

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Editors

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

Backend

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

Plugins

• Fixed the GetCurrentContentControlPr method.

x2t

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

New features

All Editors

• Added skeleton loader in embedded viewer.

Document Editor

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

Backend

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

Fixes

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Mobile Editors

• Font picker refactoring.

Backend

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

x2t

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

Package

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

Plugins

• Add and fix translations in macros plugin.

New features

All Editors

• Added the instruction on how to build all products

Spreadsheet Editor

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

Fixes

All Editors

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

Document Editor

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

Spreadsheet Editor

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

x2t

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

Server

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

Docker

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

New features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Editors

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

Package

• Removed nodejs dependency.

Docker

• Ubuntu 18.04 is now used as a base image.

Server

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

Fixes

• All components received countless fixes.

New features

All Editors

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

Plugins

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

Backend

• Added custom public key support.

Fixes

Document Editor

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

Plugins

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

Embedded mode

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

Installation

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

x2t

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

New features

Spreadsheet Editor

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

Presentation Editor

• Added the support for the theme thumbnail parameters.

document-server-integration

• Added the blockcontent mode.

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Backend

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

Plugins

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

document-server-integration

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

x2t

Common

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

doc

• Fixed the issue with the extended comments.

docx

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

xls

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

xlsx

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

odf

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

rtf

• Fixed some issues with the files in RTF format.

Docker

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

• Added support for asynchronous loading of plugins.

All mobile editors

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

Mobile Document Editor

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

Mobile Spreadsheet Editor

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

Embedded viewers

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

Fixes

All editors

• Fixed a lot of bugs.

Deprecations

All editors

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

New features

Plugins

• Added the translations for Photo Editor plugin.

Fixes

All editors

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

Document Editor

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

Presentation Editor

• Fixed the issue with the slide background color.

x2t

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

Windows version

• Fixed a misprint on Redis configuration page.

Fixes

All editors

• Fixed more problems with SVG.

Document Editor

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

Spreadsheet Editor

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

Plugins Editor

• Fixed the logging error for plugins.

Backend

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

New features

Document Editor

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Mobile web editors

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

Document Builder

• Fixed the errors in Document Builder documentation.

Packages

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

Docker installation

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Fixes

All editors

• A lot of bugfixes in all product modules.

New features

All editors

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

Plugins

• Added the support for system plugins.

Backend

• Added the robots.txt handler.

x2t

• Added the default theme for XLS.

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

x2t

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

New features

All editors

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

Spreadsheet Editor

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

Spreadsheet Viewer

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

Plugins

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

• Fixed the error in copying the slide notes.

Spreadsheet Viewer

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

Plugins

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

x2t

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

Fixes

Document Editor

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

New features

All editors

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

Spreadsheet Editor

• Added support of R1C1 references style.

Document Builder

• Added the AddComment method to the ApiRange class.

Plugins

• Added the translation for plugin names and descriptions.

x2t

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Document viewer

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

Mobile web editors

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

Backend

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

x2t

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

Docker installation

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

New features

All editors

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

Spreadsheet Editor

• Enhanced the application due to the completely rewritten scroll.

Document Builder

• Added the new setLocale and getLocale functions.

Server

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

x2t

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Embedded viewer

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

Server

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

x2t

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

Docker installation

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

Fixes

RPM

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editors

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

Mobile web editors

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

Server

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

Packages

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

Plugins

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

Docker installation

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

Document Builder

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Server

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

Packages

• Updated the innodependencyinstaller to fix the requirements detection.

Plugins

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

Document Server integration examples

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

x2t

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

New features

Backend

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

Fixes

All editors

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile web editors

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

PDF viewer

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

Docker installation

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

Conversion services

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

x2t

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

ODF

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

RTF

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

XLS

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

New features

All editors

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

Backend

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

DEB and RPM

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

x2t

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile web editors

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

Backend

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

DEB

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

x2t

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Document Builder

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

Backend

• Updated the ICU dependency version from 5.5 to 6.0.

Mobile web editors

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

Integration example

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Mobile Document Editor

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

Mobile Spreadsheet Editor

• Fixed the bug with scrolling;

x2t

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

New features

Document Editor

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

Documentation

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

• Fixed the issues with the reporter mode in Safari.

Backend

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

x2t

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

New features

All editors

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

Spreadsheet Editor

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

Backend

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

Documentation

• New documentation articles describing the 5.1 version new features.

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

x2t

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

Desktop Editors

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

x2t

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

Document Builder

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

Documentation

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

Fixes

All editors

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

New features

Licensing

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

Document Builder

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

Spreadsheet Editor

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

Documentation

• Added the documentation about the program interface.

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

Integration example

• Removed the Integration Edition caption from the logo.

x2t

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

New features

Licensing

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

Fixes

Document Editor

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

Backend

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

Windows version

• Fixed enabling the JWT in Document Server example.

New features

Desktop editors

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

Fixes

All editors

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

x2t

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

Backend

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

DEB

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

Document Builder

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

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

New features

Distribution

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

All editors

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

Plugins

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

Windows version

• Added the Accept license dialog window to the installation.

Fixes

All editors

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

Document Editor

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

Presentation Editor

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

Embedded viewer

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

Backend

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

RPM

• Fixed the SELinux usage with custom ports.

Plugins

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

New feature

Backend

• Added the Document Builder service.

Plugins

• Added the possibility to automatically start the plugins.

Fixes

All editors

• Updated the interface translations.

Document Editor

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

Spreadsheet Editor

• Fixed the issue with loading the table styles.

Presentation Editor

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

New feature

Integration example

• Added support for the OpenDocument Flat Document file type.

Fixes

All editors

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

Conversion

• Fixed the issue with saving changes in HTML files.

RPM

• Fixed the problem while working with SELinux enabled.

Windows

• Migration to 64-bit Node.js.

New features

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

x2t

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

Fixes

Document Editor

• Fixed a large number of various bugs.

Spreadsheet Viewer

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

x2t

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

Windows-only release

Fixes

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

New features

Spreadsheet Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Document Editor

• Removed saving for the show snap lines option.

Mobile Presentation Editor

• Removed saving for the show snap lines option.

x2t

ODT

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

TXT

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

XLS

• Fixed the custom shape for the connectors.

ODS

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

PPTX

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

PPT

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

Document Builder

• Fixed the problems with printing and saving to PDF.

New features

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

x2t

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

Fixes

Spreadsheet Editor

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

Fixes

Rebranding

• Fixed the problems with the white-label logos.

New features

Document Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

• Fixed crash on Windows Server 2008 R2.

Fixes

All editors

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

Back-end

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

New features

Document Editor

• Added the Kazakh language for the spellchecker.

Docker installation

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

Fixes

Document Editor

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

New features

Plugins

• New plugins: Photo Editor and Document Templates.

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile web editors

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

Back-end

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

DOCX

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

document-server-integration

• Fixed the problem with the Go Back button.

Windows installation

• Fixed the problem with downloading the binaries from SourceForge.

Fixes

Spreadsheet Editor

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

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile web editors

• Completely new mobile web editors.

Back-end

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

x2t

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

  DOC

  • Support for the page backgrounds.

  XLS

  • Support for data validation;
  • Support for decryption.

  ODF

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

  RTF

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

Plugins

• A lot of new plugin features.

Fixes

Document Editor

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

Spreadsheet Editor

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

New features

Editors

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

Fixes

Back-end

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

Fixes

Embedded viewers

• Fixed the default top position for the toolbar.

Licensing

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

Back-end

• Fixed the problem with JWT access tokens.

New Features

Spreadsheet Editor

• The Polish language translations for functions.

Fixes

Spreadsheet Editor

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

Fixes

Spreadsheet Editor

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

Plugins

• Allowed the interface customization using the plugins.

Back-end

• Minor fixes for logging and status codes.

Fixes

All Editors

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

Spreadsheet Editor

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

Document conversion

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

Back-end

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

Fixes

All Editors

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

Presentation Editor

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

Back-end

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

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

Fixes

Spreadsheet Editor

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

Presentation Editor

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

Document conversion

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

Licensing

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

Fixes

Presentation Editor

• Fixed the problem with opening password-protected presentations.

Fixes

Document Editor

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

Spreadsheet Editor

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

x2t

• Improved compatibility with the DOC format.

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

Fixes

Spreadsheet Editor

• Fixed Document Server issue #63.

x2t

• Fixed Document Server issue #55.

Fixes

License

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

Fixes

Editors

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

New Features

Editors

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

Fixes

Editors

• Fixed copy-paste on MacOS Sierra.

Plugins

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

Fixes

Back-end

• ipfilter can use dns to lookup.

New Features

Plugins

• Sample plugins are enabled by default.

New Features

Back-end

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

Editors

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

Changes

• Improvements in opening of all supported formats.

Fixes

• A lot of small bugfixes in all product modules.

Changes

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

Fixes

Spreadsheet Editor

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

document-server-integration

• Minor fixes.

New features

• Added permanent Fail2Ban ignoreip section for docker containers and its gateway;
• Added the possibility to create sieve rules for users inside /var/vmail/sieve/;
• Added new extension to sieve: sieve_extensions -> editheader;
• Exposed port 4190 for ManageSieve service;
• Added the possibility to run an external script from the /var/vmail/external.sh or /app/onlyoffice/MailServer/data/external.sh path;
• Changed the default FIRST_DOMAIN parameter;
• Replaced the hard-coded password used for the first mailbox with a random one;
• Removed old useless descriptions for iRedMail administrator console path;
• Added backticks to the 'CREATE DATABASE' commands;
• Added the possibility to send mail messages from alias_domain, alias_address and full alias;
• Added the imapsync command;
• Added the new Python scripts allowing to create mailboxes, change password and run imapsync batch in /usr/src/iRedMail/tools/scripts folder inside the onlyoffice-mail-server container;
• Added the Python PIP manager and installation requirements.

Bug fixes

• Fixed the bug with mailbox not being removed when using third level domain (issue: wrong domain regex);
• Fixed the bug with the Cannot load 1024-bit DH parameters from file /etc/pki/tls/dhparams.pem warning;
• Fixed the bug with the No such file or directory being shown in many cases;
• Fixed the bug with the ECHO_INFO: command not found warning.

Runtime

• Updated OpenSSL to the latest version (1.0.2).

Runtime

• Fixed the issue when the amavisd-new interface could not start without the properly configured IPv6.

Connection Settings

• Added page to the Settings for the integration of Community Server (Windows version) with Mail Server.

Installation Script

• Fixed the error shown if the mail domain is not specified, now Mail Server will not be installed if this is the case.

Refactoring

• Removed version from the iRedMail folder;
• iRedMail completed with commits from v.0.9.2;
• Deleted unused packages from iRedMail;
• Added the SpamAssassin setup with initial bayes_tokens.

Runtime

• Fixed the incorrect MySQL server name in the config;
• Fixed the issue with the config section duplication when starting the Docker container;
• Fixed the issue with sending mail to a group/alias address;
• Fixed the startup API issue.

Logging

• Fixed logging during the installation.

Networking

• Fixed the fail2ban and iptables issue when starting Docker in a network mode;
• Fixed the issue with Mail Server on an external physical server.

Settings

• Redesigned Mail Server settings page.

Mail Server

• Mail Server for Docker first release.

Bug fixes

• Bug Fixes & Performance Improvements.

General

• Control Panel is available in the free Community version with all settings excepting the editors logo replacement;
• Added the vsyscall check to the installation scripts when installing Mail Server on Debian with kernel 4.18.0 and later;
• Redesign of the navigation menu: added Common and Portal settings sections, added icons to menu items;
• Added the advanced rebranding page in the Common Settings;
• Added the possibility to reindex the full-text search;
• Updated node.js, updated packages (transition to samlify for SSO);
• Added the Encryption at rest block in the Storage section;
• Added the Private Room section for the server version only;
• Added the upgrade page with a proposal to upgrade to Enterprise Edition;
• Added the activate page with a possibility to upload a license file;
• Added the HideAuthPage option to the SSO settings to hide the authorization page. When the HideAuthPage option is enabled, an automatic redirect from the authorization page to the SSO service will occur.

LDAP

• Added the Sign in to domain option on the authorization page.

Single Sign-on

• Transition to the new samlify library;
• Added the HideAuthPage option to the SSO settings to hide the authorization page. When the HideAuthPage option is enabled, an automatic redirect from the authorization page to the SSO service will occur.

LDAP

• Added more fields mapped for the users loaded via LDAP: user photo, birthday, contacts, primary phone number;
• Added the setting to autosync LDAP on schedule;
• Added the possibility to give administrator rights to the user group at the portal via LDAP;
• Updated the rules for LDAP users.

LDAP

• Fixed the Server internal error error when using the groups enclosed inside each other in the AD (bug #37414).

Single Sign-on

• Fixed the issue when the user data between the Service Provider and the portal was transferred via HTTP only, even when HTTPS was enabled.

Single Sign-on

• Fixed the Invalid ssoConfig error which occurred when the link to the IdP contained the question mark '?', e.g.: IdP Single Sign-On Endpoint URL: https://accounts.google.com/o/saml2/idp?idpid=777777;
• Fixed the Invalid authentication token error which prevented from adding a user to the portal using the AD FS, in case the + or - characters were present when sending the encrypted data.

General

• Added the changelog for Control Panel and link to it;
• Fixed the bug when JWT parameters were not sent when updating Document Server(bug #36270);
• Fixed the bug when Audit Trail heading was present at the login history page (bug #36026);
• The current machine is now checked for being linked with the domain name for multiple portals.

LDAP

• Fixed the bug with the LDAP Domain not found error which occurred if the DN record had no DC records (the users with Sun/Oracle DS were affected); now if the LDAP domain could not be specified, the LDAP domain will acquire the unknown value or the ldap.domain value from the web.appsettings.config configuration file;
• Fixed the bug with the Sizelimit Exceeded error when trying to get more than 1000 users from the Active Directory;
• Increased the login speed with the Group Membership setting enabled;
• Added additional logging;
• Fixed the bug with LDAP operation hanging when using Mono v5.2.0 and older;
• Fixed the bug with the error when trying to login using the email address entered in the fields different from the Mail Attribute;
• Fixed the bug occurring in the enclosed groups, when the users were displayed not in all groups.

General

• Added the documentserver-prepare4shutdown.sh script launch when updating the document-server for the correct edited document saving.

LDAP

• Dramatically changed LDAP integration, migrated to the single library for the work with LDAP (Novell.Directory.Ldap.NETStandard, Nuget, MIT);
• Login and email are now split into two separate fields;
• Added the support for big data;
• Increased the work speed via the LDAP protocol (the connection to the server and receiving the data is now made once per session, added the limits when only a certain number of results is necessary, fixed the slow login for bit data, removed the sorting out used to find the SID parameter);
• Fixed the user re-creation issue;
• Fixed the duplicate username issue;
• Fixed the already existing email issue;
• Replaced the LDAP user deletion with account deactivation (for further data migration and data safety);
• Instead of re-creating a user with an unknown SID but an existing email the data is updated;
• Added the attempt to save the correct UserName/Login in case a similar one is already taken on the portal.

Single Sign-on

• Added the AD FS support;
• Replaced the Single Sign-on link at the authorization page with the customizable button, added the button customization to the SSO setting of the Control Panel.

HTTPS

• Added the support of letsencrypt service for the domain certificate generation.

Single Sign-on

• Added the new sso.auth service;
• Added the new SSO settings page;
• Added the support for Shibboleth.

General

• The Control Panel migrated from MVC to Node.js.

LDAP

• Added LDAP synchronization for users and groups when saving the settings, after login and using the Sync button;
• Changed email formation for LDAP users;
• Fixed the problem of creation of users with invalid emails;
• Fixed the problem of duplicate users;
• Added icons and hints to the users in the list for the admin;
• Blocked for editing the user profile fields imported using LDAP;
• Added the real LDAP password saving to the database during login in case LDAP Auth is disabled, now the LDAP users will become common portal users when LDAP Auth is disabled;
• Added new API Settings method - Sync LDAP;
• Added new translations;
• Bug fixes.

Version for Windows

• Made changes at the Update page for the Control Panel for Windows;
• Updates are performed using the downloaded installation packages for each module.
• The current installed component version numbers are obtained via API request to the Community Server.
• The new versions available for download are obtained via the request to the https://download.onlyoffice.com/install/windows/updates.txt file, where all the latest component version numbers and links for their download are stored in the JSON format.