Import Drops Unrecognized Date Format String
Submitted by Steven Lai
Link to original bug (#529362)
Description
Please describe the problem:
After importing an xls spreadsheet, certain date format string that is not recognized by gnumeric is lost.
Steps to reproduce:
In Excel, set A1 = "3/1/2007 12:00:00 AM" set A1 number format to 上午/下午h"時"mm"分"
It is displayed as "上午12時00分" in Excel
Actual results: Open in gnumeric, A1 becomes 39142, and the number format of the cell is dropped
Expected results: number format string kept, even it doesn't recognize the format string
Does this happen every time? yes, for this case but it appears that not every unrecognized case hits this problem
Other information:
Version: 1.8.x