To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100530 Issue #|100530 Summary|Wrong Conversion of ips, dots are deleted Component|Spreadsheet Version|OOo 3.0.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|gorgonz
------- Additional comments from gorg...@openoffice.org Tue Mar 24 21:45:46 +0000 2009 ------- I have a csv file, where one column keeps the ip. Whenever i insert the data to calc, using the menu item Einfügen->Tabelle von Datei with these entries, then some ip adresses loose the dots. Since I don't see a possibility to add an attachment, i will paste the file contenet into this desciption. Don't worry about the content, it is the collection of spammers, that i caught at my forum ;) --------------------------- 18.01.2009, 20:07|89.49.252.109|freenet Cityline GmbH|daniel1994-mic...@web.de| 18.01.2009, 20:15|89.49.252.109|freenet Cityline GmbH|danielmic...@rocketmail.com| 03.02.2009, 01:41|69.1.239.140|ARBINET-THEXCHANGE|dopoff...@gmail.com| 07.02.2009, 21:47|94.75.221.73|LEASEWEB|@yalta.krim.ws| 08.02.2009, 14:58|94-76-213-144|blueconnex.net|elkemail1...@googlemail.com| 08.02.2009, 21:46|94.75.221.73|LEASEWEB|@ukrmail.org| 09.02.2009, 21:00|94.75.221.73|LEASEWEB|dingodo...@mail.saratov.com| 10.02.2009, 10:56|94.75.221.73|IP gesperrt|--------------| 16.02.2009, 00:16|98.215.1.171|Comcast Cable Communications|veleszjun...@xmail.com| 16.02.2009, 19:32|89.113.78.103|Z-Telecom Ltd (RU)|loaddche...@sweetville.net| 18.02.2009, 20:00|89.149.244.57|NETDIRECT-NET|c...@tadros-youssef.com| 19.02.2009, 23:37|194.146.133.230|Privately Owned Enterprise "Poisk", Lugansk, Ukraine|s...@racersbid.com| 22.02.2009, 11:44|87.248.169.14|STARNETMD-Chisinau, Moldova|3...@onllinevideo.cn| 23.02.2009, 05:07|195.69.84.58|Synapse Network-Ukraine|atheroscle...@gmail.com| 23.02.2009, 11:23|194.146.133.230|POISK-UA-NET,Ukraine|d...@drezbilling.com| 23.02.2009, 13:23|194.146.133.230|IP gesperrt|--------------| 24.02.2009, 00:50|213.118.255.61|Telenet Operaties N.V.|radiov...@goldwarez.org| 24.02.2009, 02:50|92.112.236.14|Ukrtelecom IP access network-Ukraine|darleneduranuh...@gmail.com| 24.02.2009, 06:25|94.142.128.151|SIA "CSS GROUP" hostin-Latvia|perde...@gmail.com| 24.02.2009, 08:45|92.112.236.14|Ukrtelecom IP access network-Ukraine|phoebekernsho...@gmail.com| 24.02.2009, 08:45|92.112.236.14|IP gesperrt|--------------| 24.02.2009, 21:34|62.43.160.66|ES-ONO-20000503-Barcelona|teaffe...@gmail.com| 25.02.2009, 00:21|62.43.160.66|ES-ONO-20000503-Barcelona|crazylifebllogh...@gmail.com|crazylifeblogg 25.02.2009, 06:13|62.43.160.66|ES-ONO-20000503-Barcelona|bitzz...@mymail-in.net|bitzzi 25.02.2009, 10:17|62.43.160.66|ES-ONO-20000503-Barcelona|peertestlipallroundtalkfo...@gmail.com|derforumjunkie 25.02.2009, 19:26|62.43.160.66|IP gesperrt|--------------| 25.02.2009, 20:52|87.118.94.24|Keyweb AG IP Network-Erfurt|vi...@lightflowers.info|VicDovbysh 27.02.2009, 23:51|92.113.195.42|Ukrtelecom IP access network-Ukraine|adamzsw...@xmail.com|heidiabramsbujmc 27.02.2009, 23:51|92.113.195.42|IP gesperrt|--------------| 27.02.2009, 23:59|94.142.128.151|IP gesperrt|--------------| 27.02.2009, 23:59|195.69.84.58|IP gesperrt|--------------| 27.02.2009, 23:59|87.248.169.14|IP gesperrt|--------------| 02.03.2009, 01:22|92.112.194.172|Ukrtelecom IP access network-Ukraine|marcelgrayit...@gmail.com|marcelgrayitnrw 02.03.2009, 21:22|87.118.94.24|IP gesperrt|--------------| 04.03.2009, 12:02|92.112.36.161|Ukrtelecom IP access network-Ukraine|kayewilliampe...@gmail.com|kayewilliampelvb 04.03.2009, 18:02|92.112.36.161|IP gesperrt|--------------| 05.03.2009, 09:34|92.112.199.216|Ukrtelecom IP access network-Ukraine|grahambentoney...@gmail.com|grahambentoneybpi 05.03.2009, 17:02|92.112.199.216|IP gesperrt|--------------| 08.03.2009, 22:01|201.205.208.138|IANA-BLK|mrxplld...@myrxpill.com|mrxplldrgs 09.03.2009, 20:31|201.218.198.164|IANA-BLK|maennerratcomb...@gmail.com|maennerrat 09.03.2009, 20:53|92.112.200.113|Ukrtelecom IP access network-Ukraine|suifewetbe...@gmail.com|erickawestongueto 11.03.2009, 09:10|89.113.78.199|Z-Telecom Ltd-RU|zaeba1...@gmail.com|frimitofruics 14.03.2009, 03:31|89.105.228.141|FARLEP-TELECOM-HOLDING, a subprovider-Ukraine|339337...@getasiansex.com|ayucGatcfs 15.03.2009, 20:39|201.218.198.164|IANA-BLK|namireab...@gmail.com|panamafirma 15.03.2009, 21:25|201.218.198.164|IP gesperrt|--------------| 16.03.2009, 17:53|194.8.75.192|Dragonara Alliance Ltd-GB|bradzca...@e-mail.org|larabetty 17.03.2009, 03:37|194.8.75.191|Dragonara Alliance Ltd-GB|effiftseex...@gmail.com|aribrenda 17.03.2009, 15:37|201.205.208.138|SAN ANTONIO DE BELEN-Costa Rica|rdllsgp...@myrxpill.com|rdllsgpxrm 18.03.2009, 00:37|201.205.208.138|IP gesperrt|--------------| 18.03.2009, 17:42|194.8.75.191|Dragonara Alliance Ltd-GB|teesmomsil...@gmail.com|BesidentBib 19.03.2009, 08:21|194.8.74.37|dashk...@megapochta.cn|DashaOlssen 19.03.2009, 10:11|66.197.231.213|HOSTNOC-2BLK-USA|jjjjvo...@gmail.com|JessyBVCZ --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org