Issue 109227 - Sorting "auto incremented" lists
Summary: Sorting "auto incremented" lists
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2 RC5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-13 14:36 UTC by pagalmes.lists
Modified: 2013-08-15 10:57 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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