WKBK_TRANSPOSED_GRID_SAMPLE_HEADER
STRING, comprising a comma-separated list of sample attributes
When a workbook is loaded in transposed mode, then:
- If empty (default on deploy), or the preference is missing, or contains no valid sample attributes, then the Sample Code is displayed in the Sample header cell, centre-justified, and the row height is increased if required.
- If not empty, then the comma-separated list of sample attributes is used to construct the column header in the Sample header cell, rendered as a multi-lined data grid header, and the row height is adjusted to accommodate the content based on the number of lines of text are included in the header content.
The properties for sample header can come from:
- Job details
- Sample details
- Sample-scheme details
The grid header height is auto-adjusted to accommodate the number of lines required for each listed sample attribute.
For example, where the setting is:
J.JobName, S.SampleName, S.SampleDescription, S.SampleCode, SS.ProfileSequence
then the header is rendered as a five-line header, with each row containing the job name, sample name, sample description, sample code and sample scheme's profiles sequence:
Job_123456
Job_123456.Sample_XXX
Sample_AAA_Description
LAB1_0000005678
24
If the column width, as defined by the WKBK_TRANSPOSED_GRID_COLUMN_WIDTH application preference, is too narrow, or when changes to column widths make the columns too narrow, then column headers are truncated on each header line. When the column width is reduced/increased, then the multi-line headers are truncated/grown per line. For example:
Job_1...
Job_1...
Sampl...
LAB1_...
24
Note that the WKBK_FONT_SETTING application preference allows the font size and family of the Sample column headers in the transposed grid to be configured.
The transposed sample column headers are available to all workbook scripts.
Where a Workbook Load script is defined, when the transposed mode of the workbook is first presented or refreshed and the script is executed, then the script can adjust the text content, width and height of the data column header. Header height is auto-adjusted.
Typically the preference is not set at role or user level.
