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...
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:
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: ---

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

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

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.

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]