Articles avec le tag :
Fermer
Changelog
Fermer
Centre d'aide
Document Server for Linux

Compiling Document Server for a local server

Document Serverv.5.2 Document Server changelog

Version 5.2.3

Release date: 10/31/2018

New features

All editors

  • Updated the interface translations to all the main languages available in the editors.

Spreadsheet Editor

  • Enhanced the application due to the completely rewritten scroll.

Document Builder

  • Added the new setLocale and getLocale functions.

Server

  • Added logging for SaveLock;
  • Added the possibility to copy the changes and files with browser error to a special directory.

x2t

  • Performed refactoring for conversion of WordArts from ODF to OOXML and vice versa;
  • Performed refactoring for conversion of form controls in spreadsheets (for ODF files);
  • Added conversion for bookmarks for OdfFormatwriter component.

Fixes

All editors

  • Fixed the bug with CFF fonts (glyph loader);
  • Added the display of LoadingScriptError error in case of sdk-all.js loading faiure;
  • 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.

Document Editor

  • 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 bug with pressing the TAB key;
  • 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 Cannot read property 'length' of null error which occurred when some files were opened (bug #39210);
  • 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.

Spreadsheet Editor

  • 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 Maximum call stack size exceeded which occurred when the application was switched to fullscreen (bug #38972);
  • 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.

Presentation Editor

  • 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).

Embedded viewer

  • The viewer now shows an error when trying to open password protected files (bug #39251);
  • Fixed the JavaScript error which occurred when opening TXT files (bug #39250).

Server

  • Fixed the license endDate information for trial version;
  • Fixed the Cannot read property 'time' of null error;
  • Changed the logrotate configuration directory.

x2t

  • 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 the user files in XlsFormatReader component;
  • Fixed the problems with the user files in PptFormatReader component;
  • Fixed the problems with some user files in PptxFormat component;
  • Fixed the problems in OdfFormat and OdfFormatWriter components;
  • Disabled truetype fonts conversion in HTML viewer;
  • Fixed the problems with opening of some RTF files (bug #39315);
  • Fixed the row selection issue in PDF files (bug #39214);
  • Fixed the issue when only the last ConditionalFormatting was written from the Editor.bin (bug #39391).

Docker image

  • Fixed the ‘/var/run/rabbitmq’: Permission denied issue on container restart (Docker-DocumentServer issue #92);
  • Fixed the startup on minishift removing the /etc/onlyoffice;
  • Setup the correct logrotate configuration rights.

Version 5.2.2

Release date: 10/05/2018

Fixes

RPM

  • Fixed the DS_PORT problem which occurred during the installation of ONLYOFFICE Enterprise Edition.

Version 5.2.0

Release date: 09/28/2018

New features

All editors

  • Added the possibility to customize the initial zoom for the embedded editors;
  • 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);
  • Changed the encoding format for the TXT files (bug #36998);
  • Added the mode for filling forms;
  • Enabled closing the chart dialog while loading (bug #36870);
  • 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 possibility to set options when saving to PDF format (bug #34914);
  • 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 closing the window when saving to CSV;
  • Enabled saving page options to a file before printing;
  • Added the possibility to view combo charts.

Presentation Editors

  • 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).

Mobile web editors

  • Added the sheet renaming option in the mobile editor (bug #37701).

Server

  • Added the savefile request handler;
  • Renamed crypted into encrypted, transferred replyStr to saveUrl handler;
  • Added useridoriginal parameter to all messages in chat;
  • userId parameter is now used instead of sessionId in locks (server issue #91);
  • Added the PDFA file type;
  • Added the spawnOptions config parameter for X2T;
  • The title parameter is now used in ConvertService.ashx;
  • The forked statsd is now used to support Ubuntu 18.04;
  • The branding parameter is now set to int instead of string and boolean for older versions;
  • A new plugins key is now used instead of branding (reverted to boolean);
  • Added the reSave parameter to mark saving of the repeated changes;
  • Added the info/json handler for license;
  • Added the /info page (available only from localhost).

Package

  • The package version is now used to disable cache prefix;
  • The package version in server URLs are now used instead of date;
  • The custom port setup is added to the example URL in IIS;
  • The configs in local.json have been redesigned;
  • Added the support of logrotate;
  • Added the libcurl3-gnutls dependency for the DEB package;
  • The license has been updated.

Plugins

  • Added the display of a message when an error has occurred (in ClipArt).

Docker image

  • Node.js has been updated to version 8;
  • Added output logs to console and correct support of docker logs;
  • The interactive flag to start container is no longer required.

Document Builder

  • Added the following API functions: GetRows, GetCols, GetCount, GetHidden, SetHidden, GetColumnWidth, SetColumnWidth, GetRowHeight, SetRowHeight, GetWpar, SetOffset, GetAdress, SetLeftMargin, GetLeftMargin, SetRightMargin, GetRightMargin, SetTopMargin, GetTopMargin, SetBottomMargin, GetBottomMargin, SetPageOrientation, GetPageOrientation, GetSelection;
  • Added the following API properties: Rows, Cols, Count, Hidden, ColumnWidth, Width, RowHeight, Height, MergeArea, WrapText, LeftMargin, Orientation, PrintHeadings, PrintGridlines, Selection.

Fixes

All editors

  • Fixed the issue when comments from other users were missing (bug #37570);
  • Fixed the issues which occurred when opening some files received from users.

Document Editor

  • Disabled bookmarks in the document headers (bug #38957);
  • Fixed XML parsing error in Firefox (bug #36960).

Spreadsheet Editor

  • 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).

Server

  • Fixed the maximum file size for conversion value (bug #37559);
  • Fixed the installation on any linux system by using useradd (server issue #89);
  • Fixed the fillForms mode;
  • Fixed the healthcheck service behavior in case of disconnected Redis or RabbitMQ;
  • Now the authorization header is not reduced if the inBody option is used;
  • Improved the average calculation at server start;
  • The SVG image file format pasting is now not allowed.

Package

  • Updated the innodependencyinstaller to fix the requirements detection.

Plugins

  • Fixed the issue with ClipArt being of zero size;
  • Fixed the error which occurred when adding macros (bug #38408).

Document Server integration examples

  • Fixed the issues which occurred when several files were added at once (bug #37017);
  • Fixed the issues with uploading big files;
  • Fixed the comment mode available for Spreadsheet Editor only;
  • Java example: fixed the encoding space and path problems;
  • PHP example: fixed a lot of problems with URLs.

x2t

  • Fixed the issues which occurred when opening some files received from users.

Version 5.1.5

Release date: 07/18/2018

New features

Backend

  • Added the logging and warning for the errors concerning license connections and user limit, as well as the appropriate settings to the configuration file.

Fixes

All editors

  • Updated the interface translations to all the main languages available in the editors;
  • 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).

Spreadsheet Editor

  • 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 chinese 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.

Presentation Editor

  • 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).

Mobile editors

  • Fixed the browser hangup which occurred when shapes were added (bug #37601);
  • Fixed the JavaScript error which occurred in specific XLSX files (bug #37824) (DocumentServer issue #311);
  • Fixed the incorrect caption used for the document loading (bug #37687);
  • Fixed the issue with document closing which occurred when the 'Back' button was tapped (bug #37649);
  • Fixed the placement of the Settings icon (bug #37738).

PDF viewer

  • Fixed the browser hangup occurring on some specific PDF files (bug #37466).

Docker

Conversion services

  • Fixed the issue with opening some XPS files (bug #37565);
  • Fixed the issue with clipping of a shape in header/footer (bug #36423);
  • Fixed the bug with calculating an inverse matrix in PDF.

x2t

ODF

  • Fixed table width in ODT format files (bug #37832);
  • Fixed the issues which occurred when opening some files received from users.

RTF

  • Fixed the issues with reading comments in RTF format files;
  • Fixed the bug with opening a file containing image in a shape (bug #37902);
  • Fixed the issue with plugin data not being saved (bug #34747);
  • Fixed the issues which occurred when opening some files received from users.

XLS

  • Fixed problems with files containing combo charts (bug #37945, #37946);
  • Fixed the issues which occurred when opening some files received from users.

Version 5.1.4

Release date: 05/24/2018

New features

All editors

  • 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.

Backend

  • Added the openProtectedFile option to disable opening password-protected files.

DEB and RPM

  • Removed the upper version dependency for Node.js;
  • Removed the librabbitmq-tools dependency.

x2t

  • Updated the compatibilityMode setting now preventing opening the files in MS Word 2016 compatibility mode;
  • Added the long file name support for MS Windows.

Fixes

All editors

  • Updated the interface translations to all the main languages available in the editors;
  • Fixed the z-index value for tooltip synchronization;
  • 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 layout for the changes review dialog.

Document Editor

  • Fixed getting the parent cell in blocklevelstd;
  • Fixed the chinese text justification (bug #37659, DocumentServer issue #293);
  • Fixed the problem with the navigation sidebar focus in Firefox (bug #37460);
  • 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).

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).

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).

Mobile editors

  • Disabled the edit button during the document load;
  • Fixed the function descriptions (bug #37691);
  • Fixed the round corners for modal windows (bug #37700).

Backend

  • Removed the payload field from JWT when the inBody option is on;
  • Performed the refactoring for the install/uninstall shared libraries.

DEB

  • Fixed the DS_COUNT: command not found uninstall error;
  • Fixed the uninstallation error with the documentserver-prepare4shutdown.sh script;
  • Fixed the libcurl dependency for Ubuntu 18.04.

x2t

  • 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);
  • Downgraded the ICU dependency version to 5.8.2 (which is compatible with MS Windows XP and Windows Vista).

Version 5.1.3

Release date: 04/27/2018

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);
  • Added the possibility to customize the initial zoom for the embedded editors.

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 possibility to export documents to the RTF format.

Spreadsheet Editor

  • Added the translation of functions into French;
  • Added the possibility to select the cell format via context menu (bug #16272);
  • Added the new selector for link type.

Presentation Editor

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

Document Builder

  • Added the GetColumnWidth method which allows to get the width of the current column (sdkjs issue #315).

Backend

  • Updated the ICU dependency version from 5.5 to 6.0.

Mobile editors

Integration example

  • Added the support for OTT, OTS and OTP formats.

Fixes

All editors

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).

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).

Mobile Document Editor

  • Fixed the issues with replacing the text which occurred when a new paragraph was created (bug #37456).

Mobile Spreadsheet Editor

  • Fixed the bug with scrolling;

x2t

Version 5.1.2

Release date: 04/11/2018

New features

Document Editor

  • Added the support of multiple comments display in the comment balloon (bug #37422).

Documentation

  • Updated the documentation articles describing the 5.1 version new features.

Fixes

All editors

  • Fixed the crash occurring when a document was loaded in Safari 11.1;
  • Fixed the undo error occurring after copy/paste in co-editing (bug #37424);
  • Fix problems with some Thai symbols (bug #37446) (sdkjs issue #297).

Document Editor

  • Replaced the content control GetTag method used with the GetLabel one (sdkjs issue #296);
  • Fixed the crash occurring when PDF file is reconnected or checked if idle (sdkjs issue #291);
  • 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).

Spreadsheet Editor

  • Fixed the copy/paste error occurring in the open source version menu (bug #37426);
  • Fixed the translations for functions into Spanish;
  • Fixed the issue with opening the pivot tables which contain VALUES (sdkjs issue #298).

Presentation Editor

  • Fixed the issues with the reporter mode in Safari.

Backend

  • Fixed the problem which led to the file corruption caused by the restored connection when the file version is assembled (server issue #80).

x2t

  • Fixed the Mac OS related build problems;
  • Fixed the shape geometry occurring in PPT files from the latest MS Office versions.

Version 5.1.1

Release date: 04/05/2018

New features

All editors

  • Updated the interface translations to all the main languages available in Document Server.

Spreadsheet Editor

  • Added the CONVERT, FTEST, HYPGEOM.DIST functions;
  • Added the translation of functions and their descriptions into Spanish.

Backend

  • Added the reconnection.attempts and reconnection.delay options to the configuration file; these options are applicable for the editor-server connection;
  • Added the fonts folder to the static content;
  • Added the sockjs config section for testing purposes.

Documentation

  • New documentation articles describing the 5.1 version new features.

Fixes

All editors

  • 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 error with the repeated reconnection;
  • 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).

Document Editor

  • Fixed the right-mouse button menu for the table of contents (bug #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;
  • Fixed the issue when the B8a property with the null value could not be read in some files (bug #37378);

Spreadsheet Editor

  • 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 Cannot read property 'toLocaleString' error in some files (bug #37343);
  • Fixed the Cannot read property '4' error in some files (bug #37376);
  • 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);
  • Removed the console.log for End_CollaborationEditing;
  • Fixed the bug with clearing the cached canvas;
  • Fixed the bug with calculation of slide layout bounds;
  • Fixed the Cannot read property 'Ec' of null error in some files (bug #37386).

Backend

  • Fixed the font generation;
  • Fixed the inconsistent database status after the files assemble and the open/close connection is too fast.

x2t

  • 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.

Desktop Editors

  • Fixed the bug with the gradient;
  • Fixed the issue with printing the cell borders (bug #35367).

Version 5.1.0

Release date: 03/28/2018

New features

All editors

  • 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;
  • Added the new fonts to the default font set;
  • 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: ;
  • Rewritten the connection of the second user to document in the Strict mode;
  • Increased the document supported size (without media content);
  • Added Korean and Latvian as interface languages.

Document Editor

  • 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;
  • Renamed the Review tab to Collaboration;
  • Renamed the Display Modes entries for Track Changes option;
  • 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;
  • 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

  • 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;
  • Added the new None table template;
  • Added the new editing tools for the pivot tables;
  • 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.

Presentation Editor

  • Added the special paste;
  • Added the presentation level comments.

Plugins

  • Added the Macros plugin;
  • Fixed the plugin autostart problem.

x2t

  • 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.

Document Builder

  • Added the Format, GetSheet, GetSheets methods for the Api class;
  • Added the ForEach, GetValue methods for the ApiRange class;
  • Added the GetCells, GetIndex, GetName, GetRowHeight, GetUsedRange, GetVisible, SetVisible methods for the ApiWorksheet class.

Documentation

  • 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 a lot of bugs;
  • Fixed the toolbar icons problems;
  • Fixed the editing issues occurring when connecting a document with numerous changes.

Version 5.0.7

Release date: 01/16/2018

New features

Licensing

  • Added the new license type: licensing by the unique user IDs and access period.

Document Builder

  • Added a lot of getters and setters to the methods for the Spreadsheet Editor;
  • Added the new AddSheet method.

Spreadsheet Editor

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

Documentation

  • Added the documentation about the program interface.

Fixes

All editors

  • Updated the translations into main editor languages;
  • Set focus out of the editor frame in MS Internet Explorer/Edge browsers.

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).

Backend

  • Fixed the IIS URL Rewrite issue which occurred when uploading an image;
  • Fixed the issue with the TTF fonts not being gzipped.

Integration example

  • Removed the Integration Edition caption from the logo.

x2t

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

Version 5.0.6

Release date: 12/11/2017

New features

Licensing

  • Added the new license type: licensing by the number of unique users.

Fixes

Document Editor

  • Fixed the JavaScript error which occurred when inserting an empty cell to the chart title (bug #36441);
  • Temporarily removed the non-actual Rich Text Content control documentation files;
  • Fixed the bug with the Clipart plugin window not hiding if version history is opened (bug #36464).

Backend

  • Reduced the long outgoing authorization request headers (bug #36202).

Windows version

  • Fixed enabling the JWT in Document Server example.

Version 5.0.5

Release date: 11/28/2017

New features

Desktop editors

  • Added two types of restrictions for the document editing - OnlySignatures and View.

Fixes

All editors

  • Fixed the red cross issue with the images in some situations.

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).

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).

Plugins

  • Fixed calling the plugins in the non-tabbed interface (issue #84);
  • Fixed crashes when resizing an unknown OLE object;
  • Added the progress bar the the Yandex.Translate plugin.

x2t

  • Fixed the colors schemes for table cells (bug #36322);
  • Fixed the problem with the images in footnote (bug #36380).

Backend

  • Fixed the connection calculation so that the users viewing the document were exclueded from the total connection number value.

DEB

  • Fixed the Node.js dependency (forced Node.js 6 LTS).

Document Builder

  • Reduced the service key size to 20 characters;
  • Changed HTTP error code from 403 to 402 in case of incorrect license.

Version 5.0.4

Release date: 11/14/2017

Fixes

All editors

  • Refactoring: removed some unused code;
  • Fixed the Polish language bug (AltGr + X/AltGr + C when using Mozilla Firefox/MS Edge);
  • Fixed the bug with image paths.

Document Editor

  • Fixed the bug with removing and adding items from the listview;
  • 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 issue with opening the version history.

Spreadsheet Editor

  • 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).

Presentation Editor

  • 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.

Backend

  • Fixed the issue with the conversion task being lost when entering and leaving the editor quickly (endless opening);
  • Fixed the timeout error appearing when the first user does not perform saving.

Version 5.0.3

Release date: 11/02/2017

New features

Distribution

  • Renamed the onlyoffice-documentserver-integration distribution package to onlyoffice-documentserver-ie;
  • Added the new distribution package for developers: onlyoffice-documentserver-de.

All editors

  • Updated the messages about the version limitations;
  • Added Sogou Pinyin input in Google Chrome;
  • Added the support for FODS, FODT, FODP formats.

Plugins

  • Added the new plugin scheme (system & parallel work).

Windows version

  • Added the Accept license dialog window to the installation.

Fixes

All editors

  • Fixed the button outlines in Mozilla Firefox;
  • Fixed the Developer Mode caption rotation in Microsoft IE11 (bug #36076).

Document Editor

  • Fixed the JS error occurring when the Text Art was added using the Enter button (bug #36134);
  • Fixed the cursor issues with object rotation (bug #36114).

Presentation Editor

  • 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).

Embedded viewer

  • Fixed the Error code -23 issue (bug #36122).

Backend

  • Fixed the error when the view mode was determined without taking into consideration the permissions.comment settings.

RPM

  • Fixed the SELinux usage with custom ports.

Plugins

  • Fixed the bug with the resize cursor in the plugin window;
  • Fixed the JavaScript error which occurred when running the PhotoEditor (bug #36050);
  • Fixed the problems with scrolling.

Version 5.0.2 SaaS only

Release date: 10/13/2017

New feature

Backend

  • Added the Document Builder service.

Plugins

  • Added the possibility to automatically start the plugins.

Fixes

All editors

  • Updated the interface translations.

Document Editor

  • Fixed the issue with sending the mail in the mail merge (bug #36007).

Spreadsheet Editor

  • Fixed the issue with loading the table styles.

Presentation Editor

  • Fixed the bugs in the Reporter mode;
  • Fixed the issue which occurred when the slide was moved (bug #36031).

Version 5.0.1 SaaS only

Release date: 10/05/2017

New feature

Integration example

  • Added support for the OpenDocument Flat Document file type.

Fixes

All editors

  • Updated the translations and help files;
  • Fixed the rebranding logo (bug #35860);
  • Fixed the click on the logo;
  • Fixed the text input after copying the comment (bug #35851).

Spreadsheet Editor

  • Fixed the following hotkey issues: Ctrl+L (bug #35854), Alt+H (Firefox problem - bug #35857), Ctrl+= (Firefox problem - bug #35853);
  • Fixed the issue with recalculating the absolute formulas (bug #28388);
  • Fixed the issue with replacing the text in pivot tables (bug #35858);
  • Fixed the issue with incorrect characters after copy-paste within a shape (bug #35913);
  • Fixed the issue with sorting in some XLSX files (bug #35904);
  • Fixed the issue with sorting the table header (bug #35950).

Presentation Editor

  • Fixed the controls in the slide preview mode (bug #35440);
  • Fixed the bugs with copying the notes;
  • Fixed the connector connection problem (bug #35867);
  • Fixed the connector problem with copy-paste operations (bug #35024).

Plugins

  • Fixed the issue with opening the Character Table (bug #35875);
  • Fixed the problem with hotkeys in the Character Table (bug #35890).

Conversion

  • Fixed the issue with saving changes in HTML files.

RPM

  • Fixed the problem while working with SELinux enabled.

Windows

  • Migration to 64-bit Node.js.

Version 5.0.0 SaaS only

Release date: 09/23/2017

New features

Spreadsheet Editor

  • Added the support for opening pivot tables;
  • Added the support for 69 new functions: AGGREGATE, BESSELI, BESSELJ, BESSELK, BESSELY, BINOM.DIST.RANGE, BITAND, BITLSHIFT, BITRSHIFT, BITOR, BITXOR, CHITEST, CHISQ.TEST, COVARIANCE.P, COVARIANCE.S, DAVERAGE, DAYS, DCOUNT, DCOUNTA, DGET, DMAX, DPRODUCT, DSTDEV, DSUM, DVAR, ECMA.CEILING, ERFC.PRECISE, FORECAST.LINEAR, ISFORMULA, ISOWEEKNUM, MAXIFS, MINIFS, MINIFS, MODE.MULT, MODE.SNGL, NEGBINOM.DIST, NETWORKDAYS.INTL, NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, QUARTILE.INC, QUARTILE.EXC, PERMUTATIONA, POISSON.DIST, PHI, RRI, SKEW.P, SHEET, SHEETS, STDEV.P, STDEV.S, SWITCH, T.TEST, TEXTJOIN, TRIMMEAN, TTEST, UNICODE, VAR.P, VAR.S, WEIBULL, WEIBULL.DIST, WORKDAY.INTL, Z.TEST, ZTEST.

Presentation Editor

  • Added the ability to add, open and save presentation notes;
  • Added the support for opening and saving the videos.

Back-end

  • Database optimization, faster opening of large files;
  • Added the ability to rebuild not built, forgotten files.

x2t

  • Added the support for reading of OOXML and XLS files containing macros;
  • Added the support for audio and video files to all the document formats;
  • Added the support for pivot tables to XLS format files.

Fixes

Document Editor

  • Fixed a large number of various bugs.

Spreadsheet Viewer

  • Fixed the issue with the keys not working in IE11 (DocumentServer#107 bug);
  • Fixed the issue when the COUNTIF function ignored TRUE and FALSE parameter (DocumentServer#151 bug);
  • Fixed the conditional formatting bugs.

x2t

  • Fixed a lot of bugs based on user sent files;
  • Fixed functions for ODS format files.

Version 4.4.4

Release date: 09/13/2017

Windows-only release

Fixes

  • Fixed the log folder creation in silent and verysilent setup mode.

Version 4.4.3

Release date: 08/14/2017

Fixes

Document Editor

  • Fixed issues with opening some DOCX files (bug #35307);
  • Fixed the issue with the chart legend being blocked during co-editing (bug #35492).

Spreadsheet Editor

  • 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).

Presentation Editor

  • Fixed the comment bug (bug #35408);
  • Fixed the bug with drag-and-dropping the chart into a title.

Version 4.4.2

Release date: 07/24/2017

New features

Spreadsheet Editor

  • Added support for more new options in sparklines (bug #35296).

Fixes

Document Editor

  • 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 (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Spreadsheet Editor

  • Fixed the Show empty cells as box in Russian (bug #35299);
  • Fixed the sparkline type in the settings window (bug #35296);
  • Hid the functions which have not yet been implemented: CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE (bug #35314);
  • 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 (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Presentation Editor

  • 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 disconnecting the connector after ungrouping (bug #35316);
  • 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 (Chinese, Czech, German, Italian, Russian, Spanish), and added a new translation (Slovak).

Mobile Document Editor

  • Removed saving for the show snap lines option.

Mobile Presentation Editor

  • Removed saving for the show snap lines option.

x2t

ODT

  • Fixed saving some files to ODT (bug #35389).

TXT

  • Fixed the empty TXT on opening (bug #35396).

XLS

  • Fixed the custom shape for the connectors.

ODS

  • Fixed the issue with margins;
  • Fixed the converted named range with the formulas.

PPTX

  • Fixed the audio WAV files;
  • Fixed the old OLE standard.

PPT

  • Fixed the previous user pictures;
  • Fixed the picture read stream.

Document Builder

  • Fixed the problems with printing and saving to PDF.

Version 4.4.1

Release date: 07/05/2017

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, GAMMALN.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

Version 4.3.6

Release date: 06/14/2017

Fixes

Rebranding

  • Fixed the problems with the white-label logos.

Version 4.3.5

Release date: 06/05/2017

New features

Document Editor

  • Added the showReviewChanges option to the configuration, which automatically opens the review changes panel.

Fixes

Document Editor

  • Disabled the version history for PDF, DJVU and XPS files;
  • Fixed the problem with DropCap fonts.

Spreadsheet Editor

  • Limited the number of cell styles to 1000 (bug #113);
  • Fixed adding spacing when copying data from MS Excel;
  • Fixed the chart axis position.

Back-end

  • Fixed crash on Windows Server 2008 R2.

Version 4.3.4

Release date: 05/16/2017

Fixes

All editors

  • Fixed the opening error when the SDK loads before the fonts;
  • Fixed the error of the shape display without the gradient angle (bug #34887);
  • Editors now show correct limited functionality notification for IE 9 and IE 10.

Back-end

  • Fixed the error with user data from JWT usage;
  • Added logs for the spellchecker checkHealth.

Version 4.3.3

Release date: 04/28/2017

New features

Document Editor

  • Added the Kazakh language for the spellchecker.

Docker version

  • Added the possibility to use PostgreSQL storage as a volume.

Fixes

Document Editor

  • Fixed the aligning of the Footnotes setting in Firefox (bug #34840);
  • Fixed the colors for shapes (bug #34785);
  • Fixed the problem with the shapes inside a table.

Version 4.3.2

Release date: 04/17/2017

New features

Plugins

Fixes

All editors

  • Minor updates to the existing translations;
  • Fixed the Plugins icon at the @2x resolution (bug #34681).

Document Editor

  • Fixed moving the image to another page header (bug #34637);
  • Fixed removing a shape if undo of grouping operation is performed (bug #34654).

Spreadsheet Editor

  • Fixed the decreasing size of a 3D chart (bug #34685);
  • Fixed the problem which appeared when a formula was pasted;
  • Fixed the tooltip position at the @2x resolution (bug #34678);
  • Fixed the problem with shrink to fit (bug #34758).

Presentation Editor

  • Fixed the problem appearing when a comment was removed (bug #34773).

Mobile Web Editors

  • Fixed the problem with opening the viewer in the open source version.

Back-end

  • Fixed the infinite loop with URI.parse (bug #34716);
  • Fixed the connection leak on healthCheck.

DOCX

  • Fixed the issue with the DOCX file damaged when a chart was copied inside a shape (bug #34695).

document-server-integration

  • Fixed the problem with the Go Back button.

Windows installation

  • Fixed the problem with downloading the binaries from SourceForge.

Version 4.3.1

Release date: 04/06/2017

Fixes

Spreadsheet Editor

  • 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.

Version 4.3

Release date: 04/03/2017

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.

Mobile Web Editors

  • Completely new mobile web editors.

Back-end

  • Added the possibility to run documentserver on a custom port;
  • Added the possibility to check for and drop idle users;
  • Added the possibility to perform forced save (by timeout and using the button).

x2t

  • 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.

Plugins

  • A lot of new plugin features.

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);
  • Many other minor and major bugfixes.

Version 4.2.11

Release date: 03/13/2017

New features

Editors

  • Added the possibility to completely hide About and the left toolbar (available to the licensed users only).

Fixes

Back-end

  • Fixed the issue when the JWT token without the permissions field crashes downloadAs.

Version 4.2.10

Release date: 02/20/2017

Fixes

Embedded viewers

  • Fixed the default top position for the toolbar.

Licensing

  • Fixed the availability of the chat and comments buttons for the editors without the license file.

Back-end

  • Fixed the problem with JWT access tokens.

Version 4.2.9

Release date: 02/14/2017

New Features

Spreadsheet Editor

  • The Polish language translations for functions.

Fixes

Spreadsheet Editor

  • Fixed the wrong order of elements in equations (bug #34029).

Version 4.2.8

Release date: 02/06/2017

Fixes

Spreadsheet Editor

  • Fixed entering the characters with diacritical symbols (bug #33908)
  • Fixed the horizontal scroll when using a trackpad (bug #27197)

Plugins

  • Allowed the interface customization using the plugins.

Back-end

  • Minor fixes for logging and status codes.

Version 4.2.7

Release date: 02/01/2017

Fixes

All Editors

  • Prevent editors from performing the save operation if there are no changes to save.

Spreadsheet Editor

  • Fixed error occurring when assembling files with Ranges in some rare cases.

Document conversion

  • Fixed errors occurring when converting from the XLSX to the CSV format.

Back-end

  • Fixed server compilation if the PRODUCT_VERSION and BUILD_NUMBER variables are not defined.

Version 4.2.5

Release date: 01/16/2017

Fixes

All Editors

  • Fixed a rare problem occurring when saving a file with a specific chart type.

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.

Back-end

  • Fixed a problem occurring when opened connection was not closed with close command received while performing some asynchronous actions.

Version 4.2.4

Release date: 01/09/2017

Fixes

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 Match formula return value in some cases (bug #33735).

Back-end

  • Fixed the missing Asana-Math font in the default installation, needed for equations.

Version 4.2.3

Release date: 12/23/2016

Fixes

Spreadsheet Editor

  • Fixed the usage of functions with references to the other sheets.

Presentation Editor

  • Fixed the timeout error appearing while printing some PPTX files.

Document conversion

  • Fixed the problem with conversion to PDF format when only the first document page was converted.

Licensing

  • Without a valid license file the chat and comment buttons are unavailable, as well as editing the customer information and the logo image at the editor header is not allowed.

Version 4.2.2

Release date: 12/21/2016

Fixes

Presentation Editor

  • Fixed the problem with opening password-protected presentations.

Version 4.2.1

Release date: 12/06/2016

Fixes

Document Editor

  • Fixed the broken Insert number of page button;
  • Fixed the problem with the last hieroglyph duplicate;
  • Fixed the problem with changing the chart type from 2D to 3D (bug #33284).

Spreadsheet Editor

  • Fixed JavaScript error when adding a chart in IE and Edge (bug #33597);
  • Fixed the problem with an empty cell when changing sparklines (bug #33598).

x2t

  • Improved compatibility with the DOC format.

Version 4.2.0

Release date: 12/01/2016

New Features

All Editors

  • Added the possibility to set a dash type for shapes;
  • Redesigned the embedded viewers;
  • Better support of HiDPI systems;
  • Update bootstrap to version 3.3.7.

Document Editor

  • Added the possibility to set Fit to Page or Fit to Width as a default zoom value;
  • Ability to insert number of pages into the document;
  • Added the possibility to open and edit footnotes;
  • 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 set Fit to Width as a default zoom value;
  • Added the possibility to insert equations in Presentation Editor.

Back-end

  • Updated Node.js from version 4.2.0 to the current LTS release: 6.9.1.

Fixes

Spreadsheet Editor

x2t

Version 4.1.8

Release date: 11/03/2016

Fixes

License

  • Minor fix for a better license compatibility with the Hide Menu functionality.

Version 4.1.7

Release date: 11/01/2016

Fixes

Editors

  • Fixed a JavaScript error when opening a document in IE 9 and IE 10.

Version 4.1.6

Release date: 10/26/2016

New Features

Editors

  • Added the possibility to hide the menu bars in the editors using the config.

Version 4.1.5

Release date: 10/13/2016

Fixes

Editors

  • Fixed copy-paste on MacOS Sierra.

Plugins

  • Fixed the image load and OLE problems;
  • Viewers do not show plugins any more.

Version 4.1.4

Release date: 10/07/2016

Fixes

Back-end

  • ipfilter can use dns to lookup.

Version 4.1.3

Release date: 09/28/2016

New Features

Plugins

  • Sample plugins are enabled by default.

Version 4.1.2

Release date: 09/22/2016

New Features

Back-end

  • Switched to using PostgreSQL instead of MySQL on back-end;
  • Added the possibility to filter users using ipfilter.

Editors

  • Added whole new code handling text input. Better support for languages which use hieroglyphs;
  • Added whole new copy-paste which is better compatible with external sources.

Changes

  • Improvements in opening of all supported formats.

Fixes

  • A lot small bugfixes in all product modules.

Version 4.0.3

Release date: 08/04/2016

Changes

  • Added the possibility to use full-toolbar mode in the editors with a standard license. Previously the users of standard license were forced to use compact toolbar only.

Version 4.0.2

Release date: 08/03/2016

Fixes

Spreadsheet Editor

  • Fixed losing comments on second and subsequent worksheets (bug #32895);
  • Fixed losing empty values of data with format different from General in the autofilter (bug #32805).

document-server-integration

  • Minor fixes.

Introduction

Document Server is an online office suite comprising viewers and editors for texts, spreadsheets and presentations, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time. This installation guide is designed to give the user the possibility to compile and deploy Document Server from the source codes without any additional help. The guide is intended for the users with the knowledge and skills of Linux OS based server administration.

System requirements

Hardware

  • Processeur
    dual-core avec fréquence d'horloge de 2 GHz ou plus
  • RAM
    2 GB or more
  • HDD
    at least 40 GB of free space
  • Additional Requirements
    at least 2 GB of swap

Software

  • OS
    64-bit Debian, Ubuntu or other compatible distribution with kernel version 3.13 or later
  • Compiler with C11 support
All the below actions are described for Ubuntu Server 14.04. Other distributives might require some specific actions not described here.

Installing dependencies

Before you start the compilation, you need to install all the tools and dependencies necessary for the installation and build process. Node.js is installed using the commands:

sudo apt-get install -yq curl apt-transport-https ca-certificates
curl -sL https://deb.nodesource.com/setup_8.x | sudo -E bash -
sudo apt-get install -y nodejs
You might also need to install npm and dependencies, depending on your version of Ubuntu. This can be done using the following command:
sudo apt-get install npm

After that update npm running the command:

sudo npm install -g npm

Install grunt:

sudo npm install -g grunt-cli

Most of the other dependencies can be installed using the single command:

sudo apt-get install --force-yes -yq \
    wget \
    build-essential \
    libcurl4-gnutls-dev \
    libglib2.0-dev \
    libgdk-pixbuf2.0-dev \
    libgtkglext1-dev \
    libatk1.0-dev \
    libcairo2-dev \
    libxml2-dev \
    libxss-dev \
    libgconf2-dev \
    default-jre \
    qt5-qmake \
    qt5-default  \
    p7zip-full \
    git \
    subversion

Getting and building Document Server source code

Get the latest version of Document Server source code from GitHub:

git clone --recursive https://github.com/ONLYOFFICE/DocumentServer.git

Switch to the Document Server directory:

cd DocumentServer

Download and build third party modules:

cd core/Common/3dParty && ./make.sh

Now you need to build Document Server components:

  1. Build core:
    cd ../.. && make
    
  2. Build sdkjs:
    cd ../sdkjs && make
    
  3. Build server:
    cd ../server && make
    

Installing and configuring Document Server

Installing dependencies

First install the dependencies necessary for Document Server correct work:

sudo apt-get update
sudo apt-get install adduser redis-server rabbitmq-server nodejs libstdc++6 libcurl3 libxml2 libboost-regex-dev zlib1g fonts-dejavu fonts-liberation ttf-mscorefonts-installer fonts-crosextra-carlito fonts-takao-gothic fonts-opensymbol libxss1 libcairo2 xvfb libxtst6 libgconf2-4 libasound2
Copying Document Server to its folder

Switch to the server folder of Document Server and build and install it using the command:

cd ../server && sudo make install

The built Document Server will be copied to the /var/www/onlyoffice/documentserver/ folder, the onlyoffice user will be created. Also Document Server work folders will be created, the font list and the font thumbnails will be created automatically.

Installing and configuring NGINX

  1. Install NGINX:
    sudo apt-get install nginx
    
  2. Disable the default website:
    sudo rm -f /etc/nginx/sites-enabled/default
    
  3. Now you need to set up the new website. To do that create the /etc/nginx/sites-available/onlyoffice-documentserver file with the following contents:
    map $http_host $this_host {
      "" $host;
      default $http_host;
    }
    map $http_x_forwarded_proto $the_scheme {
      default $http_x_forwarded_proto;
      "" $scheme;
    }
    map $http_x_forwarded_host $the_host {
      default $http_x_forwarded_host;
      "" $this_host;
    }
    map $http_upgrade $proxy_connection {
      default upgrade;
      "" close;
    }
    proxy_set_header Host $http_host;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $proxy_connection;
    proxy_set_header X-Forwarded-Host $the_host;
    proxy_set_header X-Forwarded-Proto $the_scheme;
    server {
      listen 0.0.0.0:80;
      listen [::]:80 default_server;
      server_tokens off;
      rewrite ^\/OfficeWeb(\/apps\/.*)$ /web-apps$1 redirect;
      location / {
        proxy_pass http://localhost:8000;
        proxy_http_version 1.1;
      }
      location /spellchecker/ {
        proxy_pass http://localhost:8080/;
        proxy_http_version 1.1;
      }
    }
  4. Ad the symlink to the newly created website to the /etc/nginx/sites-available directory:
    sudo ln -s /etc/nginx/sites-available/onlyoffice-documentserver /etc/nginx/sites-enabled/onlyoffice-documentserver
    
  5. And restart NGINX to apply the changes:
    sudo nginx -s reload
    
Installing and configuring PostgreSQL

Install PostgreSQL using the following command:

sudo apt-get install postgresql

Once PostgreSQL is installed, run the following commands to create the PostgreSQL database and user:

The created database must have onlyoffice both for user and password.
sudo -i -u postgres psql -c "CREATE DATABASE onlyoffice;"
sudo -i -u postgres psql -c "CREATE USER onlyoffice WITH password 'onlyoffice';"
sudo -i -u postgres psql -c "GRANT ALL privileges ON DATABASE onlyoffice TO onlyoffice;"

Run the following command to configure the database:

psql -hlocalhost -Uonlyoffice -d onlyoffice -f /var/www/onlyoffice/documentserver/server/schema/postgresql/createdb.sql
Upon that, you will be asked to provide a password for the onlyoffice PostgreSQL user. Please enter the onlyoffice password.

Running Document Server

All Document Server components run as foreground processes. Thus you need separate terminal consoles to run them or specific tools which will allow to run foreground processes in background mode.
  1. Start the FileConverter service:
    cd /var/www/onlyoffice/documentserver/server/FileConverter/sources/ && export NODE_ENV=production-linux NODE_CONFIG_DIR=/etc/onlyoffice/documentserver && sudo -u onlyoffice -E node /var/www/onlyoffice/documentserver/server/FileConverter/sources/convertermaster.js
    
  2. And the SpellChecker service:
    export NODE_ENV=production-linux NODE_CONFIG_DIR=/etc/onlyoffice/documentserver && sudo -u onlyoffice -E node /var/www/onlyoffice/documentserver/server/SpellChecker/sources/server.js
    
  3. After that the DocService:
    export NODE_ENV=production-linux NODE_CONFIG_DIR=/etc/onlyoffice/documentserver && sudo -u onlyoffice -E node /var/www/onlyoffice/documentserver/server/DocService/sources/server.js
    
Download Best editors on your website Let your site users view, edit and collaborate
on all types of text, spreadsheet and presentation files
Cela peut vous aider aussi :
Fermer