Get started

Create a new spreadsheet

To create a new spreadsheet:

1. Open Odoo Documents and navigate to the section or folder in which the spreadsheet should be created.

2. Click New and select Spreadsheet.

   小訣竅

   Alternatively, from the All folder, click New and select Spreadsheet, then select in which Workspace (i.e., folder) the spreadsheet should be created. If file centralization has been enabled for spreadsheets, you will also have the option to save the new spreadsheet in the Spreadsheet folder.

3. Click Blank spreadsheet or, to create a new spreadsheet using an existing template, select the relevant template.

4. Click Create.

5. Click on Untitled spreadsheet at the top of the screen to edit the name of the spreadsheet.

小訣竅

It is also possible to create a new spreadsheet by:

• clicking File ‣ New from the menu bar of an open spreadsheet; or

• inserting a list, pivot table, or chart from another Odoo app into a new spreadsheet directly from the app in question.

In these cases, the new spreadsheet is saved in Odoo Documents in the My Drive personal folder or, if file centralization has been enabled for spreadsheets, in the Spreadsheet folder.

範本

电子表格模板可让您快速创建电子表格，无需从头开始。例如，您可以创建月度预算报告或季度销售佣金报告的模板。

備註

数据库中的所有用户都可以使用模板。

创建模板

Any spreadsheet can be saved as a template.

To create a template:

1. Open the relevant spreadsheet or create a new one.

2. From the menu bar, click File ‣ Save as template. Modify the default Template Name if needed and click Confirm.

重要

Once a spreadsheet is saved as a template, any further changes to the open spreadsheet are saved only in that spreadsheet. To make changes to the template, you need to edit the template.

You can also create a template by making a copy of an existing template and editing it.

使用模板

要使用模板创建新电子表格，打开文档应用并点击 新建 ‣ 电子表格。选择相关模板后点击 创建。

或者，前往 文件管理 ‣ 配置 ‣ 电子表格模板，然后在相关模板所在行点击 :icon:fa-plus 新建电子表格。

備註

默认情况下，新电子表格继承模板名称（显示在屏幕顶部）。要重命名电子表格，点击名称进行编辑。

管理和编辑模板

进入 文件 ‣ 配置 ‣ 电子表格模板 管理模板。移除 我的模板 筛选器 以查看数据库中的所有模板。

可执行多种操作：

• 复制现有模板，点击屏幕右侧的 复制。新模板将显示在列表底部，点击 名称 可进行编辑。

• 编辑模板（包括刚复制的），点击 编辑 后进行修改，更改将自动保存。

• 删除模板，勾选模板前的复选框，点击:icon:fa-cog 操作，然后选择 删除。

Upload files

Spreadsheets in .xlsx format can be uploaded into Odoo Documents and opened as an Odoo spreadsheet. To do so:

1. Open Odoo Documents and navigate to the section or folder where the spreadsheet should be saved.

2. Click New and select Upload.

3. Select the relevant .xlsx file and click Open.

4. Click on the uploaded file.

5. By default, the original .xlsx file is deleted when it is opened as an Odoo Spreadsheet. To preserve the original file in the same folder in Odoo Spreadsheet, disable Send source file to trash.

6. Click Open with Odoo Spreadsheet.

The file is now an Odoo spreadsheet and can be fully edited in Odoo Spreadsheet.

Manage spreadsheets

Users with Editor rights to a specific spreadsheet have various options for managing the spreadsheet via the File menu:

• Make a copy: creates a duplicate of the current spreadsheet with the same regional settings (or locale).

• Save as template: allows the current spreadsheet to be used as a template for future spreadsheets.

• Download: downloads the spreadsheet in .xlsx format.

  重要

  When you download a spreadsheet in .xlsx format, any spreadsheet formulas that retrieve Odoo data from your database, e.g., via an inserted list or via other Odoo-specific functions, are converted to the values they would have returned at the moment the spreadsheet was downloaded.

  小訣竅

  Users with Viewer rights can also download a spreadsheet in .xlsx format.

• See version history: provides read-only access to previous versions of the current spreadsheet, which can be named and restored if needed.

• Print: prints a copy of the spreadsheet on a connected printer.

• Settings: allows you to view and change the locale of the current spreadsheet.

• Add to dashboard: converts the current spreadsheet into an Odoo dashboard.

版本歷史

Odoo Spreadsheet automatically saves versions of spreadsheets as changes are made, allowing users with Editor rights to browse and restore previous versions.

To access the version history of a spreadsheet, click File ‣ See version history from the menu bar. Saved versions appear in a panel on the right of the spreadsheet. The name of the user who made the change is shown, as well as the date and time of the change.

The following actions are possible:

• View an earlier version in read-only format by clicking on the relevant version.

• Restore an earlier version by clicking (vertical ellipsis) then Restore this version.

• Copy an earlier version by clicking (vertical ellipsis) then Make a copy. A copy of the version opens as a new spreadsheet.

• Create named versions by clicking on the date and time of the relevant version and entering the desired name. The date and time of the version are then displayed below the new name.

小訣竅

When viewing an earlier, read-only version of a spreadsheet, the following actions are still possible:

• Search the spreadsheet by clicking Edit ‣ Find and replace or using the shortcut Ctrl + H.

• Copy an individual cell or selected area by clicking Edit ‣ Copy or using the shortcut Ctrl + C.

Regional settings

To ensure data is displayed consistently for all users, the regional settings (or locale) of a spreadsheet, are managed at spreadsheet level. This locale affects the following settings and formats:

• thousand and decimal separators

• date and time formats

• first day of the week

By default, a new spreadsheet inherits the regional settings of the user who created it. For example, any spreadsheets created by a user whose language is set to French (BE) / Français (BE) will follow Belgian French conventions.

A spreadsheet’s locale can be viewed and changed at any time by a user with Editor rights. To view the locale of a spreadsheet, click File ‣ Settings from the menu bar. The Spreadsheet settings panel opens on the right of the spreadsheet. To change the locale, select the appropriate locale from the dropdown.

小訣竅

When you open a spreadsheet that has a different locale to that of your user profile, a blue (globe) icon appears at the top right of the spreadsheet. Hovering over the icon reveals a warning message that indicates the spreadsheet locale and highlights formats that differ.

If no (globe) icon is shown, this means the spreadsheet’s locale is the same as that of your user profile.

Convert a spreadsheet into a dashboard

A user with the appropriate access rights can convert an Odoo spreadsheet into a dashboard that is then accessible via Odoo Dashboards. To do so:

1. Click File ‣ Add to dashboard from the menu bar.

2. Enter the Dashboard Name.

3. Select the relevant Dashboard Section from the dropdown or, to create a new dashboard section, type the name of the new section, then click Create.

4. If necessary, modify the Access Groups to determine which user groups can access the dashboard.

5. Click Create.

小訣竅

• By default, the first tab of the spreadsheet serves as the front end of the dashboard.

• It is also possible to convert a spreadsheet to a dashboard from within the Dashboard configuration settings, by directly adding the spreadsheet to an existing or new dashboard section.

• After a spreadsheet has been converted to a dashboard, it is deleted from Odoo Documents. Any subsequent modifications need to be made via Odoo Dashboards.