emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Carsten Dominik <carsten.dominik@gmail.com>
To: Haroldo Stenger <harold.stenger@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: formula
Date: Tue, 4 Aug 2009 16:45:18 +0200	[thread overview]
Message-ID: <3258ED92-7E35-4CE9-857B-90E00A5401D9@gmail.com> (raw)
In-Reply-To: <3678e0bb0908040723x74413f21qee4a440f41360eaf@mail.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
> >>
> >>
> >
>
>
>

  reply	other threads:[~2009-08-04 14:45 UTC|newest]

Thread overview: 10+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
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             ` Carsten Dominik [this message]
2009-08-05 23:53               ` formula Haroldo Stenger
2009-08-04 14:52             ` formula Nick Dokos

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=3258ED92-7E35-4CE9-857B-90E00A5401D9@gmail.com \
    --to=carsten.dominik@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=harold.stenger@gmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).