Release Notes for Synology Office

Important notes

1. This update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the regions.

Fixed Issues

1. Fixed an issue where users with permissions could not delete rules of protected sheets and ranges.
2. Fixed an issue where date formats in imported spreadsheets might not be displayed correctly.
3. Fixed an issue where printed documents were not displayed correctly.
4. Fixed an issue where nicknames might not be displayed correctly.
5. Fixed an issue where the worksheet list in the spreadsheet could not be scrolled.
6. Improved the compatibility with Microsoft Office files, LibreOffice, and CSV files.

Compatibility and Installation

1. Synology Office 3.6 Official requires Synology Drive Server 3.4 Official, Universal Viewer 1.1 Official, and DSM 7.2 and above.

What's New

General

1. Supports Immersive Mode to hide the menu and toolbar for a focused work environment.

Spreadsheet

1. Supports pivot tables.
2. Supports grouping data to allow for collapsing or expanding rows or columns.
3. Added the "Filter only for me" option in the filter window, allowing for private filter views.
4. Added support for the formula FLATTEN.

Document

1. Added markdown support in documents, enabling users to easily format text by inputting markdown syntax along with their content.
2. Improved the document loading speed.
3. Supports real-time updating of the user's location in the "Show outline" panel as they scroll through the document.
4. Added the "Preferences" options, enabling users to customize automatic formatting preferences.

Slides

1. Supports grouping slides into sections to allow for collapsing or expanding them.
2. Added markdown support in slides, enabling users to easily format text by inputting markdown syntax along with their content.
3. Improved the slides loading speed.
4. Added the "Preferences" options, enabling users to customize automatic formatting preferences.

Fixed Issues

1. Improved the compatibility with Microsoft Office files.
2. Fixed an issue where the protected range settings were lost when copying a file that contained protected ranges.
3. Fixed an issue where certain formula calculations yielded incorrect results.
4. Fixed an issue where sorting cells could cause hyperlinks within cells to disappear.
5. Fixed an issue where printed files were displayed incorrectly.
6. Minor bug fixes and stability enhancement.

Compatibility & Installation

1. Synology Office 3.5.3 requires DSM 7.2 and above.

Fixed Issues

1. Enhanced the compatibility of importing and exporting spreadsheets.

Important Notes

1. The update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the region.

What's New

1. Supports installing Synology Office on Peta Volumes.

Important Notes

1. This update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the regions.

Fixed Issues

1. Fixed an issue where empty cells with number formatting applied might not display correctly after sorting.
2. Fixed an issue where users could not correctly apply conditional formatting and style to cells.

Compatibility and Installation

1. Synology Office 3.5 requires DSM 7.1.1 and above.

What's New

General

1. Supports zooming in and out by holding the Ctrl key while scrolling with the mouse wheel.
2. Supports opening files at the same zoom level as the last time they were open.
3. Supports converting encrypted Microsoft Office files into Synology Office files.

Spreadsheet

1. Supports viewing the edit history by cell.
2. Added new functions, including IMPORTRANGE, CONCAT, and XLOOKUP.
3. Added the highlighter function to highlight the active row or column.
4. Supports copying the data summary at the lower-right corner by clicking on it.
5. Supports smooth scrolling to improve the scrolling experience in worksheets with large amounts of data.

Document

1. Supports watermarking documents to mark source or for ownership purposes.
2. Supports using rulers and tab stops to set the page margins and paragraph indents.
3. Supports using formatting marks to show hidden characters, such as spaces, paragraph marks, or tab characters.

Slides

1. Supports using rulers to set paragraph indents.
2. Added the highlighter tool for use in presentation mode.

Fixed Issues

1. Improved the experience of editing Synology Office files via web browsers on mobile devices.
2. Improved the compatibility with Microsoft Word, including watermarks, rulers, and tab stops.
3. Fixed an issue where deleting multiple rows would also delete filtered rows that are hidden.
4. Fixed an issue where creating a data validation rule might fail when using "List of items" as the rule and time format as the "Value".
5. Fixed an issue where saving historical versions might fail when there are emojis in the file.
6. Fixed an issue where hyperlinks in a Synology spreadsheet converted from Microsoft Excel might not display correctly.
7. Fixed an issue where downloading a Synology spreadsheet as Microsoft Excel might fail when one of its worksheets has a name with a lot of characters.

Compatibility and Installation

1. Synology Office 3.5 requires DSM 7.1.1 and above.

What's New

General

1. Supports zooming in and out by holding the Ctrl key while scrolling with the mouse wheel.
2. Supports opening files at the same zoom level as the last time they were open.
3. Supports converting encrypted Microsoft Office files into Synology Office files.

Spreadsheet

1. Supports viewing the edit history by cell.
2. Added new functions, including IMPORTRANGE, CONCAT, and XLOOKUP.
3. Added the highlighter function to highlight the active row or column.
4. Supports copying the data summary at the lower-right corner by clicking on it.
5. Supports smooth scrolling to improve the scrolling experience in worksheets with large amounts of data.

Document

1. Supports watermarking documents to mark source or for ownership purposes.
2. Supports using rulers and tab stops to set the page margins and paragraph indents.
3. Supports using formatting marks to show hidden characters, such as spaces, paragraph marks, or tab characters.

Slides

1. Supports using rulers to set paragraph indents.
2. Added the highlighter tool for use in presentation mode.

Fixed Issues

1. Improved the experience of editing Synology Office files via web browsers on mobile devices.
2. Improved the compatibility with Microsoft Word, including watermarks, rulers, and tab stops.
3. Fixed an issue where deleting multiple rows would also delete filtered rows that are hidden.
4. Fixed an issue where creating a data validation rule might fail when using "List of items" as the rule and time format as the "Value".
5. Fixed an issue where saving historical versions might fail when there are emojis in the file.
6. Fixed an issue where hyperlinks in a Synology spreadsheet converted from Microsoft Excel might not display correctly.
7. Fixed an issue where downloading a Synology spreadsheet as Microsoft Excel might fail when one of its worksheets has a name with a lot of characters.

Fixed Issues

1. Enhanced the compatibility with Microsoft Office files.

Important Notes

1. This update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the regions.
2. Replaced some themes with new themes. Legacy themes are still available and can be found by going to the Synology Drive web portal, click Create > From template, and click Show Legacy Templates at the upper-right corner.
3. Models with Armada370 and Comcerto2k platforms are no longer supported.
   • Armada370: DS216se, DS115j, RS214, DS414slim, DS214se, DS114, DS213j
   • Comcerto2k: DS414j

Compatibility and Installation

1. Synology Office 3.4 requires Synology Drive Server 3.1.

What's New

General

1. Allows users to add font types they have on their computers into Synology Drive Admin Console so that the font types can be used in Synology Office.
2. Supports using the color picker to directly pick up color in a file after Synology Office Extension is installed.
3. Supports version rotation to save storage space and to reduce the time required for backup and restoration.
4. Added the following font types: Yu Mincho, Yu Gothic, YuKyokasho, Meiryo, Angsana New, Cordia New, Browallia New, and TH Sarabun New.
5. Supports filtering comments with multiple criteria at the same time, such as status, type, or "mention me".
6. Supports replacing an image with another, while maintaining the same size and position as the original image.

Spreadsheet

1. Supports array formulas that result in multiple values, which are automatically spilled into neighboring cells.
2. Added support for new formulas, including SEQUENCE, SORT, SORTBY, UNIQUE, FILTER, RANDARRAY, and TRANSPOSE.
3. Supports splitting text into columns by custom delimiters.
4. Supports removing duplicates in selected columns.
5. Supports the anchor of images and charts to cells, allowing them to be automatically modified whenever the cells are moved or resized.
6. Supports filtering cells by text color or background color.
7. Supports inserting and deleting a selected range of cells.
8. Supports using drag-and-drop to move cells or a range of cells.
9. Supports generating links to filter view.
10. Supports downloading spreadsheets in .csv format.
11. Supports retaining the comments within files when exporting and importing the files between Microsoft Office and Synology Office.

Document

1. Supports inserting text into shapes.
2. Supports aligning an entire table horizontally on a page.
3. Supports inserting code block.
4. Supports hotkeys for quickly switching between the table of content page and linked pages.

Slides

1. Supports inserting code block.
2. Supports using the pen tool in presentation mode.
3. Supports importing themes from other slides.
4. Supports snapping objects to gridlines.

Fixed Issues

1. Fixed an issue where downloading slides as .pptx files might fail.
2. Fixed an issue where the dates displayed in comments were not automatically updated.
3. Fixed an issue where other users editing a file while a user is leaving a comment on the same file might cause the comment to disappear.
4. Fixed an issue where a blank page might be printed when printing data in spreadsheet.
5. Fixed an issue where using hotkeys to insert timestamps failed.
6. Enhanced the compatibility with Microsoft Office files.
7. Fixed an issue where users cannot reset colors set by conditional formatting.
8. Fixed an issue where entering texts into code block might cause the text to become scrambled.

Limitations

1. Printing PDF files might cause hyperlinks within the files to be lost.

Important Notes

1. The update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the region.

Fixed Issues

1. Fixed an issue where saving a file might fail when the file has a large number of historical versions.
2. Fixed an issue where opening Microsoft Office files via "View" > "Open in Synology Office" in File Station might fail.
3. Fixed an issue where downloading files as PDF might fail on Firefox 98.

Important Notes

1. This update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on regions.
2. The annual calendar was removed from Spreadsheet templates.
3. Due to issues fixed in this release, row height in spreadsheet may be shrunken and content may not fully display. To resize a row, manually adjust it or right-click on the row heading and select "Adjust row height automatically".

Compatibility & Installation

1. Synology Office 3.3 requires Synology Drive Server 3.0 and DSM 6.2.3 and above.
2. If PHP 7.4 and Node.js v12 were not installed, the system will automatically install them after the update to ensure package functionality.

What's New

General

1. Supports displaying nicknames instead of usernames to identify users more easily in Synology Office.
2. Added Microsoft JhengHei and Helvetica Neue font types.
3. Shortened the time for opening Synology Office files.
4. Supports evenly distributing row height and column width for selected areas in a table.
5. Supports inserting hyperlinks from a list of Synology Drive files.
6. Supports searching and replacing using regular expressions.
7. Added the "Get link" button in the left sidebar for obtaining file links.
8. Added the "skip", "copy and replace", and "copy, but keep both files" options to the "Copy to" function when there are file name conflicts in Synology Office.

Spreadsheet

1. Supports displaying descriptions of functions and hints for function arguments.
2. Supports clearing multiple formatting at once for the same format type.
3. Supports pasting transposed data.
4. Shortened the time for renaming, deleting, copying, rearranging, hiding, or setting the color of worksheets.
5. Supports linking to specific areas or to other worksheets.
6. Supports searching within formulas while ignoring formula results.
7. Supports copying and pasting conditional formats.
8. Supports NORMSDIST and DATEDIF functions.
9. Enhanced the compatibility of importing and exporting spreadsheets.

Document

1. Supports automatically breaking tables across pages.
2. Supports inserting tables into headers and footers.
3. Added new numbered and bulleted list templates.
4. Enhanced numbered and bulleted lists including multilevel lists, continue numbering, and adding prefixes or suffixes.
5. Supports page counting and word counting for selected texts only.
6. Added inspection tool to easily review revisions and quickly accept or reject all revisions at once.
7. Enhanced the performance of a document performance when there is a large number of comments and revisions.

Slides

1. Added new numbered and bulleted list templates.
2. Enhanced numbered and bulleted lists including multilevel lists, continue numbering, and adding prefixes or suffixes.
3. Added gridlines for easier alignment of objects.
4. Enhanced the performance of slides performance when the file includes a large number of pages.

Fixed Issues

1. Enhanced the accuracy of spell checking.
2. Fixed an issue where users might not be able to open exported slides in Microsoft PowerPoint.
3. Fixed an issue where row height in spreadsheet is always automatically fit and could not be manually set to cut off content.
4. Fixed an issue in spreadsheet where dragging formulas to fill adjacent cells might give incorrect results when there are hidden rows or columns.
5. Fixed an issue where the SUBTOTAL function might incorrectly include other SUBTOTAL values in the range of data.
6. Fixed an issue where comments might be displaced when there is a shortage of available screen space.
7. Fixed multiple security vulnerabilities.

Important Notes

1. The annual calendar was removed from Spreadsheet templates.
2. Due to issues fixed in this release, row height in spreadsheets may be shrunken and content may not fully display. To resize a row, manually adjust it or right-click on the row heading and select "Adjust row height automatically".
3. New package installation is not supported for models with Armada370 platform. Updating to this package version is not affected.
4. This is the last version to support models with Armada370 and Comcerto2k platforms.

Compatibility and Installation

1. Updated to be compatible with DSM 7.0.
2. If PHP 7.4 and Node.js v12 were not installed, the system will automatically install them after the update to ensure package functionality.

What's New

General

1. Supports displaying nicknames instead of usernames to identify users more easily in Synology Office.
2. Added Microsoft JhengHei and Helvetica Neue font types.
3. Shortened the time for opening Synology Office files.
4. Supports evenly distributing row height and column width for selected areas in a table.
5. Supports inserting hyperlinks from a list of Synology Drive files.
6. Supports searching and replacing using regular expressions.
7. Added the "Get link" button in the left sidebar for obtaining file links.

Spreadsheet

1. Supports displaying descriptions of functions and hints for function arguments.
2. Supports clearing multiple formatting at once for the same format type.
3. Supports pasting transposed data.
4. Shortened the time for renaming, deleting, copying, rearranging, hiding, or setting the color of worksheets.
5. Supports linking to specific areas or to other worksheets.
6. Supports searching within formulas while ignoring formula results.
7. Supports copying and pasting conditional formats.
8. Supports NORMSDIST and DATEDIF functions.
9. Enhanced the compatibility of importing and exporting spreadsheets.

Document

1. Supports automatically breaking tables across pages.
2. Supports inserting tables into headers and footers.
3. Added new numbered and bulleted list templates.
4. Enhanced numbered and bulleted lists including multilevel lists, continue numbering, and adding prefixes or suffixes.
5. Supports page counting and word counting for selected texts only.
6. Added inspection tool to easily review revisions and quickly accept or reject all revisions at once.
7. Enhanced the performance of a document performance when there is a large number of comments and revisions.

Slides

1. Added new numbered and bulleted list templates.
2. Enhanced numbered and bulleted lists including multilevel lists, continue numbering, and adding prefixes or suffixes.
3. Added gridlines for easier alignment of objects.
4. Enhanced the performance of slides performance when the file includes a large number of pages.

Important Notes

1. This update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on regions.

Compatibility and Installation

1. Updated to be compatible with DSM 6.2.4. If you have encountered issues when copying or pasting images in Synology Office, please update Synology Office to this version.

Fixed Issues

1. Fixed multiple security vulnerabilities.

Fixed Issues

1. Fixed the issue where user groups with valid permissions are unable to modify cells in protected ranges.
2. Fixed the issue where importing files with data validation rules might fail.
3. Fixed the issue where updating locale settings might not automatically take effect.

Important Note

1. The update is expected to be available in all regions within the next few days. The actual time of release may vary slightly depending on the region.

What's New

For Spreadsheet

1. Updated the calendar template to the year 2020.

Bug Fixed

For Document, Slides and Spreadsheet

1. Fixed the issue where the text might break into the next line when superscript or subscript has been applied to some of the characters.
2. Fixed the issue where spelling errors marked by red underline might change to black after viewing version history via Safari.
3. Fixed the issue where users might encounter incorrect layout display when importing or exporting Microsoft Excel .xlsx files.

For Document

1. Fixed the issue where justified text alignment might be ignored in print preview and printouts.
2. Fixed the issue where inserting images might fail after viewing version history.

For Slides

1. Fixed the issue where applied themes might fail to display properly when the zoom is over 100%.

For Spreadsheet

1. Improved the precision of rounding decimal numbers for formula results.
2. Fixed the issue where the suggested user list in comments is unable to display fully.
3. Fixed the issue where comments might disappear after sorting cells.

4. Fixed the issue where data validation might fail after renaming worksheets.

5. Fixed the issue where importing files might fail when there are uppercase characters in the file extension.

6. Fixed the issue where importing .csv files might fail on ARM platforms.
7. Fixed the issue where hyperlinks in worksheets might not work after the files are exported as .xlsx files and imported back into Synology Office.

What’s New

1. Enhanced the performance of exporting spreadsheets which contain numerous merged cells.
2. Enhanced the performance when deleting a large number of worksheets in spreadsheets.
3. Supports continuously hiding rows or columns with keyboard shortcuts.
4. Improved the compatibility of importing and exporting Microsoft Excel XLSX files for better format accuracy.

Fixed Issues

1. Fixed the issue where backing up Synology Office template via Hyper Backup might fail.
2. Fixed the issue where Synology Office files might fail to be opened when a user quota limit is reached.
3. Fixed the issue where exporting large Synology Office files might fail.
4. Fixed the issue where inserting cut cells to a new row will fail in spreadsheets.
5. Fixed the issue where syncing spreadsheet data might fail when another user is deleting worksheets of the same file at the same time.
6. Fixed the issue where using data validation with the number rule might fail.

Compatibility & Installation

1. Synology Office 3.2 will be gradually rolling out to global users.
2. Synology Office 3.2 requires Synology Drive Server 2.0 version or above.

What's New

For Document, Slides and Spreadsheet

1. Added physical file of Synology Office file types to allow file export to another Synology Drive server and open them.
2. Added advanced chart options to provide various settings when creating charts in Synology Office files.
3. Optimized the compatibility and service stability for importing and exporting files.

For Slides

1. Supports cropping images into various shapes.
2. Supports setting format for images with size, rotation angle, transparency etc.
3. Supports transition and animation effects for slides and objects.
4. Supports inserting videos and automatically playing videos in presentation mode.
5. Supports importing from PPT file type.

For Spreadsheet

1. Supports protected range and worksheet to set permissions for specific working areas.

Minor bug fixes.

1. Added Spreadsheet template for 2019 Calendar.
2. Fixed an issue where resolution of Slides might be abnormal on Google Chrome 72.0.3626.109 or later browser versions.
3. Fixed a security vulnerability (Synology-SA-19:11).
4. Minor bug fixes.

1. Fixed the return value of the MATCH function.
2. Fixed an issue where there may be an extra blank page when printing a document on Safari.
3. Fixed an issue where importing .xlsx files containing images might fail .
4. Fixed an issue where creating files on Firefox may fail.
5. Fixed an issue where cutting and pasting texts on IE may fail.
6. When a formula contains the name of a worksheet, changing the name of the worksheet no longer affects the formula.
7. Fixed an issue where users may not be able to open a file after running Hyper Backup.
8. Fixed an issue where users may not be able to open a file after managing it with SMB.
9. Fixed an issue where comment-only users may not be able to resolve comments.
10. Minor bugs fixes.

1. Fixed an issue where users might not be able to scroll to a cell in spreadsheets if the cell is in frozen area when executing Find and Replace.

2. Fixed an issue where spreadsheets might not be able to be downloaded as PDF files.

3. Fixed the return value of INDEX function.

4. Added support for IFS function in spreadsheets.

5. Fixed an issue where documents with multiple pages might fail to display properly.

6. Enhanced the compatibility of imported spreadsheets and documents.

7. Minor bugs fixes.

1. Fixed an issue where documents and slides might fail to be saved as template files.

2. Enhanced compatibility of imported spreadsheets and slides.

3. Fixed an issue where merge cells might not show normally across two pages in documents.

4. Fixed an issue where it cannot insert images in a frozen range in spreadsheets.

5. Minor bugs fixes.

What’s New

1. Customized template is supported for spreadsheets, documents and slides.

2. User can give a specific history version a name.

3. Filter view allows user to filter data without influencing the way other users viewing the same spreadsheet.

4. Supports changing the color of a sheet tab, copying a sheet to another file, and hiding a sheet.

5. In spreadsheets, user can change absolute reference by pressing F4.

6. In spreadsheets, user can apply various styles to the text within a cell.

7. In spreadsheets, user can search content in a specific range.

8. In spreadsheets, user can select the range for reference in another sheet by mouse.

9. Supports spell check suggestion and personal dictionary for documents and slides.

Fixed Issues

1. Enhanced overall performance.

2. Enhanced compatibility for exported PDF files.

3. Enhanced usability for viewing documents with separators and set it as default viewing mode.

4. Fixed an issue where documents and slides might fail to input texts normally.

5. Fixed an issue where spreadsheet can’t hide merged cells.

6. Minor bug fixes.

1. Thai user interface is now available.

2. Fixed an issue where thousands separator might not be changed along with time zone.

3. Fixed an issue where Slides might fail to paste images which are copied from Microsoft  .pptx file.

4. Minor bug fixes.

1. Fixed multiple security vulnerabilities (Synology-SA-18:12).

2. Supports printing spreadsheets in landscape orientation.

3. Enhanced the import and export compatibility of Microsoft Office files.

4. Minor bug fixes.

1. Enhanced the format compatibility of imported spreadsheets and documents.

2. Fixed an issue where spreadsheets might fail to be exported.

3. Fixed an issue where formats might fail to be applied to text in slides.

4. Fixed an issue where data validation might be lost in spreadsheets.

5. Minor bug fixes.

1. Fixed an issue where Office might fail to start.

2. Fixed an issue where users’ file privilege might not be updated until they reload the files. 

3. Optimized the size and resolution of inserted images.

4. Added support for setting non-numeric chart data as zero or null.

5. Improved the efficiency of updating the outline panel in documents. 

6. Minor bug fixes.

Compatibility and Installation

1. Synology Office 3.0.0 is compatible with DSM 6.1.3 and above.

2. Synology Drive, Universal Search, Synology Application Service, Node.js v4 and PHP 7.0 are required to be installed before you install Synology Office 3.0.0.

3. If a user account/group has the “Deny“ permission in the application privilege settings of Cloud Station Server or Office 2.0, the user account/group will not have the application privilege of Drive after it is installed. 

What’s New

1. Office has been integrated with Synology Drive as an add-on package for online collaboration.

2. The "comment only" permission type is supported for shared files.

3. [Slides] The brand new file type, Slides, is now available for editing presentations online.

4. [Spreadsheet] Users can now reference data from one sheet to another.

5. [Spreadsheet] The feature of defining range names is now available.

6. [Document] The print layout is now available for viewing documents with page separators.

7. [Document] Page setup and header/footer insertion are now available.

Fixed Issues

1. Enhanced the import/export compatibility for files of Microsoft Office and OpenOffice formats.

2. Fixed an issue where certain collaboration features in Slides might not work properly.

3. Fixed an issue where users might be forced to log out while importing files.

4. Minor bug fixes.

1. Fixed an issue where users might fail to move data to another volume on specific models.
2. Fixed an issue where the Office package might fail to be restored using Hyper Backup.
3. Minor bug fixes.

1. Fixed a security vulnerability where attackers might execute commands against Synology NAS. (CVE-2017-11150)