How to ignore horizontal lines in tables and references

How to ignore horizontal lines in tables and references

[Benjamin Andresen]

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

Re: How to ignore horizontal lines in tables and references

[Benjamin Andresen]

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

Re: Re: How to ignore horizontal lines in tables and references

[Nick Dokos]

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

Re: How to ignore horizontal lines in tables and references

[Carsten Dominik]

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