KB159842825: WebCenter - Attribute (numeric) values in drop-down based on Excel List are sorted incorrectly

Summary

Numeric Attributes values in drop-down list based on Excel Lists seem incorrectly sorted. In fact, they are sorted alphabetically instead of ascending numerically.

Symptoms

Numeric values in the Attribute drop-down are sorted alphabetically instead of ascending numerically.

For example: 1 10 11 2 3 4 5 6 7 8 9.

Workaround

To ensure the numbers are sorted numerically, add a leading zero to the single digit numbers (or as required).

Example: 01 02 03 04 05 06 07 08 09 10 11...

Article information
Applies to	WebCenter all versions
Created	06-Jan-15
Last revised
Author	IMY
CW Number	274785

Contents