ONLYOFFICE
Spreadsheet: Date formats "ddd" and "dddd" are incompletely supported
Do you want to request a feature or report a bug? A Bug (unsupported standard feature)
What is the current behavior?
- Formats "ddd" and "dddd" are supported in imported files, but cannot be set as a format within OnlyOffice
- "ddd" and "dddd" are also unsupported in the "TEXT()" function: Both cause the format string to be displayed rather than the formatted date
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.
What is the expected behavior?
- ddd and dddd should be usable in custom date formats, and possibly incorporated in the standard date formats
- =TEXT("16/3/2022","ddd") should display "Wed", =TEXT("16/3/2022","dddd") should display "Wednesday" (depending on locale)
Did this work in previous versions of DocumentServer? Not that I know of
DocumentServer version: 7.0.0
Operating System: Linux
Browser version: Firefox 91.6
UPDATE: It appears that while my system locale is english, and the OnlyOffice interface is in english, the date formats being used after importing an external file with "ddd"/"dddd" date formats, are "jjj"/"jjjj", and the formatted dates are displaying in french.
"jjj"/"jjjj" also work in the TEXT() function, but are not converted from "ddd"/"dddd" on import.
This conversion and locale-dependency seems very strange indeed.
Hello, @jonathanwin! Thank you for report.
Please check your regional settings in the spreedsheet editor. They are located: File -> Advanced Settings -> Regional Settings. Select: English (United States) and apply the settings. This have to fix the issue with displaying dates in French.
I think first problem is that when the file is opened, there is no automatic recalculation. This is a known issue. We discuss it with our team in issue 51178 in our private issue tracker.
Right now you can use the "Calculation" option on the "Formula" tab. Then the values will be displayed correctly (see screenshot).
