Version 6.2 of ONLYOFFICE editors is released with data validation and digital signatures
The new version of the open-source office suite brings more features to spreadsheets and enhanced security
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.
The developers also added new functions to spreadsheets:
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.
Website — https://www.onlyoffice.com/
Online version source code — https://github.com/
Desktop version source code — https://github.com/
All available integrations — https://www.onlyoffice.com/