Text @-fields enable you to put the page number, the date, the document title as defined in the Options dialogue box, a picture, a colour or font change or a reference to another cell into your document. Text @-fields are also used to put the required entries into mail shots. Text @-fields can be included in headers and footers, for page numbering and document titling.
Text @-fields take the form:
@identifier@@@...@
Identifier Effect
D
date
F
font
G
picture or graph
L
leafname
N
current time
P
current page number
T
file title as defined in Options dialogue box
number
number is number of field for a mailshot
cell ref
value of cell referred to
When the caret is not in the cell containing the Text @-field, the cell shows the value of the Text @-field. When the caret is moved onto the cell, the actual @ identifier is shown, for editing.
The number of @ characters after the identifier determines the size of the Text @-field for formatting. Provided the number of characters in the value to be displayed is less than or equal to the size of the Text @-field, the line will be formatted correctly. The field is displayed in the minimum space and any extra spaces are distributed throughout the line if it is justified.
Inserts the current date.
If you want to fix the date into the cell, mark it as a block and give the Snapshot command.
Specifies a change of font within a cell.
@F:fontname,x,y@
@F:Corpus.Medium,24,24@
switches the font to 24 point Corpus.Medium.
The easiest way to specify this is by using the Local Font command and selecting the settings in the dialogue box.
Displays a picture from a file, scaled as specified.
@G:filename,scale_factor@
If the filename is just a leafname, PipeDream looks in the directory of the current document.
The easiest way to specify this is to place the caret at the top left of where you want the picture and drag the picture into the PipeDream document.
Inserts the leafname of the current file.
Inserts the current time.
If you want to fix the time into the cell, mark it as a block and give the Snapshot command.
Inserts the current page number.
@P@@@@
displays the page number allowing for a width of up to four characters.
This Text @-field is particularly useful if inserted into a footer for page numbering.
Inserts the document title as defined in the Options dialogue box.
To display it within the text, type @T@. There should be sufficient @ signs after the T to reserve space for the title.
@T@@@@@
allows for a title five characters long.
Inserts the field represented by number into a text cell in a mailshot.
@2@@@@@@@
inserts field 2 into a mailshot, allowing for a width of up to 7 characters.
Inserts the value of the cell referred to.
@A5@@@@@
reserves five characters for the contents of cell A5 to be displayed.
There must be as many @-signs following the Text @-field identifier as the maximum number of characters needed to display the item, including any minus signs, brackets, and leading and trailing characters. This is necessary to maintain formatting when the item is included.
If the reference is to a number cell, the value will be displayed in the same format as in the cell itself, with alignment ignored.
cell_reference can be an external reference, i.e. a reference to a cell in a different document.
[fred]A1
is a reference to cell A1 in the document called ‘fred’.