On Jul 31, 2009, at 4:34 PM, Benjamin Andresen wrote:
Hello everyone,
I'm having a bit of a problem with tables and references. I try to use
tables + spreadsheet capabilities for data entry while testing certain
things, and one table design that works conceptually for me is the
following:
| Attempt | Start | End|
Success | Wait in Min |
|-++
+-+-|
| 1 | <2009-07-31 Fri 04:43> | <2009-07-31 Fri 04:44> |
No | 1 |
| 2 | <2009-07-31 Fri 04:45> | <2009-07-31 Fri 04:46> |
No | 1 |
| 3 | <2009-07-31 Fri 04:48> | <2009-07-31 Fri 04:49> |
No | 1 |
|-++
+-+-|
| Results |||
0% | 1 |
#+TBLFM: $5='(ba/org-time-diff-min $2 $3)::@5$4='(ba/find
"Yes"|'(@2$...@4$4))::@5$5=vmean(@2$...@4$5);%.1f
The problem I'm having is when my cursor is at @4$1 and I'm pressing
RET.
It creates a new row where I can enter new data, as expected.
It will increment the
@5$5 part to @6$5
Now the problem is when I try to automate the formulas a bit.
If I would instead of
@5$5=vmean(@2$...@4$5);%.1f
use
@5$5=vmean(@2$...@-1$5);%.1f
the following message will come up during evaluation:
Row descriptor -1 used in line crosses hline
Does anyone have any idea how I can make this work? The problem goes
away when I delete the horizontal line. If my table design is wrong or
there is a better way to do what I'm open to changing it.
The fact that relative references are not allowed to cross horizontal
separator lines is an old feature which I implemented fro some obscure
reason. I think now is the tie to get rid of it, because it causes
more confusion than anything.
I have just pushed a change to this effect, thanks for bringing it up.
- Carsten
Thanks in advance,
benny
___
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