Skip to Content
This question has been flagged
xlsxExportingv13
2 Replies
4019 Views
Avatar
Open Blue Sea Farms

Hello community,

Is there a way to configure the exporting tool so that the blank lines have the same content of the previous line, avoiding leave blank cells? This issue occurs when there are one or more fields from another model (like sales and invoices, for example)

I need to use the exported information in a dynamic table, but the standard way how Odoo is doing it doesn't work for this purpose.

I'd appreciate your help.

The attached image from the model "sale.order" shows the commented issue (blank cells were painted in yellow to highlight)  


Avatar
Discard
Avatar
Amr Abd-Alkrim (FireBits)
Best Answer

Odoo made the blank lines for a purpose which is reimporting the exported data again to odoo.
The blank lines tells odoo that these orderlines belongs to this sale order so with out the blanks Odoo can't tell if the order has more than one orderline.

I hope you understand that you have to fill the blanks manually and there is no option to let Odoo do it for you right now.
You can request it as a new feature in the next Odoo though. 

Go to Odoo in github and request a new feature.


Happy to help :) an upvote will be awesome


Avatar
Discard
Open Blue Sea Farms
Author

Thanks Amr for your response.

Amir

hmm, not true.

The blank cells can be filled in with the same data as the first row and that won't cause any issue as long as they are all exactly the same. Blank cells are not a must have.

This can be inconvenient when importing data into another database.

Avatar
Masoud
Best Answer

Hasn't anything related to this problem come up yet? this is a huge problem when you're exporting data to make a report out of it in Excel especially when it's a multi-dimensional thing in your company like exporting sales orders and stuff like that!

Avatar
Discard
Related Posts Replies Views Activity
Export data to custom XLSX template in python
python xlsx Exporting odoo16features
Avatar
Avatar
1
Oct 24
2846
HRMS Appraisal question
xlsx Exporting CSV Appraisal odoo17
Avatar
0
Aug 24
1243
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo?
v13
Avatar
Avatar
Avatar
2
Jun 24
6330
Error login LinkedIn v13 enterprise
v13
Avatar
Avatar
2
Mar 24
1811
What are mandatory export fields
Exporting
Avatar
Avatar
1
Feb 24
2588