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.

To provide a more secure way to store, edit and co-edit documents in the cloud, we implemented the end-to-end encryption feature based on the blockchain technology. Currently, this option is available in test mode. To learn more why we use blockchain and what are the advantages of using this technology, you can refer to this article.

Generally, to co-edit documents securely, each co-author should

install and launch the latest version of the Desktop Editors with the end-to-end encryption support (version 5.2.7 and later),

enable the end-to-end encryption mode

connect to the ONLYOFFICE cloud via the Desktop Editors interface.

The Community Server is required to ensure sharing files and access rights management. You can use both the SaaS and server versions (starting from Community Server v.9.6.4 and Document Server v.5.2.3).

Step 1. Enable the end-to-end encryption mode

Launch Desktop Editors. In the main program window, switch to the Settings tab. Click the Test end-to-end encryption switcher. After that, the End-to-end encryption tab will be available at the left sidebar.

Open the End-to-end encryption tab. First you need to create an account in our test blockchain network. Please note that currently this network is intended for testing purposes only.

Click the Create an account button. In a new window that opens, you can see a Mnemonic phrase which is used to generate a key pair. Keep it in a safe place as it is the only way to unlock your blockchain account. This might be necessary if you forgot your account password, or want to access your existing account from another local machine, or want to switch between two your accounts.

Specify your new account Password and confirm it in the corresponding fields. The password should contain at least 8 characters. This password will be used to enable the encryption mode during the next sessions.

this password is also used to protect the .docx file that contains the mnemonic phrase corresponding to your current blockchain account. The file is stored on your local machine and can be found here:C:\Users\<currrent_user>\AppData\Local\ONLYOFFICE\DesktopEditors\data\sdkjs-plugins\advanced_crypto_data.docx

When ready, click the Create account button. Now the encryption mode is enabled.

To enable the encryption mode during the next sessions, open the End-to-end encryption tab at the left sidebar in the main program window and click the switcher on the top or use the I already have an account link below. The Secure Login window opens where you need to specify your blockchain account password and click the Log in button.

currently, you can create an unlimited number of accounts. But documents encrypted using one of the accounts cannot be accessed from a different account. If you have created several accounts, you can use the Forgot password? link, then enter your mnemonic phrase that corresponds to the necessary account and specify a new password to restore access to the account.

Important
If you forgot the mnemonic phrase, there is no possibility to restore access.

Step 2. Connect to the ONLYOFFICE cloud

Before you start sharing and co-editing encrypted documents, every participant of the co-editing process must

enable the end-to-end encryption mode in the Desktop Editors,

connect to the ONLYOFFICE cloud via the Desktop Editors interface.

When a user connects to the ONLYOFFICE cloud for the first time, the user’s public key is stored to the cloud office database. The user’s public key will be used for the document password encryption if somebody wants to share a file with the user. Once all the participants’ public keys are stored in the base, the sharing and co-editing processes can be performed in the secure end-to-end encryption mode.

To connect to the ONLYOFFICE cloud, switch to the Connect to cloud tab. Press the ONLYOFFICE button and specify your web office address in the new window. Click the Connect now button and specify the credentials used to access your cloud office account.

For more detailed information on how to connect to your cloud office, you can refer to the corresponding instructions if you are using the SaaS version or server version.

Step 3. Share and co-edit encrypted documents in the cloud

When you connected to the ONLYOFFICE cloud via Desktop Editors with the end-to-end encryption mode enabled, you can encrypt documents in the cloud to store them securely. A document becomes encrypted once it is saved for the first time in the encryption mode. During saving the file you should see the “Saving encryption data to blockchain” message.

Encrypted documents stored in the ONLYOFFICE cloud are marked with the icon in the file list.

Once the encryption data are saved to blockchain, you can share the encrypted file with other cloud office users.

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

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

by default, Full Access is selected for each particular user. If necessary, change the permission details selecting one of the available options from the drop-down list next to the person name: Full Access, or Deny Access. When ready, click Save at the bottom of the Sharing Settings window.

in the encryption mode, there is no possibility to provide access to the file via an external link.

When the user you shared the file with opens the document using the ONLYOFFICE Desktop Editors with the end-to-end encryption mode enabled, the password is not required, as it is automatically decrypted with the user’s private key.

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