Skip to Content
Home └Spreadsheet & Dashboards └Odoo Spreadsheet basics

Spreadsheet & Dashboards

0 %

Completed

Course content

Odoo Spreadsheet basics

40 XP
Prev Next
Fullscreen Share

Learn how to access and navigate Odoo Spreadsheet so you can work with and analyze live Odoo data. 

Rating
0 0

There are no comments for now.

Join this Course
to be the first to leave a comment.

1. What is the benefit of converting a range of cells into a spreadsheet table?
It automatically calculates the profit margin. It adds styling and makes the data easier to manage/expand. It freezes the first row and first column automatically. It locks the cells so they cannot be edited.
2. Which of the following is true about functions in Odoo Spreadsheet?
Odoo only supports its own proprietary functions and cannot use standard formulas like SUM or AVERAGE. Functions can only be used on numerical data, not on text cells or dates. To use a function, you must first export the spreadsheet to an external editor and then re-upload it. Odoo supports standard spreadsheet functions as well as Odoo-specific functions that link to live database data.
3. What does a blue globe icon above the spreadsheet indicate?
The spreadsheet is currently being shared with external users. The spreadsheet's regional settings differ from your own user profile settings. The Odoo database is currently syncing data with a global cloud server. The file is an imported external document and has not yet been converted to a native Odoo format.
4. How does "wrapping" help when dealing with long header text in narrow columns?
It automatically shrinks the font size to fit the cell width. It rotates the text 90 degrees to point upwards. It allows the text to appear over multiple lines within the same cell. It creates a pop-up note showing the full text that appears when you hover over the cell.
5. How can you change the access rights on a specific spreadsheet to only allow "Viewer" access?
By opening the spreadsheet, clicking "Share", then changing the individual or general access rights from "Editor" to "Viewer." This isn’t possible; access rights are managed at the level of the Documents folder in which the spreadsheet is saved. By opening the spreadsheet, then setting it to "Read-Only" mode via the File > Settings menu. By locking the spreadsheet with a password that only the owner knows.