You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/05/28 11:21:59 UTC
[Bug 119454] New: [From Symphony] Spreadsheet does not recognize
"date" format for cells in Formula Input line in imported .xls.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
Priority: P3
Bug ID: 119454
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported
.xls.
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: binbjguo@gmail.com
Hardware: PC
Status: UNCONFIRMED
Version: OOo 3.4 Beta
Component: open-import
Product: spreadsheet
Created attachment 77638
--> https://issues.apache.org/ooo/attachment.cgi?id=77638&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |121014
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
--- Comment #4 from liupingtan <do...@gmail.com> ---
Created attachment 78712
--> https://issues.apache.org/ooo/attachment.cgi?id=78712&action=edit
capture.png
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
Du Jing <bj...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |bjdujing@gmail.com
Ever confirmed|0 |1
--- Comment #1 from Du Jing <bj...@gmail.com> ---
confirmed,change its status
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #2 from Regina Henschel <rb...@t-online.de> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
Shan Zhu <sh...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |ms_interoperability
CC| |shanzhu33@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 119454] [From Symphony] Spreadsheet does not recognize "date"
format for cells in Formula Input line in imported .xls.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=119454
liupingtan <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |doneyourself@gmail.com
--- Comment #3 from liupingtan <do...@gmail.com> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.