Version 6.2 of ONLYOFFICE editors is released with data validation and digital signatures

RIGA, Latvia - March 18, 2021 - PRLog -- The developers ONLYOFFICE, an open-source office suite, have released version 6.2 with table of figures, new features in spreadsheets, and document protection in the desktop app.

Data validation to restrict the entered data type

The feature helps you restrict the type of data entered into a cell. The most popular use case for this feature is creating drop-down lists. They limit the entry choices for a selected cell — users just pick an item from a list which speeds the process and reduces the risk of errors.

Slicers to visualize filtering in pivot tables

The spreadsheet editor now has Slicers for pivot tables. This functionality provides quick filtering and helps you indicate the filtering state to understand what data is currently displayed.

Custom number format

If the existing number formats don't meet your needs, starting from version 6.2 you can change the way the values show up by creating and applying custom number formats.

New functions

The developers also added new functions to spreadsheets:

• GROWTH to calculate predicted exponential growth by using existing data.
• TREND to calculate a linear trend line.
• LOGEST to calculate an exponential curve that fits the data and get an array of values that describes the curve.
• UNIQUE to get a list of unique values from the specified range.
• MUNIT to get the unit matrix for the specified dimension.
• RANDARRAY to get an array of random numbers.

Table of figures to organize illustrations

In ONLYOFFICE 6.2, it's possible to create a table of figures. Much like a table of contents, it allows to list and organize the tables, equations, images, charts, and shapes.

About ONLYOFFICE editors

ONLYOFFICE Docs is an office suite that includes editors for text documents, spreadsheets, and presentations.

The free community version is distributed under AGPLv3 license. There's also a paid Enterprise version with pro functionality (content controls, document comparison), tech support, and clustering capabilities.

Community or Enterprise versions can be used within ONLYOFFICE Workspace, an open-source productivity solution, or integrated with popular sync and share apps, such as ownCloud, Nextcloud, Seafile, etc.

ONLYOFFICE desktop app is totally free and is distributed under AGPLv3 license.

Useful links

Website — https://www.onlyoffice.com/

Online version source code —  https://github.com/ONLYOFFICE/DocumentServer

Desktop version source code — https://github.com/ONLYOFFICE/DesktopEditors

All available integrations — https://www.onlyoffice.com/all-connectors.aspx