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 2013/12/15 11:03:57 UTC

[Bug 100530] Wrong Conversion of ips, dots are deleted

https://issues.apache.org/ooo/show_bug.cgi?id=100530

ghia <ge...@ghia.eu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gerard@ghia.eu

--- Comment #6 from ghia <ge...@ghia.eu> ---
I still have the problem:

When copy/paste an IP address from a html or text document to Calc, the dots
disappear.
Eg  
- copy 75.125.255.255 from a document eg FireFox, Notepad
- paste into cell A1
- result is 75125255255
- expected 75.125.255.255

Most IP adresses do paste correctly, eg.
87.99.64.0
66.235.222.10
75.125.0.0
85.249.176.0
64.92.160.0
60.31.0.0
201.54.128.0
86.57.202.0
86.57.204.0
80.227.0.0
85.255.112.0

However also a lot don't, resulting in:
46105114127 (should be 46.105.114.127)
61145121117 (etc.)
61145121118
61145121120
61145121124
61145121126
77247181160
82144220224
82195246192
82195246192
85251106128
85251106192
85251106200
85251106204
89187131128
91121167140
93167194248
94142128128
108171248250
135196106144
188207200112
195113214192
195127173128
208115111240
213131246192
213199218192
213239236128
217144240244
217144240248
220189228144
222170106200
98247255255
98255255255
99127255255
99191255255
99198127255
99255255255
101231255255
108171248250
108171255255
108178255255
109111191255
109120191255

It seems that mosttimes IP addresses ending on .0 are pasted correctly.
The error seems in general with non-zero parts at the end.
But also a lot paste correct eg:
95.79.199.255
95.79.31.255
95.79.47.255
95.79.67.255
95.79.87.255
95.81.63.255
96.39.255.255
96.41.255.255
96.42.255.255
96.47.239.255
97.74.255.255
97.95.255.255
98.31.255.255
99.63.255.255
99.95.255.255

The origin of the IP address data is an IP block list from cPanel, which I
tried to sort with Calc. But it does not matter if an IP is copied from an HTML
document or a text document as eg Notepad or ooo Writer.

AOO400m3(Build:9702)  -  Rev. 1503704
2013-07-16 14:54:56 (Di, 16 Jul 2013)
PC Win7

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.