Circular definition in spreadsheet?

[Alasdair]

Here's a simple example:

Enter 1 in A1 and 2 in B1.  Now enter "=A1+B1" in C1, and "=A1+B1+C1" in D1.
Enter "=A1+1" in A2, and "=D1" in B2.  Now, try to copy C1 to C2 (so that C2 should contain "=A2+B2").  And you get: "Syntax Error: Circular definition".

I'm mystified and stumped by this.  All relevant values are available, and I have no idea what's going on.  It must have something to do with using the value of D1 in cell B2, although I fail to see why that's an issue.

Anyway, how can I avoid this error?  Basically I'm doing calculations along one row, copying the final result into the next row,  and then proceeding with the same calculations in the new row.  It is a fairly basic and ordinary spreadsheet use, but I keep getting this "Circular Definition" error.

I'm using a TI-nspire CAS second generation, (not colour), OS version 3.9.0.463.

Many thanks!

[Gert]

Do not use ctrl-c and ctrl-v, but use the 'drag formula':

- select the cell(s)

- move move pointer to lower right of selection until "+" appears

- click

- move pointer over cells to be filled

- click.

Succes,

Gert