Issue 3851 - Text cells passed to DATE function are interpreted as 0
Summary: Text cells passed to DATE function are interpreted as 0
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
: 16519 19089 25977 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-04-03 21:02 UTC by Unknown
Modified: 2005-10-27 11:30 UTC (History)
1 user (show)

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

Attachments
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 Unknown 2002-04-03 21:02:11 UTC 
If the DATE function is used with cells that are of type text, but have a text
representation of a number, the function interprets it as a zero instead of
attempting to convert the text to a number.  The cells must be modified after
they are set to be Text cells in order for the problem to show.
For example, with the following cells:
A1  3    (Number)
A2  16   (Number)
A3  2002 (Text)

The formula: =DATE($A3;$A1;$A2)
evaluates to:  3/16/00

The same spreadsheet in Excel gives:  3/16/02
Comment 1 peter.junge 2002-04-04 10:35:00 UTC 
Hi Chris,
this is no bug at all because OOo handles these datatypes very strict.
But I'll keep it as Feature/Remind because I see some issue related to
this strict handling myself.
Best regards, Peter
Comment 2 peter.junge 2002-04-04 12:01:07 UTC 
Just a reminder.
Comment 3 peter.junge 2003-02-10 17:18:42 UTC 
reopen
Comment 4 peter.junge 2003-02-10 17:21:57 UTC 
@Bettina: We had a lot of complaints about this behaviour in the time
while I kept it as reminder. Meanwhile I'm also convinced that do it
the same way excel does would have a lot of advantages.

Peter
Comment 5 daniel.rentz 2003-07-07 09:20:08 UTC 
*** Issue 16519 has been marked as a duplicate of this issue. ***
Comment 6 frank 2003-09-19 10:09:12 UTC 
*** Issue 19089 has been marked as a duplicate of this issue. ***
Comment 7 frank 2003-09-22 09:19:42 UTC 
*** Issue 19089 has been marked as a duplicate of this issue. ***
Comment 8 daniel.rentz 2004-03-26 17:22:09 UTC 
*** Issue 25977 has been marked as a duplicate of this issue. ***
Comment 9 ooo 2005-10-27 11:29:35 UTC 
This is nothing special to the DATE() function, it's the general text instead of
number issue.

*** This issue has been marked as a duplicate of 5658 ***
Comment 10 ooo 2005-10-27 11:30:11 UTC 
Closing dupe.