LibreOffice supports Minguo year date formats such as GGGEE, GGEE, EE and E Minguo year. However, it does not identify Minguo year directly from the inputs of Taiwan people. The ruling government in Taiwan is the Republic of China (ROC) which was founded in 1912 in mainland China. 2017 is 民國106年 (Minguo year 106). (2017-1912+1) In general, people in Taiwan (zh_TW locale) use both systems in living. * 2 or 3 digits (such as 99 or 106) for Minguo year * 4 digits (such as 2017) for common era year The public servants in the government only use Minguo calendar. They input “106/10/11” intuitively for 2017/10/11, but LibreOffice identifies as “0106-10-11” by default. Reproducible: always Steps to reproduce: 1. Switch to zh_TW locale (Chinese (Traditional)). 2. Open Calc 3. Type 106/10/11 to present it is 2017/10/11 Actual result: 1. LibreOffice identifies the input as 0106-10-11 Expected result: 1. LibreOffice identifies the input as 2017-10-11 for zh_TW locale users.
The default format of date in a cell is YYYY/M/D and that is the reason why it showed 0106/10/11. This seems to be a UX improvement issue. Currently users using different calendar need to explicitly set date time format to their own. This issue can split into two parts: - If in CE calendar, should it showed 0106 when inputting the date 106/10/11? (YYYY) - Is it possible to set default date format with different locale?
(In reply to Franklin Weng from comment #1) > The default format of date in a cell is YYYY/M/D and that is the reason why > it showed 0106/10/11. This seems to be a UX improvement issue. Currently > users using different calendar need to explicitly set date time format to > their own. > > This issue can split into two parts: > > - If in CE calendar, should it showed 0106 when inputting the date > 106/10/11? (YYYY) > - Is it possible to set default date format with different locale? Maybe ODF specification has some definitions here. And I believe it should all set to common era year internally at least to make LibreOffice know which year it is. The main idea behind this bug report is that the identification to common era year can be enabled with Year (Two Digits), "Interpret as years between XXXX and 2029" in Options > LibreOffice > General. I mean, maybe we can also enable the same kind of setting by default for zh_TW locale to deal with the 2 or 3 digits for Minguo year and 4 digits for common era year.
Another user raised this issue on ask.libreoffice.org https://ask.libreoffice.org/zh-tw/question/197619/calc-ri-qi-min-guo-nian-yue-ri-de-chu-li-ru-he-zhuan-huan-wei-zheng-que-ge-shi/?comment=197853#post-id-197853 I marked NeedUXEval here. IMO it makes sense to show year number according to the cell format _AND_ locale settings.
As this just popped up on the ux-advise list: note that there is already work ongoing for this, see https://gerrit.libreoffice.org/73973 I'm assigning this bug to Mark for the time being (sorry for invading your space ;-)
Assigned means no further input from UX is needed. Feel free to ask, Mark.
Hi Mark Hung, You patch in https://gerrit.libreoffice.org/73973 is abandoned right now. Are you still working on this issue? @Eike, would you like to take over instead ?
Change to new and unassign myself because I was not sure about the design and didn't continue working on this.