General

Default Locale Settings

In addition to the display language in Office, which can be selected at Settings > Profile, you may also want to change the formatting of numbers, currencies, and dates according to your language and geographic region when working with spreadsheets. Follow the steps below to change the default locale for all spreadsheets.

  1. Click the Account icon > Settings > Office > Default locale.
  2. The default locale will be the same as your browser locale. Select a locale from the drop-down menu to change the default locale.
  3. Click OK.

Note:

Compatibility of Synology Office Files with Microsoft Files

To convert Microsoft Office files to Synology Office files:

With the Office package installed, you can use the following functions in Drive:

Supported file formats for conversion:

To download Synology Office files as Microsoft Office files

After opening a file you want to download, go to the File menu > Download. The file will be downloaded as the following types:

Note:

Managing Templates

The Office package provides a variety of built-in templates, which all users can create files with but are not allowed to edit, share, delete, or rename. However, users can also create their own customized templates, which they could edit, share, delete, rename, and publish. To go to the template page, click File > New file from template.

To create a customized template:

  1. Open an existing file that you would like to save as a template.
  2. Open the File menu, and click Save as template.
  3. Specify a name for the template.

Note:

To share a template:

Click the Share icon in the toolbar. Select who you want to share the template with and what type of permission to give. After the template is shared, users with permission will be able to see it by clicking + > From template in the Drive portal or File > New file from template in the Office editor.

You can share your template with:

  1. User: for specific users to access your template.
  2. Group: for users in specific groups to access your template.
  3. Internal: for all internal users who can access Drive to access your template.

Permission types for template sharing include:

  1. Edit: Users who are given the managing permission can edit, share, delete, and rename your template.
  2. View: Users with the viewing permission can only create new files with your template.

Note:

To share a template URL:

To share your template via a URL, click the Share icon in the tool bar, copy the sharing link of the template, and send it to whoever you would like to share the template with.

After receiving and opening the link:

  1. Users with the View permission will be directed to the view mode.
  2. Users with the Edit permission will also be directed to the view mode, but can switch to editing as well.
  3. Users with no permission will be directed to the Request access page.

Using Templates

For built-in templates, you can only preview and create files with them from the template page. As for templates shared to you by other users, you can view and create files with a template that you have the permission to view, while for a template that you are permitted to edit, you will be able to rename, delete, edit, and publish it. For more details, please see below:

To edit and publish a template:

  1. Edit your templates like any other regular file.
  2. After your editing is complete, please publish the template to make sure that users who create files with the template will be using the finished version of it.

Note:

Managing File Versions

When you work on your files in Office, versions will be saved automatically to the server periodically, so you won't have to worry about any loss of information if you close a file without saving it. The complete version history for each file is recorded, including the last modified time and users who have made changes to the file.

To restore or copy a file version:

  1. Open a file.
  2. Click the View History icon in the left sidebar. You will then see a main window with a list of historical versions on the right side.
  3. Click on a version from the list, and a preview of this version will appear in the main window. You can switch from the Hide record mode to Show record for the differences between versions to be highlighted.
  4. You can click the More icon on the right end of an unnamed version and choose Name version to specify a name for the version.
  5. You can also click the More icon on the right end of a named version and choose Rename or Remove name to rename or delete the name of the version.
  6. Click Restore in the lower right corner to restore the file to the selected version, which will overwrite the current one. Alternatively, click Make a copy to save the selected version as a separate file.

Note:

Encrypting Files

You can add password protection to confidential files, which can be done as you create a file or afterwards.

To create a new file with encryption:

  1. Click the File menu > New encrypted file.
  2. Select Document, Spreadsheet or Slides.
  3. Enter and confirm the password, and then click OK. The encrypted file will be opened in a new tab.

Note:

To add encryption to an existing file:

  1. Click the Encrypt icon in the left sidebar after opening a file.
  2. You can edit the title if necessary.
  3. Enter a password into the Password field.
  4. Enter the password again into the Confirm password field.

Note:

The following data will not be retained in the encrypted file:

To change the password of an encrypted file:

  1. Click the Encrypt icon in the left sidebar after opening a file.
  2. Select Change password.
  3. Enter the current password in the Password field.
  4. Enter the new password in the New password field.
  5. Enter the new password again in the Confirm password field.
  6. Click OK.

To create an unencrypted copy of an encrypted file:

  1. Click the Encrypt icon in the left sidebar after opening a file.
  2. Select Create an unencrypted copy.
  3. Enter the password in the Password field.
  4. Click OK.

Sharing Office Files

You can choose whether to grant viewing, editing, commenting, or managing permission to other DSM users or groups. After a file is shared, invitees will accept notifications.

Sharing link permission:

Click the Share icon in the toolbar. Select one of the below options from the Permission drop-down menu.

To invite accounts:

  1. In the User/Group field, enter a DSM username or a group name. DSM will suggest usernames or group names as you start typing.
  2. Select whether you want to allow this user or group to view, edit, manage, or only comment on this item from the drop-down menu.
  3. Click the + button to share this item with that user or group. You can add multiple users or groups.
  4. Click OK.

Note:

Backup and Restoration

With Hyper Backup, you can back up Office to local or remote destinations and restore the settings and data of the package to a previous point of time. You must backup both Drive and Office at the same time because Synology Office files are managed in Drive. For detailed information, please go to Drive Help > Backup and Restoration.