Release Notes for Synology Office

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

1. Adjusted the display names of online collaborators.
2. Fixed an issue where the data in one document might not be synced when multiple collaborators make large amounts of changes at the same time.
3. Fixed an issue where images might disappear when selected after spreadsheets have been zoomed in or out.
4. Fixed an issue where results might be incorrect when a cell containing a formula is copied to multiple cells.
5. Minor bug fixes.

General

• Added internal sharing permission, enabling users to share files via sharing links requiring login credentials.
• Added an option allowing non-admin users to share files publicly.
• File URL and sharing link are now consistent.
• Added support for exporting odt and .ods file formats and importing odf and .rtf formats (installation of Document Viewer required). 
• Color is customizable in documents and spreadsheets.
• Added support for performing data deduplication when backing up Office data via Hyper Backup, thereby enhancing storage efficiency (system requirements: Hyper Backup 2.0.0 or above and Hyper Backup Vault 2.0.0 or above, with system memory over 128 MB required).
• Added support for pasting the copied content via context menu after installing Synology Office Extension on Google Chrome.

Document

• Added the image editing features, including crop, border style, and rotation features.
• Table formats including border color and width are now adjustable.

Spreadsheet

• Supports preview of range and frequently used statistical information (e.g., sum, average , count, etc.) when selecting cells
• The calculated results can be instantly previewed when entering formulas and values.
• Supports zoom mode for flexible content viewing. 
• Supports OFFSET formula.

1. Fixed an issue where opening encrypted documents might fail.
2. Fixed an issue where syncing document content might fail after disconnecting abnormally.
3. Fixed an issue where deleting comments left by other editors in a document might fail.
4. Fixed an issue where the refresh button in the table of contents might display incorrectly after zooming in/out the document.
5. Minor bugs fixes.

1. Fixed an issue where opening files might fail.
2. Fixed an issue where row height in imported spreadsheets might be incorrect.
3. Minor bugs fixes.

1. Fixed an issue where creating a historical version of a spreadsheet might fail and cause excessive CPU usage when the spreadsheet contained formulas.
2. Fixed an issue where the style of a cell with conditional formatting or data validation might be lost after reloading the spreadsheet.

General

1. Users can use Office without the user home service enabled by an administrator.
2. Supports moving data storage from one volume to another.
3. Provides uninterrupted service when Office is being backed up by Hyper Backup.
4. Supports .doc file type for import (installation of Document Viewer required).
5. Enhanced the usability of color pickers.
6. Fixed an issue where saving a historical version as a new copy might fail.
7. Fixed an issue where users might fail to remove permissions from a group that has been deleted.

Document

1. Supports inserting and editing shapes.
2. Supports adjusting table border colors.
3. Supports vertical alignment in a table.
4. Fixed an issue where unwanted HTML tags might appear in the content copied from Microsoft Word.
5. Fixed an issue where images copied from websites might not display normally.
6. Fixed an issue where users might fail to adjust the width of a table copied from Google docs.
7. Fixed an issue where inserting a table of contents into a table might lead to incorrect display of the table.

Spreadsheet

1. Fixed an issue where users might fail to make a reply to comments in the comment panel.
2. Fixed an issue where users might fail to edit or delete conditional format rules in an imported file.
3. Fixed an issue where users might fail to select an item from the data validation list for a cell.
4. Fixed an issue where cell border style might be incorrect.
5. Fixed an issue where the calculated result of the RATE formula might be incorrect.

Compatibility and Installation

1. Synology Office 2.0.1 can only be installed on Synology products running DSM 6.0.2 onward.
2. Installation of Synology Application Service and Node.js v4 is required before installing Synology Office 2.0.1.

What’s new

1. Office is an upgrade from the SpreadSheet package.
2. Introduces a new file type - document, allowing you and others to collaborate on text-oriented files with a rich array of built-in tools.
3. Provides a brand-new UI design to enhance user experience.
4. Users can grasp major updates via notifications.
5. Users can organize files with folders and labels.
6. Users can use Synology Chat directly via the Chat plugin from a document or spreadsheet.
7. The interactive feature of comments is supported to increase collaboration efficiency.
8. Provides practical templates for documents and spreadsheets.
9. Supports searching for folders, documents, and spreadsheets in Office via Synology Universal Search (DSM 6.1 Beta or above required).
10. Data in spreadsheets can now be converted into charts.
11. Format customization is available for currencies and dates in spreadsheets.
12. Added a button for frequently used formulas to the spreadsheet toolbar.
13. Added more styles for cell borders in spreadsheets.
14. Minor bug fixes.

1. Enhanced format compatibility of imported spreadsheets.
2. Fixed an issue where data synchronization might fail after undoing specific operations.
3. Fixed an issue where date-related content might not display correctly after being copied and pasted.
4. Fixed an issue where the feature of ”Replace all” in the Find and Replace window might not work properly.
5. Minor bug fixes.

1. Users can now insert email hyperlinks.
2. Fixed an issue where filtered results might not be accurate.
3. Fixed an issue where font might not display correctly on a printout.
4. Fixed an issue where filtering might fail for cells with data validation.
5. Minor bug fixes.

1. Enhanced overall performance of SpreadSheet.
2. Enhanced the accuracy of formulas.
3. Date and Time formulas can now automatically detect Daylight Saving Time.
4. You can copy data validation rules from one cell to another.
5. You can paste only the format of a cell by pressing Ctrl + Shift + V.
6. You can press Esc on the keyboard to clear the dashed border of a range selected to be copied.
7. Fixed an issue where importing a spreadsheet might fail.
8. Fixed an issue where filter might not work properly.
9. Fixed an issue where the cut area in one sheet might not disappear after being pasted to another sheet.
10. Fixed an issue where the sheet tab scrolling buttons might disappear after too many sheets were added.
11. Minor bug fixes.

1. Fixed an issue where cell content might be lost in cell edit mode when users scrolled the cell out of view.
2. Fixed an issue where date format might be incorrect after cells containing date were copied to another sheet.
3. Fixed an issue where multiple users might fail to create new sheets within a spreadsheet at the same time.
4. Fixed an issue where the text for a hyperlink could not be displayed properly when containing double quotation marks.
5. Fixed an issue where users could not break lines of text in merged cells by pressing Ctrl-Enter.
6. Fixed an issue where filtered content could not be displayed correctly in a spreadsheet imported from Google Sheets.
7. Minor bug fixes.

1. Allows you to host your collaboration drive and work easily with others by sharing spreadsheets.
2. Customize access permissions for guests, DSM users and groups, and set read/write privileges for specific spreadsheets.
3. Multiple users can edit the same spreadsheet simultaneously and see the modifications in real time.
4. View the revision history and restore the spreadsheet to a previous version.
5. Manage your spreadsheets with multiple attributes by adding tags to individual spreadsheets and quickly find them later.
6. Supports import and export of other spreadsheet formats.
7. Supports data validation, conditional formatting, filter and spelling check.
8. Spreadsheet encryption is supported to protect confidential spreadsheets.
9. Supports application backup in the Hyper Backup package.
10. Range selection is supported in SpreadSheet functions.
11. Supports selecting multiple rows/columns/cells by pressing and holding the “Ctrl” key.
12. Over 300 formulas are supported.
13. SpreadSheet Function List is provided with instructions on frequently used functions and usage examples.
14. Allows you to insert images to spreadsheets.
15. You can now print your spreadsheets.