emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* problems with table mode
@ 2008-04-20 19:32 Pete Phillips
  2008-04-20 20:27 ` Carsten Dominik
  0 siblings, 1 reply; 4+ messages in thread
From: Pete Phillips @ 2008-04-20 19:32 UTC (permalink / raw)
  To: org-mode mailing list

I am having a problem with a table I use to calculate my annual leave


| Basic Entitlement |         33 |
| Carryover         |          5 |
|-------------------+------------|
| Date              | No of days |
|-------------------+------------|
| 25th April        |          1 |
| 26th - 28th May   |          3 |
|-------------------+------------|
| Used              |          4 |
| Remaining         |          4 |
#+TBLFM: @III+1$2=vsum(@II+1$2..@III-1$2)::@III+2$2=@1$2+@2$2-@III+1

The table gives me the correct calculation for 'Used' - i.e., the number
of days I have taken so far.

However, the formula for the 'Remaining' row gives me the error 

  org-table-get-stored-formulas: Double definition `$2=' in TBLFM line, please fix by hand 

I don't understand this - if @III+1$w works for the second column in the
Used row, why doesn't @III+2$2 work for the second column in the
Remaining row ?

Any help appreciated.

Regards
Pete

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2008-04-21  6:38 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2008-04-20 19:32 problems with table mode Pete Phillips
2008-04-20 20:27 ` Carsten Dominik
     [not found]   ` <18940.1208723747@localhost>
2008-04-21  6:13     ` Carsten Dominik
2008-04-21  6:38       ` Pete Phillips

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).