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 _______________________________________________ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
