
From:  Haroldo Stenger 
Subject:  Re: [Orgmode] formula 
Date:  Wed, 5 Aug 2009 20:53:18 0300 
No. A column formula starts like %3=... and applies to all fields
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.
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 `Cc *' to a different function?
Maybe you Cu is bound to something else?
You can try to move the cursor into the #+TBLFM line and press `Cc Cc' there, this should also update the entire table, as should `Cu Cc Cc'
anywhere in the table.
 Carsten
I upgraded to the las orgmode version.
I must be doing something really wrong, since Cu Cc * 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 <address@hidden>
Hi Haroldo,
Well, I am using the newest version of Orgmode for which you'd have to use a filed formula for the first field in the balance column. Then using your
formulas, `Cu Cc *' does fill the entire table:
 in  out  balance 
++
   0 
 30   30 
  25  5 
 100   105 
 500   605 
  400  205 
   205 
#+TBLFM: address@hidden + @+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: address@hidden + @+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 Cc * in @3$3 , @4$3 and address@hidden
The complete filling of the $3 column doesn't take place by issuing the commands in http://orgmode.org/org.html#Updatingthetable. If I go to @6$3 , @7$3 and @8$3 and type Cc * I obtain what I want, being:
 in  out  balance 
++
   
 30   30 
  25  5 
 100   105 
 500   605 
  400  205 
   205 
#+TBLFM: address@hidden + @+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 <address@hidden>
>
> 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 columnformula and relative references in the formula. So far, so good. Now, I have the formula line like this
>>
>> #+TBLFM: address@hidden + @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 columnformula. 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 <address@hidden>
>> 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 Cc ' 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 Cc ' and then go to each of the references and type Sdownarrow as many times. I'd thank any idea here.
>>
>> best regards, haroldo.
>> (thanks for orgmode, it's great)
>> _______________________________________________
>> Emacsorgmode mailing list
>> Remember: use `Reply All' to send replies to the list.
>> address@hidden
>> http://lists.gnu.org/mailman/listinfo/emacsorgmode
>>
>>
>
[Prev in Thread]  Current Thread  [Next in Thread] 