Top 15 New Features in Odoo 17 Spreadsheet App

Cybrosys Technologies

29-12-2023

1. Default Number & Date Format

The default number and date formats are now based on the spreadsheet creator's configuration and can be changed in the file settings.

Odoo 17 Spreadsheet App

2. Dynamic Pivot Tables

Use the single formula ODOO.PIVOT.TABLE to display an entire and dynamic pivot table.

Odoo 17 Spreadsheet App

3. Version History

View past versions of a spreadsheet and duplicate it at an earlier stage.

Odoo 17 Spreadsheet App

4. Group Rows or Columns

Group rows or columns to easily collapse and open them.

Odoo 17 Spreadsheet App

5. Split Text into Columns

Use the split text to columns feature or the SPLIT function to take text from one or more cells and split it into multiple cells.

Odoo 17 Spreadsheet App

6. Autofill Alphanumeric Values

Autofill now supports alphanumeric values.

Odoo 17 Spreadsheet App

7. Blank Spreadsheets Auto-Cleanup

New spreadsheets left blank and unmodified are now deleted after 24 hours.

Odoo 17 Spreadsheet App

8. Cell Reference When Scrolling

Keep track of cells being edited when navigating between sheets.

Odoo 17 Spreadsheet App

9. Contextual Domain Import

The contextual domain is now imported when a model is inserted into a spreadsheet.

Odoo 17 Spreadsheet App

10. Drag & Drop Sheets

Move sheets in the bottom bar by drag-and-dropping them.

Odoo 17 Spreadsheet App

11. ODOO Formulas Insertion

ODOO formulas can be inserted from the function menu.

Odoo 17 Spreadsheet App

12. Autofill Beyond Viewport

Scroll beyond the visible area of the screen when using the autofill.

Odoo 17 Spreadsheet App

13. Extend Filters to Match New Data Sources

Field matching is now automatic for data sources already set in the global filters.

Odoo 17 Spreadsheet App

14. Image Insertion

Insert images in spreadsheets.

Odoo 17 Spreadsheet App

15. Search Granularity

Find and replace characters more quickly by searching all sheets, the current sheet only, or a specific range of sheets.

Odoo 17 Spreadsheet App