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 [email protected] 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|[email protected]| 18.01.2009, 20:15|89.49.252.109|freenet Cityline GmbH|[email protected]| 03.02.2009, 01:41|69.1.239.140|ARBINET-THEXCHANGE|[email protected]| 07.02.2009, 21:47|94.75.221.73|LEASEWEB|@yalta.krim.ws| 08.02.2009, 14:58|94-76-213-144|blueconnex.net|[email protected]| 08.02.2009, 21:46|94.75.221.73|LEASEWEB|@ukrmail.org| 09.02.2009, 21:00|94.75.221.73|LEASEWEB|[email protected]| 10.02.2009, 10:56|94.75.221.73|IP gesperrt|--------------| 16.02.2009, 00:16|98.215.1.171|Comcast Cable Communications|[email protected]| 16.02.2009, 19:32|89.113.78.103|Z-Telecom Ltd (RU)|[email protected]| 18.02.2009, 20:00|89.149.244.57|NETDIRECT-NET|[email protected]| 19.02.2009, 23:37|194.146.133.230|Privately Owned Enterprise "Poisk", Lugansk, Ukraine|[email protected]| 22.02.2009, 11:44|87.248.169.14|STARNETMD-Chisinau, Moldova|[email protected]| 23.02.2009, 05:07|195.69.84.58|Synapse Network-Ukraine|[email protected]| 23.02.2009, 11:23|194.146.133.230|POISK-UA-NET,Ukraine|[email protected]| 23.02.2009, 13:23|194.146.133.230|IP gesperrt|--------------| 24.02.2009, 00:50|213.118.255.61|Telenet Operaties N.V.|[email protected]| 24.02.2009, 02:50|92.112.236.14|Ukrtelecom IP access network-Ukraine|[email protected]| 24.02.2009, 06:25|94.142.128.151|SIA "CSS GROUP" hostin-Latvia|[email protected]| 24.02.2009, 08:45|92.112.236.14|Ukrtelecom IP access network-Ukraine|[email protected]| 24.02.2009, 08:45|92.112.236.14|IP gesperrt|--------------| 24.02.2009, 21:34|62.43.160.66|ES-ONO-20000503-Barcelona|[email protected]| 25.02.2009, 00:21|62.43.160.66|ES-ONO-20000503-Barcelona|[email protected]|crazylifeblogg 25.02.2009, 06:13|62.43.160.66|ES-ONO-20000503-Barcelona|[email protected]|bitzzi 25.02.2009, 10:17|62.43.160.66|ES-ONO-20000503-Barcelona|[email protected]|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|[email protected]|VicDovbysh 27.02.2009, 23:51|92.113.195.42|Ukrtelecom IP access network-Ukraine|[email protected]|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|[email protected]|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|[email protected]|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|[email protected]|grahambentoneybpi 05.03.2009, 17:02|92.112.199.216|IP gesperrt|--------------| 08.03.2009, 22:01|201.205.208.138|IANA-BLK|[email protected]|mrxplldrgs 09.03.2009, 20:31|201.218.198.164|IANA-BLK|[email protected]|maennerrat 09.03.2009, 20:53|92.112.200.113|Ukrtelecom IP access network-Ukraine|[email protected]|erickawestongueto 11.03.2009, 09:10|89.113.78.199|Z-Telecom Ltd-RU|[email protected]|frimitofruics 14.03.2009, 03:31|89.105.228.141|FARLEP-TELECOM-HOLDING, a subprovider-Ukraine|[email protected]|ayucGatcfs 15.03.2009, 20:39|201.218.198.164|IANA-BLK|[email protected]|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|[email protected]|larabetty 17.03.2009, 03:37|194.8.75.191|Dragonara Alliance Ltd-GB|[email protected]|aribrenda 17.03.2009, 15:37|201.205.208.138|SAN ANTONIO DE BELEN-Costa Rica|[email protected]|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|[email protected]|BesidentBib 19.03.2009, 08:21|194.8.74.37|[email protected]|DashaOlssen 19.03.2009, 10:11|66.197.231.213|HOSTNOC-2BLK-USA|[email protected]|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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
