Issue 23328 - Spreadsheet converting text to dates
Summary: Spreadsheet converting text to dates
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P1 (highest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-09 02:29 UTC by memyselfi
Modified: 2008-04-11 08:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 memyselfi 2003-12-09 02:29:55 UTC 
MS Excel has this nasty habit of converting certain strings of text into dates. 
OOo, prior to 1.1 handled, handled this problem quite well by treating these 
strings as strings. However, in 1.1, OOo imitates Excel and converts strings to 
dates. AAAARRRRRRRRRGH!!!!!!!!!!!!!!

e.g. 04-3-5023 is a product code. OOo 1.1 converts it to 4/03/23 (like Excel).
Comment 1 frank 2003-12-09 10:01:14 UTC 
Hi,

as we do it like Excel and Excel compatibility is one of the Keyfeatures of OOo,
this is not a bug.

Also Prio 1 is much to high. Prio 1 stands for a totally broken Application, and
this is clearly not the case.

To solve your problem, just place a single quote in front of the part number.
This is the sign that Calc should treat the following numbers as text.

Frank
Comment 2 frank 2003-12-09 10:03:32 UTC 
closed wf
Comment 3 frank 2003-12-10 10:22:10 UTC 
Hi,

to make yourseld familiar with the Priority settings, just click on the Blue
Priority Link next to the drop down box.

Grrrr, checked it now and found that the opening window does not contain any
text. Have to file an Issue for that.

Just try it at another time.

Frank

PS. Issue 23387 is the missing text bug.
Comment 4 mfrasca 2008-04-11 08:12:41 UTC 
if you stumble on this issue, you might want to check
http://www.openoffice.org/issues/show_bug.cgi?id=87999
(which is still open) and vote for it.