How to install Desktop Editors from snap package?

New Features

All Editors

• Implemented a new Document Server integration scheme.
• Added the ability to connect Seafile.
• Added the ability to protect documents, spreadsheets and presentations using a digital signature.
• Added the ability to manually set font size up to 300 pt (409 pt in the Spreadsheet Editor).
• Added the ability to switch between text field, combo box, list items in some dialog windows using the Tab/Shift+Tab keys.
• Changed loaders for long-running operations.

Document Editor

• Added the ability to insert and edit Table of Figures.

Spreadsheet Editor

• Improved formatted table autoexpansion.
• Added the ability to insert slicers for pivot tables.
• Added the Data Validation settings.
• Added the ability to create custom number formats.
• Added new functions: GROWTH, TREND, LOGEST, UNIQUE, MUNIT, RANDARRAY.

Presentation Editor

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

Fixes

• All components received countless fixes.

New Features

All Editors

• Added support of the fb2 format for viewing. The html/epub/mht formats are now available for all platforms.
• Updated fill settings for autoshapes, cells, slides, TextArt: added a spinner for setting the picker position, buttons for adding and removing the current picker. Updated styles. When adding a new picker, the current appearance of the gradient does not change.
• Added the ability to set an arbitrary angle for a gradient fill.
• Added the ability to edit Math AutoCorrect options (remove or change existing entries, add new ones, restore default values).
• Added the Recognized functions functionality to the proofing settings.
• Added icons to context menus.
• Renewed the File panel: the Apply button is always visible.
• Added the ability to copy a comment from the left sidebar.

Document Editor

• Added the Line numbers functionality.
• Added the ability to insert, edit, and convert endnotes.
• Added the ability to create cross-references.
• Added the Autoformat as you type functionality to the proofing settings.
• Added the Select Data button in the Chart Editor window.

Spreadsheet Editor

• Added the Sheet view functionality (available only for the paid version).
• Added a button to insert a pivot table in the Insert tab.
• Added additional options for editing chart data (series and categories).
• Redone changing the cell editor height.
• Added a new cursor for column\row hover.
• Added the ability to display shadows for frozen areas.
• Added the Autoformat as you type functionality to the proofing settings.

Plugins

• Updated the Translator plugin. It uses Google Translate instead of Yandex.

Fixes

• All components received countless fixes.

Fixes

All Editors

• Fixed a problem with inserting the BMP images in a document (Bug #47276).

Fixes

All Editors

• Actualized Help.

Document Editor

• Fixed losing comments added to the docx document (Bug #46770).

Spreadsheet Editor

• Fixed refreshing a pivot table in R1C1 (Bug #46052).

Convert

• Fixed an error while opening a specific xls file (Bug #46728)

Backend

• Fixed several vulnerabilities.
• Fixed Path Traversal vulnerability via the download as params.
• Fixed ER_DATA_TOO_LONG: Data too long for column 'callback' at row 1.
• Fixed a problem with generating a new presentation theme (Bug #46754).

New features

All Editors

• Added the option to adjust application interface scaling (Windows, Linux).
• Added the AutoFit settings for shapes.
• Added the ability to insert special characters. Hotkeys have been implemented in the Document Editor only.
• Added the autorun settings for macros. If the Show Notification option is selected, a user will be notified about macros existence.
• Added the ability to select an image from the document manager for watermarks, shapes and slides fill (Bug 42913).
• Added the AutoCorrect list (Bug 44659).
• Redesigned the color selection component.
• Added the ability to change a position and size of chart elements (a title, an area, a legend and data labels).
• Added the Ctrl + 0 hotkey to reset zoom to 100%. A sequence fits a slide to workview in the Presentation Editor (Bug 45106).
• Changed a behaviour of hiding icons in tabs when reducing editor windows. They are hiding as needed now.

Document Editor

• Added the ability to insert date and time (Bug 36585).
• Added the ability to print the selection in the view mode (Bug 44338).
• Added the ability to convert equations from old formats (Bug 44511).
• Changed a placeholder for content controls.
• Redone the algorithm of justifying a paragraph with condensing spaces (Bug 40851, Bug 44960).

Spreadsheet Editor

• Added full support of pivot tables (inserting and editing).
• Added the autofilter settings in pivot tables (by labels, by values, additional sort parameters).
• Added support of opening all conditions existing in a file for data bar conditional formatting.
• Added support of opening all gradients existing in a file for data bar conditional formatting.
• Added full support of slicers for formatted tables (Bug 30397).
• Added the special paste settings (Bug 42544).
• Added the ability to move a sheet from one workbook to another.
• Added the ability to insert an internal link to a named range (Bug 44821).
• Added the ability to print titles (Bug 43869).
• Added a component for cells selection.
• Added the ability to remove duplicate values. Also available for formatted tables.
• Added the ability to insert function via the Function Arguments dialogue.
• Added the ability to get a hyperlink to an internal range and open the workbook with linking to it.
• Added the Wrap Text and Shrink to Fit settings in the right toolbar.
• Added the Vertical Text option in the text orientation settings.
• Combined the bulleted and numbered list settings. Added the ability to create lists from the List Settings dialogue.
• Added the ability to change the function in the Total Row for formatted tables.
• Added the delimiter settings for the Special Paste and Text to Columns dialogues.
• Added the LINEST function (Bug 45534).
• Added the Ctrl+; and Ctrl+Shift+; hotkeys for date and time insertion (Bug 42876).
• Added the Shift+F3 hotkey for a function insertion.
• Added the status bar settings.
• Added the ability to select the column or row of a formatted table or the whole table by one mouse click.

Presentation Editor

• Changed the interface for an internal link.
• Added the ability to print the selection in the view mode (Bug 44338).
• Combined the bulleted and numbered list settings. Added the ability to create lists from the List Settings dialogue.

Fixes

• All editors received countless fixes.

Fixes

All editors

• Fixed several vulnerabilities in convertion app (Bug #46348, Bug #46352, Bug #46353, Bug #46384, Bug #46434, Bug #46436).
• Fixed vulnerability in TXT converter (Bug #46437).
• Fixed Path Traversal vulnerability via image upload params (Bug #46113).
• Fixed Path Traversal vulnerability via savefile param (Bug #46037).
• Fixed Path Traversal vulnerability via Convert Service param (Bug #45976).

New features

All Editors

• Added support of the Private Rooms plugin (ONLYOFFICE Enterprise Edition 11.0 is needed as well).
• Added the possibility to gain access to some features of the Document Server commercial versions.

Fixes

All Editors

• Fixed opening zero-byte files created with the MS Office folder menu.
• Fixed an issue with opening long path files (Bug 45117).
• Added the ability to run the application with the system title bar by the --system-title-bar flag (Linux) (Bug 43189) (#271).
• Fixed an unexpected application window behavior after finishing the presentation preview (Bug 44968).
• Fixed an unexpected application behavior after undocking a window with the presenter mode (Bug 45483).
• Fixed the ability to resize the application windows on Mac OS (Bug 45135).
• Fixed an issue with connecting to cloud servers if the URL address contains spaces (Bug 42293).
• Fixed an issue with restoring the application window after some scenarios (Bug 45292).
• Fixed the display of a dialog window while closing all application windows (Bug 44974).
• Fixed scaling a window title on HiDPI displays in some scenarios (Bug 45060).
• Fixed a duplication of the print button after undocking the PDF viewer window (Bug 45170).
• Improved some translations in dialog windows.
• Fixed a position of the application window after printing operations was canceled (Bug 45003).
• Fixed an issue with displaying artifacts on the about page in some scenarios (Bug 44684).
• Fixed an issue with displaying artifacts after the installation on Windows 10 was finished (Bug 45089).
• Fixed an issue with updating the user name while the document is opened (Bug 45254).
• Added a user name limitation in the field (Bug 44742).
• Fixed an issue with locking modal dialog windows while the print dialog window in opened and updocked (Bug 42791).
• Fixed an editor tab position after the window is attached (Bug 44749).
• Added a custom title for the Windows Apps entry in the Add or Remove Programs list.
• Fixed an unexpected system reboot after the VSRedis installation.
• Fixed the display of dialog windows on some linux color schemes (Bug 31995).

Document Editor

• Fixed an issue with the auto color feature for graphical objects in some DOCX user files (Bug 45460).
• Fixed an issue with increasing the font size in some DOCX user files (Bug 44852).
• Fixed disabling the undo/redo buttons after comparing the documents.
• Fixed an incorrect display of some PDF user files (Bug 45336, Bug 39097, Bug 19078).
• Fixed an incorrect display of a watermark on CJK languages (Bug 45886).
• Fixed the export of some DOCX user files to PDF (Bug 45319).

Spreadsheet Editor

• Fixed an invalid icon in the cell border menu (Bug 45910).
• Fixed an error with copying and pasting a formatted table in some XLSX files (Bug 45731).
• Fixed an error with the formatted table creation in some XLSX files (Bug 45773).
• Fixed an error with entering big data in the last partially viewed cell (Bug 45653) (#903).
• Fixed an appearance of the color selection dialog box for bulleted lists (Bug 45417).

Presentation Editor

• Fixed an appearance of the color selection dialog box for bulleted lists (Bug 45417).

New features

All Editors

• Added the Multi-Window mode (Windows, Linux).
• Loading speed improvements.
• Symbol table now is a system component, not a plugin.
• Added a new button: Top Toolbar -> Collaboration -> Remove comments.
• The Default Size button in the image settings was replaced with the Actual Size one.

Document Editor

• Added the possibility to remove table cells.
• Added the possibility to insert several rows/columns into the table.
• Added the possibility to add captions for images, shapes, tables and equations.
• Added new options for bulleted and numbered lists.
• Added the possibility to draw and erase a table.
• Added the possibility to edit gutter and mirror margins.

Spreadsheet Editor

• Added support of reading drop-down lists.
• Added support of reading data validation.
• Added the possibility to recalculate all formulas.
• Added new scale options.
• Added new options for cell fill.
• Added the possibility to set Cell Snapping for images, shapes and charts.
• Added the possibility to work with several sheets at once.
• Added the bulleted and numbered list options to the context menu.
• Added the possibility to change the bullets marker.
• Added new spellchecker options.
• Added the possibility to sort by several columns/rows.
• Added a new option for setting separators.

Presentation Editor

• Added the possibility to add objects (tables, shapes, charts, images) to a slide template.
• Added the possibility to reset a slide.
• Added new list settings.
• Added the possibility to add objects (images, charts, tables) to a placeholder.

Fixes

• All components received countless fixes.
• Localization improvements.
• Fixed some security issues.
• Fixed some more issues with user files.

Document Editor

• Fixed an issue with the comment duplication after editing some DOCX files and opening them in other editors (bug #44689).

Spreadsheet Editor

• Better support of the TIME function (bug #44849).

Files editing/convertion

• Fixed some security issues.
• Fixed issues with opening some DOC, RTF and XLSX files (bug #44756, bug #44934, bug #44840).
• Fixed corrupting the mime-type parameter after editing some DOCX files (bug #44957).

Fixes

All editors

• Improved compatibility with macOS 10.15 Catalina.

Document Editor

• Fixed the problem with removing previously added text by other user in the review mode (bug #43183);
• Fixed the problem with moving text in the review mode (bug #43238);
• Fixed the problem of inserting a table over another table;
• Fixed the problem with reviewed numbering;
• Fixed some problems with watermarks.

Plugins

• Fixed starting the Photo Editor plugin (bug #42473);
• Fixed issues with the YouTube plugin.

New features

All editors

• Added more options for Paragraph spacing;
• Added the possibility to set paragraph Outline level;
• Added the possibility to get current color scheme;
• Updated the Document Info page;
• Added better templates for tables and increased their number;
• Added the possibility to select languages using keyboard (bug #24317);
• Added the possibility to show a shadow for images and shapes;
• Added the possibility to use mentions in comments;
• Added the possibility to show multi-gradient fill in shapes (bug #40719).

Document Editor

• Added the possibility to create a new style with the next style being the same as previous one;
• Added the possibility to add watermarks;
• Added the possibility to save DOCX using the mode compatible with older versions;
• Added the tooltip for table styles.

Spreadsheet Editor

• Added the possibility to change look of chart elements;
• Added the possibility to set headers and footers;
• Added a new tab to work with formulas;
• Added the possibility to group data;
• Added the spellchecker;
• Added the possibility to resize the autofilter window;
• Added the possibility to show the number of cells in autofilter window;
• Added the possibility to save 10 last used functions;
• Set default value for regional settings (bug #41549);
• Added support for asynchronous loading of formulas.

Presentation Editor

• Added new themes for slides;
• Added the possibility to set headers and footers;
• Added the possibility to insert the slide number;
• Added the possibility to insert date and time;
• Added the tooltip for table styles.

Fixes

All editors

• Fixed the issue when adding the document info was not detected as the document change (bug #42717);
• Fixed the problem with the paste operation after the settings were opened;
• Fixed some issues with loading of translations.

Document Editor

• Fixed the problem with the content control selection (bug #42657);
• Fixed the problem with accepting/rejecting the changed in case the moved text is included into the selection (bug #42665);
• Fixed the problem with deleting the text that had been previously added by the same user (bug #41242);
• Fixed the No image uploaded error for the watermark background (bug #42832);
• Fixed the issue with the unit of measurements used for the rulers (bug #42608);
• Fixed the display of the style list in the Create New Style window when the window size is small (bug #42799);
• Fixed the issues with changing the display mode for the change tracking (without the Plugins tab).

Spreadsheet Editor

• Fixed the issue with opening certain files with pivot table without a pivot style;
• Fixed the JavaScript error in the SUBTOTAL function (bug #42833);
• Fixed the issues with the scale options occurring when printing (bug #34704);
• Fixed the issues with adding images from storages (bug #42789);
• Fixed the auto-sum symbol icon;
• Fixed the button icons (chat, comments).

x2t

doc

• Fixed the issue with the extended comments.

docx

• Fixed the issue with the bookmark saving inside a hyperlink.

xls

• Fixed the issues with the marker filters in certain XLS files (bug #42239);
• Fixed the issues with the image size when saving to XLS (bug #42618);
• Fixed the issues with the group data display (bug #42216).

xlsx

• Fixed the issues with the tooltip for data validation (bug #42667);
• Fixed the Excel recovery error for files with comments (bug #42968);
• Fixed the issues with the reply duplicates (bug #42969).

odf

• Fixed error in headers/footers;
• Fixed the issues with the print areas (bug #42654);
• Fixed the issues with the column width (bug #42790);
• Fixed the issues with the cell color (bug #42932);
• Fixed the issues with the link to the cells formatted as table (bug #42938).

New features

Plugins

• Added the translations for Photo Editor plugin.

Fixes

All editors

• Fixed the problems with the connection to Community Server v10.0.4;
• Fixed bugs in encryption mode.

Document Editor

• Fixed the JavaScript error which occurred when undoing the previous insert action of an empty row into a table (bug #41995);
• Fixed the problem with adding an equation inside a hyperlink;
• Fixed the issue when the files with math created by Aspose crashed when opened.

Presentation Editor

• Fixed the issue with the slide background color.

x2t

• Fixed the issue with decoding XLSX escaped chars (bugs #36575 and #41890).

Fixes

All editors

• Changed the placement for the Undo/Redo, Save and Print buttons in the top toolbar;
• Added about 250 document languages (mostly without a spellchecker);
• Completely rewritten the font engine, adding a better support of Chinese, Japanese and Korean fonts and much more;
• Added the possibility to flip and rotate shapes and images;
• Added the possibility to crop images;
• Adding a bookmark does not close the bookmark window;
• The comments are now shown in all editing and viewing modes;
• Added the new hotkeys on MacOS and their description in documentation;
• Added options for objects alignment (align to page, margin, slide);
• Added new hints for shapes (bug #20091);
• Completely rewritten the photo editor plugin;
• Fixed more problems with SVG;
• Fixed a lot of bugs with drawings positioning.

Document Editor

• Added formulas in tables;
• Added the possibility to save as DOTX, PDF-A, OTT;
• The review changes are now shown in view mode;
• Added the possibility to prevent deletion of the review changes of another user;
• Added the possibility to prevent deletion of the comments of another user;
• Added the description for moved text and move to changed text in review mode;
• Added the possibility to get link to bookmark;
• Added the possibility to automatically copy the selected text to the search window;
• Added the support for calculating tabs in Word 2013 style positioned to the right of the right margin;
• Fixed the JavaScript error which occurred while scrolling in mail merge window (bug #41787);
• Fixed the JavaScript error which occurred while opening some specific DOCX files (bug #41847);
• Fixed the JavaScript error which occurred while using the final mode in review mode (bug #41846);
• Fixed the problem with updating positions in the inner classes within a paragraph (bug #41848);
• Fixed the issue when records were added to reviews with changes of the text properties if in fact there have been no changes (bug #41833);
• Fixed the critical bug on settting up the hideContentControlTrack property;
• Fixed the issue with showing the changes from the second user if the display of the changes was disabled (bug #41576);
• Fixed the problem with accepting/rejecting review changes;
• Fixed the JavaScript error which occurred while entering the text in content control in specific DOCX files (bug #41687);
• Fixed the problem with calculating the numbering value within merged cells (bug #41699);
• Fixed the JavaScript error which occurred while undoing the entered text in review mode (bug #41708);
• Fixed the issue with deleting the whole TOC field after selecting it (bug #41714);
• Fixed the issue with showing the numbering as changes for review in specific documents (bug #41518);
• Fixed the issue with the opening Modelling_scholarly_communication_report_final1.docx file (bug #41717);
• Fixed the crash which occurred when refreshing the recalculated data;
• Fixed the bug with moving object in group;
• Fixed the problem with rendering WMF files (bug #41495).

Spreadsheet Editor

• Added the bg-BG, sv-SE and sv-FI number formats;
• Translates the functions and their descriptions to Italian;
• Replaced the behavior of the mouse click for the links in cells;
• Added the ASC, BETAINV, HYPERLINK functions;
• Added the support of print areas;
• Added the possibility to set the exact text orientations in degrees;
• Added the text to column wizard;
• Added the paste text wizard;
• Added the possibility to save as XLTX, PDF-A, OTS;
• Added the support of the array formulas;
• Added the support for the gradient and texture cell fill;
• A hint is now shown with function and argument descriptions while typing;
• Added the support to show minimum and maximum values in the status bar;
• Added the possibility to distribute objects;
• Rewritten the cut cell process (cell is not removed after cutting);
• Fixed the JavaScript error which occurred for Replace all in some cases (bug #41760);
• Fixed the column index error which occurred during insertion;
• Fixed the issue with adding the changes to the history on drawing sparklines;
• Fixed the issue with undoing the moved cell in print area (bug #41723).

Presentation Editor

• Added the possibility to save as POTX, PDF-A, OTP;
• Added the font rendering option;
• Added an option to search and replace the text;
• Added the possibility to enter the slide number manually for the internal hyperlinks.

Fixes

All editors

• Major bugfix for interaction with Nextcloud and ownCloud portals.

New features

All editors

• Added Polish as a new interface language;
• Added an option to change the user interface language;
• Added an option to change the user name;
• Improved HiDPI screens detection;
• Extended the list of providers for collaboration portals (ownCloud, Nextcloud);
• Added encryption options (developer preview version);
• Added a warning when opening a file protected with password;
• The resolved comments are now not shown by default in Document Editor and Spreadsheet Editor;
• Added the possibility to customize availability of help in the editor;
• Added the display of the File and Plugins tabs for viewers;
• The username is now highlihgted by color in the comments, review changes, chat messages;
• Prevented the duplication of online users in the left chat panel;
• Added the possibility to sort comments in the popover by ascending creation time.

Document Editor

• Added the possibility to work with bookmarks;
• Added the possibility to add/change hyperlinks anchored to bookmarks/headings;
• Added the possibility to change numbering value, start/continue numbering;
• Added settings for content controls (highlighting and appearance);
• Review changes and comments are now displayed in the combined window;
• Added presets for А0, А1, А2, А6 page size (bug #36583);
• Enabled closing the chart dialog while loading (bug #36870);
• Changed the encoding format for the TXT files (bug #36998);
• Added the mode for filling forms;
• Enabled closing the window when saving to TXT format;
• Enabled inserting shapes when a shape is selected;
• The new revisions are now checked in the Fast co-editing mode.

Spreadsheet Editor

• Added the cell settings in the right panel;
• Added the Layout tab;
• Added the hint for autofilters;
• Added the possibility to change the encoding format for CSV files (bug #36998);
• Enabled saving page options to a file before printing;
• Added the possibility to view combo charts;
• Enhanced the application due to the completely rewritten scroll;
• Added support of R1C1 references style.

Presentation Editor

• Added hints to presentation themes (bug #21362);
• Added the presenter preview in the viewer (bug #37499);
• Enabled closing the chart dialog while loading (bug #36870).

Fixes

All editors

• Updated translations;
• Fixed the position for the zoom buttons in the toolbar;
• Fixed the File tab which had lost active state when the inner panels had been clicked;
• Fixed the Replace image by URL context menu option (bug #37651);
• Fixed the possibility to copy the comments from the comment balloon (bug #37666, #35896);
• Fixed the footnote dialog layout (bug #37660);
• Fixed the JavaScript error which occurred when the autoshape connector was changed (bug #37788);
• Fixed the error which occurred when the default tab in a shape was changed (bug #38084);
• Fixed the issues with opening a custom color for shapes (bug #37841);
• Fixed the issue when comments from other users were missing (bug #37570);
• Fixed the bug with CFF fonts (glyph loader);
• Fixed the Cannot read property '$icon' of undefined error when using the Ctrl+S keyboard shortcut in chart editor (bug #39254);
• Removed the Command+H keyboard shortcut used for Mac OS;
• Fixed the issue with special paste icon when inserting ClipArt (bug #39462);
• Added the display of conversion error in case a PDF had been renamed to DOCX;
• Fixed the bug with a solid fill without a color;
• Fixed the issue with opening the presenter view on ownCloud\Nextcloud (bug #39559);
• Fixed the bug when a new font was applied (current font name and new name are empty);
• Fixed a lot of bugs in the files in all supported formats received from the users.

Document Editor

• Fixed getting the parent cell in blocklevelstd;
• Fixed the chinese text justification (bug #37659, DocumentServer issue #293);
• Fixed the setting for the Real-time collaboration changes option when View All is selected;
• Fixed the window layout issue with a protected document (bug #37658);
• Disabled bookmarks in the document headers (bug #38957);
• Fixed the issue with opening a DOCX file with track changes and calculations created by Aspose;
• Fixed the problem with reading the ID of a content control;
• Fixed the crash in CNumberingLvlLegacy.ReadFromBinary;
• Fixed the problem with table selection;
• Fixed the problem with replacing a misspelled word with another;
• Fixed the critical issue which occurred when the document had been locked on the undo in the Fast collaboration mode;
• Fixed the missing Hide Degree menu entry for equations (bug #39135);
• Fixed the problem which occurred when recalculations were made in co-editing;
• Fixed the problem with processing the pageDown button in co-editing;
• Fixed the Cannot read property 'eb' of nul error which occurred when a table column was deleted (bug #39252);
• Fixed the problem with rendering which occurred when replacing the text (bug #39269);
• Fixed the problem with saving/loading the table state on undo/redo;
• Fixed the issue with displaying the chart added with macros (bug #39304);
• Fixed the problem with calculating large tables separated by columns;
• Fixed the error which occurred after the selection of the font name in combo box was discarded;
• Fixed the inputs for Korean, Chinese and Japanese characters in content control (bug #39724);
• Fixed the problem with recalculating large tables in a document;
• Fixed the problem with accepting/rejecting uncalculated revision changes;
• Fixed the bug with recalculating a document when a section was deleted;
• Fixed the problem which occurred when complex fields in selection were checked;
• Fixed the problem with updating cursor position in collaborative editing;
• Fixed the bug with moving cursor through a table;
• Fixed the problem with moving an image inside a large table;
• Fixed the problem with updating the current position in table after accepting changes;
• Fixed the bug with special paste of paragraph with numbering;
• Fixed the issues with reading comments in RTF format files;
• Fixed the bug with opening a file containing image in a shape (bug #37902).

Spreadsheet Editor

• Fixed the issue with entering the functions with the arrow keys and scrolling;
• Fixed the multiselect autofit column width, now autofit will affect existing columns only (bug #37555);
• Fixed the function dependency and file generation after copying with drag and drop;
• Fixed the Out of memory error when inserting rows to the file with many columns;
• Fixed the error occurring for chart with an empty dataset (bug #37762);
• Fixed the issues with comment deleting (bug #37772);
• Fixed the issues with opening XLSX files received from users (bug #38113);
• Fixed the hyphen position for Сhinese symbols with wrapping;
• Fixed the missing translation for the functions into French and Spanish;
• Fixed the missing region formats;
• Disabled the table settings when the cell is edited;
• Fixed the issue which occurred when the active cell in selection across merge was merged;
• Fixed the issue with the selection which occurred when selecting a row/column/all;
• The options for hiding headings, gridlines, freeze panes are hidden in the viewer (bug #38033);
• Fixed the issue with the comments being lost after reopening an XLSX file (bug #37892) (DocumentServer issue #316);
• Fixed the issue with opening a file with an unknown image format;
• Fixed problems with files containing combo charts (bug #37945, #37946);
• Fixed the crash which occurred when a file was built with comment changes;
• Fixed the issue when an incorrect chart was added to the area with autofilter (bug #39168);
• Fixed the issue with the incorrectly selected cells when a formula was changed using the keyboard (bug #39181);
• Fixed the issue when the browser hung on some files with formulas (bug #39190);
• Fixed the incorrect display of doughnut chart with autofilter (bug #39200);
• Fixed the incorrect IF function values (bug #39233);
• Fixed the problem with the number of replacements made (bug #39273);
• Fixed the Cannot read property 'Zb' of null which occurred when trying to copy a shape deleted by another user (bug #39312);
• Fixed the this.dPc is not a function which occurred during the data sorting (bug #39397);
• Fixed the issues with undo applied to the filter in specific files (bug #39402);
• Fixed the scroll to end of the table issue (bug #21946);
• Fixed the issue with sorting of the first row in some files (bug #39397);
• Fixed the issue with the sorting range if filtered data was present in it (bug #39410);
• Fixed the double columns borders display issue (bug #39392);
• Fixed the issue with rendering of the last rows in some files (bug #39394);
• Disabled the cell settings when editor is disconnected;
• Fixed the issues with printing and calculation; sped up cache preparation;
• Fixed the issues with scrolling in some files (bug #39395);
• Fixed the issue with data loss in the second table sheet (bug #39511);
• Fixed the issue when the editor was freezing after consequent use of cut and paste for several columns (bug #37965);
• Fixed the incorrect sum function for the copied sheet (bug #39548);
• Fixed the JavaScript error which occurred when more data than cell width is entered (bug #39623);
• Fixed the incorrect digit counting when using the Decrease Decimal option (bug #39661);
• Fixed the issue with opening file with si and formula parameters used without ref;
• Fixed the issue which occurred when some files with chart are opened (bug #39902);
• Fixed the JavaScript error which occurred when specific sheet was copied to file during co-editing (bug #39921).

Presentation Editor

• Fixed the issue with deleting the placholder text in strict co-editing mode (bug #37712);
• Fixed the issue with the comment duplication in exported PPTX (bug #37698);
• Fixed the JavaScript error occurring when opening an empty presentation in the comment mode (bug #37679);
• Fixed the issue with copying and pasting the text into the 'Slide Title' placeholder in Fast co-editing mode (bug #37922);
• Fixed the bug with copying and pasting a slide containing a picture (bug #37928);
• Fixed the issue with placeholder titles in Chinese (bug #37927) (onlyoffice-owncloud issue #189);
• Fixed the Cannot read property 'Ia' of null error which occurred when some PPTX files were opened (bug #39191);
• Fixed the problem with negative spacing;
• Fixed the Cannot read property 'W' of undefined error which occurred when copying a table (bug #39264);
• Fixed the issue with opening some PPT files (bug #39901).

Backend

• Updated the compatibilityMode setting now preventing opening the files in MS Word 2016 compatibility mode;
• Fixed the issues which occurred when opening some DOC, RTF and XLS files received from users;
• Fixed the export of the current list from XLSX to CSV (bug #37579);
• Fixed the issues which occurred when opening specific PPTX files (bug #37589);
• Fixed the issues which occurred when opening specific RTF files (bug #37500);
• Fixed the issue with saving comments for presentation;
• Fixed the issues with slide themes when exporting to ODT (bug #37740);
• Fixed the issues with chart legend in ODS files (bug #37746);
• Fixed the issue when an empty RTF file was opened (bug #39172);
• Fixed the problems with opening of some ODS files (bug #39192);
• Fixed the conversion to raster for graphiscs on linux without set fonts;
• Fixed the binary conversion of mathType version over 3.0 with PptxFormat component;
• Fixed the problems with the document structure for specific files (bug #39236);
• Fixed the issue which occurred when opening in some resulting files in MS Word (bug #39216);
• Fixed the problems with opening specific DOCX files (bug #39248);
• Fixed the problems with opening of some RTF files (bug #39315);
• Fixed the row selection issue in PDF files (bug #39214);
• Fixed the loss of grouped autoshapes in ODT (bug #39467);
• Fixed the issue with conversion of some WMF files (bug #39533);
• Fixed the bug with metadata in UTF-16 format;
• Fixed the issue with conversion of some XLS files (bug #39541);
• Fixed the issue with conversion of some VML files with drawing_ml markup;
• Refactoring of auto shapes for OdfFormat;
• Fixed the bug with calculating an inverse matrix in PDF.

New features

All editors

• Added the new View Settings menu option at the top right corner of the editor window;
• Added the possibility to replace the image via context menu (bug #11493);
• Updated translations;
• Added the new no-squares font engine, which finds the best replacement font for the □ characters;
• Added the possibility to distribute the data in tables;
• Completely rewritten the composite input for characters;
• Added the new header and background color;
• Added the support of shape side panel for images;
• Added the support for changing the table size using drag'n'drop;
• Added the new bullet list marker: –;
• Increased the document supported size (without media content).

Document Editor

• Implemented the East Asian script and line break in hieroglyphs support (sdkjs issue #300);
• Added the Ctrl+Shift+Num8 hotkey to show/hide nonprinting characters;
• Added the support of multiple comments display in the comment balloon (bug #37422);
• Added the support for the Table of Contents;
• Added the possibility to set the Tab leading symbols;
• Added the new Navigation left sidebar item;
• Added the new References tab;
• Fixed the issue when version history could not be saved if the second user joined the co-editing in the Strict mode; now it is saved if the first user has autosaving disabled;
• Renamed the Display Modes entries for Track Changes option;
• Changed the behavior of the Go to documents option, it now opens a new tab;
• Added the possibility to set negative values for the top and bottom page margins;
• Copying the paragraph style will not overwrite the custom set style;
• Added the special paste of tables.

Spreadsheet Editor

• Added the translation of functions into French;
• Added the translation of functions and their descriptions into Spanish;
• Added the possibility to select the cell format via context menu (bug #16272);
• Custom user cell styles are now placed before the default ones;
• Added the new functions: F.TEST, FORECAST.ETS, FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, FORMULATEXT, IFS, PDURATION, CONVERT, FTEST, HYPGEOM.DIST;
• Added the new None table template;
• Added the new regional presets: Deutsch (Schweiz), Español (México), Nederlands (Nederland), Slovenčina (Slovenská republika);
• Added the new date formats: yy/m/d, yy/mm/dd, yyyy/m/d;
• Added the preview for the CSV files before opening them;
• Added the new selector for link type.

Presentation Editor

• Added hints for presentation themes (bug #21362);
• Added the special paste;
• Added the presentation level comments;
• Added the new selector for link type.

Backend

• Updated the ICU dependency version from 5.5 to 6.0;
• Added the support for a lot of features for XLS format (macros, controls, etc.);
• 5-10% speedup of opening OOXML files;
• Better compatibility with OpenFormat and RTF;
• Fixed a lot of bugs in the files in all supported formats received from the users.

Documentation

• New documentation articles describing the 5.1 version new features;
• Added the translation of the documentation for Document Editor and Presentation Editor into French, Spanish, German, for Spreadsheet Editor into French;
• Added search in the documentation pages.

Fixes

All editors

• Fixed the crash on opening the files with empty pie charts (sdkjs issue #318);
• Fixed the undo error occurring after copy/paste in co-editing (bug #37424);
• Fix problems with some Thai symbols (bug #37446) (sdkjs issue #297);
• The fonts with the zero width of the glyphs are now hidden from the font picker;
• The changes for undo/redo are not saved in server build mode;
• Changed the size of the images pasted from HTML;
• Fixed the problem with the text selection when using the Shift key;
• Fixed the redundant symbol appearing in cells after undo-redo operation (bug #37343);
• Fixed the problems with the icons of some buttons;
• Fixed the synchronization of the co-editing mode between the top toolbar button and the menu (bug #37377);
• Fixed the toolbar icons problems.

Document Editor

• Fixed the issue with the table display after HTML conversion (bug #37472);
• Fixed the bug which occurred when a comment was added to the whole document (bug #37425, DocumentServer issue #287, sdkjs issue #319);
• Fixed the issue with copying the Rich Text Content from a table (bug #37546) (sdkjs issue #320);
• Replaced the content control GetTag method used with the GetLabel one (sdkjs issue #296);
• Fixed the issue with searching the text in drawings (sdkjs issue #292);
• Fixed the problem with loading a PDF file which has been renamed to DOCX (sdkjs issue #295);
• Fixed the right-mouse button menu for the table of contents (#37241);
• The images in Text Art objects are not clipped;
• Added the vertical clip for drawing the inline objects;
• Fixed the problems with drawing the inline objects;
• Fixed the bug with wrong calculation of the text clip rectangle.

Spreadsheet Editor

• Fixed the issues with the function dependencies and file assembly after adding a column or row (sdkjs issue #312);
• Fixed the issues with opening some XSLX files (bug #37515) (sdkjs issue #316);
• Fixed the issue with opening the pivot tables which contain VALUES (sdkjs issue #298);
• Fixed the right mouse button error (bug #37330);
• Fixed the issue occurring when hieroglyphs from the text editor were inserted (bug #37356);
• Fixed the bug occurring when autocomplete did not work for functions if the point character is present in function name (bug #37300);
• Fixed the bug occurring when autocomplete did not work for functions if the _ or \ character are used in the named range (bug #37354);
• Fixed the bug occurring when autocomplete did not work for functions if Chinese numbers were used;
• Fixed the issues with sheet context menu visibility (bug #37307);
• Fixed the translations for functions;
• Fixed the problems with inserting the function into the cell which is opened for editing (bug #37348).

Presentation Editor

• Fixed the problem with hieroglyphs in chart title (bug #37293);
• Fixed the chart title focusing problem during co-editing (bug #37295);
• Fixed the object selection problem during co-editing (bug #37336);
• Fixed the bug with clearing the cached canvas;
• Fixed the bug with calculation of slide layout bounds.

Backend

• Fixed the issues which occurred in some user files containing tables (core issue #71);
• Fixed the issues with opening DOCX, PPTX, RTF, and ODF files received from users (core issue #75 and core issue #76);
• Fixed the Mac OS related build problems;
• Fixed the shape geometry occurring in PPT files from the latest MS Office versions;
• Fixed the font generation;
• Fixed the issue which occurred when reopening files containing macros (bug #37323);
• Fixed the issues which occurred when opening some DOCX and XLS files received from users.

New features

All editors

• Added support for the two-factor authentication;
• Added Brazilian Portuguese as a new interface language.

Spreadsheet Editor

• Added strikeout, superscript and subscript options to the top toolbar (bug #26581).

Fixes

All editors

• Updated translations.

Document Editor

• Fixed the issue with opening DOCX file containing formula in MS Word (bug #36490);
• Fixed the JavaScript error which occurred while inserting a spreadsheet cell with comment (bug #36506);
• Fixed the bug with inserting the content control into a math equation;
• Fixed the selection from object in header/footer not being reset after keyboard move.

Spreadsheet Editor

• Fixed the wrong dependence in some functions with references to other sheets which occurred after a sheet was removed;
• Fixed the issue with opening an ODT file containing a chart;
• Fixed the issue with calculating a sparkline in some cases (bug #36603);
• Fixed the issue with printing an image outside of the printing range (bug #36573).

Presentation Editor

• Fixed the issue with blocking the shape for the users co-editing in different modes (bug #36435);
• Fixed the issue with the Constant proportions chart button working only once (bug #36494);
• Fixed the JavaScript error which occurred while inserting a page number from Document Editor (bug #36508);
• Fixed the JavaScript error which occurred while undoing a table (bug #36515).

Conversion

• Fixed the issues with some DOCX, DOC, RTF files from the users;
• Fixed the issues with MathType equations in some DOCX files (bug #36524).

New features

All editors

• New preinstalled plugin set;
• Added the support for SSO authorization at the portals;
• Added Czech and Slovak as new interface languages;
• Added the support for macros;
• Added the support for FODS, FODT, FODP formats.

Fixes

All editors

• Fixed the bug with image paths.

Document Editor

• Fixed the JavaScript error which occurred when inserting an empty cell to the chart title (bug #36441);
• Fixed the red cross issue with the images in some situations;
• Fixed the bug with the synchronization of data from several dialog windows;
• Fixed the line ending in thumbnails;
• Fixed the issues with pasting the simple text to equations;
• Fixed the cursor issues with object rotation (bug #36114);
• Fixed issues with opening some DOCX files (bug #35307);
• Fixed the issue with the chart legend being blocked during co-editing (bug #35492);
• Fixed issues when the tab was set several times (bug #34923);
• Fixed printing in Microsoft Edge (bug #35323);
• Fixed the documentation on moving the shape by a pixel (bug #34983);
• Fixed the special paste in fast co-editing mode (bug #35310);
• Fixed issues with duplicates in strict co-editing mode after the special paste (bug #35312);
• Fixed bug with moving the cursor to the beginning of the document after removing the content control;
• Fixed minor problems with co-editing in real time (bugs #35398, #35399, #35400);
• A lot of fixes in the existing translations.

Spreadsheet Editor

• Fixed the a.Se is not a function error while opening some files (bug #36344);
• Fixed the error with merged table colors;
• Fixed the cell merging after a table template is applied (bug #36405);
• Fixed the JavaScript error for some pivot table styles (bug #36290);
• Checked the xfIndexNumber when merging styles to avoid the errors with column styles;
• Fixed the conditional formatting while changing cell values (bug #36253);
• Fixed the issue with the shape size not changing with the help of yellow markers (bug #35451);
• Fixed the VLOOKUP and HLOOKUP functions being case sensitive (bug #35528, DocumentServer#140);
• Fixed the Show empty cells as box in Russian (bug #35299);
• Fixed the sparkline type in the settings window (bug #35296);
• Fixed the JavaScript error in the conditional formatting with the function and offset (duplicate variable) (bug #35334);
• Fixed the JavaScript error in SEARCH function (bug #35340);
• Fixed the freeze pane shadow which had not been hiding (bug #35359);
• Fixed showing the hidden objects;
• Fixed the VLOOKUP cell format;
• A lot of fixes in the existing translations.

Presentation Editor

• Fixed the issue with the button layout in the reporter mode;
• Disabled the scroll to target function in selectwheel (when the selection is empty);
• Fixed applying the image as a background for several slides (bug #36399);
• Fixed the mouse slide scroll without the zoom change (bug #28096);
• Fixed disabling the Previous/Next buttons during the slide demonstration;
• Fixed the presentation demonstration issue appearing when starting from the beginning;
• Fixed the issue with scrolling the notes;
• Fixed the text insert operation duration (bug #36208);
• Fixed the browser zoom problem with the pointer;
• Fixed the reporter mode resizing in Microsoft IE;
• Fixed the bug with positioning the hyperlink and slide number tooltips;
• Fixed the slide resizing bug;
• Fixed the issue with the text search in a placeholder (bug #36133);
• Fixed the layout problem in the reporter mode;
• Fixed the JavaScript error in Tables_test.pptx file (bug #17147);
• Fixed the comment bug (bug #35408);
• Fixed the bug with drag-and-dropping the chart into a title;
• Fixed changing the presentation language if no shape was selected (bug #35231);
• Fixed the columns in the placeholder (bug #35074);
• Fixed the connector losing shape when moving shapes in a group (bug #35317);
• Fixed the hidden markers for the connector on a chart and an image (bug #35300);
• Fixed the cell link reference issue after the copy-paste operation (bug #35362, DocumentServer#122);
• A lot of fixes in the existing translations.

Plugins

• Fixed crashes when resizing an unknown OLE object;
• Fixed the problems with scrolling.

Conversion

• Fixed the colors schemes for table cells (bug #36322);
• Fixed the problem with the images in footnote (bug #36380);
• Fixed saving some files to ODT (bug #35389);
• Fixed the custom shape for the connectors in XLS;
• Fixed the issue with margins in ODS;
• Fixed the converted named range with the formulas in ODS;
• Fixed the audio WAV files in PPTX;
• Fixed the old OLE standard in PPTX.

New features

Document Editor

• Added the Special Paste feature;
• Added the rich text content support;
• Added translations for the paragraph styles;
• Added the comments display in the view mode;
• Added the option to hide the resolved comments;
• Added the option to specify custom columns.

Spreadsheet Editor

• Added the support for the functions with conditional formatting;
• Added the possibility to specify a custom delimiter for the CSV file import/export;
• Added support for the ACOT, ACOTH, ARABIC, BASE, BETA.DIST, BETA.INV, BETADIST, BINOM.DIST, BINOM.INV, CEILING.MATH, CEILING.PRECISE, CHIDIST, CHIINV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, COMBINA, CONCAT, CONFIDENCE.NORM, CONFIDENCE.T, COT, COTH, CSC, CSCH, DECIMAL, EXPON.DIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, FDIST, FINV, FLOOR.MATH, FLOOR.PRECISE, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMA.PRECISE, GAMMADIST, GAMMAINV, GAUSS, IFNA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, ISO.CEILING, LOGNORM.DIST, LOGNORM.INV, NUMBERVALUE, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, RANK, RANK.AVG, RANK.EQ, SEC, SECH, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, TDIST, TINV, XOR functions;
• The hidden rows are now excluded from copying, autofilling, formatting etc.;
• Updated the active cell color;
• Changed the frozen pane display: now it has shadow;
• Added translations for the cell styles;
• Added the possibility to search and replace using the data from the selection;
• Added the option to hide the resolved comments;
• Added the possibitity to specify bullets and numbering for the text within a shape;
• Added the possibility to specify columns for the text areas;
• Added the possibility to add the connectors for the shapes;
• Added the support for Shift+Delete, Ctrl+Insert and Shift+Insert keyboard shortcuts for cut/paste operations.

Presentation Editor

• Added the possibility to connect shapes using the lines;
• Added the possibility to specify columns for the text areas;
• Added the possibitity to specify bullets and numbering for the text within a shape;
• Added the spellchecker;
• Added the possibitity to download the file as ODP.

Plugins

• Added the new plugin window type (without borders, shadows, buttons).

x2t

• Dramatically increased the speed for opening the OOXML files: 200% faster in Windows, 20% faster in Linux;
• Enhanced the conversion from/to RTF format;
• Enhanced support for password protected OOXML and binary Microsoft files (DOC, XLS);
• Added support for password protected PPT files.

Fixes

Spreadsheet Editor

• Fixed duplicate text appearing after the carriage return (DocumentServer issue #109).

New features

All editors

• Added full support of high-DPI monitors;
• Added the possibility to set alternative text for shapes.

Document Editor

• Added the undo option for the Fast co-editing mode;
• Added the All changes saved caption in the bottom toolbar;
• Added an option to add and edit footnotes;
• Added new languages for spellchecker (43 in total).

Spreadsheet Editor

• Added support for the AVERAGEIFS, COUNTIFS, SUMIFS functions;
• Refactoring and improvements for formulas;
• Added a totally new Cell Format window with more options;
• Added the possibility to use sort options window while sorting ranges;
• Added the sorting direction for the filter buttons;
• Added the filter condition at statistical information;
• Added the special paste feature;
• Added the support for the surface chart;
• Added the new cell border styles (11 in total).

Presentation Editor

• Added the undo option for the Fast co-editing mode.

Conversion

• Optimization and speed-up;
• Better support for all formats, including (but not limited to) the ones listed below:

  DOC

  • Support for the page backgrounds.

  XLS

  • Support for data validation;
  • Support for decryption.

  ODF

  • Support for global document settings;
  • SVG refactoring;
  • Support for the page backgrounds (image, pattern, gradient);
  • Support for the smart art conversion;
  • Support for sheet/workbook views;
  • Support OLE and other embedded objects conversion.

  RTF

  • Added hyperlink text replacement generation if it is absent;
  • Added support for office digital signatures;
  • Added extended drawings;
  • Added custom shapes;
  • Added support for the text when drawing shapes.

Fixes

Document Editor

• Fixed the issue with drag'n'dropping a table inside a footnote (bug #33548);
• Fixed the issue with cropping of shape group (bug #33110).

Spreadsheet Editor

• Fixed the issue with the absolute reference when inserting a new row (ONLYOFFICE/DocumentServer#41);
• Fixed the issue with the onDocumentStateChange event (ONLYOFFICE/DocumentServer#88);
• Fixed the issue with the formula translations (ONLYOFFICE/DesktopEditors#23);
• Fixed the issue with the password-protected XLSX (ONLYOFFICE/DesktopEditors#24);
• Fixed the issue with a non-breaking space (ONLYOFFICE/DesktopEditors#26);
• Fixed the issue with the AVERAGEA function which has text format;
• Fixed the issue with the broken workbook after copying the list (bug #33588);
• Fixed the issue with the formula recalculation by F4 hotkey (bug #32901);
• Fixed the issue with SUMIFS function (bug #33602);
• Fixed the issue with the image size when inserting (bug #33604);
• Fixed the issue with the sparkline zero values (bug #33612);
• Fixed the issue with changing the number format when changing the regional format (bug #31395);
• Fixed the issue with replacing the formula delimiters (bug #33608);
• Fixed the issue with cell size while drag'n'dropping (bug #33607);
• Fixed the issue with the cursor size in @2x resolution (bug #33606);
• Fixed the error when the files got broken if you tried to change the style of an unsupported chart (bug #34650);
• Fixed the stack error while copying a big array of formula data;
• Fixed the error of rendering a 3D diagram in a small area (bug #34632);
• Fixed the error when chart range was changed while applying a preset.
• Many other minor and major bugfixes.

Fixes

All Editors

• Prevent editors from performing the save operation if there are no changes to save.
• Fixed a rare problem occurring when saving a file with a specific chart type.
• Fixed the problems with copy-paste functions.

Document Editor

• Fixed the problem with the changes missing when several users enter the text at the same time (bug #33726)
• Fixed the bug with the cursor positioning after the InsertContent function is used.

Spreadsheet Editor

• Fixed the wrong order of elements in equations (bug #34029).
• Fixed entering the characters with diacritical symbols (bug #33908)
• Fixed the horizontal scroll when using a trackpad (bug #27197)
• Fixed error occurring when assembling files with Ranges in some rare cases.
• Fixed errors occurring when converting from the XLSX to the CSV format.
• Fixed the Match formula return value in some cases (bug #33735)

Presentation Editor

• Fixed a problem occurring when saving a file with the notes copied from Document Editor;
• Fixed a problem occurring when saving a file with a chart copied from Presentation Editor.

New Features

All Editors

• Added the possibility to set a dash type for shapes;
• Better support of HiDPI systems.

Document Editor

• Added the possibility to open and edit footnotes;
• Ability to insert number of pages into the document;
• Remade version history. Added the possibility to hide minor features.

Spreadsheet Editor

• Added the possibility to insert equations in Spreadsheet Editor;
• Added the possibility to open and edit sparklines;
• Added a new SUMIFS function;
• Added the possibility to select data from the drop-down menu in the context menu;
• Added a multiselection support;
• Added the rotation of 3D charts;
• Updated and improved the visual styles for all chart types;
• Brought back the Freeze Panes option in the View Settings menu;
• Added the new algorithm for calculating a cell height.

Presentation Editor

• Added the possibility to insert equations in Presentation Editor.

Fixes

Document Editor

• Fixed the broken Insert number of pages button;
• Fixed the problem with the last hieroglyph duplicate;
• Fixed the problem with changing the chart type from 2D to 3D.

Spreadsheet Editor

• Fixed the problem with an empty cell when changing sparklines.

x2t

• Improved compatibility with the DOC format.