formula

formula

[Haroldo Stenger]

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

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)

[-- Attachment #1.2: Type: text/html, Size: 473 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

Re: formula

[Carsten Dominik]

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

Re: formula

[Haroldo Stenger]

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

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: 2958 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

Re: formula

[Carsten Dominik]

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
>
>

Re: formula

[Haroldo Stenger]

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

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: 7195 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

Re: formula

[Carsten Dominik]

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
> >>
> >>
> >
>

Re: formula

[Haroldo Stenger]

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

Carsten ,

I take for granted that a filed formula is a column formula , like the one I
was using.

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: 6433 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

Re: formula

[Carsten Dominik]

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
> >>
> >>
> >
>
>
>

Re: formula

[Nick Dokos]

Haroldo Stenger <harold.stenger@gmail.com> wrote:

> 
> Carsten ,
> 
> I take for granted that a filed formula is a column formula , like the one I
> was using.
> 
That's incorrect: look at Carsten's modification of your TBLFM line:

> #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2::@2$3=0
                                     ^^^^^^---- this is the field formula.

The field formula initializes the top cell of the "balance" column. The
column formula (what you had before) then applies to the rest of the column.


> 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 ?
> 

You are probably getting an error and somehow missing it: here is what I get
without the field formula:

,----
| Debugger entered--Lisp error: (error #("Row descriptor -1 used in line 4 crosses hline" 15 17 (fontified t font-lock-fontified t face org-meta-line)))
|   signal(error (#("Row descriptor -1 used in line 4 crosses hline" 15 17 (fontified t font-lock-fontified t face org-meta-line))))
|   error("Row descriptor %s used in line %d crosses hline" #("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t)) 4)
|   org-table-find-row-type([dline hline dline dline dline dline dline dline dline hline] 2 dline t 1 1 4 #("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t)))
|   org-table-get-descriptor-line(#("-1" 0 2 (face org-meta-line font-lock-fontified t fontified t)))
|   org-table-get-range(#("@-1$3" 0 5 (fontified t font-lock-fontified t face org-meta-line)) nil 3)
|   org-table-eval-formula(nil #("@-1$3 + @+0$1 - @+0$2" 0 21 (fontified t font-lock-fontified t face org-meta-line)) noalign nocst nostore noanalysis)
|   org-table-recalculate(t)
|   call-interactively(org-table-recalculate)
|   org-ctrl-c-ctrl-c(nil)
|   call-interactively(org-ctrl-c-ctrl-c nil nil)
`----

HTH,
Nick

Re: formula

[Haroldo Stenger]

[-- 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