Issue 25073 - IP-address error in cell
Summary: IP-address error in cell
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-04 15:53 UTC by lpiepho
Modified: 2004-02-05 09:30 UTC (History)
1 user (show)

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

Attachments
example (5.50 KB, application/vnd.sun.xml.calc)
2004-02-04 15:55 UTC, lpiepho 		no flags Details
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 lpiepho 2004-02-04 15:54:00 UTC 
Typing an IP-address like 192.168.100.99 into a cell works perfectly, but
IP-addresses with three digits at the end get wrecked. Example:
192.168.100.100 becomes 192168100100
The cell properties are not changed, both numbers are standard numbers. Changing
the regioncode doesn't work either.
Comment 1 lpiepho 2004-02-04 15:55:42 UTC 
Created attachment 12883 [details]
example
Comment 2 frank 2004-02-05 09:30:00 UTC 
hi,

this is not a bug.

The thousands seperator in your locale is a point, am I right ?

So the last triplet is recognized as another thousand if the last set has three
numbers. If it has only two numbers in the last triplet, it is no valid number
and therefore converts to text.

If you need your IP's as numbers, just set the numberformat for the cell to
something showing no decimal places and thousands separators.

Frank
Comment 3 frank 2004-02-05 09:30:25 UTC 
closed invalid