Re: [office] Proposal for Spreadsheets: New sort option "natural sort"

From
<>
Date
2007-01-19T20:57:40+00:00
ID
Thread
Re: [office] Proposal for Spreadsheets: New sort option "natural sort"
Interesting idea.

How far do we take it?  

For example do we allow multiple levels,
as in:

A1.1, A1.2, A1.10, ... , A19.1, A20.3,
etc.

-Rob

 wrote on 01/19/2007 05:26:03
AM:

> Dear TC members,

> 

> this is a proposal for a new attribute of the <table:sort> element:

> 

> The attribute "table:natural-sort" specifies how string
values are sorted.

> If the attribute's value is "true", string-prefixed numbers
will be sorted

> in a "natural", number-aware way, i.e. A1, A2, A3, ... ,
A19, A20,

> instead of the normal, alpha-numeric behavior, i.e.

> A1, A10, A11, A12, ... ,A19, A2, A20, A3, A4, ... , A8, A9.

> 

> <define name="table-sort-attlist" combine="interleave">

>      <optional>

>          <attribute name="table:natural-sort"
a:defaultValue="false">

>              <ref name="boolean"/>

>          </attribute>

>      </optional>

> </define>

> 

> Best regards

> 

> Michael

> -- 

> Michael Brauer, Technical Architect Software Engineering

> StarOffice/OpenOffice.org

> Sun Microsystems GmbH             Nagelsweg
55

> D-20097 Hamburg, Germany          

> http://sun.com/staroffice         +49 40 23646
500

> http://blogs.sun.com/GullFOSS

>