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