Spreadsheet Quotation Calculator
spreadsheet_quotation · OCA/spreadsheet
-
Security25/25No findings
-
Activity25/25Last human commit 5 months ago
-
Required by5/250 modules depend on it
-
Maturity5/25In 1 Odoo series since 18.0
Heuristic over the facts below, not an audit · How it's computed
Description
This module allows linking spreadsheet calculators to quotation templates in Odoo. When a sale order is created from a template that has a calculator, a copy of the spreadsheet is automatically assigned to the order with a pre-configured global filter so the ODOO.LIST formulas display only that order's lines.
The spreadsheet calculator is built on top of spreadsheet_oca and
uses ODOO.LIST formulas to display sale order line data (product,
quantity, unit price, etc.). Users can add custom formulas, calculations,
and charts to build complex pricing logic.
A Field Sync side panel lets users map spreadsheet columns to sale order line fields. This column-based approach is more intuitive than cell-by-cell mapping and makes it easy to push calculated values back to the sale order.
Dependencies
Code analysis
Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.
Views touched 3
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
sale_order_template_view_form_inherit |
sale.order.template.form.spreadsheet | sale.order.template | form | Inherits sale_management.sale_order_template_view_form |
sale_order_view_form_inherit |
sale.order.form.spreadsheet | sale.order | form | Inherits sale.view_order_form |
spreadsheet_quotation_create_form |
spreadsheet.quotation.create.form | spreadsheet.quotation.create | form | New |
HTTP endpoints 0
No HTTP endpoints found for this module.
Models touched 3
-
has_spreadsheetBooleancompute='_compute_has_spreadsheet' -
spreadsheet_idMany2one → spreadsheet.spreadsheetcopy=Falsestring='Quotation Calculator' args: 'spreadsheet.spreadsheet'
-
action_open_spreadsheet_calculator(self) -
action_sync_spreadsheet_order_lines(self, commands)Sync sale order lines from the quotation calculator spreadsheet. -
create(self, vals_list)@api.model_create_multi -
write(self, vals)
-
spreadsheet_idMany2one → spreadsheet.spreadsheetcopy=Truehelp='Spreadsheet used as pricing calculator for quotations created from this template.'string='Quotation Calculator' args: 'spreadsheet.spreadsheet'
-
action_create_spreadsheet_calculator(self) -
action_open_spreadsheet_calculator(self)
-
line_countIntegerdefault=DEFAULT_LINE_COUNThelp='Initial number of rows to display in the list.'string='Number of lines' -
nameChardefault='Quotation Calculator'required=True -
sale_order_template_idMany2one → sale.order.templatereadonly=Truerequired=True args: 'sale.order.template'
-
action_create(self)
Loading…