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

[robert_weir@us.ibm.com]

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

Michael.Brauer@Sun.COM 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          michael.brauer@sun.com
> http://sun.com/staroffice         +49 40 23646
500
> http://blogs.sun.com/GullFOSS
>