Created attachment 158775 [details]
A test file to reproduce the issue
When I open a CSV file with Calc and the file contains columns where IPs are listed, some of the IPs are mangled and shown as integers and the others are shown correctly, if no column type is specified in the import wizard.
For example the IP "22.214.171.124" is displayed correctly, whereas the IP "126.96.36.199" is displayed as "84157123122".
It would be nice if this behaviour could be changed.
I'll attach two screenshot and an CSV file to reproduce the issue.
Created attachment 158776 [details]
The import wizard without specified column type
Created attachment 158777 [details]
Screenshot of the mangled IPs
What is the thousand separator used in your locale?
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?
(In reply to naitsirch from comment #4)
> Okay, I understand your point. The thousand separator in my locale is "."
> 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
I think it's really difficult to find someone to fix your proposal.
There are solutions on the import window to solve much of the special cases.
In this case select the column clicking in the head, and fix their type to text.
You are right. Thank you anyway :-)