Skip to content
Health
60/100
fair
  • Security25/25
    No findings
  • Activity25/25
    Last human commit 5 months ago
  • Required by5/25
    0 modules depend on it
  • Maturity5/25
    In 1 Odoo series since 18.0

Heuristic over the facts below, not an audit · How it's computed

Security findings
Grave / minor (static analysis)
Required by
0
Modules depending on it
External deps
0 pip · 0 bin
Python packages / system binaries
License
AGPL-3
No conflicts with its dependencies
Folder size
2.2 MB
Module directory on disk
Code analysis 0 migration notes 3 models 3 views 0 HTTP endpoints

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

Odoo dependencies
Python dependencies
None
System dependencies
None
Required by
None

Code analysis

Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.

Views touched 3

XML IDNameModelTypeStatus
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

New fields (2)
  • has_spreadsheet Boolean
    compute='_compute_has_spreadsheet'
  • spreadsheet_id Many2one → spreadsheet.spreadsheet
    copy=False string='Quotation Calculator' args: 'spreadsheet.spreadsheet'
Public methods (4)
  • 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)

New fields (1)
  • spreadsheet_id Many2one → spreadsheet.spreadsheet
    copy=True help='Spreadsheet used as pricing calculator for quotations created from this template.' string='Quotation Calculator' args: 'spreadsheet.spreadsheet'
Public methods (2)
  • action_create_spreadsheet_calculator(self)
  • action_open_spreadsheet_calculator(self)

New fields (3)
  • line_count Integer
    default=DEFAULT_LINE_COUNT help='Initial number of rows to display in the list.' string='Number of lines'
  • name Char
    default='Quotation Calculator' required=True
  • sale_order_template_id Many2one → sale.order.template
    readonly=True required=True args: 'sale.order.template'
Public methods (1)
  • action_create(self)

Loading…