* formula @ 2009-08-02 22:58 Haroldo Stenger 2009-08-03 10:51 ` formula Carsten Dominik 0 siblings, 1 reply; 10+ messages in thread From: Haroldo Stenger @ 2009-08-02 22:58 UTC (permalink / raw) To: emacs-orgmode [-- 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-02 22:58 formula Haroldo Stenger @ 2009-08-03 10:51 ` Carsten Dominik 2009-08-03 23:53 ` formula Haroldo Stenger 0 siblings, 1 reply; 10+ messages in thread From: Carsten Dominik @ 2009-08-03 10:51 UTC (permalink / raw) To: Haroldo Stenger; +Cc: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-03 10:51 ` formula Carsten Dominik @ 2009-08-03 23:53 ` Haroldo Stenger 2009-08-04 6:07 ` formula Carsten Dominik 0 siblings, 1 reply; 10+ messages in thread From: Haroldo Stenger @ 2009-08-03 23:53 UTC (permalink / raw) To: Carsten Dominik, emacs-orgmode [-- 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-03 23:53 ` formula Haroldo Stenger @ 2009-08-04 6:07 ` Carsten Dominik 2009-08-04 6:28 ` formula Haroldo Stenger 0 siblings, 1 reply; 10+ messages in thread From: Carsten Dominik @ 2009-08-04 6:07 UTC (permalink / raw) To: Haroldo Stenger; +Cc: emacs-orgmode 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 > > ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 6:07 ` formula Carsten Dominik @ 2009-08-04 6:28 ` Haroldo Stenger 2009-08-04 11:40 ` formula Carsten Dominik 0 siblings, 1 reply; 10+ messages in thread From: Haroldo Stenger @ 2009-08-04 6:28 UTC (permalink / raw) To: Carsten Dominik, emacs-orgmode [-- 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 6:28 ` formula Haroldo Stenger @ 2009-08-04 11:40 ` Carsten Dominik 2009-08-04 14:23 ` formula Haroldo Stenger 0 siblings, 1 reply; 10+ messages in thread From: Carsten Dominik @ 2009-08-04 11:40 UTC (permalink / raw) To: Haroldo Stenger; +Cc: emacs-orgmode 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 > >> > >> > > > ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 11:40 ` formula Carsten Dominik @ 2009-08-04 14:23 ` Haroldo Stenger 2009-08-04 14:45 ` formula Carsten Dominik 2009-08-04 14:52 ` formula Nick Dokos 0 siblings, 2 replies; 10+ messages in thread From: Haroldo Stenger @ 2009-08-04 14:23 UTC (permalink / raw) To: Carsten Dominik, emacs-orgmode [-- 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 14:23 ` formula Haroldo Stenger @ 2009-08-04 14:45 ` Carsten Dominik 2009-08-05 23:53 ` formula Haroldo Stenger 2009-08-04 14:52 ` formula Nick Dokos 1 sibling, 1 reply; 10+ messages in thread From: Carsten Dominik @ 2009-08-04 14:45 UTC (permalink / raw) To: Haroldo Stenger; +Cc: emacs-orgmode 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 > >> > >> > > > > > ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 14:45 ` formula Carsten Dominik @ 2009-08-05 23:53 ` Haroldo Stenger 0 siblings, 0 replies; 10+ messages in thread From: Haroldo Stenger @ 2009-08-05 23:53 UTC (permalink / raw) To: emacs-orgmode [-- 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: formula 2009-08-04 14:23 ` formula Haroldo Stenger 2009-08-04 14:45 ` formula Carsten Dominik @ 2009-08-04 14:52 ` Nick Dokos 1 sibling, 0 replies; 10+ messages in thread From: Nick Dokos @ 2009-08-04 14:52 UTC (permalink / raw) To: Haroldo Stenger; +Cc: emacs-orgmode, Carsten Dominik 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 ^ permalink raw reply [flat|nested] 10+ messages in thread
end of thread, other threads:[~2009-08-05 23:53 UTC | newest] Thread overview: 10+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2009-08-02 22:58 formula Haroldo Stenger 2009-08-03 10:51 ` formula Carsten Dominik 2009-08-03 23:53 ` formula Haroldo Stenger 2009-08-04 6:07 ` formula Carsten Dominik 2009-08-04 6:28 ` formula Haroldo Stenger 2009-08-04 11:40 ` formula Carsten Dominik 2009-08-04 14:23 ` formula Haroldo Stenger 2009-08-04 14:45 ` formula Carsten Dominik 2009-08-05 23:53 ` formula Haroldo Stenger 2009-08-04 14:52 ` formula Nick Dokos
Code repositories for project(s) associated with this external index https://git.savannah.gnu.org/cgit/emacs.git https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is an external index of several public inboxes, see mirroring instructions on how to clone and mirror all data and code used by this external index.