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

Kseniya Fedoruk - Jun 21 '23 - - Dev Community

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"
        },
        ...
    ]
});
Enter fullscreen mode Exit fullscreen mode

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"
Enter fullscreen mode Exit fullscreen mode

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.

Debugging Document Builder

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

Useful links

What’s new in ONLYOFFICE Docs 7.4

ONLYOFFICE for developers

API changelog

Get ONLYOFFICE Docs Developer Edition

Download Document Builder

. . . . . . . . . . . . . .
Terabox Video Player