Download it now!
Bug 113184 - Minguo (ROC) calendar year identification support for zh_TW locale
Summary: Minguo (ROC) calendar year identification support for zh_TW locale
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CJK CJK-Chinese-Traditional
  Show dependency treegraph
 
Reported: 2017-10-17 14:03 UTC by Cheng-Chia Tseng
Modified: 2019-12-05 12:57 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Cheng-Chia Tseng 2017-10-17 14:03:44 UTC
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.
Comment 1 Franklin Weng 2017-10-17 14:56:23 UTC
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?
Comment 2 Cheng-Chia Tseng 2017-10-17 15:31:29 UTC
(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.
Comment 3 Franklin Weng 2019-06-22 12:44:08 UTC
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.
Comment 4 Eike Rathke 2019-06-27 11:42:40 UTC
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 ;-)
Comment 5 Heiko Tietze 2019-07-11 15:59:43 UTC
Assigned means no further input from UX is needed. Feel free to ask, Mark.
Comment 6 Xisco Faulí 2019-10-29 09:19:37 UTC
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 ?
Comment 7 Mark Hung 2019-12-05 12:57:43 UTC
Change to new and unassign myself because I was not sure about the design and didn't continue working on this.