Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

Support for Chinese date formats

Desktop editors
,
#1

Suggest a feature
For feature suggestions, describe the result you would like to achieve in detail.
In MS Excel and WPS, Ability to automatically identify Chinese date formats, like 4月9日. Automatically recognized as a custom format, like m"月"d"日 or yyyy"年"m"月"d"日", and so on.
If you open such an xlsx file in spreadsheet, Such a date format will be displayed as a normal number. For example, 4月9日will be displayed as 44660.

OS version: linux, windows
App version: 6, 7
Downloaded from: ONLYOFFICE website / Other (specify)

#2

Hello @jyjyjin
Could you please provide us with an example of xlsx file which correctly works with Chinese date format in MS Excel? We will check it out and discuss internally.

#3

Hello @Alexandre
Ok. I uploaded a example file using wetransfer.com. This is the download link: WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free

#4

Hello @jyjyjin
Thank you for provided file. We added your request to internal tracklist (internal number - 38377). We have started working on it.

#5

okay thank you.

#6

Good day! Glad to inform you that the issue has been addressed in the newest version of Document Server!

#7

okay thank you so much.

#8

Hello @Dmitry
I downloaded the latest version, tested it, and found that the issue was not resolved. I took a screenshot in wps, please look at it again. Thank you.

screenshot_in_wps
screenshot_in_wps833×824 78 KB

screenshot_in_onlyoffice
screenshot_in_onlyoffice765×357 12.8 KB

#9

Hello @jyjyjin
Please accept our sincere apologies. We have informed you incorrectly. The fix for mentioned situation will be placed in v.7.2 which will be release this summer.
Sorry for inconvenience. We will update this post when v.7.2 released.

#10

Ok. Thank you.

#11

Hello @jyjyjin
We just released Desktop Editors v.7.2 which includes a fix for described situation. Please run the update process and check the result.