Skip to content

Spreadsheet

Spreadsheet renders repeated data as an editable grid. XPath selects the collection context and ItemXPath selects the rows below that context; ItemXPath defaults to *. Changes made in the grid update the corresponding row nodes in the form data.

Columns and Editors

Each Column has a label, a field XPath, alignment, and a Type: Text, Number, Date, DateTime, Time, or Boolean. The client chooses an editor and filter appropriate to that type. Date values use their date portion; DateTime editor values omit the timezone portion while editing, so choose the column type to match the data model.

The optional Editor control collection provides a row editor. The grid enables paging and supports range selection. It refreshes when its item collection changes or when its own bound node changes while visible.

Example

1
2
3
4
5
6
7
8
9
<Spreadsheet XPath="Lines" ItemXPath="Line">
    <Columns>
        <Column XPath="Description" Type="Text"><Label><Content>Description</Content></Label></Column>
        <Column XPath="Quantity" Type="Number" Align="Right"><Label><Content>Quantity</Content></Label></Column>
        <Column XPath="DueDate" Type="Date"><Label><Content>Due date</Content></Label></Column>
    </Columns>
    <Editor />
    <Rules />
</Spreadsheet>