Error in the formula Text ()

User Support
1

Hello, I have in Libreoffice A table created with the formula=Text(c4;"dd.mm.yyyy) This works too. But not in collabora. There is dd.12…yyyy

2

hii @Joehosch

Check Locale Settings in Collabora:

Collabora Online may be using a different locale setting, which can affect date formatting.

Go to Settings → Locale and make sure the locale is set correctly (e.g., en-US or de-DE depending on your region).

Use Correct Formula Syntax: Try adjusting the formula slightly:

=TEXT(C4, "DD.MM.YYYY")

Make sure that the format string uses uppercase DD for day, MM for month, and YYYY for year, as Collabora might have stricter interpretation of date formatting compared to LibreOffice.

thanks,
Darshan