After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 529361 - Far-East Date Formats
Far-East Date Formats
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: Main System
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-04-22 11:16 UTC by Steven Lai
Modified: 2018-05-22 13:26 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Steven Lai 2008-04-22 11:16:26 UTC 
Please describe the problem:

There were several case we came across

Here is one example:

In Excel, "ggge" refers to the Japanese style date system. Emperor name followed by the current year of the emperor's reign.


Steps to reproduce:


set A1 = 3/3/2007
set number format for AI to: [$-411]ggge"年"m"月"d"日";@

Actual results:

A1 becomes "2007年3月3日"

Expected results:

A1 becomes "平成19年3月3日"


Does this happen every time?


Other information:

FYI, there's a 3rd party patch that solves this problem for Japanese language, but it appears to be very old and unmaintained
Comment 1 Jody Goldberg 2008-04-22 12:57:04 UTC 
Known problem.  I requested more detail on how to interpret things as part of the MS OOXML process in ECMA TC45, but have not looked into writing the required code.
Comment 2 Morten Welinder 2009-03-05 19:56:02 UTC 
> FYI, there's a 3rd party patch that solves this problem for Japanese language,
> but it appears to be very old and unmaintained

Do you have a reference for that?
Comment 3 Andreas J. Guelzow 2010-01-14 18:05:12 UTC 
This is of course related to bug #529362
Comment 4 GNOME Infrastructure Team 2018-05-22 13:26:40 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/97.