ONLYOFFICE Docs 7.4 for developers: AI helper, drawing, API updates, and more

#update #onlyoffice #opensource #api

The latest version of ONLYOFFICE Docs for developers is already available with lots of new features and API enhancements.

ONLYOFFICE Docs Developer Edition v.7.4

Freehand drawings via the Draw tab
Radar charts to illustrate multivariate data through graphs
Saving graphic objects as pictures
Saving docs and sheets as PNG/JPG images
Ability to combine documents
Limiting edit access to protected ranges
New formulas: SEQUENCE, XMATCH, EXPAND, FILTER, ARRAYTOTEXT, SORT
Improved Pivot tables
Page Break Preview
Further interface scaling options: 250/300/350/400/450/500%

Detailed changelog can be found on GitHub.

Support for more file formats

Version 7.4 brings support for new file formats:

documents — mhtml, stw, sxw, wps, wpt;
spreadsheets — et, ett, sxc;
presentations — dps, dpt, sxi.

Further parameters for the setUsers method

The setUsers method sets a list of users to mention in the comments or grant the access rights to edit the specific sheet ranges.

The newly added users.id field defines the identification of the user. It is used only for protecting the sheet ranges when granting editing rights to the specified user.

And the newly added c parameter defines the operation type from the onRequestUsers event. It can take one of the following values – mention or protect.

docEditor.setUsers({
    "c": "protect",
    "users": [
        {
            "email": "john@example.com",
            "id": "78e1e841",
            "name": "John Smith"
        },
        {
            "email": "kate@example.com",
            "id": "F89d8069ba2b",
            "name": "Kate Cage"
        },
        ...
    ]
});

Support for the Chinese dameng database

Among the supported database types there is the Chinese dameng. To connect it, change the database type to dameng. For example, for Docker you will need to adjust the DB_TYPE parameter.

API enhancements for plugins

Thanks to the extended API, plugins can now have as many windows as you want (for example, you can execute a custom script in a separate window) and be dynamically embedded in the context menu of the editors. It gives you more freedom and enhances the number of possible usage scenarios for plugins.

One of the brightest examples here is the updated ChatGPT plugin. From now on, it provides more useful features such as word analysis, image generation, text summarization and keyword generation, translation, etc.

With the pluginsmanager server utility admins are now able, when a manual installation is required, to install or uninstall plugins with a single command line, instead of copying the folders, e.g.:

cd /var/www/onlyoffice/documentserver/server/tools/
./pluginsmanager --directory="/var/www/onlyoffice/documentserver/sdkjs-plugins" --install="zotero"

Full list of plugin API updates, new events and methods

API updates for Document Builder

It’s now possible to conveniently debug the Doc Builder JS core in the Chrome or Chromium browser.

Moreover, in the Document Builder API, lots of new characters, font, and range methods were added to the Spreadsheet API, as well as some other methods, including the following ones:

Full list of new DocBuilder methods