From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Subject: Re: Table questions Date: Tue, 19 Dec 2006 10:54:31 -0600 Message-ID: <1x3b7bbzco.fsf@bass.biostat.umn.edu> References: <1oac1qih6j.fsf@bass.biostat.umn.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Gwmhd-0005oQ-HC for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 16:40:49 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Gwmhc-0005nd-2j for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 16:40:49 -0500 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Gwmhb-0005na-U0 for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 16:40:47 -0500 Received: from [199.232.41.67] (helo=mx20.gnu.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.52) id 1GwkDJ-0005X5-NL for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 14:01:21 -0500 Received: from [80.91.229.2] (helo=ciao.gmane.org) by mx20.gnu.org with esmtp (Exim 4.52) id 1GwiHz-0008Pa-He for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 11:58:03 -0500 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1GwiEn-00010v-0r for emacs-orgmode@gnu.org; Tue, 19 Dec 2006 17:54:45 +0100 Received: from bass.biostat.umn.edu ([160.94.208.81]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 19 Dec 2006 17:54:45 +0100 Received: from wuolong by bass.biostat.umn.edu with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 19 Dec 2006 17:54:45 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org On 18 Dec 2006, Carsten Dominik wrote: > On Dec 14, 2006, at 17:19, Michael wrote: > > 1. In table calculation, how to refer to a cell in a different column and > > different row? Specifically, I want column 8 row 5 to be the ratio of > > column 7 row 5 and column 7 row 4. > You cannot, at least currently. I am not sure how well this would > work, because the table editor makes it very easy to swap rows, columns, > to add and delete columns, and such references would become invalid > unless one would carefully track these changes. I agree that you probably don't want to exactly replace the full power of Excel. But this simple feature makes it possible to keep track of simple data. I won't mind having to redo the formula after row swapping etc., which I think won't happen so often for a given table anyway. > Having said this, I do want to do a bit more in this direction, but > this is nowhere near completion. > > 2. I think the table minor mode would be a fantastic tool in editing tables > > in a LaTeX file. I wonder whether it is possible to let orgtbl recognize > > \begin{tabular}\end{tabular} and use & as column delimiter rather than | > > (also respect end of line \\)? > Yes, I think it would and I have been thinking to make this possible. > However, once I allow this, people will want to use \multicolumn, and > this seems for me to be beyond the scope. I think you can ignore the rows with multicolumn in it, which would satisfy most people I imagine. > Have you tried > M-x align-current RET > in a LaTeX table? It does wonders. I'll try that. Thanks very much for all the hard work, Michael