Far-East Date Formats
Submitted by Steven Lai
Link to original bug (#529361)
Description
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
Version: git master