Psion 3a Series - Circular References - the Indicator; Moving Data with Bring

Circular references - the E indicator
In its simplest sense, a circular reference is where a formula refers to itself - for
example, if cell B2 contained the formula =B2 .
It is also a circular reference when two formulae depend on each other - for example, if
you have =D3+1 in cell B2, and =B2 + 1 in cell D3.
A circular reference usually means you've made a mistake - for example, you've
typed in the wrong cell reference. They are rarely used deliberately in a worksheet.
Circular references can be very complex, leading from cell to cell around the
worksheet, finally returning to the cell from which they started.
Each lime a worksheet is recalculated, the values in cells involved in a circular
reference may change in strange ways. For example, in the previous example, the
values in B2 and D3 would rise by one at each recalculation.
Detecting circular references
The indicator appears at the right end of the input line when the worksheet
contains a circular reference. Use the 'Jump to' option, and accept its suggestion of
'Circular reference'; the cell pointer will move to one of the cells involved in the
circular reference.
If you have Manual recalculation set on, the E§ indicator may not be up to date, as
the worksheet is only cheeked when it is recalculated.
Moving data with 'Bring'
You can use the 'Bring' option on the 'Edit' menu to copy data highlighted in another
application. To get data out of the Spreadsheet, highlight it, then select Bring' in the
other application.
1. In the file you are copying from, highlight the data to be copied.
2. Move to the file to to which you want to copy the data. Position the cursor or cell
pointer where you want the data to go, and select 'Bring' from the 'Edit' menu. The
data is copied in. In the Spreadsheet, it will overwrite cells, just like 'Paste'.
• Between two worksheets all values, text and formulae are copied. This is as if you'd
used 'Copy', then opened the second worksheet and pasted the data in. Relative
references in formulae are automatically updated. Absolute references are left as
they are. The format, alignment and protection information are also copied.
Both files must be open at the same time. To open the second one without exiting
the first one. highlight it in the System screen and select it with Shift-Enter.
• Between a Spreadsheet and other applications, everything you can see is pasted.
Formulae are copied as the values they display on the screen. Format information is
lost. A row in the Spreadsheet corresponds to a line in the other application.
1135= Some applications will limit the amount of data they accept - for example, taking
only the first line of the data.
If you separate numbers and text in the Word Processor with tab characters, you can
'Bring' them into separate cells in the Spreadsheet.
8: The Spreadsheet 141