ASAP: LANGUAGE SETTINGS (CALC) DOCUMENTS xslx "save as pdf" locale setting?

Hello,

while Collabora via Nextcloud Office Integration and Docker Container (Collabora Code) generally respects language settings of users.

Current docker settings:

  • dictionaries=de_DE, en_US
  • https config
  • v24.04.10.1.1 collabora/code

Nextcloud Config:

  • all (default) language and locale settings set, except forced (de_DE)

Textual description: When I right-click export as pdf on a xslx in the Nextcloud and I have some datetime in the header of the calc document it gives me a fully different dateformat in the exported, saved pdf than my browser or my user account has.

how to test?

  1. open test.xlsx

  2. go to insert & click on header/footer

  3. put the datetime top right (right area); custom format

  4. you see the format as your set language in nextcloud! keep that in mind

  5. now close the document, click right click on it in nextcloud folder view and click on save asexport as pdf

  6. Check the exported pdf’s date (click on it for preview). It shows the wrong date format

I could not upload all the images individually when I wanted to sent it, so I just took a huge ss of it.

Important questions to answer:

Where does this date inserting get its locale / language from? How can I change that?

I need a urgent fix for this.

Thank you

BTW other users have those issues too, there are many questions how to configure.

This is a docker config help but …

linked threads:

help[.]nextcloud[.]com/t/where-are-the-language-settings-for-collabora/3114

forum[.]collaboraonline[.]com/t/ui-default-language/1664

help[.]nextcloud[.]com/t/how-do-i-change-the-default-language-in-collabora/53667

help[.]nextcloud[.]com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762

a few of the threads that i could find, i had a longer list but your forum is so broken, it does not even allow me to post multiple links (yea i know its a prevention mechanism but its crap)

Tracked at ASAP: HEADER/FOOTER Language/Locale Setting Collabora/CODE Calc Documents xslx etc (nextcloud folder view -> right click -> save as pdf) · Issue #12773 · CollaboraOnline/online · GitHub