ONLYOFFICE-DocumentServer-5.1.1

New Features

All Editors

• Update translations
• New help entries

Spreadsheet Editor

• Add CONVERT, FTEST, HYPGEOM.DIST formulas
• Add Spanish formula translations

Back-end

• Add reconnection.attempts, reconnection.delay options to config - applicable for editor-server connection
• Add fonts folder to static content
• Add sockjs config section for testing purposes

Fixes

All Editors

• Hide empty width glyphs fonts in font picker
• Don't save changes for undo/redo in server build mode
• Change size of image pasted form html
• Fix problem in text selection with Shift
• Fix redundant symbol in cell after undo-redo (#37343)
• Fix error with repeated reconnection
• Fix problems with icons of some buttons
• Fix sync coedit button in top toolbar and menu (#37377)

Document Editor

• Fix right mouse buttom menu for TOC (#37241)
• Fix usage Clip ParaDrawing by line top and bottom
• Don't clip images in text arts
• Add vertical clip for inline drawing
• Fix problems in drawing inline objects
• Fix bug in calculation text clip rect in documents
• Fix Cannot read property 'B8a' of null error in some files (#37378)

Spreadsheet Editor

• Fix right mouse button error (#37330)
• Fix inserting hieroglyphs from text editor (#37356)
• Fix bug with enter symbol point in formula autocompleate (#37300)
• Fix bug with enter symbol _ or \ in start formula autocompleate (bug #37354)
• Fix bug with enter Chinese numbers in formula autocompleate
• Fix Cannot read property 'toLocaleString' error in some files (#37343)
• Fix Cannot read property '4'' error in some files (#37376)
• Fix sheet context menu visibility (#37307)
• Fix translations for formulas
• Fix inserting function in opened cell (#37348)
• Correct some formulas translations

Presentation Editor

• Fix hieroglyph problem in chart title (#37293)
• Fix chart title focus problem in coedit (#37295)
• Fix object selection problem in coedit (#37336)
• Remove console.log about End_CollaborationEditing
• Clamp scroll_central position
• Bug with clearing cached canvas
• Fix bug in calculation of slide layout bounds
• Fix Cannot read property 'Ec' of null error in some files (#37386)

Back-end

• Fix font generation
• Fix inconsistent database status after files assemble in case of rapid open/close connection

x2t

• Fix reopening files with macros (#37323)
• Fix opening some Docx user files
• Fix opening some XLS user files

DesktopEditors

• Fix gradient bug
• Fix printing cell borders (#35367)

ONLYOFFICE-DocumentServer-5.1.0

New Features

All Editors

• New no squares font engine, find best replacement font for □ characters
• Ability to distribute data in tables
• New fonts in default font set
• Fully rewritten composite input for characters
• New header and background color
• Support of shape side panel for images
• Change table size by drag'n'drop
• New bullet list marker - –
• Redone connection of second user to document in Strict mode
• Increase supported document size (without media-content)
• New help entries
• Search in help

Document Editor

• Ability to set Tab Leader symbols
• Support of Table of Contents
• New Navigation left sidebar
• New Reference tab
• Rename Review tab to Collaboration
• Changes history in Strict Co-Edit
• Rename Display Modes entries for Track Changes
• File tab Go to documents opens in new tab
• Ability to set negative top and bottom page margin
• Copy paragraph style will not overwright custom run style
• Special paste of tables

Spreadsheet Editor

• Custom user cell styles are now placed before default ones
• 8 new formulas: F.TEST, FORECAST.ETS, FORECAST.ETS.CONFINT,
  FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, FORMULATEXT,
  IFS, PDURATION
• New None Table Template
• New editing tools for Pivot Tables
• New regional presets - Deutsch (Schweiz), Español (México),
  Nederlands (Nederland), Slovenčina (Slovenská republika)
• New date formats yy/m/d, yy/mm/dd, yyyy/m/d
• CSV preview before opening

Presentation Editor

• Special paste
• Presentation level comments

Plugins

• Added Macros plugin
• Fix plugin autostart problem

x2t

• Support a lot of features in xls format (macros, controls etc.)
• Speedup of opening ooxml files on 5-10%
• Better compatibility with OpenFormat, RTF
• Fix a lot of error in user-send files in all supported formats

Document Builder

• Add new GetSheets, GetSheet, methods
• Add GetVisible, SetVisible, GetName GetIndex for ApiWorksheet
• Add getter and setter properties Visible in ApiWorksheet
• Add getter property Index in ApiWorksheet
• Add getter and setter properties Name in ApiWorksheet
• Add getter property Sheets in Api
• Add getter property ActiveCell in ApiWorksheet
• Add function GetValue in ApiRange
• Add getter property Value, function ForEach in ApiRange
• Add function Format in Api
• Add function GetCells in ApiWorksheet
• Add getter property Cells in ApiWorksheet
• Add function GetUsedRange in ApiWorksheet
• Add getter property UsedRange in ApiWorksheet
• Add function GetRowHeight in ApiWorksheet

Fixes

All Editors

• A lot of bugs fixed
• Fix toolbar icons problems
• Fix editing problems while connecting to document with a lot of changes

ONLYOFFICE-DocumentServer-5.0.7

New Features

Licensing

• New license type - by unique users id's and access period

Document Builder

• Add a lot of getters and setters
• New methods to AddSheet

Spreadsheet Editors

• Add stirkeout, superscript and subscript in top toolbar (bug #26581)

Help

• New entries in help for each editor tab

Fixes

All Editors

• Update translations
• Set focus out of the editor frame in IE/Edge

Document Editor

• Fix opening docx file with formula in MS Word (bug #36490)
• Fix JS error while inserting Spreadsheet cell with comment (bug #36506)
• Fix bug with inserting the content control in the math equation.
• Fix reset selection from object in header/footer after keyboard move

Spreadsheet Editors

• Fix wrong dependence in formula with 3D Ref after removing sheet
• Fix opening odt with chart
• Fix calculating sparkline in some case (bug #36603)
• Fix printing image outside of printed range (bug #36573)

Presentation Editor

• Fix shape blocking in coedit for users with different mode (bug #36435)
• Fix chart Constant proportions working only once (bug #36494)
• Fix JS error while inserting page number from Document Editor (bug #36508)
• Fix JS error while undo of table (bug #36515)

Back-end

• Fix IIS URL Rewrite while uploading image
• Fix ttf fonts not gziped

Integration Example

• Remove Integration Edition from logo

x2t

• Fix some DOCX, DOC, RTF files from users
• Fix DOCX with MathType equations (bug #36524)

ONLYOFFICE-DocumentServer-5.0.6

New Features

Licensing

• New license type - by unique users count

Fixes

Document Editor

• JS Error while inserting empty cell to chart title (bug #36441)
• Remove non-actual Rich Text Content Control help files
• Hide Clipart plugin window if version history opened (bug #36464)

Back-end

• Long outbox request authorization headers are reduced (bug #36202)

Windows Version

• Fix jwt enabling in ds example

ONLYOFFICE-DocumentServer-5.0.5

New Features

DesktopEditors

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

Fixes

All Editors

• Fix red cross for images in some situations

Spreadsheet Editors

• Fix a.Se is not a function error while opening file (bug #36344)
• Fix error with merge table colors
• Fix merge cells after apply table template (bug #36405)

Presentation Editor

• Check buttons layout in reporter mode
• Disable scroll to target in selectwheel (empty selection)
• Fix applying image as background for several slides (bug #36399)
• Fix mouse slide scroll without change zoom (bug #28096)

Plugins

• Fix calling plugins in non-tabbed interface Docker-DocumentServer#84
• Fix crash on unknown ole-object resize
• Yandex.Translate add progress bar

x2t

• Fix colors schemes for table cells (bug #36322)
• Fix problem with image in footnote (bug #36380)

Back-end

• Fix calculate connections. exclude view users

deb

• Fix nodejs dependency (force NodeJS 6 LTS)

Document Builder

• Service key size reduced to 20 characters
• Change HTTP error code from 403 to 402 in case of incorrect license

ONLYOFFICE-DocumentServer-5.0.4

Fixes

All Editors

• Remove some unused code
• Fix Poland language bug (altGr + x/c on firefox/edge)
• Fix bug with images paths

Document Editor

• Fix bug with removing and adding items from listview (tab list)
• Fix bug with creating several synchronize tips
• Fix line end in thumbnails
• Fix paste simple text to equations
• Fix opening version history

Spreadsheet Editor

• Fix JS error for some pivot table styles (bug #36290)
• Check xfIndexNumber when merging styles to avoid errors with column styles
• Fix conditional formatting while changing cell values (bug #36253)

Presentation Editor

• Don't disable prev-next buttons for slide demonstration
• Fix presentation demonstration: start from beginning
• Fix notes scroll
• Fix insert text operation duration (bug 36208)
• Fix browser zoom problem with reported pointer

Back-end

• Fix conversion task is lost when entering and leaving the editor quickly (endless opening)
• Fix timeout error while first user do not performing save

ONLYOFFICE-DocumentServer-5.0.3

New Feature

Distribution

• onlyoffice-documentserver-integration renamed to onlyoffice-documentserver-ie
• New distribution type for developers - onlyoffice-documentserver-de

All Editors

• Update limitations messages.
• Added Sogou Pinyin input in Chrome
• Support of fods, fodt, fodp formats

Plugins

• New plugins scheme (system & parallel working)

Windows Version

• Add 'Accept license' dialog in installation

Fixes

All Editors

• Fix button outlines in Firefox
• Fix Developer Mode message rotate in IE11 (bug #36076)

Document Editor

• Fix JS error while adding Text Art by Enter (bug #36134)
• Fix cursor while rotating object (bug #36114)

Presentation Editor

• Fix reporter mode resize in IE
• Fix bug with position of hyperlink tooltip and slide num tooltip
• Fix slide resize bug
• Fix search in text in placeholder (bug #36133)
• Fix layout in reported mode
• Fix js error in Tables_test.pptx (bug #17147)

Embedded viewer

• Fix Error code -23 (bug #36122)

Back-end

• Fix view mode was determined without consideration of permissions.comment

RPM

• Fix using SELinux with custom ports

Pluging

• Bug with resize cursor in the plugins window
• Fix JS error in running PhotoEditor (bug #36050)
• Fix problems with scroll

ONLYOFFICE-DocumentServer-4.4.3

Fixes

Document Editor

• Fix opening some docx (bug #35307)
• Fix chart legend blocking in coedit (bug #35492)

Spreadsheet Editor

• Fix change shape size by yellow markers (bug #35451)
• Fix case sensitive VLOOKUP and HLOOKUP (bug #35528, DocumentServer#140)

Presentation Editor

• Fix comment reply duplication (bug #35408)
• Fix bug with drag-and-drop chart into title

ONLYOFFICE-DocumentServer-4.4.2

New features

Spreadsheet Editor

• Support some more new options in sparklines (bug #35296)

Fixes

Document Editor

• Fix problem with setting tab several time (bug #34923)
• Fix printing in Edge (bug #35323)
• Fix help for moving shape by pixel (bug #34983)
• Fix special paste in fast co-edit (bug #35310)
• Fix duplicates in strict mode after special paste (bug #35312)
• Fixed bug with moving cursor to the start of the document after removing content control.
• Fix minor problems with co-edit in real time (bug #35398, #35399, #35400)
• A lot of fixes in translations

Spreadsheet Editor

• Fix box for Show empty cells as in Russian (bug #35299)
• Fix sparkline type in setting window (bug #35296)
• Hide not implemented formulas: CUBEKPIMEMBER, CUBEMEMBER,
  CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET,
  CUBESETCOUNT, CUBEVALUE (bug #35314)
• Fix JS error in conditional formatting with formula and offset (duplicate variable) (bug #35334)
• Fix JS error in SEARCH formula (bug #35340)
• Fix freeze pane shadow not hiding (bug #35359)
• Fix showing hidden objects
• Fix VLOOKUP format cell
• A lot of fixes in translations

Presentation Editor

• Fix changing presentation language if no shape selected (bug #35231)
• Fix columns in placeholder (bug #35074)
• Fix connector losing shape after moving shape in group (bug #35317)
• Fix disconnecting connect after ungrouping (bug #35316)
• Fix hidden markers for connector on chart and image (bug #35300)
• Fix cell link after copy paste (bug #35362, DocumentServer#122)
• A lot of fixes in translations

Mobile Document Editor

• Remove saving show-snaplines option

Mobile Presentation Editor

• Remove saving show-snaplines option

x2t

odt

• Fix saving some files to odt (bug #35389)

txt

• Fix empty txt on opening (bug #35396)

xls

• Fix custom shape with connectors

ods

• Fix margins
• Fix convert named range with formulas

pptx

• Fix audio wav files
• Fix old standard ole

ppt

• Fix previous users picture
• Fix read picture stream

Document Builder

• Fix problems with printing and saving to pdf

Desktop Editor

• Fix showing 'Changes saved' message (bug #35358)

ONLYOFFICE-DocumentServer-4.4.1

New features

Document Editor

• Special Paste
• Rich text content support
• Translates for Paragraph Styles
• View mode with comments
• Option to hide solved comments
• Abitity to specify custom columns

Spreadsheet Editor

• Formulas with conditional formatting
• Ability to specify custom delimiter for CSV import\export
• Added 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 formulas
• Exclude hidden rows from copy, autofill, formatting etc...
• Update active cell color
• Frozen pane now with shadow
• Translates for cell styles
• Search and replace by select
• Option to hide solved comments
• Abitity to specify bullets and numbering for text in shape.
• Ability to specify columns for Text Areas
• Ability to add the connectors for the shapes
• Support Shift+Delete, Ctrl+Insert and Shift+Insert for Cut-Paste

Presentation Editor

• Ability to connect shapes via lines
• Ability to specify columns for Text Areas
• Ability to create bullet and number lists in the shapes
• Spellcheker in Presentation Editor
• Ability to download as ODP

Plugins

• New type for plugin window (without borders, shadows, buttons)

x2t

• Speedup for opening ooxml: windows 200%, linux 20%
• Better convertation from/to RTF
• Better support of password protected ooxml, binary ms
• Support of password protected ppt