Issue 25076 - Find/Replace formatting version numbers as dates.
Summary: Find/Replace formatting version numbers as dates.
Status: CLOSED DUPLICATE of issue 22345
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-04 17:16 UTC by glenns30
Modified: 2004-02-05 09:37 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 glenns30 2004-02-04 17:16:38 UTC 
I was using the spreadsheet's find/replace action to change all cells of a
specific column that contained x in the cell to 6.1.100 . I said to replace all.
Only that column and only cells with x were changed, but they appear to have
been changed to a date format. For example, they had 06/01/00 in the cell,
instead of 6.1.100 .. I checked the cell formats, and they are formatted as a
number not a date. Don't know why this happens.
Comment 1 frank 2004-02-05 09:37:29 UTC 
Hi,

this is not a bug.

This is the number recognition from Calc. The number you entered is recognized
as a date and therefore displayed as such. There are other Issues that cover
this. Simply placing an apostrophe " ' " in front of the number making this a
text will solve your problem.

Frank

*** This issue has been marked as a duplicate of 22345 ***
Comment 2 frank 2004-02-05 09:37:59 UTC 
closed double