Share via

2.1.240 Section 8.6.6, Sort By

  • Article

a.   This is not supported in Word 2010, Word 2013, Word 2016, or Word 2019.

b.   The standard defines the attribute table:data-type, contained within the element <table:sort-by>, contained within the parent element <table:sort>

This attribute is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

  1. For custom list sorts, Excel writes out the entire custom list.

  2. Excel does not save color and icon sorts.

  3. Excel does not write out the text or numeric types. It loads both as automatic.

c.   The standard defines the attribute table:field-number, contained within the element <table:sort-by>, contained within the parent element <table:sort>

This attribute is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

On save, Excel writes out a zero-based field number.

d.   The standard defines the attribute table:order, contained within the element <table:sort-by>, contained within the parent element <table:sort>

This attribute is supported in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.