ONLYOFFICE Docs 7.4 for developers: AI helper, drawing, API updates, and more
Tags: update, onlyoffice, opensource, api
Published: 2023-06-21 09:49:49

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](https://github.com/ONLYOFFICE/DocumentServer/blob/master/CHANGELOG.md#740).

{% embed https://youtu.be/ut4qh4-Vwd0 %}

## Support for more file formats

Version 7.4 brings support for new [file formats](https://api.onlyoffice.com/editors/config/#documentType):

- documents — _mhtml, stw, sxw, wps, wpt;_
- spreadsheets — _et, ett, sxc;_
- presentations — _dps, dpt, sxi._

## Further parameters for the setUsers method

The [setUsers](https://api.onlyoffice.com/editors/methods#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](https://api.onlyoffice.com/editors/config/events#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](https://github.com/ONLYOFFICE/Docker-Docs#available-%D1%81onfiguration-parameters).

## API enhancements for plugins

Thanks to the [extended API](https://api.onlyoffice.com/plugin/basic), 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](https://www.onlyoffice.com/blog/2023/06/updated-chatgpt-plugin-for-onlyoffice-docs). 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](https://api.onlyoffice.com/plugin/changelog)

## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cz47i9tuvwioixidvdan.png)

Moreover, in the [Document Builder API](https://api.onlyoffice.com/docbuilder/basic), lots of new characters, font, and range methods were added to the Spreadsheet API, as well as some other methods, including the following ones:

- [ApiCharacters/GetFont](https://api.onlyoffice.com/docbuilder/spreadsheetapi/apicharacters/getfont)
- [ApiFont/GetColor](https://api.onlyoffice.com/docbuilder/spreadsheetapi/apifont/getcolor)
- [ApiRange/Replace](https://api.onlyoffice.com/docbuilder/spreadsheetapi/apirange/replace)
- [ApiBlockLvlSdt/AddCaption](https://api.onlyoffice.com/docbuilder/textdocumentapi/apiblocklvlsdt/addcaption)
- [ApiDocument/InsertTextForm](https://api.onlyoffice.com/docbuilder/formapi/apidocument/inserttextform)

[Full list of new DocBuilder methods](https://api.onlyoffice.com/docbuilder/changelog)

### Useful links

[What’s new in ONLYOFFICE Docs 7.4](https://www.onlyoffice.com/blog/2023/06/onlyoffice-docs-7-4-released)

[ONLYOFFICE for developers](https://www.onlyoffice.com/developer-edition.aspx)

[API changelog](https://api.onlyoffice.com/editors/changelog)

[Get ONLYOFFICE Docs Developer Edition](https://www.onlyoffice.com/download-docs.aspx#docs-developer)

[Download Document Builder](https://www.onlyoffice.com/download-builder.aspx)