* How to ignore horizontal lines in tables and references
@ 2009-07-31 14:34 Benjamin Andresen
2009-07-31 14:54 ` Benjamin Andresen
2009-08-03 4:37 ` Carsten Dominik
0 siblings, 2 replies; 4+ messages in thread
From: Benjamin Andresen @ 2009-07-31 14:34 UTC (permalink / raw)
To: emacs-orgmode
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$4))::@5$5=vmean(@2$5..@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$5..@4$5);%.1f
use
@5$5=vmean(@2$5..@-1$5);%.1f
the following message will come up during evaluation:
Row descriptor -1 used in line <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.
Thanks in advance,
benny
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: How to ignore horizontal lines in tables and references
2009-07-31 14:34 How to ignore horizontal lines in tables and references Benjamin Andresen
@ 2009-07-31 14:54 ` Benjamin Andresen
2009-07-31 15:10 ` Nick Dokos
2009-08-03 4:37 ` Carsten Dominik
1 sibling, 1 reply; 4+ messages in thread
From: Benjamin Andresen @ 2009-07-31 14:54 UTC (permalink / raw)
To: emacs-orgmode
Hey,
Benjamin Andresen <benny@in-ulm.de> writes:
> | 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$4))::@5$5=vmean(@2$5..@4$5);%.1f
Of course a few minutes after sending the mail, I'm stumbling upon
one(?) answer:
Changing "@2$5..@4$5" to "@2$5..@-I$5" works. I'm not entirely sure I
completely understand the reason behind this, but it works for now.
br,
benny
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: Re: How to ignore horizontal lines in tables and references
2009-07-31 14:54 ` Benjamin Andresen
@ 2009-07-31 15:10 ` Nick Dokos
0 siblings, 0 replies; 4+ messages in thread
From: Nick Dokos @ 2009-07-31 15:10 UTC (permalink / raw)
To: Benjamin Andresen; +Cc: emacs-orgmode
Benjamin Andresen <benny@in-ulm.de> wrote:
> Hey,
>
> Benjamin Andresen <benny@in-ulm.de> writes:
>
> > | 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$4))::@5$5=vmean(@2$5..@4$5);%.1f
>
> Of course a few minutes after sending the mail, I'm stumbling upon
> one(?) answer:
> Changing "@2$5..@4$5" to "@2$5..@-I$5" works. I'm not entirely sure I
> completely understand the reason behind this, but it works for now.
>
Yes, that't correct: check section 3.5.1 of the manual. It would be nice
to expand this section to contain both a more systematic description of
the (fairly arcane) syntax (perhaps an itemized list would be easier to
scan), as well as more examples - perhaps a cookbook collection. Someone
have copious spare time on their hands? :-)
Thanks,
Nick
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: How to ignore horizontal lines in tables and references
2009-07-31 14:34 How to ignore horizontal lines in tables and references Benjamin Andresen
2009-07-31 14:54 ` Benjamin Andresen
@ 2009-08-03 4:37 ` Carsten Dominik
1 sibling, 0 replies; 4+ messages in thread
From: Carsten Dominik @ 2009-08-03 4:37 UTC (permalink / raw)
To: Benjamin Andresen; +Cc: Org Mode
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$4))::@5$5=vmean(@2$5..@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$5..@4$5);%.1f
> use
> @5$5=vmean(@2$5..@-1$5);%.1f
> the following message will come up during evaluation:
> Row descriptor -1 used in line <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
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2009-08-03 4:37 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2009-07-31 14:34 How to ignore horizontal lines in tables and references Benjamin Andresen
2009-07-31 14:54 ` Benjamin Andresen
2009-07-31 15:10 ` Nick Dokos
2009-08-03 4:37 ` Carsten Dominik
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).