From: dieter@duenenhof-wilhelm.de (H. Dieter Wilhelm)
To: Bastien <bzg@altern.org>
Cc: Xue Fuqiao <xfq.free@gmail.com>, emacs-orgmode@gnu.org
Subject: Re: About range references in the spreadsheet
Date: Sun, 27 Jan 2013 15:35:10 +0100 [thread overview]
Message-ID: <87ehh6iti9.fsf@urmel.duenenhof-wilhelm.de> (raw)
In-Reply-To: <87obgbcxdx.fsf@ucl.ac.uk> (Eric S. Fraga's message of "Sun, 27 Jan 2013 10:25:38 +1030")
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
next prev parent reply other threads:[~2013-01-27 14:35 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
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 [this message]
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87ehh6iti9.fsf@urmel.duenenhof-wilhelm.de \
--to=dieter@duenenhof-wilhelm.de \
--cc=bzg@altern.org \
--cc=emacs-orgmode@gnu.org \
--cc=xfq.free@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).