Hi I am using odoo 14, i have created a text field in odoo purchase order lines i want to create a table in this field, i can do this with Html field but when i export it to excel it doesnt show the table it just shows the html tags , how can i achieve this , is there any custom module to achieve this
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
2
Risposte
4031
Visualizzazioni
Hi jo,
Paste Special as HTML; but you need to select and then copy and paste special. I tested it in LibreOffice and worked.
Hamid
after exporting i need to copy and paste it as special ?
No, actually I just selected a table which was designed via HTML and copied and paste it. Not export.
Maybe you can use some libraries in python to select the text and copy it in the clipboard and then when generating an export, you can convert it into table. But of course it needs development.
oh okay @Hamid thank you for the input , but i need it in xlsx export not copying and pasting as i have 1000s of purchase order and each purchase order field will have one table
oh okay @Hamid thank you for the input , but i need it in xlsx export not copying and pasting as i have 1000s of purchase order and each purchase order field will have one table
Then I definitely recommend to create new fields in the model and with python code convert the HTML structure to csv format or similar and then do the export easily with the new fields.
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
2
ott 23
|
3214 | ||
|
1
apr 23
|
3860 | ||
|
2
giu 22
|
3876 | ||
|
|
0
mag 22
|
233 | ||
|
|
0
feb 22
|
2128 |
