Bug 104732 - IP Address Sorting wrong
Summary: IP Address Sorting wrong
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-17 11:50 UTC by Asif Ali Rizvan
Modified: 2016-12-17 14:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Asif Ali Rizvan 2016-12-17 11:50:20 UTC 
I am attempting to sort a sheet by an IP address column. Obviously it isn't working properly:

Given the following list:
10.10.10.1
10.10.10.2
10.10.10.3
10.10.10.10
10.10.10.30
10.10.10.100

Sorting by OOO Calc by default would be:
10.10.10.1
10.10.10.10
10.10.10.100
10.10.10.2
10.10.10.3
10.10.10.30

As system and network admins we need to sort a list of servers and their inventory based on IP addresses. Libreoffice calc should do basic ipv4 sorting at least for us to be productive. 

Thank you!.
Comment 1 m_a_riosv 2016-12-17 14:51:53 UTC 
There is an option to enable natural sorting.

Menu/Data/Sort - Options - Enable natural sort.