Issue 119454

Summary: [From Symphony] Spreadsheet does not recognize "date" format for cells in Formula Input line in imported .xls.
Product: Calc Reporter: binguo <binbjguo>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: bjdujing, doneyourself, rb.henschel, shanzhu33
Version: 3.4.0 Beta (OOo)Keywords: ms_interoperability
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 121014    
Attachments:
Description Flags
sample file can repro this bug
none
capture.png none

Description binguo 2012-05-28 09:21:59 UTC 
Created attachment 77638 [details]
sample file can repro this bug

Steps:
1. Open attached xls file in AOO.
2. Check the the second column contain dates in DD.MM.YY format and cells in this column displayed properly.
3. Check the Formula Input Line value.

Defect:
Formula Input Line show another value, not data value.
Comment 1 Du Jing 2012-07-17 08:50:06 UTC 
confirmed,change its status
Comment 2 Regina Henschel 2012-07-17 09:25:47 UTC 
I do not consider this a bug. The cell has a user defined format "TT.MM.JJ;@" (German here). Notice the additional ";@". With this addition it is not a date format.
Comment 3 liuping 2012-07-24 03:04:49 UTC 
verify AOO3.4-1359641
Open xls in MS2010, the format cell category is Date, but not date value in AOO , so i think it is defect 
refer the capture.png
Comment 4 liuping 2012-07-24 03:05:50 UTC 
Created attachment 78712 [details]
capture.png