Issue 119454 - [From Symphony] Spreadsheet does not recognize "date" format for cells in Formula Input line in imported .xls.
Summary: [From Symphony] Spreadsheet does not recognize "date" format for cells in For...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks: 121014
  Show dependency tree
 
Reported: 2012-05-28 09:21 UTC by binguo
Modified: 2012-09-18 06:48 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample file can repro this bug (14.50 KB, application/octet-stream)
2012-05-28 09:21 UTC, binguo 		no flags Details
capture.png (268.84 KB, image/png)
2012-07-24 03:05 UTC, liuping 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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