Skip to Content
Dette spørgsmål er blevet anmeldt
xlsxExportingv13
2 Besvarelser
3975 Visninger
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
Kassér
Avatar
Amr Abd-Alkrim (FireBits)
Bedste svar

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
Kassér
Open Blue Sea Farms
Forfatter

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
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
Export data to custom XLSX template in python
python xlsx Exporting odoo16features
Avatar
Avatar
1
okt. 24
2810
HRMS Appraisal question
xlsx Exporting CSV Appraisal odoo17
Avatar
0
aug. 24
1219
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
1792
What are mandatory export fields
Exporting
Avatar
Avatar
1
feb. 24
2529