Features

• Server
  • Remove ability to execute DocumentBuilder scripts from Editors.

Fixes

• Server
  • Fix vulnerability with 'insert image from url' and 'compare document from url'.
• x2t
  • Fixed convert time for specific document (Bug #49434).
  • Fixed broken pptx file after open in Presentation Editor (Bug #49429, #49202).
• Docker
  • Fixed instruction for using Let's Encrypt (Docker-DocumentServer#349).

Fixes

• Document Editor
  • Fix data loss after opening document reviewed by user (Bug #48920) (DocumentServer#1159).
  • Fix JS error while entering text after cursor mouse move (Bug #49090).
  • Fix opening docx file with chart in MS Office (Bug #49219).
• Spreadsheet Editor
  • Fix copy from Document to Spreadsheet (Bug #49013).
• Integration
  • Fix missing plugin tab (Bug #49007).

Features

• Data validation to restrict the entered data type.
  The feature helps you restrict the type of data entered into a cell. The most popular use case for this feature is creating drop-down lists. They limit the entry choices for a selected cell - users just pick an item from a list which speeds the process and reduces the risk of errors.
• Slicers to visualize filtering in pivot tables.
  The spreadsheet editor now has Slicers for pivot tables. This functionality provides quick filtering and helps you indicate the filtering state to understand what data is currently displayed.
• Custom number format.
  If the existing number formats don’t meet your needs, starting from version 6.2 you can change the way the values show up by creating and applying custom number formats.
• New functions added to spreadsheets:
  • GROWTH to calculate predicted exponential growth by using existing data.
  • TREND to calculate a linear trend line.
  • LOGEST to calculate an exponential curve that fits the data and get an array of values that describes the curve.
  • UNIQUE to get a list of unique values from the specified range.
  • MUNIT to get the unit matrix for the specified dimension.
  • RANDARRAY to get an array of random numbers.
• Table of figures to organize illustrations.
  In ONLYOFFICE 6.2, it’s possible to create a table of figures. Much like a table of contents, it allows to list and organize the tables, equations, images, charts, and shapes.
  To create a table of figures, you need to add captions for all the objects that have to be included in it.
• Other improvements
  • New interface languages: Belarusian, Catalan, Greek, Lao, Romanian.
  • New proofing options in presentations. Choose where you want to use autocorrect as you type, e.g. create numbered or bulleted lists automatically.
  • Setting font size up to 300px (up to 409px in spreadsheets) manually.