"Andreas J. Guelzow" <[EMAIL PROTECTED]> writes: > On Sat, 2006-24-06 at 21:22 +0200, Berthold Höllmann wrote: >> I have a spreadsheet where I regular add lines with 14 columns. From >> some of these columns I calculate SLOPE, INTERCEPT, or FORECAST. These >> functions do not work using ranges as $A:$A that I can use in graphs. >> These ranges are accepted, but the calculated values are wrong. I >> tried using ADDRESS, but without sucess. > > If you insert rows in the middle of your data, your formulas should be > automatically adjusted.
The data has to be appended, and it's always just one line at a time. Further the cells are "preformatted" and there are some formula cells in each of the rows. OK, I could insert a line before the last one, copy the last line to the newly inserted line and change the values in the last line. Yes it would be less effort then changing the row entries in all my formulas. Berthold -- [EMAIL PROTECTED] / <http://höllmanns.de/> [EMAIL PROTECTED] / <http://starship.python.net/crew/bhoel/> _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
