Issue 109227

Summary: Sorting "auto incremented" lists
Product: Calc Reporter: pagalmes.lists
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.2 RC5   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description pagalmes.lists 2010-02-13 14:36:52 UTC 
A new feature in OO is quite useful: I can now auto-increment IP adresses. For
ewample, I set in a cell the value 10.32.54.1, drag and I get the following list : 

10.32.54.1
10.32.54.2
10.32.54.3
...

The issue, is that sorting this kind of lists is not natural when you start
having the last number superior to 10. Here is an exemple of how IP adresses are
sorted:

My IP
10.32.54.1
10.32.54.10
10.32.54.11
10.32.54.12
10.32.54.13
10.32.54.14
10.32.54.15
10.32.54.16
10.32.54.17
10.32.54.18
10.32.54.19
10.32.54.2
10.32.54.20
10.32.54.21
10.32.54.22
10.32.54.3
10.32.54.4
10.32.54.5
10.32.54.6
10.32.54.7
10.32.54.8
10.32.54.9

I would expect to have:

My IP
10.32.54.1
10.32.54.2
10.32.54.3
10.32.54.4
10.32.54.5
10.32.54.6
10.32.54.7
10.32.54.8
10.32.54.9
10.32.54.10
10.32.54.11
10.32.54.12
10.32.54.13
10.32.54.14
10.32.54.15
10.32.54.16
10.32.54.17
10.32.54.18
10.32.54.19
10.32.54.20
10.32.54.21
10.32.54.22

Regards,
Comment 1 kyoshida 2010-02-13 18:33:31 UTC 
This is a duplicate to an issue to which I personally attached a patch to solve
this.

*** This issue has been marked as a duplicate of 26565 ***
Comment 2 kyoshida 2010-02-13 18:33:58 UTC 
Ah, sorry.  My mistake.  Not a duplicate.
Comment 3 Edwin Sharp 2013-08-15 10:57:16 UTC 
As given in description.

Rev. 1507307 Win 7