| Tables, Fields and Selectors - part 1 |
| Part of the "Working With QuSheet" tutorial for QuSheet |
| Part of the "Working With QuSheet" tutorial for QuSheet |
| Summary |
Tables hold data. QuSheet interprets data according to the operations being performed. |
Fields define extra columns in Tables. All Tables have access to all fields but Tables can leave fields blank if they are not relevant. |
A: The default setting for viewing a Table within a workbook is to *not* display columns for fields which have no values defined, either within the workbook or with any sheet addition. |
As QuSheet traverses Headings, it sets values to Fields which are then used to look up rows in Tables. QuSheet searches rows in Tables in order, starting with any additions made for individual Sheets, looking for the first match. Care must be taken to ensure that rows with undefined Fields are not placed before Table rows which they may be obscuring. |
Fields have default values, either within the Workbook or as extra Field additions in a given Sheet. These default values are used by front-end Table processing: colour-coding and with the pop-up list which appears on right-click / F12. |
Fields are also used extensively in Selectors. Selectors are used to set Fields to collections of values for the repeated processing of Heading and Sheet entries. |
A Selector can be simply a Field – in which case the field simply takes its collection of default values. |
Selectors can also set one or more Fields in a more sophisticated manner. |
A Selector has a number of lines defining Fields and the values they should take. If a Field is specified without a “field value source”, then the Field takes on its defined values. If a “field value source” is set to a Table, then the Table is searched for all row matches according to the current Field values, and then the Field value in those matched roes is used to provide the set of values that the required Field should take. |
A: Note that when a Table is searched for Field values, including during the evaluation of a Selector, the Field being searched is first cleared before searching takes place. |
A: Note also that it is now possible to set a Field value within a Heading by using a non-field-access operation (typically "ignore") with a Field specified but no Operand or Explanation specified. |
| Summary » |
| View (duration 7m) |
| You will need to view this page on a non-handheld screen to see the presentation. |
| Addenda / Errata |
A: The default setting for viewing a Table within a workbook is to *not* display columns for fields which have no values defined, either within the workbook or with any sheet addition. |
A: Note that when a Table is searched for Field values, including during the evaluation of a Selector, the Field being searched is first cleared before searching takes place. |
A: Note also that it is now possible to set a Field value within a Heading by using a non-field-access operation (typically "ignore") with a Field specified but no Operand or Explanation specified. |
| Addenda / Errata » |
| « Summary |
Tables hold data. QuSheet interprets data according to the operations being performed. |
Fields define extra columns in Tables. All Tables have access to all fields but Tables can leave fields blank if they are not relevant. |
A: The default setting for viewing a Table within a workbook is to *not* display columns for fields which have no values defined, either within the workbook or with any sheet addition. |
As QuSheet traverses Headings, it sets values to Fields which are then used to look up rows in Tables. QuSheet searches rows in Tables in order, starting with any additions made for individual Sheets, looking for the first match. Care must be taken to ensure that rows with undefined Fields are not placed before Table rows which they may be obscuring. |
Fields have default values, either within the Workbook or as extra Field additions in a given Sheet. These default values are used by front-end Table processing: colour-coding and with the pop-up list which appears on right-click / F12. |
Fields are also used extensively in Selectors. Selectors are used to set Fields to collections of values for the repeated processing of Heading and Sheet entries. |
A Selector can be simply a Field – in which case the field simply takes its collection of default values. |
Selectors can also set one or more Fields in a more sophisticated manner. |
A Selector has a number of lines defining Fields and the values they should take. If a Field is specified without a “field value source”, then the Field takes on its defined values. If a “field value source” is set to a Table, then the Table is searched for all row matches according to the current Field values, and then the Field value in those matched roes is used to provide the set of values that the required Field should take. |
A: Note that when a Table is searched for Field values, including during the evaluation of a Selector, the Field being searched is first cleared before searching takes place. |
A: Note also that it is now possible to set a Field value within a Heading by using a non-field-access operation (typically "ignore") with a Field specified but no Operand or Explanation specified. |
| « Addenda / Errata |
A: The default setting for viewing a Table within a workbook is to *not* display columns for fields which have no values defined, either within the workbook or with any sheet addition. |
A: Note that when a Table is searched for Field values, including during the evaluation of a Selector, the Field being searched is first cleared before searching takes place. |
A: Note also that it is now possible to set a Field value within a Heading by using a non-field-access operation (typically "ignore") with a Field specified but no Operand or Explanation specified. |
-> output produced by QuSheet, licenced to "Richard Develyn", 15 Oct 2009 130|1|24094