I'm not sure how tolerant you mean. Would it help to use @-I and @-II Edd
On Tue, Apr 1, 2008 at 11:19 AM, Russell Adams <[EMAIL PROTECTED]> wrote: > On Tue, Apr 01, 2008 at 11:05:01AM -0500, Russell Adams wrote: > > Speaking of tables today, I thought I'd post a question that I haven't > > found a simple answer for. > > > > How do you sum a table reliably? (ie: tolerant of editing) > > > > This table requires the use of org-table-insert-row (etc...) in order > > to keep the formula correct. > > > > | Header | > > |--------| > > | 1 | > > | 2 | > > | 3 | > > | 4 | > > | 5 | > > |--------| > > | 15 | > > #+TBLFM: @7$1=vsum(@[EMAIL PROTECTED]) > > > > How can I do something like this, where the last cell is automatically > > the sum of the column, and not an absolute reference that must be > maintained? > > > > | 1 | > > | 2 | > > | 3 | > > | 4 | > > | 5 | > > |--------| > > | 15 | > > #+TBLFM: LAST=vsum($0..$0) > > > > Thanks. > > In reply to myself, perhaps a way to refer to last cell would work. > > | 15 | > > |--------| > | 1 | > | 2 | > | 3 | > | 4 | > | 5 | > #+TBLFM: @1$1=vsum($I..$LAST) > > That way using tab on the value "5" would add a new line and not break > the formula reference. > > > > Thanks. > > > ------------------------------------------------------------------ > Russell Adams [EMAIL PROTECTED] > > PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ > > Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3 > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode > _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
