Re: [Orgmode] formula
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.domi...@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.domi...@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: $...@-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: $...@-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: $...@-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.domi...@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: $...@-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.domi...@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
Re: [Orgmode] formula
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: $...@-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.domi...@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 ___ 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: [Orgmode] formula
Sure, sorry, that's what text is for :) | in | out | balance | |-+-+-| | | | | | 30 | | 30 | | | 25 | 5 | | 100 | | 105 | | 500 | | | | | 400 | | | | | | #+TBLFM: $...@-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: $...@-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.domi...@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: $...@-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.domi...@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 ___ 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: [Orgmode] formula
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: $...@-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: $...@-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: $...@-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.domi...@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: $...@-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.domi...@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 ___ 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: [Orgmode] formula
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.domi...@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: $...@-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: $...@-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: $...@-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.domi...@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: $...@-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.domi...@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 ___ 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: [Orgmode] formula
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.domi...@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: $...@-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: $...@-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: $...@-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.domi...@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: $...@-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.domi...@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)
Re: [Orgmode] formula
Haroldo Stenger harold.sten...@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: $...@-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 ___ 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: [Orgmode] formula
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 ___ 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: [Orgmode] formula
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: $...@-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.domi...@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 ___ 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: [Orgmode] formula question
Indeed, thank you very much. Fixed in the GIT repo. - Carsten On Dec 22, 2008, at 5:06 PM, henry atting wrote: Since the last upgrade of org-mode (now 6.16) when I do a `C-c C-c' on `=' in a table field I am always prompted like this: replace field formula with column formula (y or n) The formula is a simple addition of the amounts of the preceeding fields: #+TBLFM: $...@-1$3::$3=$1+$2 Before the upgrade I never got that (useless) prompt. henry ___ 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 ___ 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