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/17 18:06:58 UTC

[Bug 123869] New: Pasting IP addresses, dots are sometimes deleted

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

            Bug ID: 123869
        Issue Type: DEFECT
           Summary: Pasting IP addresses, dots are sometimes deleted
           Product: Calc
           Version: 4.0.0
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: gerard@ghia.eu
                CC: issues@openoffice.apache.org

When copy/paste an IP address from a html or text document to Calc, the dots
disappear for some addresses.
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

I added a comment to https://issues.apache.org/ooo/show_bug.cgi?id=100530
but it seems not to be picked up, as there is AFAIK no way to change the status
of the bug or display lists with last added comments.

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

[Bug 123869] Pasting IP addresses, dots are sometimes deleted

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123869

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #4 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
@ghia 
This is not a bug, and all you told in your comment is well known.

Auto Number Recognition is a very old issue, as old as Spreadshhets itself, it
will be impossible to beet all users needs. Please ask for help for your
problem 
at
<http://user.services.openoffice.org/en/forum/>
or here:<http://www.openoffice.org/support/>
If you want to report bugs please consider hints on
<http://wiki.openoffice.org/wiki/QA/HowToFileIssue> 
There are lots of possibilities how to paste IP-Addresses as text.

Currently I think that much more users want this auto recognition for pasting
numbers with thousands separator than users who need to paste IP-addresses. But
as I told you, if you have a good idea for a new feature in number recognition
what extends the existing possibilities please do not hesitate to 

Please do not reopen bugs closed by experienced QA staff, but write a comment
without changing status if you have additional questions or concerns. 

And please do not spam other bugs with long comments to an unrelated issue if
you can simply use a hyperlink to an existing Bug

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

[Bug 123869] Pasting IP addresses, dots are sometimes deleted

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123869

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |elish@apache.org

--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Can not reproduce
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Debian

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

[Bug 123869] Pasting IP addresses, dots are sometimes deleted

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123869

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|NOT_AN_ISSUE                |---

--- Comment #3 from ghia <ge...@ghia.eu> ---
Yes, I am from Belgium and we use the European format for numbers, with the ','
as decimal separator.
Altough the thousands separator is in general not used and is also not in my
general default formatting.

And yes, I could activate the thousands separator format to see the dots, but
this does not help me match because it still stays a number and does not become
a text, where I can use formulae like =MID(A2;1;FIND(".";A2;1)-1) on.

Feature or bug? 
When features behave headstrong and cocky, they are more a bug to me. The input
conversion goes way beyond the formatting rules for the document, where the
general number format is 1234,56 . 
It also does not take into account the format of the column or cell where it is
pasted into. Setting the cell as text and then pasting, makes no difference.

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

[Bug 123869] Pasting IP addresses, dots are sometimes deleted

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123869

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rainerbielefeld_ooo_qa@biel
                   |                            |efeldundbuss.de
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #2 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Effect is reproducible with "AOO 4.0.1   – German UI / German locale  [Rev.
1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”
 4.0  User Profile used for all  predecessor versions

But probably not a bug, but a feature.
I am pretty sure that reporter uses German Locale or similar, where the dot is
used as thousands separator. Because of that as expected effect for me is NOT
reproducible with server installation of "AOO 4.1.0-Dev – English  UI / English
locale - [AOO410m1(Build:9750)  -  Rev. 1546757 - 2013-12-02]" on German WIN7
Home Premium (64bit)", own separate user profile. Because for this locale the
dot is not a thousands separator "75.125.255.255" will be inserted as a string.

@ghia
Dots should reappear if in menu 'Format -> Cell -> Numbers' you check
"Thousands separator"
Please feel free to reopen this issue if you find evidence that this one is a
real issue. Or submit an Enhancement Request if you think you know a way to
make some aotodetect more smart.

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