emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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).