# How to set default language for all Collabora/Nextcloud Office files?

**URL:** <https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762>\
**Category:** 📑 How to\
**Tags:** collabora-online, nextcloud-office\
**Created:** [July 26, 2022, 11:53pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762 "2022-07-26T23:53:50Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [July 26, 2022, 11:53pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/1 "2022-07-26T23:53:50Z")

</div>

We are using Australian English on our Nextcloud instance. We’ve got the following in our config.php:

```auto
        "default_phone_region": "AU",
        "default_locale": "en_AU",
        "force_locale": "en_AU",
        "default_language": "en",
        "force_language": "en",

```

It works great. However, Collabora doesn’t seem to follow this, nor is the AU language even available. It always defaults to American English:

 ![lang](https://help.nextcloud.com/uploads/default/original/3X/d/e/de7aaa8c244ee1690167ee772340b8958d9a491e.png)\

But we could use UK English in the interim.

So, how do I tell Collabora to always use UK English by default though, for everything? (i.e. all newly created files, whether templates or not)?

And as an aside, is there a possibility Australian English will be available in Collabora in future?

Thanks,  
E

---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [July 27, 2022, 8:20am UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/2 "2022-07-27T08:20:17Z")

</div>

I think your question is better placed in [https://forum.collaboraonline.com/](https://forum.collaboraonline.com/)

Shortly the was similar question:

> **[Collabora CODE (with seafile) default language](https://forum.collaboraonline.com/t/collabora-code-with-seafile-default-language/1163)**
>
> Hi there, I’m using seafile and collabora together in dockers on my raspberry pi 4 and it’s working great. One problem though, I can’t seem to set the default language for my documents (spreadsheets specifically) so all the dates appear in the...

you can control available dictionaries within Collabora config \> [Allowed dictionary languages](https://sdk.collaboraonline.com/docs/installation/Configuration.html#allowed-dictionary-languages)

But most likely the language come from the template file you use to create your documents. So adopting Office template files should do the trick - for existing documents you will need to change the language manually…

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [July 27, 2022, 12:20pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/3 "2022-07-27T12:20:11Z")

</div>

Hi there, thanks for the answer and for that link. Unfortunately it’s not quite an answer I think. It mentions setting an environment variable with Docker that didn’t work for the OP, and we’re not using Docker anyway. We’re using the `Collabora Online - Built-in CODE Server` and `Nextcloud Office` apps bundled with Nextcloud.

Apologies, I should’ve been more clear.

Anyway, one option then. Where are the files that Collabora/Nextcloud Office apps uses as blanks? For example, with OnlyOffice and Nextcloud we could hack the core files in `/var/www/nextcloud/apps/onlyoffice/assets/en-US/` (such as `new.docx` for example) to save over a version of that blank file with the dictionary already set to Australian English, which would be used as a new file for all users by default. Nextcloud would complain about file integrity check failing, and it wasn’t a good solution since the files always got wiped out after every update, but it was something to get the behaviour we want.

I understand users can have individual templates (but only if they set them up in their user account), so I’m wanting a solution where we can force the language globally, like we have with Nextcloud settings for everything else as posted above (and also so it’s not dependent on the user having to set their own templates—i.e. we want all new docs to be created in Australian or UK English regardless of whether a user has templates set or not). Does that make sense?

Hacking core files isn’t the best, but if there’s no config setting, a similar solution for Collabora/Nextcloud Office would work in the meantime while the software matures?

But I hope there’s a config setting or something else I can do, if someone knows how!

Thanks,  
E

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [July 27, 2022, 12:27pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/4 "2022-07-27T12:27:28Z")

</div>

Oh, I should also provide more detail about versions:

Collabora Online - Built-in CODE Server  
22.5.401

Nextcloud Office  
6.1.1

and we’re using Nextcloud 24.0.3.

Thanks!

---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [July 28, 2022, 8:23pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/5 "2022-07-28T20:23:21Z")

</div>

> [@esxpfe](#):
>
> Unfortunately it’s not quite an answer I think.

I know this is not the **exact answer**. The idea was to point you into right direction. This forum is run by unpaid enthusiasts - don’t expect somebody else will solve your **really specific** issue… folks here are happy to help, but **you** have to go the last mile to solve the problem (and hopefully report the solution)…

> [@esxpfe](#):
>
> globally

visiting **Settings \> Office** as admin user you will find this setting - is likely what you are looking for

 ![image](https://help.nextcloud.com/uploads/default/original/3X/f/7/f7c3dd626f51a173283c3f600a37dae7c92366ba.png)

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [July 29, 2022, 3:04am UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/6 "2022-07-29T03:04:09Z")

</div>

Oh please don’t get me wrong, I’m here for the same reasons and I appreciate your answer. 😃

I tried adding a in `Settings > Office` called “New.docx” that contained all the default settings we’d like, but we got this error message:

“… Only template files can be uploaded.”

 ![OfficeSettingsError](https://help.nextcloud.com/uploads/default/original/3X/3/2/32a1685185d83665c0ba69c6e94c148c29e43143.png)

Any ideas on how I make a template file inside Nextcloud with the Collabora settings we want?

Thanks!  
E

---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [July 29, 2022, 9:21am UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/7 "2022-07-29T09:21:24Z")

</div>

I’m sorry I have the feeling you are kidding…  
.docx is **not** a template and definitely not a Collabora format…

Create a _template_ file with LibreOffice Writer and upload it:

![image](https://help.nextcloud.com/uploads/default/original/3X/3/9/3997f6070e8bb7132cbe3c0763642cf650a49349.png)

then you can choose this template when creating new text document (and follows the language you defined there):

![image](https://help.nextcloud.com/uploads/default/original/3X/6/d/6d823c560a9538b8f89deede8d4cdebd95239044.png)

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [July 29, 2022, 8:26pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/8 "2022-07-29T20:26:58Z")

</div>

Aha, thank you for that. 🙂 We are getting close to solution. I didn’t realise external tools (LibreOffice) were needed and that only OTT files could be used, even though we are using the OOXML option turned on:

 ![Screenshot from 2022-07-30 06-22-44](https://help.nextcloud.com/uploads/default/original/3X/a/2/a21f0ba876ba01ae72ece28d305e8bde9bd4b424.png)

The problem now is that I created `Blank.ott` to overwrite the default “Blank” template (with our desired always-default language settings, etc), but it didn’t take. Instead we have option for “Blank” _and_ the “Blank” template. Is this a bug now I wonder?

![Screenshot from 2022-07-30 05-57-29](https://help.nextcloud.com/uploads/default/original/3X/e/6/e69ad878cb78ae61c5fff3ecc9b38fe2d53e61f9.png)

The same problem also occurs if I try creating a `Blank.dotx` using LibreOffice also.

Thanks,  
E

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [August 1, 2022, 11:48am UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/9 "2022-08-01T11:48:32Z")

</div>

I’ve also found [this post](https://help.nextcloud.com/t/default-blank-templates-changed-but-not-changed/142137) and also tried doing what they did (which is what [this documentation](https://collabora-online-for-nextcloud.readthedocs.io/en/latest/templates/) says) and replacing `document.ott` with our desired template in `appdata_[instanceid]/richdocuments/empty_templates/` but that didn’t work either unfortunately…

---

<div class="post-metadata">

**Author:** ![esxpfe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/esxpfe/32/40543_2.png) [@esxpfe](https://help.nextcloud.com/u/esxpfe)\
**Post date:** [September 13, 2022, 3:58pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/10 "2022-09-13T15:58:25Z")

</div>

This is a bug, have opened an issue:

> <https://github.com/nextcloud/richdocuments/issues/2430>
>
> \*\*Describe the bug\*\*
> Can't overwrite \`Blank\` template in \`Settings \> Office\` \> …\`Global Templates\`, nor \`appdata\_\[instanceid\]/richdocuments/empty\_templates/\`
> 
> I tried adding a \`Blank.ott\` in \`Settings \> Office\` \> \`Global Templates\` which appears as a template but does not overwrite the default. "Blank" still appears, as well as our desired "Blank":
> 
> !\[e69ad878cb78ae61c5fff3ecc9b38fe2d53e61f9\](https://user-images.githubusercontent.com/1122344/182638324-e18304ce-608b-4d3d-9edd-ebb01adf05a2.png)
> 
> After searching, I found the \[Collabora documentation\](https://collabora-online-for-nextcloud.readthedocs.io/en/latest/templates/) which states to replace \`document.ott\` with our desired template in \`appdata\_\[instanceid\]/richdocuments/empty\_templates/\` but that didn’t work either unfortunately. The \`Blank\` template does not overwrite the default.
> 
> We are using Collabora Online - Built-in CODE Server version 22.5.401 and Nextcloud Office 6.1.1 on Nextcloud 24.0.3.
> 
> We are also using this setting ticked in \`Settings\` \> \`Office\` \> \`Advanced Settings\` to use Open XML and hence DOTX template, but I also tried OTT file and that didn't work either.
> !\[Capture\](https://user-images.githubusercontent.com/1122344/189106443-b578ea27-6367-46c4-b7f4-e6109f64e9e2.PNG)
> 
> \*\*Expected behavior\*\*
> To be able to replace \`Blank\` template in \`Settings \> Office\` \> \`Global Templates\`
> 
> \## Server details
> 
> \*\*Operating system\*\*:
> Ubuntu 20.04.4 LTS
> 
> \*\*Web server:\*\*
> nginx/1.18.0
> 
> \*\*Database:\*\*
> psql (PostgreSQL) 12.11
> 
> \*\*PHP version:\*\*
> PHP 8.0.14 (cli) (built: Dec 20 2021 21:22:38)
> 
> \*\*Nextcloud version:\*\*
> 24.0.3
> 
> \*\*Version of the richdocuments app\*\*
> Nextcloud Office 6.2.0
> 
> \*\*Version of Collabora Online\*\*
> Collabora Online - Built-in CODE Server 22.5.502
> 
> \<details\>
> \<summary\>Logs\</summary\>
> 
> \#### Nextcloud log (data/nextcloud.log)
> \`\`\`
> {"reqId":"vqtPs3nOafJSNdaJEhZk","level":3,"time":"2022-08-11T08:15:02+10:00","remoteAddr":"","user":"--","app":"integration\_whiteboard","method":"","url":"--","message":"\[ERROR\] Spacedeck is unreachable, it might not be running. cURL error 7: Failed to connect to localhost port 9666: Connection refused (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for http://localhost:9666/api/spaces","userAgent":"--","version":"24.0.3.2","data":{"app":"integration\_whiteboard"},"id":"62f43b11ef294"}
> \`\`\`
> \</details\>

---

<div class="post-metadata">

**Author:** ![Jelle\_van\_der\_Pal](https://help.nextcloud.com/user_avatar/help.nextcloud.com/jelle_van_der_pal/32/69871_2.png) [@Jelle\_van\_der\_Pal](https://help.nextcloud.com/u/Jelle_van_der_Pal)\
**Post date:** [March 11, 2025, 2:15pm UTC](https://help.nextcloud.com/t/how-to-set-default-language-for-all-collabora-nextcloud-office-files/142762/11 "2025-03-11T14:15:02Z")

</div>

YES! This is what I was looking for - way to long now. Suddenly my localisation had dissapeared following a recent update, but this fixed it. Thanks!
