Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
676 Lượt xem

My goal is to conditionally format the rows in my spreadsheet based on the value of a specific column's cell in each row. However, the conditional formatting "Format cells if..." menu does not have a "Custom Formula is..." options like Google Sheets or Excel. 


Am I missing something or does Odoo need to add this functionality?

Ảnh đại diện
Huỷ bỏ

No, you're correct. 'Custom Formula is...' isn't currently a thing

Câu trả lời hay nhất

You're right, Odoo's spreadsheet application (which is part of Odoo's core modules) doesn't have the advanced "Custom Formula is" conditional formatting option that you find in Google Sheets or Excel.

You are not missing anything. Odoo's spreadsheet functionality is more basic in terms of conditional formatting capabilities. It currently offers a more limited set of predefined conditions.

Odoo's Current Conditional Formatting:

As of now (May 31, 2025), Odoo's spreadsheet conditional formatting typically allows you to set rules based on:

  • Cell value being equal to, not equal to, greater than, less than, between, or not between specific values.
  • Text content (containing, not containing, starting with, ending with).
  • Date conditions (is, is before, is after, etc.).
  • Blanks or non-blanks.

The Need for "Custom Formula is"

The "Custom Formula is" option is a powerful feature because it allows you to define much more complex and dynamic formatting rules based on formulas that can reference other cells in the row or even other parts of the spreadsheet. This is essential for many advanced data analysis and reporting scenarios.

Possible Workarounds (Limited):

While you can't directly use a custom formula, you might be able to achieve some limited conditional formatting effects by:

  1. Creating Helper Columns: Add extra columns to your spreadsheet that calculate intermediate values based on formulas. Then, apply conditional formatting to your target column based on the values in these helper columns. This can be cumbersome, but it's sometimes the only way to achieve a specific result.
  2. Using Odoo Studio (If you have Enterprise): Odoo Studio allows you to customize the views of your data. While it won't directly add conditional formatting to the spreadsheet itself, you could potentially use Studio to create a custom list view of your data with formatting applied based on conditions. This would be more of a visual representation of the data in Odoo, rather than within the spreadsheet app.

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 1 25
1659
2
thg 3 25
770
1
thg 5 25
2001
0
thg 8 15
4902
2
thg 9 24
1373