ONLYOFFICE Docs 7.0: online forms, password protection in spreadsheets, collaboration improvements and more

Great news, everyone!

The latest version of the open-source office suite comes with plenty of new features allowing you to create documents with fillable fields, protect sheets and workbooks with a password, and make the most of improved collaboration and usability.

Create fillable forms online

Starting from version 7.0, you can create fillable forms online. This brand-new functionality allows you to automate your electronic document workflow making it possible to create and fill out quickly various kinds of documents, e.g. legal agreements, contracts, reports, admission forms, questionnaires, etc.

Using fillable fields of various types, you can create forms from scratch or take an existing DOCX document as a basis, edit and collaborate on them with other users in real time. A fillable form can be saved as a standard PDF file or as OFORM so that you can share and fill it out online. This functionality is very similar to the standard content controls but offers more advanced field properties and customization options.

Read this post to find out more about ONLYOFFICE forms and how they work.

Where to find: Top toolbar -> Forms tab*

*The tab appears only when you open a DOCXF (special format for editing forms) or OFORM file.

Protect workbooks and sheets with a password

With ONLYOFFICE Docs v7.0, you can make your work with spreadsheets more secure. The newest version allows you to protect separate sheets and workbooks with passwords.

Where to find: Top toolbar -> Protection tab -> Protect Workbook/Protect Sheet

Open and save query tables in spreadsheets

ONLYOFFICE Docs v7.0 comes with support for query tables. A query table allows you to prepare data for reporting and analysis by combining data from one or more tables in a spreadsheet. Now you can open spreadsheets with query tables and save them without losing any data.

Make use of the new editing features in documents

Hyperlink autcorrection. Now you can choose if the ONLYOFFICE document editor should replace links and local paths with hyperlinks automatically.

Where to find: Advanced settings -> Spell checking -> AutoFormat as you type

Data from local files and URLs for Mail merge. The Mail merge feature, which allows you to create a batch of personalized documents for each recipient, now supports local files and URLs.

Where to find: Home tab -> Mail Merge -> From File/From URL/From Storage

Add transitions and play animations in presentations

New Transitions tab. ONLYOFFICE Docs v7.0 makes it easier to add and edit transitions on your slides. Everything you need can be found now in one place — on the newly added Transitions tab on the top toolbar. You can choose between different transition types, adjust their parameters and settings with a couple of clicks without getting distracted by other fields and slide properties.

Where to find: Top toolbar -> Transitions tab

Showing animations. Now when you play your slides that contain animations, the ONLYOFFICE editor starts to play all the animations automatically.

Saving presentations to PNG and JPG. The newest version of the ONLYOFFICE presentation editor gives you one more option to save your slides. Now you can choose between PNG and JPG formats.

Where to find: File tab -> Save Copy As…

Hyperlink autcorrection. Like in text documents, now you can choose if the ONLYOFFICE presentation editor should replace links and local paths with hyperlinks automatically.

Where to find: Advanced settings -> Spell checking -> AutoFormat as you type

Collaborate more conveniently

Version History in spreadsheets. The ONLYOFFICE spreadsheet editor now comes with the version history feature so that users can navigate through their previous drafts and restore them if necessary. By default, each draft is saved as a version when the last user closes the spreadsheet.

Where to find: File tab -> Version History

Comment sorting. Now you can quickly sort comments in a text document, spreadsheet or presentation, which makes it easier to work with comments left by different users at different times. For example, you can view all the comments in chronological order, from the newest to the oldest and vice versa. Also, you can sort the comments by author alphabetically using two available options — A to Z and Z to A.

Where to find: Click Comments on the left-side panel -> Sort comments

Two display modes for reviewing text documents. Version 7.0 lets you choose between two display modes when reviewing changes made by other co-authors:

• show changes in balloons when you click them;
• show changes in tooltips when you hover your mouse over them.

Where to find: File tab -> Advanced settings -> Track Changes Display

Ability to see other users’ selection. When co-editing spreadsheets with other people in real time, you can see their selections marked with different colours.

Enjoy the enhanced usability

Dark mode for the text editor. This feature prevents eye strain and improves readability in half-light environments. When the mode is on, a light colour text is presented against a dark screen, which significantly reduces the light emitted by devices.

Where to find: Click View settings under your user name in the upper right corner -> Dark mode

Keyboard shortcuts to quickly access what you need. ONLYOFFICE Docs v7.0 makes it easier to work with documents, spreadsheets and presentations settings by means of keyboard shortcuts. When you press Alt in any editor, you will see tooltips in the form of shortcut buttons that allow you to quickly access the required tool, like copy/past actions, font size, zoom options, etc.

Where to find: Press the Alt key

New zoom options in all the three editors. In addition to the existing scaling options, documents, spreadsheets and presentations can now be scaled up to 500%. Scaling is applied automatically in accordance with the settings of your browser or operating system.

Open-source all the way

With the release of Docs v7.0, ONLYOFFICE opens the source code of the professional editing features, such as document comparison, content controls and sheet views for spreadsheets, and makes them available in all solutions. Previously, all these features were exclusively accessible on a paying basis. Today, their source code is open for everyone on GitHub.

The newly added fillable forms are also part of the open-source solutions. All this makes ONLYOFFICE open as never before.

Watch the video overview

Watch the most important updates from version 7.0 in this video:

Download ONLYOFFICE Docs v7.0

The self-hosted version of ONLYOFFICE Docs 7.0 is already available, including Docker, deb, rpm and exe packages. Snap will be released a bit later.

DOWNLOAD NOW

In cloud solutions, the new version will be available a bit later.