Apache OpenOffice (AOO) Bugzilla – Issue 78833
Adding Japanese specific localized sort list 「睦月,如月,弥生,卯月,皐月,水無月,文月,葉月,長月,神無月,霜月,師走」
Last modified: 2017-05-20 11:31:34 UTC
"localized sort list" often used in Japanese is not included in Calc. Kanji besides English is used when exemplifying it on a day of the week. And, "localized sort list" is desirable for japanese to be incorporated by default. I made only Japanese patch because I understood only Japanese. However, it is very easy to add Sort List of other languages. And, it might be significant for people of other languages, too.
Created attachment 46209 [details] Screen Shot of localized Sort List(Japanese)
Created attachment 46210 [details] patch of localized Sort List(Japanese)
This is the wrong approach. The SortList entries are generated when they are first needed by the Calc spreadsheet application, depending on the locale the application runs in, using the day and month names of the locale data elements <LC_CALENDAR><Calendar>, for Japanese the data is in i18npool/source/localedata/data/ja_JP.xml and for MS-Excel compatibility has English names for the Gregorian calendar and Japanese names for the Gengou calendar. If you see only English names you probably started the application in an English locale and not a Japanese locale. To see Japanese names as well, quit all OOo applications including the QuickStarter, from <UserInstallation>/user/registry/data/org/openoffice/Office/Calc.xcu remove the SortList node, and restart the application in a Japanese locale.
Closing.
The reason that I added to Calc.xcu is that it wants to use it for AutoFill. Because I had thought that the entry in i18npool/source/localedata/data/ja_JP.xml was the list for the calendar, it was thought that the list for AutoFill did not have to be added. Could you tell me if there is a file that should add the list for AutoFill? If you tell me, I want to correct it.
There is only one list. AutoFill uses the SortList entries.
curvirgo: thanks a lot!
If the SortList entry is used for AutoFill, I think that my approach is no wrong. Because the SortList is added to <HomeDir>/user/registry/data/org/openoffice/Office/Calc.xcu when the user add new entry, I think that standard SortList should be <InstallDir>/share/registry/data/org/openoffice/Office/Calc.xcu. Still, do you think that my approach is wrong? Should I add it to the element of i18npool/source/localedata/data/ja_JP.xml?
Curvirgo, Please read my description in http://www.openoffice.org/issues/show_bug.cgi?id=78833#desc4 again. The SortList is _generated_ from the locale data for the locale the Office is started in, as long as no SortList entries are stored in the user configuration. Of course, if the user modifies or adds SortList entries the entries are written to <HomeDir>/user/registry/data/org/openoffice/Office/Calc.xcu. And no, no SortList should be present as default in <InstallDir>/share/registry/data/org/openoffice/Office/Calc.xcu because then the initial list would not be generated from the locale data anymore. Again: if you do not see Japanese day and month names and the user configuration has a SortList node, it is probably because you started the application in a different locale and added SortList entries.
It seems both misunderstand both :) I wanted to propose that I should add the following entries to SortList(Japanese localized data) used for AutoFill because these are frequently used. Nine new entries for japanese SortList: 日,月,火,水,木,金,土 (日),(月),(火),(水),(木),(金),(土) 1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月 睦月,如月,弥生,卯月,皐月,水無月,文月,葉月,長月,神無月,霜月,師走 第1四半期,第2四半期,第3四半期,第4四半期 第1四半期,第2四半期,第3四半期,第4四半期 子,丑,寅,卯,辰,巳,午,未,申,酉,戌,亥 子年,丑年,寅年,卯年,辰年,巳年,午年,未年,申年,酉年,戌年,亥年 甲,乙,丙,丁,戊,己,庚,辛,壬,癸 This patch preserves japanese localized SortList in "<InstallDir>/share/registry/res/ja/org/openoffice/Office/Calc.xcu". The directory where localized Calc.xcu is put is not "<InstallDir>/share/registry/data/org/openoffice/Office/". Therefore, this patch doesn't make a change to "<InstallDir>/share/registry/data/org/openoffice/Office/Calc.xcu".
Created attachment 46281 [details] This screen shot is a state before changing.
Created attachment 46283 [details] This screen shot is a state after it changes.
Created attachment 46286 [details] This screen shot is the SortList of Microsoft Excel.
Created attachment 46287 [details] This screen shot shows the position in which "localized SortList" is put.
Created attachment 46288 [details] This screen shot is a content of original SortList.
Created attachment 46289 [details] This screen shot is a content of localized SortList.
reopen...
*** Issue 79406 has been marked as a duplicate of this issue. ***
Please note that making the configuration entry localizable in this manner is not what we want. It breaks the dynamic mechanism we currently have. Maybe we can find a way to add this to i18npool's locale data instead. Please elaborate for each of the 9 lists what exactly they are. All entries seem to be related to names of days of week, names of months and names of eras, except the last list that has only 10 entries.
I arranged nine lists each kind. = names of days of week = 1. 日,月,火,水,木,金,土 2. (日),(月),(火),(水),(木),(金),(土) = names of months = 3. 1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月 4. 睦月,如月,弥生,卯月,皐月,水無月,文月,葉月,長月,神無月,霜月,師走 = names of quarter = 5. 第1四半期,第2四半期,第3四半期,第4四半期 6. 第1四半期,第2四半期,第3四半期,第4四半期 Numeric character of "6." is ASCII character, however "5." is not ASCII character. = names of oriental zodiac = <十二支(ju-nishi)> 7. 子,丑,寅,卯,辰,巳,午,未,申,酉,戌,亥 8. 子年,丑年,寅年,卯年,辰年,巳年,午年,未年,申年,酉年,戌年,亥年 = names of oriental zodiac = <十干(jikkan)> 9. 甲,乙,丙,丁,戊,己,庚,辛,壬,癸 Ju-nishi and jikkan might be combined and be used. (Sample : this site is Japanese only) http://www.hana300.com/aaeto.html
er may know well about this: http://en.wikipedia.org/wiki/Chinese_Zodiac Hope this help :)
Because I want to understand my wrong approach, could you explain what kind of thing the dynamic mechanism is?
Here is a newest patch, and I believe this doesn't break your dynamic mechanism. I confirmed the following actions. 1. When user is customizing SortList, i18npool and "<InstallDir>/share/registry/res/<locale>/org/openoffice/Office/Calc.xcu" is not used and "<HomeDir>/user/registry/data/org/openoffice/Office/Calc.xcu" is used. 2. When user is not customizing SortList, i18npool is not used and "<InstallDir>/share/registry/res/<locale>/org/openoffice/Office/Calc.xcu" is used. 3. When user is not customizing SortList and the element of SortList doesn't exist in "<InstallDir>/share/registry/res/<locale>/org/openoffice/Office/Calc.xcu", i18npool is used. If this patch breaks the dynamic mechanism that you say, could you please explain more?
Created attachment 47163 [details] newest patch (for SRC680_m221)
Created attachment 47164 [details] Japanese localize data (for SRC680_m221)
There was a similar request in Korean community. A user wanted to have a sort list item '甲子, 乙丑, 丙寅...' for AutoFill, which is supported in Excel. It is possible to add such items by manually editing Sort List, but it would be nice to have a way to make them available to default installation.
Reset assigne to the default "issues@openoffice.apache.org".