Artikel zum Thema:
Schließen
Changelog
Schließen
Hilfe-Center
Community

Installing Community Edition with additional script parameters

Enterprise Editionv.17.11 Community Server changelog

Version 9.5.0

Release date: 11/02/2017

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

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

Version 9.1.0

Release date: 07/03/2017

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.

Version 9.0

Release date: 04/08/2017

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.

Version 8.9.2

Release date: 12/05/2016

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;

Version 8.8

Release date: 03/09/2016

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.

Version 8.6

Release date: 08/02/2015

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.

Version 8.5

Release date: 03/26/2015

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

Version 8.1

Release date: 02/24/2015

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.

Version 8.0

Release date: 11/19/2014

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.

Version 7.7

Release date: 06/23/2014

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.

Version 7.6

Release date: 04/15/2014

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.

Version 7.5

Release date: 09/06/2013

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.

Version 7.4.1

Release date: 05/15/2013

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.

Version 7.4

Release date: 04/25/2013

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.
Document Server changelog

Version 5.0.4

Release date: 11/14/2017

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

Version 5.0.3

Release date: 11/02/2017

New features

Distribution

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

All editors

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

Plugins

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

Windows version

  • Added the Accept license dialog window to the installation.

Fixes

All editors

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

Document Editor

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

Presentation Editor

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

Embedded viewer

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

Backend

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

RPM

  • Fixed the SELinux usage with custom ports.

Plugins

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

Version 5.0.2 SaaS only

Release date: 10/13/2017

New feature

Backend

  • Added the Document Builder service.

Plugins

  • Added the possibility to automatically start the plugins.

Fixes

All editors

  • Updated the interface translations.

Document Editor

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

Spreadsheet Editor

  • Fixed the issue with loading the table styles.

Presentation Editor

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

Version 5.0.1 SaaS only

Release date: 10/05/2017

New feature

Integration example

  • Added support for the OpenDocument Flat Document file type.

Fixes

All editors

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

Conversion

  • Fixed the issue with saving changes in HTML files.

RPM

  • Fixed the problem while working with SELinux enabled.

Windows

  • Migration to 64-bit Node.js.

Version 5.0.0 SaaS only

Release date: 09/23/2017

New features

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

x2t

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

Fixes

Document Editor

  • Fixed a large number of various bugs.

Spreadsheet Viewer

  • Fixed the issue with the keys not working in IE11 (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.

Version 4.4.4

Release date: 09/13/2017

Windows-only release

Fixes

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

Version 4.4.3

Release date: 08/14/2017

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Version 4.4.2

Release date: 07/24/2017

New features

Spreadsheet Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

  • Fixed changing the presentation language if no shape was selected (bug #35231);
  • Fixed the columns in the placeholder (bug #35074);
  • Fixed the connector losing shape when moving shapes in a group (bug #35317);
  • Fixed disconnecting the connector after ungrouping (bug #35316);
  • Fixed the hidden markers for the connector on a chart and an image (bug #35300);
  • Fixed the cell link reference issue after the copy-paste operation (bug #35362, 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.

Version 4.4.1

Release date: 07/05/2017

New features

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

x2t

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

Fixes

Spreadsheet Editor

Version 4.3.6

Release date: 06/14/2017

Fixes

Rebranding

  • Fixed the problems with the white-label logos.

Version 4.3.5

Release date: 06/05/2017

New features

Document Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

  • Fixed crash on Windows Server 2008 R2.

Version 4.3.4

Release date: 05/16/2017

Fixes

All editors

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

Back-end

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

Version 4.3.3

Release date: 04/28/2017

New features

Document Editor

  • Added the Kazakh language for the spellchecker.

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

Version 4.3.2

Release date: 04/17/2017

New features

Plugins

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Web Editors

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

Back-end

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

DOCX

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

document-server-integration

  • Fixed the problem with the Go Back button.

Windows installation

  • Fixed the problem with downloading the binaries from SourceForge.

Version 4.3.1

Release date: 04/06/2017

Fixes

Spreadsheet Editor

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

Version 4.3

Release date: 04/03/2017

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Web Editors

  • Completely new mobile web editors.

Back-end

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

x2t

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

    DOC

    • Support for the page backgrounds.

    XLS

    • Support for data validation;
    • Support for decryption.

    ODF

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

    RTF

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

Plugins

  • A lot of new plugin features.

Fixes

Document Editor

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

Spreadsheet Editor

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

Version 4.2.11

Release date: 03/13/2017

New features

Editors

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

Fixes

Back-end

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

Version 4.2.10

Release date: 02/20/2017

Fixes

Embedded viewers

  • Fixed the default top position for the toolbar.

Licensing

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

Back-end

  • Fixed the problem with JWT access tokens.

Version 4.2.9

Release date: 02/14/2017

New Features

Spreadsheet Editor

  • The Polish language translations for functions.

Fixes

Spreadsheet Editor

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

Version 4.2.8

Release date: 02/06/2017

Fixes

Spreadsheet Editor

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

Plugins

  • Allowed the interface customization using the plugins.

Back-end

  • Minor fixes for logging and status codes.

Version 4.2.7

Release date: 02/01/2017

Fixes

All Editors

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

Spreadsheet Editor

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

Document conversion

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

Back-end

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

Version 4.2.5

Release date: 01/16/2017

Fixes

All Editors

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

Presentation Editor

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

Back-end

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

Version 4.2.4

Release date: 01/09/2017

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

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

Version 4.2.3

Release date: 12/23/2016

Fixes

Spreadsheet Editor

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

Presentation Editor

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

Document conversion

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

Licensing

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

Version 4.2.2

Release date: 12/21/2016

Fixes

Presentation Editor

  • Fixed the problem with opening password-protected presentations.

Version 4.2.1

Release date: 12/06/2016

Fixes

Document Editor

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

Spreadsheet Editor

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

x2t

  • Improved compatibility with the DOC format.

Version 4.2.0

Release date: 12/01/2016

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

Fixes

Spreadsheet Editor

x2t

Version 4.1.8

Release date: 11/03/2016

Fixes

License

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

Version 4.1.7

Release date: 11/01/2016

Fixes

Editors

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

Version 4.1.6

Release date: 10/26/2016

New Features

Editors

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

Version 4.1.5

Release date: 10/13/2016

Fixes

Editors

  • Fixed copy-paste on MacOS Sierra.

Plugins

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

Version 4.1.4

Release date: 10/07/2016

Fixes

Back-end

  • ipfilter can use dns to lookup.

Version 4.1.3

Release date: 09/28/2016

New Features

Plugins

  • Sample plugins are enabled by default.

Version 4.1.2

Release date: 09/22/2016

New Features

Back-end

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

Editors

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

Changes

  • Improvements in opening of all supported formats.

Fixes

  • A lot small bugfixes in all product modules.

Version 4.0.3

Release date: 08/04/2016

Changes

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

Version 4.0.2

Release date: 08/03/2016

Fixes

Spreadsheet Editor

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

document-server-integration

  • Minor fixes.
Mail Server changelog

Version 1.6.25

Release date: 07/03/2017

Runtime

  • Updated OpenSSL to the latest version (1.0.2).

Version 1.6.21

Release date: 04/26/2017

Runtime

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

Version 1.6.20

Release date: 12/13/2016

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.

Version 1.6.7

Release date: 06/22/2016

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.

Version 1.6.0

Release date: 03/09/2016

Settings

  • Redesigned Mail Server settings page.

Version 1.5.0

Release date: 04/20/2015

Mail Server

  • Mail Server for Docker first release.
Community Editionv.17.08 Community Server changelog

Version 9.5.0

Release date: 11/02/2017

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

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

Version 9.1.0

Release date: 07/03/2017

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.

Version 9.0

Release date: 04/08/2017

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.

Version 8.9.2

Release date: 12/05/2016

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;

Version 8.8

Release date: 03/09/2016

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.

Version 8.6

Release date: 08/02/2015

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.

Version 8.5

Release date: 03/26/2015

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

Version 8.1

Release date: 02/24/2015

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.

Version 8.0

Release date: 11/19/2014

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.

Version 7.7

Release date: 06/23/2014

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.

Version 7.6

Release date: 04/15/2014

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.

Version 7.5

Release date: 09/06/2013

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.

Version 7.4.1

Release date: 05/15/2013

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.

Version 7.4

Release date: 04/25/2013

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.
Document Server changelog

Version 5.0.4

Release date: 11/14/2017

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Backend

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

Version 5.0.3

Release date: 11/02/2017

New features

Distribution

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

All editors

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

Plugins

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

Windows version

  • Added the Accept license dialog window to the installation.

Fixes

All editors

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

Document Editor

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

Presentation Editor

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

Embedded viewer

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

Backend

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

RPM

  • Fixed the SELinux usage with custom ports.

Plugins

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

Version 5.0.2 SaaS only

Release date: 10/13/2017

New feature

Backend

  • Added the Document Builder service.

Plugins

  • Added the possibility to automatically start the plugins.

Fixes

All editors

  • Updated the interface translations.

Document Editor

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

Spreadsheet Editor

  • Fixed the issue with loading the table styles.

Presentation Editor

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

Version 5.0.1 SaaS only

Release date: 10/05/2017

New feature

Integration example

  • Added support for the OpenDocument Flat Document file type.

Fixes

All editors

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

Conversion

  • Fixed the issue with saving changes in HTML files.

RPM

  • Fixed the problem while working with SELinux enabled.

Windows

  • Migration to 64-bit Node.js.

Version 5.0.0 SaaS only

Release date: 09/23/2017

New features

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

x2t

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

Fixes

Document Editor

  • Fixed a large number of various bugs.

Spreadsheet Viewer

  • Fixed the issue with the keys not working in IE11 (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.

Version 4.4.4

Release date: 09/13/2017

Windows-only release

Fixes

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

Version 4.4.3

Release date: 08/14/2017

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Version 4.4.2

Release date: 07/24/2017

New features

Spreadsheet Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

  • Fixed changing the presentation language if no shape was selected (bug #35231);
  • Fixed the columns in the placeholder (bug #35074);
  • Fixed the connector losing shape when moving shapes in a group (bug #35317);
  • Fixed disconnecting the connector after ungrouping (bug #35316);
  • Fixed the hidden markers for the connector on a chart and an image (bug #35300);
  • Fixed the cell link reference issue after the copy-paste operation (bug #35362, 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.

Version 4.4.1

Release date: 07/05/2017

New features

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Plugins

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

x2t

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

Fixes

Spreadsheet Editor

Version 4.3.6

Release date: 06/14/2017

Fixes

Rebranding

  • Fixed the problems with the white-label logos.

Version 4.3.5

Release date: 06/05/2017

New features

Document Editor

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

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

  • Fixed crash on Windows Server 2008 R2.

Version 4.3.4

Release date: 05/16/2017

Fixes

All editors

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

Back-end

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

Version 4.3.3

Release date: 04/28/2017

New features

Document Editor

  • Added the Kazakh language for the spellchecker.

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

Version 4.3.2

Release date: 04/17/2017

New features

Plugins

Fixes

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Web Editors

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

Back-end

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

DOCX

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

document-server-integration

  • Fixed the problem with the Go Back button.

Windows installation

  • Fixed the problem with downloading the binaries from SourceForge.

Version 4.3.1

Release date: 04/06/2017

Fixes

Spreadsheet Editor

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

Version 4.3

Release date: 04/03/2017

New features

All editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Mobile Web Editors

  • Completely new mobile web editors.

Back-end

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

x2t

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

    DOC

    • Support for the page backgrounds.

    XLS

    • Support for data validation;
    • Support for decryption.

    ODF

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

    RTF

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

Plugins

  • A lot of new plugin features.

Fixes

Document Editor

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

Spreadsheet Editor

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

Version 4.2.11

Release date: 03/13/2017

New features

Editors

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

Fixes

Back-end

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

Version 4.2.10

Release date: 02/20/2017

Fixes

Embedded viewers

  • Fixed the default top position for the toolbar.

Licensing

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

Back-end

  • Fixed the problem with JWT access tokens.

Version 4.2.9

Release date: 02/14/2017

New Features

Spreadsheet Editor

  • The Polish language translations for functions.

Fixes

Spreadsheet Editor

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

Version 4.2.8

Release date: 02/06/2017

Fixes

Spreadsheet Editor

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

Plugins

  • Allowed the interface customization using the plugins.

Back-end

  • Minor fixes for logging and status codes.

Version 4.2.7

Release date: 02/01/2017

Fixes

All Editors

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

Spreadsheet Editor

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

Document conversion

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

Back-end

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

Version 4.2.5

Release date: 01/16/2017

Fixes

All Editors

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

Presentation Editor

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

Back-end

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

Version 4.2.4

Release date: 01/09/2017

Fixes

Document Editor

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

Spreadsheet Editor

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

Back-end

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

Version 4.2.3

Release date: 12/23/2016

Fixes

Spreadsheet Editor

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

Presentation Editor

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

Document conversion

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

Licensing

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

Version 4.2.2

Release date: 12/21/2016

Fixes

Presentation Editor

  • Fixed the problem with opening password-protected presentations.

Version 4.2.1

Release date: 12/06/2016

Fixes

Document Editor

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

Spreadsheet Editor

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

x2t

  • Improved compatibility with the DOC format.

Version 4.2.0

Release date: 12/01/2016

New Features

All Editors

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

Document Editor

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

Spreadsheet Editor

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

Presentation Editor

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

Back-end

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

Fixes

Spreadsheet Editor

x2t

Version 4.1.8

Release date: 11/03/2016

Fixes

License

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

Version 4.1.7

Release date: 11/01/2016

Fixes

Editors

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

Version 4.1.6

Release date: 10/26/2016

New Features

Editors

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

Version 4.1.5

Release date: 10/13/2016

Fixes

Editors

  • Fixed copy-paste on MacOS Sierra.

Plugins

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

Version 4.1.4

Release date: 10/07/2016

Fixes

Back-end

  • ipfilter can use dns to lookup.

Version 4.1.3

Release date: 09/28/2016

New Features

Plugins

  • Sample plugins are enabled by default.

Version 4.1.2

Release date: 09/22/2016

New Features

Back-end

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

Editors

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

Changes

  • Improvements in opening of all supported formats.

Fixes

  • A lot small bugfixes in all product modules.

Version 4.0.3

Release date: 08/04/2016

Changes

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

Version 4.0.2

Release date: 08/03/2016

Fixes

Spreadsheet Editor

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

document-server-integration

  • Minor fixes.
Mail Server changelog

Version 1.6.25

Release date: 07/03/2017

Runtime

  • Updated OpenSSL to the latest version (1.0.2).

Version 1.6.21

Release date: 04/26/2017

Runtime

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

Version 1.6.20

Release date: 12/13/2016

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.

Version 1.6.7

Release date: 06/22/2016

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.

Version 1.6.0

Release date: 03/09/2016

Settings

  • Redesigned Mail Server settings page.

Version 1.5.0

Release date: 04/20/2015

Mail Server

  • Mail Server for Docker first release.

Introduction

Community Edition is a paidfree version free for educational institutions of collaborative system developed to manage documents, projects, customer relationship and email correspondence, all in one place.

Community Edition is shipped in two main versions: as a virtual machine image, compatible with most popular virtual machine managing software, and as an automatic installation script for Linux operating systems with Docker installed. The script will set up Docker containers with all the components necessary for Community Edition correct work and is easy to run, manage and update.

After you download the Community Edition installation script, you might need to run it specifying some additional parameters, for example, if you want to install each component on a separate machine. Use the following command to display the list of all the available script parameters:

bash opensource-install.sh -h

You can find a short description and some usage examples for these parameters below.

Container name

Parameter Description
-cc, --communitycontainer community container name
-dc, --documentcontainer document container name
-mc, --mailcontainer mail container name
-cpc, --controlpanelcontainer control panel container name

These parameters can be used to assign a custom name to a container when running it. By default, the following names are used for the containers: onlyoffice-community-server, onlyoffice-document-server, onlyoffice-mail-server, onlyoffice-control-panel.

Example

bash opensource-install.sh -ims false -cc name1 -dc name2 -cpc name3
bash opensource-install.sh -ims false -cc name1 -dc name2

This will install all the Community Edition components without Mail Server. After the installation, the Community Server, Document Server and Control Panel containers will acquire the specified names (name1, name2, name3). Use the docker ps command to display all the running containers and verify that names have been acquired correctly.

Image name

Parameter Description
-ci, --communityimage community image name or .tar.gz file path
-di, --documentimage document image name or .tar.gz file path
-mi, --mailimage mail image name or .tar.gz file path
-cpi, --controlpanelimage control panel image name or .tar.gz file path

These parameters can be used to specify a name of the image that a container should be started from. The specified image should be stored in our official public repository on Docker Hub. If you have downloaded a .tar.gz archive from the Downloads page, you can also specify a path to this .tar.gz file stored on your machine.

Example

bash opensource-install.sh -ims false -ci onlyoffice4opensource/communityserver-ee -ids false -icp true
bash opensource-install.sh -ims false -ci onlyoffice/communityserver -ids false

This will run a container from the specified Community Server image stored in the repository as well as run a Control Panel container.

bash opensource-install.sh -ims false -ics true -ci "/home/user/onlyoffice4opensource-communityserver-ee_8.9.0.150.tar.gz" -ids false -icp true

This will run a container from the specified local .tar.gz file that contains the Community Server image as well as run a Control Panel container from the image stored in the Docker Hub repository.

Component version

Parameter Description
-cv, --communityversion community version
-dv, --documentversion document version
-mv, --mailversion mail version
-cpv, --controlpanelversion control panel version

These parameters can be used to install a certain component version if for some reasons you do not want to install the latest version available in the repository. By default, an image tagged as latest is used to run each component container.

Example

Open the Docker Hub repository in your browser, select the necessary component and go to the Tags tab to view all the tags available in the repository. Specify the version you want to install for the necessary components:

bash opensource-install.sh -ics true -cv 8.9.0.150 -ids false -icp true -cpv 1.6.0.52 -ims true -md "yourdomain.com"
bash opensource-install.sh -ics true -cv 8.9.0.150 -ids false -ims true -md "yourdomain.com"

This will install the Community Server 8.9.0.150 version, the Control Panel 1.6.0.52 version and the latest version of Mail Server as its version has not been specified explicitly.

Server IP

Parameter Description
-dip, --documentserverip document server ip
-mip, --mailserverip mail server ip
-mdbip, --mailserverdbip mail server db ip

These parameters can be used to connect the components if you install them on separate machines.

Example

bash opensource-install.sh -ics true -icp true -ids false -ims false -dip 192.168.3.202 -es false
bash opensource-install.sh -ics true -ids false -ims false -dip 192.168.3.202 -es false

This will install Community Server with Control Panel and connect it with Document Server installed on a different machine which has the 192.168.3.202 IP address.

Mail domain name

Parameter Description
-md, --maildomain mail domain name

This parameter allows to specify your own domain name that will be used for Mail Server.

Example

bash opensource-install.sh -md "yourdomain.com"

This will install all the Community Edition components including Mail Server with the yourdomain.com domain name specified.

Your domain that will be used for maintaining correspondence must be valid and configured for this machine (i.e. it should have the appropriate A record in the DNS settings that points your domain name to the IP address of the machine where Mail Server is installed).
In the command above, the "yourdomain.com" parameter must be understood as a service domain for Mail Server. It is usually specified in the MX record of the domain that will be used for maintaining correspondence. As a rule, the "yourdomain.com" looks like mx1.onlyoffice.com

Component update

Parameter Description Values Default
-u, --update use to update existing components true|false false

This parameter allows to install the latest versions of the necessary components if the corresponding components installed on your machine are outdated.

Example

bash opensource-install.sh -u true

This will consequently stop those containers that need to be updated, remove them and then run the latest versions of the corresponding Community Edition components. If the current component version coincides with the latest available one, such a container will not be affected. If you have skipped some components during the previous installation, they will also be skipped. The portal data should be picked up automatically.

Credentials

Parameter Description
-un, --username dockerhub username
-p, --password dockerhub password

These parameters are used in case we provide you credentials to access a test repository so that you can run containers from images stored in it.

Example

bash opensource-install.sh -md "yourdomain.com" -un username -p password

Component installation

Parameter Description Values Default
-ics, --installcommunityserver install community server true|false|pull true
-ids, --installdocumentserver install document server true|false|pull true
-ims, --installmailserver install mail server true|false|pull true
-icp, --installcontrolpanel install control panel true|false|pull true

These parameters allow to specify whether you need to install a certain component or not. They can be used if you want to install each component on a separate machine.

  • Use the true value to install a component.
  • Use the false value to skip a component installation.
  • Use the pull value to download a component without installing it.
Please do not skip Control Panel installation when installing Community Server, otherwise you will not be able to enter your license key after the installation is finished and add, for instance, Mail Server to your Community Edition instance.

Example

bash opensource-install.sh -ims false 

This will install all the Community Edition components without Mail Server.

bash opensource-install.sh -ics false -ids true -icp false -ims false -es true 
bash opensource-install.sh -ics false -ids true -ims false -es true 

This will skip the installation of Mail Server, Community Server and Control Panel and will install Document Server only.

Using a component as an external server

Parameter Description Values Default
-es, --useasexternalserver use as external server true|false false

This parameter is used in case you install components on separate machines.

  • Use the true value when installing Document Server and Mail Server on separate machines.
  • Use the false value when installing Community Server together with Control Panel on a separate machine.

Example

bash opensource-install.sh -ics false -ids false -icp false -ims true -md "yourdomain.com" -es true
bash opensource-install.sh -ics false -ids false -ims true -md "yourdomain.com" -es true

This will skip the installation of Document Server, Community Server and Control Panel and will install Mail Server only.

bash opensource-install.sh -ics true -icp true -ids false -ims false -dip 192.168.3.202 -es false
bash opensource-install.sh -ics true -ids false -ims false -dip 192.168.3.202 -es false

This will install Community Server with Control Panel and connect it with Document Server installed on a different machine.

Service count

Parameter Description
-svc, --servicecount number of services

This parameter allows to specify the number of the Redis monoserve services you want to use. By default, 2 services are used, but you can specify a greater value.

Example

bash opensource-install.sh -ims false -svc 4

Swap file creation

Parameter Description Values Default
-ms, --makeswap make swap file true|false false

This parameter allows to create a 6 Gb swap file. By default, the true value is specified, therefore you do not need to specify this parameter when running the script. The swap file will be created automatically.

Example

bash opensource-install.sh -ms false

If you have previously created a swap file, you can use this command so that not to create a swap file during the installation.

In case you run the script again without specifying the -ms parameter, it checks if the onlyoffice_swapfile is present. If the swap file already exists, the script will not create a swap file once again.

How to install server version using the provided script parameters
Schließen
Download Host on your own server Available for Docker,
Windows, Linux and virtual machines
Wer sich dafür interessiert hat,
hat auch das Folgende gelesen:
Schließen