
<section id='WCF_SpreadsheetControl_id'>
    <title>
        Spreadsheet Control
    </title>
    <para>
        A Spreadsheet Control is used to enter a two-dimensional table
        of information.
    </para>
    <exhibit>
        <img src='WCF_SpreadsheetControl_ScreenCap.png'/>
    </exhibit>
    <para>
        A spreadsheet control works much like a commercial spreadsheet,
        such as Microsoft Excel. A two-dimensional table of <termtext>cells</termtext>
        is presented. One cell is always <termtext>selected</termtext>.
        This is indicated by a dark outline. In the example above, the
        Mississippi River cell is selected. The selected cell is the one
        that you are currently editing. The <termtext>selected row</termtext>
        is the row containing the selected cell.
    </para>
    <para>
        To select another cell, click on it. Alternatively, use the following
        navigation keys.
    </para>
    <exhibit>
        <table>
            <tableheader>
                <tablecolumnheader horzjust='center'>
                    Key
                </tablecolumnheader>
                <tablecolumnheader horzjust='left'>
                    Action
                </tablecolumnheader>
            </tableheader>
            <tablerow>
                <tablecell>
                    <keytext>Arrow Key</keytext>
                </tablecell>
                <tablecell>
                    Move one cell in the indicated direction
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Ctrl + Arrow Key</keytext>
                </tablecell>
                <tablecell>
                    Move one page in the indicated direction
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Enter</keytext>
                </tablecell>
                <tablecell>
                    Move one cell down
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Shift + Enter</keytext>
                </tablecell>
                <tablecell>
                    Move one cell up
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Tab</keytext>
                </tablecell>
                <tablecell>
                    Move right one cell, or to start of next row if at end of current
                    row
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Shift + Tab</keytext>
                </tablecell>
                <tablecell>
                    Move left one cell, or to end of previous row if at beginning
                    of current row
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Page Up</keytext>
                </tablecell>
                <tablecell>
                    Move up current column one page
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Page Down</keytext>
                </tablecell>
                <tablecell>
                    Move down current column one page
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Ctrl + Page Up</keytext>
                </tablecell>
                <tablecell>
                    Move to top of current column
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Ctrl + Page Down</keytext>
                </tablecell>
                <tablecell>
                    Move to bottom of current column
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>Home</keytext>
                </tablecell>
                <tablecell>
                    Move to first column in current row
                </tablecell>
            </tablerow>
            <tablerow>
                <tablecell>
                    <keytext>End</keytext>
                </tablecell>
                <tablecell>
                    Move to last column in current row
                </tablecell>
            </tablerow>
        </table>
    </exhibit>
    <para>
        Most spreadsheet controls have Add and Remove buttons. The Add
        button adds a new row, located just below the selected row. The
        Remove button removes the selected row.
    </para>
    <para>
        Some spreadsheet controls have Move Row Up and Move Row Down buttons
        that move the selected row up or down in the table. Use these
        buttons to change the relative ordering of rows.
    </para>
    <para>
        In most spreadsheet controls, you can change a column's width
        by dragging the separator between column headers.
    </para>
    <exhibit>
        <img
        src='WCF_SpreadsheetControl_ScreenCap_DraggingColumnWidth.png'/>
    </exhibit>
</section>

