Extract ODS file, add an image in a cell, and then zip it

Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Calc: threaded

Sup, I’m looking for a way to modify an ODS table, in order to do this I would need to know where Libreoffice keeps the data when you extract the file, something I don’t know. And then insert an image in a cell. I need this or something like this to create a script to generate qr codes that go into the table and indentify some documents, but knowing where the data is and how to input new data is a good start for me.

Anyone has tried this before? Thanks

I’d create a copy of the file, add such image in the UI, save, and compare differences in the zip and content. Ignore auto-style renaming and such unrelated changes. Digest the ODF v1.3 standard, mainly part3-schema, to understand added elements and attributes.

2 Likes