Datasheet View Layout Properties

You are here: Elements Reference > Form & Datasheet Elements > Datasheet Element > Datasheet View Layout Properties

Datasheet View Layout Properties

The Datasheet View Layout Properties dialog allows you to control the overall appearance of each view defined for a Datasheet Element.

After defining a view, click the Element properties icon and select Layout to open the Datasheet View Layout Properties dialog.

If the datasheet has more than one view, you must first select the view from the drop-down list on the page in which the Datasheet Element displays.

The available formatting options are:

View Drop-Down List Alignment - Select the position where CommonSpot places the drop down list that allows users to select a datasheet view. Your choices are left, center, or right.
Default Sorting - Select a column name and sort direction for the initial sorting. After the datasheet displays on a page, a user can click a column header to resort the table by that column’s data.
Results Per Page - Limit the number of results displayed on a page. CommonSpot adds page navigation links when the results do not fit onto a single page.
Show Alphabet Characters for Filtering - Check this box to provide an alphabet list for filtering results.
Show Record Count - Displays the number of records in the datasheet.
Show Column Headers - This setting allows you to display or hide all column headers.

Show Export Data Link - Selecting this checkbox tells CommonSpot to display a link above the datasheet that when clicked exports the datasheet’s values to an Excel spreadsheet.
Allow JavaScript data sorting - If selected, this option may result in reduced accessibility, as the text may not be available for to browsers that speak the words on a page.

After making your selections, click Save to return to the displayed datasheet.

Related Links

You can download PDF versions of the Content Contributor's, Administrator's, and Elements Reference documents from the support section of paperthin.com (requires login).

The following guides are available locally on your CommonSpot Server:

You can also download these other guides from the support section of paperthin.com (with login):

For technical support:

http://www.paperthin.com/support/