Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
xlsxExportingv13
2 Odgovori
4024 Prikazi
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
Opusti
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
Opusti
Open Blue Sea Farms
Avtor

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
Opusti
Related Posts Odgovori Prikazi Aktivnost
Export data to custom XLSX template in python
python xlsx Exporting odoo16features
Avatar
Avatar
1
okt. 24
2850
HRMS Appraisal question
xlsx Exporting CSV Appraisal odoo17
Avatar
0
avg. 24
1245
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
1815
What are mandatory export fields
Exporting
Avatar
Avatar
1
feb. 24
2597