Re: formula

[Haroldo Stenger <harold.stenger@gmail.com>]

[-- Attachment #1.1: Type: text/plain, Size: 6451 bytes --]

Carsten, Nick,

I finally could solve the issue. I got confused by what I consider are two
typos in the mails, I was mislead by 'filed formula' which I thought was
something new to me, when it was really a simple 'field formula'. Moreover,
column formulas (as the docs say, since I checked) start like "$3=" and not
as "%3=".

Finally, I understood that the only thing I had missing (which you kindly
provided) was the field formula that initializes the column to zero, when
instead I was trying to achieve by putting a zero directly, which (I don't
know why) does not work in combination with a column formula.

I just write this as feedback, not to bother anyone. And thanks a lot for
your kind help.

best,

haroldo

2009/8/4 Carsten Dominik <carsten.dominik@gmail.com>

>
> On Aug 4, 2009, at 4:23 PM, Haroldo Stenger wrote:
>
>  Carsten ,
>>
>> I take for granted that a filed formula is a column formula , like the one
>> I was using.
>>
>
> No.  A column formula starts like %3=... and applies to all fields
> in column 3.  A field formula starts like @2$3=... and applies to a single
> field.  I did out the correct formulas into the table I sent with my last
> email.
>
> For the rest I don't know what is wrong.
>
> Maybe you have some local setup binding `C-c *' to a different function?
> Maybe you C-u is bound to something else?
>
> You can try to move the cursor into the #+TBLFM line and press `C-c C-c'
> there, this should also update the entire table, as should `C-u C-c C-c'
> anywhere in the table.
>
> - Carsten
>
>
>
>
>> I upgraded to the las org-mode version.
>>
>> I must be doing something really wrong, since C-u C-c *  doesn't
>> recalculate the column, it just moves the point to the first row after the
>> hline.
>>
>> What can be that is missing here ?
>>
>> best regards,
>> haroldo
>>
>> 2009/8/4 Carsten Dominik <carsten.dominik@gmail.com>
>> Hi Haroldo,
>>
>> Well, I am using the newest version of Org-mode for which you'd have to
>> use a filed formula for the first field in the balance column.  Then using
>> your
>> formulas, `C-u C-c *' does fill the entire table:
>>
>>
>> |  in | out | balance |
>> |-----+-----+---------|
>> |     |     |       0 |
>>
>> |  30 |     |      30 |
>> |     |  25 |       5 |
>> | 100 |     |     105 |
>> | 500 |     |     605 |
>> |     | 400 |     205 |
>> |     |     |     205 |
>> #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2::@2$3=0
>>
>> So I don't know why this is not working for you.
>>
>> - Carsten
>>
>>
>> On Aug 4, 2009, at 8:28 AM, Haroldo Stenger wrote:
>>
>> Sure, sorry, that's what text is for :)
>>
>> |  in | out | balance |
>> |-----+-----+---------|
>> |     |     |         |
>> |  30 |     |      30 |
>> |     |  25 |       5 |
>> | 100 |     |     105 |
>> | 500 |     |         |
>> |     | 400 |         |
>> |     |     |         |
>> #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2
>>
>> That's how the table looks like after
>> - creating the table
>> - filling columns 1 and 2 with numbers
>> - creating the column formula in column 3, and
>> - typing C-c * in @3$3  , @4$3  and  @5$3
>>
>> The complete filling of the $3 column doesn't take place by issuing the
>> commands in http://orgmode.org/org.html#Updating-the-table. If I go to
>> @6$3 , @7$3 and @8$3 and type C-c *  I obtain what I want, being:
>>
>> |  in | out | balance |
>> |-----+-----+---------|
>> |     |     |         |
>> |  30 |     |      30 |
>> |     |  25 |       5 |
>> | 100 |     |     105 |
>> | 500 |     |     605 |
>> |     | 400 |     205 |
>> |     |     |     205 |
>> #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2
>>
>> I know that what I'm asking should be of easy achievement on my own, but I
>> got somewhat frustrated when I use the commands and the filling doesn't
>> happen. Thanks for helping me.
>>
>> best,
>> haroldo
>>
>>
>>
>>
>> 2009/8/4 Carsten Dominik <carsten.dominik@gmail.com>
>> >
>> > Hi Haroldo,
>> >
>> > instead of keeping us guessing what your table might look like,
>> > maybe you can just post it....
>> >
>> > - Carsten
>> >
>> > On Aug 4, 2009, at 1:53 AM, Haroldo Stenger wrote:
>> >
>> >> Dear Carsten ,
>> >>
>> >> Thanks ! That's exactly what I was in need of: a combination of a
>> column-formula and relative references in the formula. So far, so good. Now,
>> I have the formula line like this
>> >>
>> >> #+TBLFM: $5=@-1$5 + @-0$3 - @-0$4
>> >>
>> >> and the very line I typed the formula gets calculated fine. If I want
>> another line into the bus, I go to the empty field in the same column in
>> another line, and go to the Calculate menu, and choose recalculate line, and
>> the fine result appears there , as expected. But if I approach Calculate /
>> Recalculate all , in fact , nothing happens. I tried many times, without
>> result. Recalc line works perfectly, but that does not seem what I'm looking
>> for, which would be a recalculation of all the fields in the column that
>> holds my column-formula.  I'll continue reading until I find out, but if you
>> come up with an answer earlier I'd be grateful in advance !  :-)
>> >>
>> >> best ,
>> >>
>> >> haroldo
>> >>
>> >> 2009/8/3 Carsten Dominik <carsten.dominik@gmail.com>
>> >> Hi Haroldo,
>> >>
>> >>
>> >> You cannot copy a formula easily from one field t the next with
>> >> shifting the reference like you would do in a normal spreadsheet.
>> >> However, you can use relative references (see the manual) in
>> >> order to write formulas in an invariant way, and then use basic
>> >> editing commands in the C-c ' buffer to define the formula for
>> >> many fields.  Even better, use a column formula which allows
>> >> you to write a single formula for an entire column.
>> >>
>> >> - Carsten
>> >>
>> >>
>> >> On Aug 3, 2009, at 12:58 AM, Haroldo Stenger wrote:
>> >>
>> >> hi , I wonder how can a formula in a table be "copied" to a location
>> below, and its references be shifted alongwise automatically. I checked
>> every documentation I've found , but that "feature" does not show up. I'm
>> forced to copy the formula in in the C-c '  and then go to each of the
>> references and type S-downarrow as many times. I'd thank any idea here.
>> >>
>> >> best regards, haroldo.
>> >> (thanks for org-mode, it's great)
>> >> _______________________________________________
>> >> 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
>> >>
>> >>
>> >
>>
>>
>>
>>
>

[-- Attachment #1.2: Type: text/html, Size: 8278 bytes --]

[-- Attachment #2: Type: text/plain, Size: 204 bytes --]

_______________________________________________
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