Installing Community Edition for Windows on a local server

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 http://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

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 (#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

• Add 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 (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 (DocumentServer#107 bug);
• Fixed the issue when the COUNTIF function ignored TRUE and FALSE parameter (DocumentServer#151 bug);
• 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, DocumentServer#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, DocumentServer#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 (DocumentServer 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 version

• 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 issue #63.

x2t

• Fixed 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 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.

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.