CollaboraOnline locale follow Nextcloud language instead of Nextcloud locale

[maximelehericy]

Describe the bug
I use Collabora within a Nextcloud environment.
In Nextcloud, language is set to English (US), and locale to France (I am french :).

Therefore, french locale should apply when editing speadsheets. e.g: "," as separator between the integer part of a number and the fraction part.

However, when editing a ods file, numbers requires a "." as separator. Errors appears when those numbers are used with formulas, because number is interpreted as text.

Switching the language to french as below solve the issue.

To summarize, in Collabora, the locale settings follow the language defined in Nextcloud, instead of following the locale settings defined in Nextcloud.

To Reproduce
Steps to reproduce the behavior:

1. Set your Nextcloud locale to French and language to English
2. Open a spreadsheet in collabora online
3. In a cell, type =12,5+18,3
4. See error "err:509"
5. In your Nextcloud settings, set the language to French
6. Content of the cell has changed to =12;5+18;3
7. Replace ";" by ","
8. See the result of the formula

Expected behavior
Collabora langauage should follow Nextcloud language
Collabora locale should follow Nextcloud locale

Actual behavior
Collabora language follows Nextcloud language
Collabora locale follows Nextcloud language

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information)

• OS: [e.g. iOS] Windows 11
• Browser: [e.g. chrome, safari] Firefox
• Version: [e.g. 22] NC 24

Smartphone (please complete the following information)

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser: [e.g. stock browser, safari]
• Version: [e.g. 22]

Additional context
Add any other context about the problem here.

[alxrdn]

I can confirm this unexpected behaviour.

[alxrdn]

@maximelehericy did you find any workaround since then ?

I found this thread, but had no chance with these suggestions...
https://help.nextcloud.com/t/configure-locale-in-nextcloud-office-collabra-code-server/137717

[timur-g]

Thanks for a nice report. This is 2-part problem reported both in NextCloud issue 795 where resolved and in Collabora Online T40069 where set as Enhancement.

[alxrdn]

Hi @gitGT
thank you for your answer, nevertheless I'm not sure to understand the issue IDs you're referring to (eg nextcloud/server#795 doesn't relate).
Can you point us to issues URL so that we can monitor them / vote for them ?

[timur-g]

Hi. nextcloud/richdocuments#795 part was done.
Remaining part is in Collabora Productivity task system as T40069 , but that's not public.
Anyway, should it be done, as not trivial and requires a change of LOKit, this issue will be updated.

[Meimax]

Hi,
Since the last reply in this thread is now over two years old, and the internal task system is not public, I wanted to ask if there are any updates?