Style

Dropdown list and tree structure:

• Dropdown list, can be selected in the cell of Excel, such as "ProductName":

    No Sort:  The values in dropdown are arranged by system.

    Sort:

    1.Constant Value

The values in dropdown are arranged by definition sequence.  User can arrange values' sequence by "Up" and "Down".

    2.From Data Table

The values in dropdown are arranged by choosing "Ascending" or "Descending".

• Tree Structure selecting: right click the cell, a menu appears, and choice "Tree Structure selecting", such as "ProductType":

After "Tree Structure selecting..." is selected:

Excel Server homepage