Keep formats of initial ODS spreadsheet after editing

Questions
1

Describe the problem/error/question

I’m appending a line to an ODF-file from our Nextcloud. In theory that works fine, but unfortunately the convert to file node is increasing the file size from 79 KB to 764 KB and destroying some cell formats, especially for time and date.

How can this be prevented?

What is the error message (if any)?

This is how the table looks like after appending one line:

Gesprächspartner / Eintragung durch Name Datum Zeit Kontaktweg Grund Reaktion Bemerkungen Ergebnis wie gefunden (Details) Nachfassung 1 Adresse / Telefon Sonstiges
Bob John Doe Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time) Sun Dec 31 1899 13:56:00 GMT+0000 (Coordinated Universal Time) Terminbuchung Online stuff Suchmaschine
Lisa Tim Test Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time) Sun Dec 31 1899 12:00:00 GMT+0000 (Coordinated Universal Time) Terminbuchung Online other stuff Suchmaschine
Max John Doe 2024-08-05T00:00:00.000Z 1899-12-31T16:52:00.000Z Terminbuchung Online nothing

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.52.2
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu 22.04
2

hello @mokkin

Have you tried to use a compression option? As for the cell formats, I suppose n8n uses some basic library for that and there is no format option
image

3

Yes I tried with and without compression. The file size is smaller with compression, but the format problems are always the same unfortunately.

4

Unfortunately there seems to be no solution yet :frowning:

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.