Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
3816 Visualizzazioni

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     

Avatar
Abbandona
Risposta migliore

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

Avatar
Abbandona
Autore

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.

Autore

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

Autore Risposta migliore

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 


Avatar
Abbandona

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.

Post correlati Risposte Visualizzazioni Attività
2
ott 23
3061
1
apr 23
3641
2
giu 22
3667
0
mag 22
233
0
feb 22
1967