Proposal for Spreadsheets: New sort option "natural sort"

[Michael Brauer - Sun Germany - ham02 - Hamburg <Michael.Brauer@Sun.COM>]

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