<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - When opening a CSV file in Calc IPs are mangled" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131397#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - When opening a CSV file in Calc IPs are mangled" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131397">bug 131397</a> from <a class="email" href="mailto:naitsirch@e.mail.de" title="naitsirch <naitsirch@e.mail.de>"> naitsirch</a> <pre>Okay, I understand your point. The thousand separator in my locale is "." and LibreOffice interpretes an IP as a high number if the right thousand groups always consist of three digits. I suggest this solution for this special case: If the thousand separator is "." and the value is a valid IP (consists of four thousand groups where each is >= 0 and <= 255) the value should be interpreted as a number (as it is know). Additionally in the format settings of the cell is defined that thousand separator should be used. This way it is interpreted as a number and shown like a number and like an IP. What do you think?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>