[vox-tech] autoincrementing in sc spreadsheet

[Mark K. Kim]

Can't help you with the Sc, but there is a way to turn off that feature on
major spreadsheet programs.  To fix a coordinate (keep it from changing,)
prefix it with $.  So if dragging (a0*b0) to the right 1 cell will change
the value to (a1*b1), but dragging (a$0*b$0) to the right 1 cell will
not change the value.  The same can be done with the letter portion -- by
prefixing the letter with $, like ($a0*$b0).  If you prefix both the
letter and the number, it'll keep the value from changing at all
($a$0*$b$0).

-Mark


On Fri, 31 Oct 2003, Henry House wrote:

> Most familiar spreadsheets have an "autoincrement" feature, meaning that if I
> have a cell containing "a0*b0" and copy it to another cell, the row and
> column numbers are adjusted by the offset from the destination cell to the
> origin cell. For example, if I paste into the cell immediately below, the
> pasted contents will be "a1*b1". This is convenient for making big tables of
> figures that reference previous lines of calculated data, etc. (It can also
> be a bother since there is usually no easy way to turn off this behavior.)
>
> Sc does not do this. Is there any way to get this behavior?
>
> --
> Henry House
> The unintelligible text that may follow is a digital signature.
> See <http://hajhouse.org/pgp> for information.  My OpenPGP key:
> <http://hajhouse.org/hajhouse.asc>.
>
>

-- 
Mark K. Kim
AIM: markus kimius
Homepage: http://www.cbreak.org/
Xanga: http://www.xanga.com/vindaci
Friendster: http://www.friendster.com/user.jsp?id=13046
PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
PGP key available on the website