Onlyoffice, a complete, free and open source office suite, goes to version 8.3 with a multitude of improvements and innovations, even integrating one of Excel’s most practical functions.

Onlyoffice a complete free and open source office suite goes

Onlyoffice, a complete, free and open source office suite, goes to version 8.3 with a multitude of improvements and innovations, even integrating one of Excel’s most practical functions.

Barely more than three months after its last “minor” update, the collaborative office suite and Open Source Onlyoffice goes to version 8.3, once again with a substantial lot of new functions and ergonomic improvements. Supported document formats, drawing tools and calculation formulas or manipulation and editing of PDF files, Almost all office modules receive new featuresand some not least.

As usual, the update is initially deployed for Onlyoffice Docs, the online version of the various office modules, which are integrated into services cloud like those ofInfomaniak,, Hexagon or Crystpad. The real availability of version 8.3 will obviously vary from one service provider to another, depending on the deployment speed. And when the update for Onlyoffice Desktop Editors (office applications) arrives, it is generally done in the days that follow.

Onlyoffice 8.3: The spreadsheet receives one of the most powerful Excel functions

The Onlyoffice Spreadsheets tablet module, equivalent to Microsoft Excel or Google Sheets, receives several significant improvements. And among them, the arrival of one of the most practical functions of Excel: fields calculated in dynamic cross paintings. Renamed calculated elementsthis function makes it possible to use calculation formulas to generate new synthetic information, from not from the sources but from the aggregated data of the dynamic cross table.

It is a particularly powerful and flexible tool for the analysis of complex data or the creation of dynamic dashboards, and a very popular function of managers and accounting of all stripes. The arrival of the elements calculated in the dynamic cross paintings of Onlyoffice therefore marks a hell of a bond in front for the office suite, all the more when we see (with Reget) that this function is still not implemented in the venerable LibreOffice , despite the repeated years and requests.

Onlyoffice Spreadsheets also earns a multitude of other improvements: cancellation of actions during real -time coeition, automatic updating of data from external sources, automatic filling per series of days, months or years, overhaul of the assistant Creation of calculation formulas or automatic detection of delimitors in the import box of CSV files. So many new features that make the spreadsheet even more practical for daily handling and management.

Onlyoffice 8.3: News on all stages of the office suite

And the other modules of the office suite are not to be outdone. The publisher of PDF is enriched by a tool to affix ready-to-use stamps on administrative or contractual documents and now makes it possible to cancel actions during real-time co-edition (as in the spreadsheet). The navigation pane now makes it possible to carry out multiple selections on the pages, to reorganize or delete them, and text annotations can be modified on the fly thanks to a new floating editing panel.

The presentations publisher, equivalent of PowerPoint to create slideshow, gains in ergonomics and fluidity with the addition of a tab Designwhich makes it possible to “work more intuitively” on the layout of the slides. The management of themes, styles, colors, transparency or text effects is more centralized and produces more homogeneous results throughout the document. The publisher also receives a drawing and highlighting function by hand while scrolling with slideshow, which can be useful for attracting audience’s attention to a particular point.

The office automation also receives many other improvements in general scope, whose full list is available hereand here are some notable points: supported by Apple IWork (pages, Numbers, Keynote) and Hancom Office (.HWP, .HWPX) documents, comparison and combination of text documents at the level of the word or character, or a whole new drawing function titled Merge formswhich allows as its name suggests to create unique and personalized forms from basic geometric shapes.

The additions and contributions of version 8.3 are therefore far from anecdotal for a “minor” update. We can only salute the seriousness of Ascensio System, the publisher of Onlyoffice, for the regularity with which he changes his office automation suite. The application has been improving continuously since its release, and becomes according to its updates an ever more solid solution in the face of its competitors, and in particular the mastodonte Microsoft Office, which, for its part, believes in order to force force “artificial intelligence” functions by invoicing them at a high price.

ccn3