ONLYOFFICE Docs roadmap

New Features

All Editors

• Add the ability to launch several visual plugins simultaneously (a separate button should be added to the left panel for each plugin).
• Move background plugins to the Background Plugins button menu.
• Move adding a comment to the entire document from the bottom of the comments panel to the settings button.
• Add a button for adding a comment to text to the header of the comments panel (similar to the button in the toolbar).
• Add Indonesian language id-id (Indonesian (Indonesia)), en-id (English (Indonesia)) to the regional settings.
• Add the ability to set avatars for users using the onRequestUsers integrator event with the data.c="info" parameter and the setUsers method.
• Add the ability to set an avatar for the current user using the editor config: config.editorConfig.user.image (this image will not be visible for other users).
• Add the interface translation into Serbian (sr-Latn-RS, Serbian (Latin, Serbia and Montenegro)) and Arabic (ar-SA, Arabic - Saudi Arabia).
• Add the More button to the left and right panels. All buttons that do not fit in height should be placed into it: category buttons, as well as plugins that were opened in the left panel. Remove the separator that separates the category buttons from the plugins.
• Add the setting to enable support for screen readers.
• Add RTL interface support, currently in beta.
• Window management buttons are redesigned to correspond to Linux.

Forms

• For the radio button field, add the setting for the name of the selected element (Radio button choice).
• Add a chain of tips when working with docxf files.
• The .oform format is no longer supported. Forms are saved as PDFs with corresponding metadata.

Spreadsheet Editor

• Add the ability to center a sheet horizontally and vertically when printing.
• Add the ability to get a link to the selected range in the viewing mode.
• Add the new Goal Seek functionality. It allows to determine which numbers should be substituted into the formula to get the desired and known result.
• Implement a wizard for inserting charts: display a list of recommended charts and previews for all types of charts based on the selected data.
• Add the new Series tool for creating number sequences.
• Expand cell filling settings.
• Add the Expand/Collapse menu item to the toolbar and the context menu of pivot tables.

Presentation Editor

• Add the ability to set the final color for animation effects that change color.
• Make animation effect icons inactive if the effect cannot be applied to an object.

PDF Editor

• Add the ability to save changes made in fillable PDF-forms.
• Add the Date Picker for a text form with a date format in PDF.

Server

• Add the formsdataurl parameter to the Callback handler (to replace formdata), which contains a link to the json file with data from filled forms when sending with the Submit button.
• Add the following methods to API: GetFreezePanesType, SetFreezePanesType, and the FreezePanes property.
• Add the GetFreezePanes method and the FreezePanes property to ApiWorksheet.
• Add the ApiFreezePanes class with the following methods: FreezeAt, FreezeColumns, FreezeRows, GetLocation, Unfreeze.
• Add the following methods for obtaining and filling out form data to the Builder of the Document Editor: ApiDocument.prototype.GetFormsData = function(), ApiDocument.prototype.SetFormsData = function(arrData).
• Add the ApiDocument.prototype.AddDrawingToPage = function(oDrawing, nPage, x, y) method for adding any ApiDrawing to a given page.
• Support for mssql and oracle databases.
• Add JSON watermark parameter to conversion.api

Desktop Editors

• Add the Moodle provider.
• Add the ability to upload local themes to the Desktop Editors. When choosing the "Add local theme" option, open the system dialog to select a theme json file, copy the theme to the custom application folder (Windows, Linux).
• Change the widget for displaying downloads from the portal and the download indicator (Windows, Linux).
• Add shortcuts to the Start menu for creating new files (Windows).
• Add password protection for PDFs.

Mobile Editors

• Add the ability to switch to the system theme.
• Change the interface for working with forms.
• Add formula search and list of recently used formulas in the mobile Spreadsheet Editor.
• Add the ability to add a custom cell format in the mobile Spreadsheet Editor.
• Add switching to the reading or editing mode when opening the mobile Document Editor based on the mobileForceView parameter in the configuration file.
• Add the ability to set the document language in the mobile Document Editor.

New Features

All Editors

• Working on RTL in the editors core
• Switching to the common history for all editors
• Support for SVG
• Insert Symbols menu has quick access to popular and recently used symbols
• Interface scaling is preserved for future sessions

Document Editor

• Automatic hyphenation
• Smart paragraph selection

Spreadsheet Editor

• Inserting images into headers/footers
• The ability to display only formulas in cells
• The Show details feature for working with a Pivot Table. Improvement of the ability to open data on a new sheet by double-clicking a value in a Pivot Table
• Autocompletion for days of the week and months when stretching a cell value
• Trace precedents / dependents
• Insert page breaks
• Number format for fields in pivot tables
• Drag-and-drop for columns and rows
• New function: SORTBY
• Margins presets for printing
• External data update for the currently edited source file
• .csv files preserve recently used Delimiter and Encoding settings in Local storage for future sessions

Presentation Editor

• New type of transition: Morph
• Slide placeholders have alternative descriptions
• Notes and Handouts in headers/footers settings
• Selecting a slide for the start of numeration
• Insert SmartArt available via a slide placeholder
• Assigning names to objects

PDF Viewer

• Support for the PDF forms. Annotations

Mobile Editors

• Working on the common engine for the native part of mobile applications. The ability to download sdk on Android and edit files on portals natively, instead of using the mobile web version
• Web version of the editors on iOS devices now opens in full and not as a mobile version
• Version history

New Features

All Editors

• File menu reworked: added file names, new Protect tab
• New interface language: Sinhala (Sri Lanka)
• New locale: Dansk (Danmark)
• Support for opening the following formats: MHTML, SXC, ET, ETT, SXI, DPS, DPT, SXW, STW, WPS, WPT
• New embedded Help language: Turkish
• New feature: text tips for color palettes
• New feature: headers for columns in lists
• New feature: Draw tab
• New feature: Eyedropper for color palettes
• New interface scaling options: 250/300/350/400/450/500%
• New feature: saving objects as pictures
• New feature: copy formatting for graphic objects
• New diagram type: Radar
• New feature: opacity setting for border lines of graphic objects
• Plugin Manager: added Search bar and categories

Forms

• New feature: no form field filling in edit mode
• New feature: Default value field on the right panel
• New feature: add new form without exiting the current one
• Fixed-form tracking fix
• New API method: filling forms in the interface
• Minor bug fixes

Document Editor

• New feature: advanced settings for layout columns
• Updated list settings: advanced settings for numbered and multi-level lists, the Recently Used tab for list types, creating lists in the dialogue window
• New feature: Combine documents
• New feature: exceptions for letter capitalization in AutoCorrect
• Support for saving documents in PNG and JPG formats

Spreadsheet Editor

• New feature: Print range for spreadsheets
• New formula language: Armenian
• New feature: First page number in print settings
• New feature: Page Break Preview on the View tab
• New feature: Change case
• New number formats: Short Date and Long Date
• New feature: Show Values as for pivot tables
• New contextual menu items for pivot tables
• New functions: SEQUENCE, XMATCH, EXPAND, FILTER, ARRAYTOTEXT, SORT
• New feature: protecting ranges while selecting certain users with editing rights
• The Allow edit ranges button moved to the Protect sheet dialogue window
• Support for saving spreadsheets in PNG and JPG formats

Presentation Editor

• New feature: exceptions for letter capitalization in AutoCorrect

Desktop Editors

• New interface language: Sinhala (Sri Lanka)
• New feature: cloud document templates
• New printing settings: number of copies, duplex
• Reworked Linux system setting: System theme option is now unavailable

Mobile web editors

• New interface language: Sinhala (Sri Lanka)

Mobile

• New formula languages

Plugins

• Zotero plugin updated to 1.0.1: updating bibliography and citation fields, data synchronization with Zotero, converting fields to text for improved compatibility with other editors

API updates

• New database: Dameng
• New feature: font size customization
• New license check parameter: start_date
• New WOPI discovery parameters: mobileView and mobileEdit action to open mobile editors
• New plugin methods to return and replace the current word/sentence
• New editor configuration parameter: hiding the Draw tab
• node-redis connector updated to 4.6.5
• JS core debug in Chrome
• New feature added: pluginsmanager

New Features

All Editors

• Styles panel now fits the whole number of visible styles
• Table templates are now categorized
• New feature: 3D rotation for diagrams
• New dictionaries: Uzbek (Cyrillic + Latin)
• New feature: presets for inserting text boxes
• New feature: hiding right and left sidebars via the View tab
• New feature: quick access panel for equations
• New feature: changing the size of dialog windows for charts, OLE-objects and Mail Merge recipients
• Support for error bars (for viewing only)
• New feature: inserting Smart Art objects

Document Editor

• Support for equations in Unicode and LaTeX
• New feature: word count in the status bar
• Document password protection update: editing rights restriction

Spreadsheet Editor

• Templates for tables, pivot tables, cell styles are now categorized
• New feature: Watch Window for functions
• New Paste Special feature: links to other files within the portal
• New functions added: TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS

Presentation Editor

• New setting: adjusting guidelines via the View tab
• New feature: Paste Special for slides

Desktop Editors

• New printing setting: quick print

Mobile

• New feature: Sharing Settings

New Features

All Editors

• JWT with random key enabled by default. This fix CVE-2021-43445, CVE-2021-43447, CVE-2021-43448, CVE-2021-43449
• Random secret key by default. Fix CVE-2021-43444
• Fix CVE-2022-32212 by upgrading nodejs version
• Reworking the text processing module
• Remaking work with text and fonts in the Document Editor and Presentation Editor: support of new languages (e.g. Bengali, Sinhalese) and ligatures
• Ability to rename document at the top of the editor window
• Warning when a macro makes a request to any URL
• Search field is reworked
• The View tab is available in read-only mode and comment mode
• Advanced settings are reworked
• Ability to enable/disable using the Option key to navigate the editors via keyboard
• New web editor interface theme: Contrast Dark
• Web editor interface theme can be synchronized with the system theme
• New web editor info: the About section contains build number
• Top toolbar is reworked: changed icons, added Cut and Select All icons
• New interface languages: Basque, Malay, Portuguese (Portugal), Chinese (Traditional, Taiwan), Armenian
• Hotkeys for Paste Special
• Plugin manager on the Plugin tab

Forms

• Ability to add tags
• Reworked cell width setting when using Comb of characters
• New fields: email, phone number, complex field
• New settings for text fields: format, allowed symbols

Document Editor

• File navigation panel is renamed and has its own settings: expand/collapse all, expand to level X, font size, wrap headings
• Ability to remove headers/footers via toolbar
• Ability to include current title in the table of contents via toolbar and designated button
• New spellcheck settings in the advanced settings
• Ability to insert spreadsheets as OLE objects
• Reworked accepting and rejecting changes
• New multilevel bullet lists for headings only

Spreadsheet Editor

• Ability to use custom images as bullets in bullet lists
• Ability to switch rows/columns using the diagram settings in the right panel
• Ability to get a link to the selected range in the context menu
• Copied range is marked with a dotted line
• New 1904 date system
• Ability to enable and disable pivot table column autowidth

Presentation Editor

• New spellcheck settings in the advanced settings
• Ability to use custom images as bullets in bullet lists
• Reworked advanced settings’ Placement tab for precise positioning of images, autoshapes, tables, and charts
• Ability to insert spreadsheets as OLE objects
• New custom path animation effect

Desktop Editors

• Vector text print (Windows/Linux only) if there are no gradient fills on the page
• New interface language: Armenian, Portuguese (Portugal)
• Ability to add hyperlinks to local files

Mobile

• New interface language: Indonesian
• New features in the Document Editor: header navigation, ability to add table of contents and configure its settings
• New Tab Color palette for sheets in the Spreadsheet Editor

Plugins

• New translation mechanic in plugins: ability to add langs.json to folder with translations; first there is a request for a full match in file name and language, then up to the “-“ symbol

API updates

• New feature: live viewer for tracking changes in real-time
• The Document Server information contains live viewer/editor data
• New interface translation support: 4-letter language designation is supported. Currently it is used for Portuguese (Portugal) and Chinese (Traditional, Taiwan)
• New customization -> customer -> phone parameter for the About page
• New API for working with forms, new functions: ApiDocument.prototype.GetTagsOfAllForms(), ApiDocument.prototype.GetFormsByTag = function(sTag)
• New functions for working with content controls: ApiDocument.prototype.GetTagsOfAllContentControls(), ApiDocument.prototype.GetContentControlsByTag = function(sTag)

WOPI

• Ability to open embedded viewer in WOPI discovery

Server

• Publishing Docker images for amd64 и arm64 platforms with the same tag
• Auto detect of DB type in deb package

New Features

All Editors

• New menu for inserting autoshapes
• Ability to edit points of a selected autoshape
• Ability to open new diagram types: Pyramid, Bar (Pyramid), vertical and horizontal cylinders, vertical and horizontal cones
• Ability to crop a selected image to shape
• Sorting comments on the left sidebar by group
• Ability to see your file protection password when entering it
• Support for SmartArt objects without converting into a group of objects
• New interface languages: Galego/Galician, Azerbaijani
• Notifications appear when connection is lost and being restored
• Gradient fill icon shows the direction of filling for chosen colors

Forms

• Ability to zoom a form

Document Editor

• New viewer for PDF, XPS, DJVU files
• Ability to use the Page Thumbnails panel and to display the document's contents on the left sidebar for PDF files
• Support for external and internal links in PDF files via left-click
• Ability to use Hand/Select tools in PDF viewer
• The Document Info section of the Data tab contains information about PDF/XPS/DJVU files
• Ability to convert PDF/XPS files into editable files
• New toolbar tab: View
• Ability to accept/reject changes from the context menu
• Ability to use special symbols when searching within documents
• Ability to add a period with a double-space

Spreadsheet Editor

• Using a built-in preview panel before printing out a spreadsheet
• New view settings: Combine sheet and status bars, Always show toolbar, Interface theme, Show frozen panes shadow
• New currencies as per ISO 4217 without needing to change the locale
• Using tips when working with formulas for tables
• Ability to set a text qualifier when importing text from TXT/CSV
• Support for XLSB files (read only)

Presentation Editor

• New toolbar tabs: Animation, View
• Ability to duplicate slides using the Add slide menu
• Ability to move a slide to beginning/end using a slide context menu
• Ability to insert recently used shapes using a new panel on the Insert tab
• Ability to add a period with double-space

API updates

• The last callbackUrl is needed for sending a link to a compiled file if a file was edited by the same user on different tabs
• New environment variable X2T_MEMORY_LIMIT limiting memory for the x2t process
• New sections Features and Layout for Customization, the following parameters are renamed: leftMenu -> layout.leftMenu, rightMenu -> layout.rightMenu, toolbar -> layout.toolbar, statusBar -> layout.statusBar, spellcheck -> features.spellcheck
• Ability to see the customer_id and the build type on index.html

WOPI

• New headers for putFile request: X-LOOL-WOPI-IsModifiedByUser, X-LOOL-WOPI-IsAutosave, X-LOOL-WOPI-IsExitSave

New Features

All Editors

• Sorting comments on the left sidebar by date and author
• Ability to change document settings using the alt + key keyboard shortcuts
• Changing contents of the Create new... section in the File menu

Forms

• Support of a completely new docxf format for master forms
• Support of a completely new oform format for forms
• Ability to create and fill in own forms

Document Editor

• Ability to add Content Controls and use File Comparison in the OpenSource version
• Sorting comments on the left sidebar by location
• Ability to choose the display mode for review changes: Show by click in balloons, Show by hover in tooltips
• Ability to choose mail merge data from a local file and from URL
• Hyperlinks autocorrect
• DarkMode of page view

Spreadsheet Editor

• Ability to use Sheet Views in the OpenSource version
• Version history
• Ability to protect a workbook and sheet in the Protection tab
• Button with the sheet list to switch to the certain sheet
• Descriptions and names of function arguments in Portuguese (Brazil)
• Opening / saving a query table
• Ability to open the status bar in two bars
• Saving status block in the status bar
• Displaying selections made by other users

Presentation Editor

• Ability to show animations contained in a file
• Moving slide transition settings from the right-side panel to the Transitions tab of the top toolbar
• Hyperlinks autocorrect
• Ability to export presentations to a set of png or jpg images

API updates

• Ability to add additional interface themes
• New outputtype: "ooxml", "odf" types in the conversionapi to convert files to any format (docx, docm, xlsx, xlsm, pptx, pptm, or odt, ods, odp)
• When opening documents with macros, the downloadAs panel contains the docm, xlsm, pptm formats (determined by the fileType parameter)
• assemblyFormatAsOrigin parameter is enabled by default to save the assemblied file in the same format, in which it is opened
• New review section and new hideReviewDisplay, showReviewChanges, reviewDisplay, trackChanges, hoverMode parameters in the customization section of the document editor config
• New fileType parameter for onDownloadAs, onRequestSaveAs, onRequestRestore
• Ability to insert several images from the portal using the insertImage method

New Features

All Editors

• Web Application Open Platform Interface (WOPI) support.
• 125% and 175% scaling.
• Resolving all comments.
• Support for chart styles.
• Chart styles for people with disabilities.
• New previews for bulleted, numbered, multi-level lists.
• Navigating controls (checkbox, radiobox, button with text) using Tab/Shift+Tab.
• Updated work on the client: decoding pictures in all popular raster formats; working with zip archives (open / save / edit); digital signatures.

Document Editor

• Converting text to tables and vice versa.
• Auto-capitalization for the 1st word in a sentence.

Spreadsheet Editor

• Adding/setting/deleting conditional formatting.
• Adding sparklines.
• Importing data from txt and csv.
• Changing select on Tab+Enter.
• Assigning a macro to be executed when you click on a graphic object.
• Descriptions and names of function arguments in Polish, Japanese, Korean, Latvian, Lao, Norwegian, Romanian, Slovak, Slovenian, Swedish, Turkish, Vietnamese, Catalan, Czech, Chinese, Danish, Dutch, Finnish, Greek, Hungarian, Indonesian, Bulgarian, Portuguese, Ukrainian.
• Hyperlinks autocorrect.
• Presets for Freeze Panes.
• Setting for displaying zeros in cells (Show zeros).
• Argument names in the function setting dialog.
• Storing comment threads.

Presentation Editor

• Version history.
• Setting to hide the notes panel.
• Auto-capitalization for the 1st word in a sentence.

Mobile web editors

• Reworked on ReactJS.

New Features

All Editors

• Dark theme.
• Adding/editing/deleting passwords in the online version.
• 150% scaling.
• Adding files to Favorites folder.
• New chart types (line and scatter).
• Entering names for anonymous users.

Document Editor

• Button to change wrapping settings on the toolbar (Layout tab).
• Changing indent in the paragraph settings on the right panel.
• Changing text case.
• Changing list levels.
• Fixed color set in the color picker for content controls.
• Saving Track Changes status to file.
• Downloading files as/saving as HTML, FB2, EPUB.

Spreadsheet Editor

• Combo chart settings.
• XLOOKUP function.
• New cell formats: dd/mm, dd/mm/yyyy, dd/mm/yy.
• New currency for cell format - Croatian kuna.
• Grouping/ungrouping data in pivot tables.

Presentation Editor

• Transparency setting to slide properties in the right panel.
• Column setting for text in a shape on the toolbar.
• Buttons for changing text case and highlighting text with color.

New Features

All Editors

• The ability to manually set font size up to 300 pt (409 pt in the Spreadsheet Editor).
• The ability to switch between text field, combo box, list items in some dialog windows using the Tab/Shift+Tab keys.
• New interface languages: Belarusian, Catalan, Greek, Lao, Romanian.

Document Editor

• The ability to insert and edit Table of Figures.

Spreadsheet Editor

• Improvements of formatted table autoexpansion.
• The ability to insert slicers for pivot tables.
• Data Validation settings.
• The ability to create custom number formats.
• New functions: GROWTH, TREND, LOGEST, UNIQUE, MUNIT, RANDARRAY.

Presentation Editor

• The Autoformat as you type functionality in the proofing settings.
• Increment/decrement font size buttons on the toolbar.