HomeModulesWebsiteData Grid Widget
Data Grid Widget
WebsiteAuraOdoo Verified

Data Grid Widget

A one2many as a real spreadsheet grid: block paste from Excel, rectangular selection, fill down.

Technical Specifications & Compatibility

Technical Module Name
Supported Odoo Versions
v19.0
License
LGPL-3.
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
1101 lines (Python / XML / JS)

Overview & Description

Aura Odoo Tech Supports:CommunityEnterprise Data Grid Version 20.0.1.0.0: a spreadsheet grid for any one2many field Paste a spreadsheet straight into a form. Turn a one2many into a spreadsheet grid. Drag to select a block of cells, paste rows from Excel, copy them back out, fill down and type into a cell, all from the keyboard. ✓Ctrl+V pastes a block from a spreadsheet and adds the rows it needs ✓Drag to select, Ctrl+C to copy, Ctrl+D to fill down ✓A cell that cannot be read is reported, never saved as zero Built on Spreadsheet grid Copy and paste as tab-separated text Depends on Web only 5 options to fit your form 1 onchange per pasted row, not per cell 2 decimal styles read: 1.234,56 and 1,234.56 1 dependency: Odoo Web why you will like it Keying in lines without the pain Odoo's editable list edits one row at a time. This grid takes a whole block from a spreadsheet in one paste. Paste from a spreadsheet Copy a block of cells and press Ctrl+V. It lands at the cursor, and rows are added when the block is longer than the grid. Quoted cells with commas, tabs, quotes or line breaks come in as one cell. Select a rectangle Click and drag, or click and Shift+click, to select a block. Ctrl+A selects everything. The toolbar shows its size, such as 3 x 4 selected. Copy back out Ctrl+C puts the selection on the clipboard as tab-separated text, ready for a spreadsheet, and says how many cells it copied. Fill down and clear Ctrl+D copies the top row of the selection down over the rest. Delete clears the selected cells. Type like a spreadsheet F2, a double-click or any printable key starts editing a cell. Enter and Tab save it and move on, Tab at the right-hand edge goes to the start of the next row, and Escape cancels. Numbers read either way 1.234,56 and 1,234.56 are read as the same number. Selection cells accept the label in any case, and words such as yes, no, x and false are read as ticked or not. Errors are reported A cell that cannot be read as a number is left as it was, and a message names the column and the value. Read-only where it should be A computed column such as a subtotal, or a many2one column, is shown in grey and skipped when you paste over it, so the server's numbers are never overwritten. One update per row All the changes to a row travel together. A paste of 3 rows and 6 writable columns made 3 onchange calls, not 18. one attribute Add it to a field Put the widget on a one2many, list the columns you want and give the field a list sub-view that contains them. data_grid one2manymany2many The columns come from the fields of the sub-view. The demo model is an order-lines model with text, number, selection and yes/no fields and a computed subtotal. <field name="line_ids" widget="data_grid" nolabel="1" options="{'columns': 'reference,description,quantity,unit_price,subtotal,state,is_urgent', 'height': 420}"> <list> <field name="reference"/> <field name="description"/> <field name="quantity"/> <field name="unit_price"/> <field name="subtotal"/> <field name="state"/> <field name="is_urgent"/> </list> </field> Options: columns (comma-separated field names in the order you want; default is the fields of the sub-view), height (maximum height in pixels, the grid scrolls beyond it; default 360), freeze_first (keep the first column in view when scrolling sideways; default on), allow_create (Row button and rows created by a paste; default on), allow_delete (delete button; default on). see it in action Real screens, real demo data Every picture below is a capture of the widget running in Odoo 19, with a few extra sample lines added to the demo data. The grid on a form Eight lines in a grid. Subtotal is greyed because the server computes it. Lines and Total above the grid are the server's totals. Drag to select Drag over cells to select a block. The toolbar shows its size, here 3 x 4 selected. Edit a cell Double-click, press F2 or just start typing. Enter saves and moves down, Tab moves right, Escape cancels. Paste from a spreadsheet Five rows pasted from tab-separated text: prices written as 1.234,56 and 1,234.56, yes and no flags and a quoted description. Two rows were overwritten and three were added. The grey Subtotal was left to the server. Cells that cannot be read Two cells in the pasted text were not numbers. They were skipped, the old values stayed, and a message says why. Save, and the server totals After Save, Lines and Total on the form are worked out by the server from the saved rows. A frozen first column On a narrow screen the grid scrolls sideways inside its own box. The row numbers and the first column stay in view while the others move. Options: a compact grid Four columns, a fixed height with the header kept at the top, and no Row or delete buttons. A paste that would need new rows is refused with a message. Read-only columns A many2one column, here Demo, is shown in grey and skipped when you paste over it. The other columns of the same row were filled in. A read-only field When the field is read-only there is no editing, pasting or clearing. You can still select cells and copy them. how it works Three steps to a spreadsheet grid 1 Add the widget Put widget="data_grid" on a one2many field, with a list sub-view that contains the columns. 2 Choose the columns Set columns in options to list them in the order you want. Add height if the grid should scroll. 3 Paste and edit Select a cell, press Ctrl+V to paste a block from a spreadsheet, then save the form. setup Configure in two minutes Use it on your own model ✓Make sure the lines have text, number, selection or yes/no fields for the columns you want to type into ✓Edit the form view and set widget="data_grid" on the one2many ✓Add a list sub-view with the columns, and options such as columns and height ✓Upgrade your module and open a record ✓Copy cells in a spreadsheet, click a cell in the grid and press Ctrl+V Try the demo first ✓Turn on developer mode ✓Open Settings → Technical → Data Grid Demo ✓Open the Q1 price list record ✓Paste a block of rows, drag to select, press Ctrl+D, then save the form good to know Questions Which Odoo versions and editions? Odoo 19.0, Community and Enterprise. It depends only on the Web module. What does it read from the clipboard? Tab-separated text, with quoted cells, doubled quotes and either kind of line ending. That is what spreadsheets put on the clipboard when you copy cells. What if the pasted block is wider than the grid? The extra columns are dropped and a message says how many. A block that is longer than the grid adds rows, unless allow_create is off, in which case nothing is written and a message says so. Which columns can be typed into? Text, number, yes/no and selection columns, as the captures show. Computed columns and many2one columns are shown in grey and are not written to. Does it work on a many2many? The widget lists one2many and many2many as supported types. The demo and every capture here use a one2many. Does it load anything from the internet? No. There is no CDN and no external script, and the widget makes no network calls of its own. License LGPL-3. Developed by Aura Odoo Tech, https://www.auraodoo.tech. support We are here to help Written and maintained by Aura Odoo Tech. Email Questions, problems or a setting you need — write to us directly. odooaura@gmail.com Website More Odoo modules, documentation and customisation services. www.auraodoo.tech

Key Capabilities & Features

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.

Screenshots & Previews

12 images available
Data Grid Widget screenshot 1
Expand Preview
Data Grid Widget screenshot 2
Expand Preview
Data Grid Widget screenshot 3
Expand Preview
Data Grid Widget screenshot 4
Expand Preview
Data Grid Widget screenshot 5
Expand Preview
Data Grid Widget screenshot 6
Expand Preview
Data Grid Widget screenshot 7
Expand Preview
Data Grid Widget screenshot 8
Expand Preview
Data Grid Widget screenshot 9
Expand Preview
Data Grid Widget screenshot 10
Expand Preview
Data Grid Widget screenshot 11
Expand Preview
Data Grid Widget screenshot 12
Expand Preview
The AuraOdoo Quality Guarantee
100% Tested

Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.

Clean Architecture

Built according to official Odoo guidelines and PEP 8 standards with zero bloat.

Dedicated Support

Free installation assistance and quick bug turnaround from our team.