From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Cecil Westerhof Newsgroups: gmane.emacs.help Subject: Re: Problem with sum function in table in org-mode Date: Fri, 08 Jun 2007 09:45:59 +0200 Message-ID: <46690937$0$329$e4fe514c@news.xs4all.nl> References: <46679539$0$328$e4fe514c@news.xs4all.nl> <1181200375.838839.319610@k79g2000hse.googlegroups.com> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Trace: sea.gmane.org 1181292080 20334 80.91.229.12 (8 Jun 2007 08:41:20 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Fri, 8 Jun 2007 08:41:20 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Jun 08 10:41:18 2007 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1Hwa1x-0005cr-9e for geh-help-gnu-emacs@m.gmane.org; Fri, 08 Jun 2007 10:41:13 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Hwa1r-0005hn-MR for geh-help-gnu-emacs@m.gmane.org; Fri, 08 Jun 2007 04:41:07 -0400 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!xs4all!transit2.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: KNode/0.8.0 Original-Lines: 26 Original-NNTP-Posting-Host: 213.84.157.201 Original-X-Trace: 1181288759 news.xs4all.nl 329 [::ffff:213.84.157.201]:18350 Original-X-Complaints-To: abuse@xs4all.nl Original-Xref: shelby.stanford.edu gnu.emacs.help:149188 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:44772 Archived-At: carsten.dominik@gmail.com wrote: > On Jun 7, 7:18 am, Cecil Westerhof wrote: >> I have the following table inorg-mode: >> >> |--------+------------------------+-------+----------| >> | client | hours | tarif | amount | >> |--------+------------------------+-------+----------| >> | A | 12.50 | 75 | 937.50 | >> | B | 16.00 | 85 | 1360.00 | >> | C | 73.50 | 100 | 7350.00 | >> | D | 13.50 | 125 | 1687.50 | >> |--------+------------------------+-------+----------| >> | Total | :=vsum(@II..@III);%.2f | | 11335.00 | >> |--------+------------------------+-------+----------| >> #+TBLFM: $4=$2*$3;%.2f::@6$4=vsum(@II..@III);%.2f >> >> The total in the amount column works without a problem, but in the hours >> column it does not work. What is going wrong here? > > Go into the table field with the formula and press either TAB or C-c C- > c. That works. I tried 'C-c *' what did work on the other fields, but not on this one. Well, I have a workaround now. ;=}