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.

Core technology

Documents stored in the ONLYOFFICE cloud and data transferred during collaboration are protected with the symmetric encryption algorithm AES-256. To ensure even more secure work with documents in the cloud and a growth in trust to the cloud solutions in general, we implemented a new end-to-end encryption functionality based on the blockchain technology.

We use blockchain as a core technology due to its reliability and safety. Initially, blockchain is used to transfer cryptocurrency securely. We decided to use this tried and trusted technology to store and transfer other digital objects, namely document passwords.

Security is laid in the blockchain technology due to the decentralized architecture that ensures the data integrity and accuracy. Data are stored in a decentralized network and cannot be stolen, forged etc. Therefore, secure work on documents with ONLYOFFICE Desktop Editors is guaranteed by the core technology itself, not by the software developer/service provider.

Implementation in ONLYOFFICE Desktop Editors

We launched own test blockchain network based on ParityEthereum with support for the Proof-of-Authority consensus engine and created own Ethereum light client by integrating the web3.js library into the Desktop Editors to ensure the interaction with the blockchain network.

To start working, users should register in our test blockchain network and get the identifying address and a key pair used for encryption/decryption. ONLYOFFICE Community Server is also required to ensure sharing files and access rights management.

at the page with the blockchain account info, the cryptocurrency amount is displayed. This cryptocurrency is not the same as Ethereum (ETH), this is our internal cryptocurrency that can be used for the purposes of the encryption testing only (it is used to pay for the recording data on the blockchain).

Basic encryption concepts

Once a user creates an account in our blockchain network, he/she obtains a unique identification address on the network and a key pair: a public key and a private key. The public key is stored on the blockchain and used to encrypt the information about a document password, the private key is stored on the user’s local machine and used for decryption. This encryption method is called an asymmetric one as two different keys are used for encryption and decryption. The encryption and decryption are performed on the client side.

Alice shares a file with Bob, a document password that allows to open the file is encrypted with the Bob’s public key and can only be decrypted with the Bob’s private key stored on his local machine.

This method guarantees that no one, except the file owner who shared it and the recipient who was granted access to the file, can get access to the document contents. I.e. third parties, including the service provider, cannot access contents of the documents stored in the cloud.

Password protection in ONLYOFFICE

When a document is saved with the enabled encryption mode, the document is protected with a strong password which is generated automatically. The password is encrypted with the user’s public key and recorded into the blockchain. There is no the necessity for users to create, remember and store passwords as well as hand them over to collaborators in case the file should be co-edited.

If a user works on the encrypted file using Desktop Editors with the end-to-end encryption mode enabled, the encrypted file will be decrypted automatically with the user’s private key and the document password is not required.

If the encrypted file is uploaded to a different cloud storage, or stored on a local machine, when somebody tries to open the file using other application, a document password is required. As the password is stored in the blockchain in the encrypted form and is not directly accessible to the user, the encrypted file cannot be opened using other applications.

To find out practical guidance on how to encrypt documents and co-edit them securely you can refer to this article.

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