Im using Odoo's default export xlsx action and there's an unlikely behavior where it creates a huge gap between the previous one2many field and to the current one2many field. The xlsx file looks like this when opened in Excel, Sheets, or Odoo's spreadsheet:
Name | Form # | Item Lines | Color Lines | ID Lines | Shape Lines |
John Doe | Form 1 | Item 1 | Color 1 | ID 1 | Shape 1 |
Item 2 | |||||
Color 2 | |||||
Color 3 | |||||
ID 2 | |||||
Shape 2 | |||||
Shape 3 |
How can I fix that and make it look like this:
Name | Form # | Item Lines | Color Lines | ID Lines | Shape Lines |
John Doe | Form 1 | Item 1 | Color 1 | ID 1 | Shape 1 |
Item 2 | Color 2 | ID 2 | Shape 2 | ||
Color 3 | Shape 3 |
Thank you