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.

Conversion

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.

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

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.

Many other minor and major bugfixes.

Version 4.2.2

Release date: 02/16/2017

Fixes

All Editors

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

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

Fixed the problems with copy-paste functions.

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 wrong order of elements in equations (bug #34029).

Fixed entering the characters with diacritical symbols (bug #33908)

Fixed the horizontal scroll when using a trackpad (bug #27197)

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

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

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

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.

Version 4.2.1

Release date: 12/20/2016

New Features

All Editors

Added the possibility to set a dash type for shapes;

Better support of HiDPI systems.

Document Editor

Added the possibility to open and edit footnotes;

Ability to insert number of pages into the document;

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 insert equations in Presentation Editor.

Fixes

Document Editor

Fixed the broken Insert number of pages button;

Fixed the problem with the last hieroglyph duplicate;

Fixed the problem with changing the chart type from 2D to 3D.

Spreadsheet Editor

Fixed the problem with an empty cell when changing sparklines.

x2t

Improved compatibility with the DOC format.

After you have installed Desktop Editors on your computer, you can easily connect the program to your Enterprise Edition server so that you can use all the product capabilities such as collaborative editing, reviewing, commenting and communicating via the built-in chat.

If you are using your Enterprise Edition on a local network, and the users are accessing your server using the local network only, an Internet connection is not required. If you are using the Enterprise Edition over the Internet, an Internet connection is required for connecting to your server, as well as for real-time co-editing.

Step 1. Install Enterprise Edition

If you have not yet installed Enterprise Edition, the easiest way to start an instance of Enterprise Edition is to use Docker. Alternatively, you can install Enterprise Edition from RPM/DEB packages. If you are using Windows, please refer to the corresponding installation instructions.

The instructions on how to configure Enterprise Edition are available here.

Step 2. Connect to your server

To connect Desktop Editors to your server, perform the following actions:

Switch to the Connect to cloud section at the left side panel of the main program window.

Click the ONLYOFFICE button. Alternatively, you can use the Connect now link at the bottom.

The Connect to cloud office window opens with the ONLYOFFICE option selected.

in the Cloud office URL field, enter your portal address in the form yourdomain.com or https://yourdomain.com. It's also possible to specify the IP address of the machine where Enterprise Edition is installed. When ready, click the Connect now button.

The ONLYOFFICE server sign in page will open in a new tab of the Desktop Editors interface.

Specify your email and the password you use to access your account,

Click the Sign In button.

Your portal Documents module will open.

Step 3. Manage documents on your server

Once you connect Desktop Editors to your server, you can switch between the available sections (My Documents, Common Documents, Shared with Me, Project Documents, Recycle Bin) manage your files stored on the portal, create or upload new ones, view, share and edit them together with other portal users or external users.

To be able to edit a file collaboratively, share it with other portal users or provide access to the file via an external link. If you wish to edit files with external users outside of your local network, the portal should be accessible over the Internet.

click the Share button to the right of the necessary document - the Sharing Settings window opens,

click the Add Users or Add Groups button to open the user/group list, then check the users/groups you want to share the document with and click Save,

change the permission details for each particular user/group selecting one of the available options from the drop-down list next to the person/group name: Full Access, Review (this option is available for the .docx files only), Read Only, or Deny Access. When ready, click Save at the bottom of the Sharing Settings window.

to provide access to the file via an external link, turn on the External link access switcher, click the Read only link, select the necessary permissions: Full Access, Review (this option is available for the .docx files only), Read Only, or Deny Access. When ready, copy the link and close the Sharing Settings window.

For more details on how to share files you can refer to this instruction.

Step 4. Manage your connected accounts

Click the logo in the upper left corner of the Desktop Editors interface to return to the main program window, then switch to the Connect to cloud section to view the Connected clouds list. Right-click on a connected portal and use one of the available contextual menu options:

Open - to switch to the corresponding portal tab, if you are already logged in to this account, or to open the Connect to cloud office window, if you are not currently logged in (in such a case, you will need to enter your credentials),

Logout - to exit from your account,

You can also click the icon to the right of the account to exit from it.

Remove from list - to disconnect the selected account and remove it from the list.

If you have several accounts or portals, use the Add cloud button to connect one more account.

Download
No more Microsoft
All main platforms support:
Windows, Linux and Mac OS