Re: How to ignore horizontal lines in tables and references

[Carsten Dominik <carsten.dominik@gmail.com>]

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