Bug 125035 - Date format in Base is wrong.(zh-CN version)
Summary: Date format in Base is wrong.(zh-CN version)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: CJK-Chinese-Simplified
  Show dependency treegraph
Reported: 2019-04-30 04:20 UTC by yichuang驿窗
Modified: 2019-06-28 17:09 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

screenshot : week displays error (132.95 KB, image/png)
2019-05-10 00:22 UTC, yichuang驿窗
screenshot: week display problem (21.06 KB, image/png)
2019-05-10 00:50 UTC, yichuang驿窗
screenshot : another week displays error (112.24 KB, image/png)
2019-05-10 00:55 UTC, yichuang驿窗

Note You need to log in before you can comment on or make changes to this bug.
Description yichuang驿窗 2019-04-30 04:20:30 UTC
Date format in Base is wrong Date format in Base is wrong:
  User interface: Chinese (simplified)
  Local setting: Chinese (simplified)
System Env:
  Debian Stretch 9.8/Gnome/LibreOffice

Steps to Reproduce:
1.Open Base, create a new database (Firebird Embedded), then click create Form in Design View; 
2.On the form controls bar left, select Date Field, draw a date field in the form; 
3.Double click the date field, set "Date format" to "Standard(long)" and "Dropdown" to "Yes"; 
4. Save the form;
5. Open the form, select a date; 
6. Now you can find that two "month" displayed and without "date", it's wrong. 

Actual Results:
two "month" displayed and without "date" displayed.

Expected Results:
1. One month displayed;
2. One date displayed;
3; The week is shown at the end

Reproducible: Always

User Profile Reset: Yes

Additional Info:
I don't know how to upload a screetshot within this bugs-report-system, so, I upload the screenshot here:


The wrong format appeared only in zh-CN-Chinese (simplified) version, in English verion the format is OK.
Comment 1 yichuang驿窗 2019-05-10 00:22:04 UTC Comment hidden (obsolete)
Comment 2 yichuang驿窗 2019-05-10 00:50:45 UTC
Created attachment 151280 [details]
screenshot: week display problem

Week display error
Comment 3 yichuang驿窗 2019-05-10 00:55:54 UTC
Created attachment 151281 [details]
screenshot : another week displays error

In version of master 6.3 (2019-05-04_04.44.35), this problem can be reproduced.

Necessary conditions for recurring problems(Language options in LibreOffice):
1-User interface: Chinese(simplified)
2-Locale setting: Chinese(simplified)

My operating system:
Debian Stretch 9.8/Gnome
Comment 4 Ming Hua 2019-05-10 07:48:11 UTC
(In reply to yichuang驿窗 from comment #2)
> Created attachment 151280 [details]
> screenshot: week display problem

I think this should be reported as a different bug.
我觉得这个问题另行报告一个新的 bug 为好。

Also, why did you set the assignee of the bug to yourself?  It usually means you are working on fixing this bug.
还有就是你为什么把这个 bug 的 Assignee 设成你自己了?一般只有开发者在自己打算修复这个 bug 时才会这样做。
Comment 5 yichuang驿窗 2019-05-12 01:28:45 UTC
Thanks for your tips~  I will resubmit as a new bug later.
谢谢提示~  后面我会作为新bug重新提交;

I don't know about the setting of Assignee; if it's not your prompt, I may never notice it; I think it should be caused by misuse, because too little use here, the settings are not familiar. I will pay more attention to such problems in the follow-up.
关于 Assignee 的设置,我并不清楚;如果不是你提示的话,我可能永远也注意不到;我想应该是误操作造成的,因为太少使用这里,各种设置都不太熟;我会慢慢改进,提高后续bug的提交效率。
Comment 6 Ming Hua 2019-06-03 08:52:42 UTC
I can reproduce the bug described in attachment 151281 [details] with 6.3.0 Alpha1 on Windows 10.

Also that erroreous translation doesn't come from LO l10n team as there is no KeyID associated with it.  From the discussion in the Chinese LO user group (with one of the translators), nobody seems to know exactly from where it comes.
Comment 7 yichuang驿窗 2019-06-09 01:06:26 UTC
I just set the assignee to the default because I have no ability to fix this problem myself.
Comment 8 Kevin Suo 2019-06-23 08:01:37 UTC
I can reproduce on master. Set to NEW.
Could some dev people give some tips where the stings as shown on the screenshots are located?
Comment 9 Kevin Suo 2019-06-23 08:11:14 UTC
The locale data data seems to be correct:
Comment 10 Xisco Faulí 2019-06-28 12:53:45 UTC
(In reply to Kevin Suo from comment #8)
> I can reproduce on master. Set to NEW.
> Could some dev people give some tips where the stings as shown on the
> screenshots are located?

@Eike, do you have any idea where it's located ?
Comment 11 Eike Rathke 2019-06-28 17:09:15 UTC
No adhoc idea. As locale data was mentioned to be correct, either some Base routine assembles an own date format code, in which case setting a breakpoint on SvNumberFormatter::GetOutputString() could help to trace up from where in Base it is called (if so then likely through SvNumberFormatterServiceObj and not directly); or Firebird has its own notion of date formats, either built-in or maybe through ICU. Also I'm puzzled what calendar widget in the first screenshot that actually is.