[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Table rows and ranges as LHS of formulas
From: |
Carsten Dominik |
Subject: |
Re: [O] Table rows and ranges as LHS of formulas |
Date: |
Thu, 3 Mar 2011 00:16:12 +0100 |
On 3.3.2011, at 00:09, Christian Moe wrote:
> Hi, Carsten,
>
> Yes, it's really neat.
>
> I just realized, though, that there *is* an equally clean way to generate
> such tables in OOo Calc (which the Org spreadsheet has all but replaced for
> my needs):
>
> - Place 1 in cell B1. Drag across to get 1-10 in cells B1:K1.
> - Place 1 in cell A2. Drag down to get 1-10 in cells A2:A11.
> - In cell B2, type the formula =B1:K1*A2:A11. Do NOT press Enter, press
> Ctrl-Shift-Enter (or Cmd-Shift-Enter on Mac) to make it an "array formula"
> (it presents as {=B1:K1*A2:A11}).
> - Hey presto, the table is filled.
Indeed, this sounds equally compact. Thanks!
- Carsten
>
> Yours,
> Christian
>
>
> On 3/2/11 6:31 PM, Carsten Dominik wrote:
>> Hi Christian,
>>
>> thanks for the great example! I guess this is really something
>> Org has over other spreadsheets. No copy-and-paste-with-modification,
> > just a single formula.
>>
>> - Carsten
>>
>> On 2.3.2011, at 17:11, Christian Moe wrote:
>>
>>> Hi,
>>>
>>> Row formulas are great! I've missed this, but learned to work around it,
>>> since I I just assumed that if you hadn't already done it, it was not a
>>> reasonable thing to ask for.
>>>
>>> Testing... So now we can simply do e.g.:
>>>
>>> #+CAPTION: A multiplication table
>>> | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
>>> |----+---+---+---+---+---+---+---+---+---+----|
>>> | 1 | | | | | | | | | | |
>>> | 2 | | | | | | | | | | |
>>> | 3 | | | | | | | | | | |
>>> | 4 | | | | | | | | | | |
>>> | 5 | | | | | | | | | | |
>>> | 6 | | | | | | | | | | |
>>> | 7 | | | | | | | | | | |
>>> | 8 | | | | | | | | | | |
>>> | 9 | | | | | | | | | | |
>>> | 10 | | | | | | | | | | |
>>> #+TBLFM: @address@hidden@1*$1
>>>
>>> C-c C-c...and hey presto:
>>>
>>> #+CAPTION: A multiplication table
>>> | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
>>> |----+----+----+----+----+----+----+----+----+----+-----|
>>> | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
>>> | 2 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 |
>>> | 3 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 |
>>> | 4 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 |
>>> | 5 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 |
>>> | 6 | 6 | 12 | 18 | 24 | 30 | 36 | 42 | 48 | 54 | 60 |
>>> | 7 | 7 | 14 | 21 | 28 | 35 | 42 | 49 | 56 | 63 | 70 |
>>> | 8 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80 |
>>> | 9 | 9 | 18 | 27 | 36 | 45 | 54 | 63 | 72 | 81 | 90 |
>>> | 10 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 |
>>> #+TBLFM: @address@hidden@1*$1
>>>
>>>
>>> Yours,
>>> Christian
>>>
>>> On 3/1/11 3:28 PM, Carsten Dominik wrote:
>>>> Hi everyone,
>>>>
>>>> A frequently requested feature for tables has been to
>>>> be able to define row formulas in a way similar to column
>>>> formulas. The patch below allows things like
>>>>
>>>> @3=
>>>> @address@hidden
>>>> @address@hidden
>>>>
>>>> as the left hand side for table formulas in order to
>>>> write a formula that is valid for an entire column or
>>>> for a rectangular section in a table.
>>>>
>>>> Note that in contrast to column formulas, @3= will not
>>>> automatically skip a "header column" or field formulas in the
>>>> same row. In fact, making both a range formula and a field
>>>> point to the same field is forbidden and throws an error.
>>>> So to have a formula apply to all but the first column, use
>>>> something like this:
>>>>
>>>> @address@hidden
>>>>
>>>> Testing is welcome, but I am confident that this works
>>>> pretty well.
>>>>
>>>> Bastien, please let me know if you want to have this integrated
>>>> before the release, then I will do so.
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Emacs-orgmode mailing list
>>>> Please use `Reply All' to send replies to the list.
>>>> address@hidden
>>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>>
>>
>>
>
- [O] Table rows and ranges as LHS of formulas, Carsten Dominik, 2011/03/01
- Re: [O] Table rows and ranges as LHS of formulas, Bastien, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Carsten Dominik, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Nick Dokos, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Suvayu Ali, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Carsten Dominik, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Samuel Wales, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Nick Dokos, 2011/03/02
- Re: [O] Table rows and ranges as LHS of formulas, Bastien, 2011/03/03
- Re: [O] Table rows and ranges as LHS of formulas, Carsten Dominik, 2011/03/03
- Re: [O] Table rows and ranges as LHS of formulas, Bastien, 2011/03/03