all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* About range references in the spreadsheet
@ 2013-01-16 15:24 Xue Fuqiao
  2013-01-26 11:20 ` Bastien
  0 siblings, 1 reply; 11+ messages in thread
From: Xue Fuqiao @ 2013-01-16 15:24 UTC (permalink / raw)
  To: emacs-orgmode

In (info "(org) References"), there is an example explaining the range
references:

     @-1$-2..@-1   3 numbers from the column to the left, 2 up to
current row

What does `2 up to current row' mean?  I don't understand.  IIRC `@' represents row, it should be `1 up to current row'.
-- 
Best regards.

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-16 15:24 About range references in the spreadsheet Xue Fuqiao
@ 2013-01-26 11:20 ` Bastien
  2013-01-26 23:55   ` Eric S Fraga
  0 siblings, 1 reply; 11+ messages in thread
From: Bastien @ 2013-01-26 11:20 UTC (permalink / raw)
  To: Xue Fuqiao; +Cc: emacs-orgmode

Hi Xue,

Xue Fuqiao <xfq.free@gmail.com> writes:

> In (info "(org) References"), there is an example explaining the range
> references:
>
>      @-1$-2..@-1   3 numbers from the column to the left, 2 up to
> current row
>
> What does `2 up to current row' mean?  I don't understand.  IIRC `@'
> represents row, it should be `1 up to current row'.

No.  The whole sentence expands to this: 

  This range takes 3 numbers: the first one from the column to the
  left (and the row above), the 2 others up to current row.

I agree this might not be obvious but I don't have a better proposal.
Maybe a native english speaker can help here.

Best,

-- 
 Bastien

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-26 11:20 ` Bastien
@ 2013-01-26 23:55   ` Eric S Fraga
  2013-01-27 14:35     ` H. Dieter Wilhelm
  0 siblings, 1 reply; 11+ messages in thread
From: Eric S Fraga @ 2013-01-26 23:55 UTC (permalink / raw)
  To: Bastien; +Cc: Xue Fuqiao, emacs-orgmode

Bastien <bzg@altern.org> writes:

> Hi Xue,
>
> Xue Fuqiao <xfq.free@gmail.com> writes:
>
>> In (info "(org) References"), there is an example explaining the range
>> references:
>>
>>      @-1$-2..@-1   3 numbers from the column to the left, 2 up to
>> current row
>>
>> What does `2 up to current row' mean?  I don't understand.  IIRC `@'
>> represents row, it should be `1 up to current row'.
>
> No.  The whole sentence expands to this: 
>
>   This range takes 3 numbers: the first one from the column to the
>   left (and the row above), the 2 others up to current row.
>
> I agree this might not be obvious but I don't have a better proposal.
> Maybe a native english speaker can help here.
>
> Best,


I think the current description is wrong and that rows and columns have
been interchanged?  The entries defined by this range are all in the row
above (@-1) the current row.  The columns chosen are two to the left of
the current column up to the current column.

If you wish to re-word, maybe:

This range expands to three elements, all on the row above the current
row, starting with the column two to the left of the current column.


-- 
: Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D
: in Emacs 24.3.50.1 and Org release_7.9.3d-874-gf11acc

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-26 23:55   ` Eric S Fraga
@ 2013-01-27 14:35     ` H. Dieter Wilhelm
  2013-01-30 16:48       ` Bastien
  0 siblings, 1 reply; 11+ messages in thread
From: H. Dieter Wilhelm @ 2013-01-27 14:35 UTC (permalink / raw)
  To: Bastien; +Cc: Xue Fuqiao, emacs-orgmode

Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> Bastien <bzg@altern.org> writes:
>
>> Hi Xue,
>>
>> Xue Fuqiao <xfq.free@gmail.com> writes:
>>
>>> In (info "(org) References"), there is an example explaining the range
>>> references:
>>>
>>>      @-1$-2..@-1   3 numbers from the column to the left, 2 up to
>>> current row
>>>
>>> What does `2 up to current row' mean?  I don't understand.  IIRC `@'
>>> represents row, it should be `1 up to current row'.
>>
>> No.  The whole sentence expands to this: 
>>
>>   This range takes 3 numbers: the first one from the column to the
>>   left (and the row above), the 2 others up to current row.
>>
>> I agree this might not be obvious but I don't have a better proposal.
>> Maybe a native english speaker can help here.
>>
>> Best,
>
>
> I think the current description is wrong and that rows and columns have
> been interchanged?  The entries defined by this range are all in the row
> above (@-1) the current row.  The columns chosen are two to the left of
> the current column up to the current column.

Right. The formulation above would only be logical with:

  This range takes 3 numbers: the first one from TWO columns to the
  left (and the row above), the 2 others up to current row.

But still not easy to understand.

> If you wish to re-word, maybe:
>
> This range expands to three elements, all on the row above the current
> row, starting with the column two to the left of the current column.

Would be much better, I think.

More precisely: The manual speaks about `field references' and `column'-
and `row' specifications.  So I would write:

  The three SPECIFICATIONS expand to a field range from the row above
  the current row, starting with two columns to the left up to the
  current column.

(I would avoid the ambiguous expression "column two" since it is a
relative specification) alternatively

  The TWO REFERENCES expand to a field range from the row above the
  current row, starting with two columns to the left up to the current
  column.

  Dieter

-- 
Best wishes

H. Dieter Wilhelm
Darmstadt
Germany

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-27 14:35     ` H. Dieter Wilhelm
@ 2013-01-30 16:48       ` Bastien
  2013-01-31  2:09         ` Eric S Fraga
  0 siblings, 1 reply; 11+ messages in thread
From: Bastien @ 2013-01-30 16:48 UTC (permalink / raw)
  To: H. Dieter Wilhelm; +Cc: Xue Fuqiao, emacs-orgmode

Hi Xue, Eric and Dieter,

dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes:

> (I would avoid the ambiguous expression "column two" since it is a
> relative specification) alternatively
>
>   The TWO REFERENCES expand to a field range from the row above the
>   current row, starting with two columns to the left up to the current
>   column.

Yes... but this is a bit long.

I finally used this:

@@-1$-2..@@-1   @r{in the first row up, 3 fields from 2 columns on the left}

Implicitely, the sentence ends with "up to the current one", which I
think can be assumed to be obvious here.

Let me know if you think this is still confusing.

Best,

-- 
 Bastien

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-30 16:48       ` Bastien
@ 2013-01-31  2:09         ` Eric S Fraga
  2013-01-31 22:44           ` Dieter Wilhelm
  0 siblings, 1 reply; 11+ messages in thread
From: Eric S Fraga @ 2013-01-31  2:09 UTC (permalink / raw)
  To: emacs-orgmode

Bastien <bzg@altern.org> writes:

> Hi Xue, Eric and Dieter,
>
> dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes:
>
>> (I would avoid the ambiguous expression "column two" since it is a
>> relative specification) alternatively
>>
>>   The TWO REFERENCES expand to a field range from the row above the
>>   current row, starting with two columns to the left up to the current
>>   column.
>
> Yes... but this is a bit long.
>
> I finally used this:
>
> @@-1$-2..@@-1   @r{in the first row up, 3 fields from 2 columns on the left}

Concise and correct!  I'm happy with this.

-- 
: Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D
: in Emacs 24.3.50.1 and Org release_7.9.3d-898-g005917

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-31  2:09         ` Eric S Fraga
@ 2013-01-31 22:44           ` Dieter Wilhelm
  2013-01-31 23:04             ` Nick Dokos
  0 siblings, 1 reply; 11+ messages in thread
From: Dieter Wilhelm @ 2013-01-31 22:44 UTC (permalink / raw)
  To: emacs-orgmode

Eric S Fraga <e.fraga@ucl.ac.uk> writes:

> Bastien <bzg@altern.org> writes:
>
>> Hi Xue, Eric and Dieter,
>>
>> dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes:
>>
>>> (I would avoid the ambiguous expression "column two" since it is a
>>> relative specification) alternatively
>>>
>>>   The TWO REFERENCES expand to a field range from the row above the
>>>   current row, starting with two columns to the left up to the current
>>>   column.
>>
>> Yes... but this is a bit long.
>>
>> I finally used this:
>>
>> @@-1$-2..@@-1   @r{in the first row up, 3 fields from 2 columns on the left}
>
> Concise and correct!  I'm happy with this.

Sorry but I don't understand "in the first row up".  Maybe better: The
(or a) row up, 3...

Another grievance with such a terse description for me is although it
may describe the end result - the range - correctly but does not take
into account how the references at hand are working.

But maybe I'm just picking nits here :-)

What about such an approach:

@@-1$-2..@@-1 @r{a range of 3 fields: a row up, from 2 fields on the left .. a row up}


      Dieter

-- 
Best wishes

H. Dieter Wilhelm
Darmstadt
Germany

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-31 22:44           ` Dieter Wilhelm
@ 2013-01-31 23:04             ` Nick Dokos
  2013-02-01  0:11               ` Thomas S. Dye
  0 siblings, 1 reply; 11+ messages in thread
From: Nick Dokos @ 2013-01-31 23:04 UTC (permalink / raw)
  To: Dieter Wilhelm; +Cc: emacs-orgmode

Dieter Wilhelm <dieter@duenenhof-wilhelm.de> wrote:

> Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> 
> > Bastien <bzg@altern.org> writes:
> >
> >> Hi Xue, Eric and Dieter,
> >>
> >> dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes:
> >>
> >>> (I would avoid the ambiguous expression "column two" since it is a
> >>> relative specification) alternatively
> >>>
> >>>   The TWO REFERENCES expand to a field range from the row above the
> >>>   current row, starting with two columns to the left up to the current
> >>>   column.
> >>
> >> Yes... but this is a bit long.
> >>
> >> I finally used this:
> >>
> >> @@-1$-2..@@-1   @r{in the first row up, 3 fields from 2 columns on the left}
> >
> > Concise and correct!  I'm happy with this.
> 
> Sorry but I don't understand "in the first row up".  Maybe better: The
> (or a) row up, 3...
> 
> Another grievance with such a terse description for me is although it
> may describe the end result - the range - correctly but does not take
> into account how the references at hand are working.
> 
> But maybe I'm just picking nits here :-)
> 

No, I think it's unclear as well (I hadn't paid attention to the thread previously.
Sorry for joining the party late).

> What about such an approach:
> 
> @@-1$-2..@@-1 @r{a range of 3 fields: a row up, from 2 fields on the left .. a row up}
> 

Perhaps factoring out the row part makes it clearer? Also, presenting it as a movement from
the current cell might help - at least that's how I tend to read these specs:

"a range of 3 fields: up one row, two columns over to the left .. the current column (implicitly specified)"

Nick

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-01-31 23:04             ` Nick Dokos
@ 2013-02-01  0:11               ` Thomas S. Dye
  2013-02-01  5:09                 ` Nick Dokos
  2013-02-07  8:13                 ` Bastien
  0 siblings, 2 replies; 11+ messages in thread
From: Thomas S. Dye @ 2013-02-01  0:11 UTC (permalink / raw)
  To: nicholas.dokos; +Cc: Dieter Wilhelm, emacs-orgmode

Nick Dokos <nicholas.dokos@hp.com> writes:

> Dieter Wilhelm <dieter@duenenhof-wilhelm.de> wrote:
>
>> Eric S Fraga <e.fraga@ucl.ac.uk> writes:
>> 
>> > Bastien <bzg@altern.org> writes:
>> >
>> >> Hi Xue, Eric and Dieter,
>> >>
>> >> dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm) writes:
>> >>
>> >>> (I would avoid the ambiguous expression "column two" since it is a
>> >>> relative specification) alternatively
>> >>>
>> >>>   The TWO REFERENCES expand to a field range from the row above the
>> >>>   current row, starting with two columns to the left up to the current
>> >>>   column.
>> >>
>> >> Yes... but this is a bit long.
>> >>
>> >> I finally used this:
>> >>
>> >> @@-1$-2..@@-1 @r{in the first row up, 3 fields from 2 columns on
>> >> the left}
>> >
>> > Concise and correct!  I'm happy with this.
>> 
>> Sorry but I don't understand "in the first row up".  Maybe better: The
>> (or a) row up, 3...
>> 
>> Another grievance with such a terse description for me is although it
>> may describe the end result - the range - correctly but does not take
>> into account how the references at hand are working.
>> 
>> But maybe I'm just picking nits here :-)
>> 
>
> No, I think it's unclear as well (I hadn't paid attention to the
> thread previously.
> Sorry for joining the party late).
>
>> What about such an approach:
>> 
>> @@-1$-2..@@-1 @r{a range of 3 fields: a row up, from 2 fields on the
>> left .. a row up}
>> 
>
> Perhaps factoring out the row part makes it clearer? Also, presenting
> it as a movement from
> the current cell might help - at least that's how I tend to read these specs:
>
> "a range of 3 fields: up one row, two columns over to the left .. the
> current column (implicitly specified)"

"a range of three fields in the row before the current row, starting two
columns before the current column and ending in the current
column."

-- 
Thomas S. Dye
http://www.tsdye.com

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-02-01  0:11               ` Thomas S. Dye
@ 2013-02-01  5:09                 ` Nick Dokos
  2013-02-07  8:13                 ` Bastien
  1 sibling, 0 replies; 11+ messages in thread
From: Nick Dokos @ 2013-02-01  5:09 UTC (permalink / raw)
  To: Thomas S. Dye; +Cc: Dieter Wilhelm, emacs-orgmode

Thomas S. Dye <tsd@tsdye.com> wrote:


> >> >> @@-1$-2..@@-1 @r{in the first row up, 3 fields from 2 columns on
> >> >> the left}
> >> >
> 
> "a range of three fields in the row before the current row, starting two
> columns before the current column and ending in the current
> column."
> 

That's the best one so far imo, and I doubt it can get any better.

Nick

^ permalink raw reply	[flat|nested] 11+ messages in thread

* Re: About range references in the spreadsheet
  2013-02-01  0:11               ` Thomas S. Dye
  2013-02-01  5:09                 ` Nick Dokos
@ 2013-02-07  8:13                 ` Bastien
  1 sibling, 0 replies; 11+ messages in thread
From: Bastien @ 2013-02-07  8:13 UTC (permalink / raw)
  To: Thomas S. Dye; +Cc: Dieter Wilhelm, nicholas.dokos, emacs-orgmode

tsd@tsdye.com (Thomas S. Dye) writes:

> "a range of three fields in the row before the current row, starting two
> columns before the current column and ending in the current
> column."

Yes, it's very explicit, but a bit long -- I try to have the
explanation fit in one line.  I updated again to this:

  3 fields in the row above, starting from 2 columns on the left

-- 
 Bastien

^ permalink raw reply	[flat|nested] 11+ messages in thread

end of thread, other threads:[~2013-02-07  9:06 UTC | newest]

Thread overview: 11+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2013-01-16 15:24 About range references in the spreadsheet Xue Fuqiao
2013-01-26 11:20 ` Bastien
2013-01-26 23:55   ` Eric S Fraga
2013-01-27 14:35     ` H. Dieter Wilhelm
2013-01-30 16:48       ` Bastien
2013-01-31  2:09         ` Eric S Fraga
2013-01-31 22:44           ` Dieter Wilhelm
2013-01-31 23:04             ` Nick Dokos
2013-02-01  0:11               ` Thomas S. Dye
2013-02-01  5:09                 ` Nick Dokos
2013-02-07  8:13                 ` Bastien

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.