|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Entry rules > Text rules |
Here are some guidelines for texts used in questions and other entries:
Try to avoid the following characters in texts, because these have special meanings:
•! (exclamation mark)
•~ (tilde)
•; (semicolon)
•^ (caret)
Only use the following characters as described below:
•\ (backslash) use following headers in response texts for reports
•[ ] (square brackets) use to surround carry forward text
•Putting a new line in text will not be honoured in CSV or Excel tables output
All text is normally put into one cell and new lines are ignored and replaced with a space in OpenXML/Excel output.
The following special character sequences can be used to control the output:
<br> causes a new line to be started
<b> causes the following text to be bold
</b> causes the following text to stop being bold
<i> causes the following text to be italic
</i> causes the following text to stop being italic
<ul> causes the following text to be underlined
</ul> causes the following text to stop being underlined
IMPORTANT: some title and header output is always all bold, so <b> and </b> will be ignored for these.
These commands are removed from text tables (.txt) output but will appear the comma separated value tables output (.csv) which are then implemented in the spreadsheet output (.xlsx).
If you are producing TXT tables and XLSX tables then you can use a newline and a <br> in text. The new line will be used in TXT tables and the <br> in the XLSX tables.
Here is an example:
This <b>bold text</b> is unlike this <i>italic text</i> and this <ul>underlined text</ul> as you can see.
It will be output to XLSX as:
This bold text is unlike this italic text and this underlined text as you can see.
These settings can overlap as shown:
This text is <b><i>bold and italic,</b> but only italic here</i>
It will be output to XLSX as:
This text is bold and italic, but only italic here
Note that bold text is wider than other text and could cause row heights to be miscalculated when text is wrapped. Try not to use too much bold in one text. If miscalculation does occur then using <br> to split the line should cure the problem.