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)

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.