From mboxrd@z Thu Jan 1 00:00:00 1970 From: gregory mitchell Subject: Re: Showing table formulas in cells Date: Sat, 25 Jul 2009 16:21:15 -0700 Message-ID: <170f0450907251621xb3537b8p3f14e23caf43fa97@mail.gmail.com> References: <170f0450907250025o6a26e69ctdc348cc224f2c62a@mail.gmail.com> <87zlase6z0.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0946876314==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MUqYJ-0001yp-E3 for emacs-orgmode@gnu.org; Sat, 25 Jul 2009 19:21:19 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MUqYH-0001xI-PG for emacs-orgmode@gnu.org; Sat, 25 Jul 2009 19:21:18 -0400 Received: from [199.232.76.173] (port=38221 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MUqYH-0001x7-K2 for emacs-orgmode@gnu.org; Sat, 25 Jul 2009 19:21:17 -0400 Received: from qw-out-1920.google.com ([74.125.92.144]:23424) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MUqYG-00038R-S2 for emacs-orgmode@gnu.org; Sat, 25 Jul 2009 19:21:17 -0400 Received: by qw-out-1920.google.com with SMTP id 5so1574483qwf.24 for ; Sat, 25 Jul 2009 16:21:15 -0700 (PDT) In-Reply-To: <87zlase6z0.fsf@bzg.ath.cx> 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: Bastien Cc: emacs-orgmode@gnu.org --===============0946876314== Content-Type: multipart/alternative; boundary=0016e6475eb43174fe046f8ffadc --0016e6475eb43174fe046f8ffadc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi Bastien, On Sat, Jul 25, 2009 at 3:24 PM, Bastien wrote: > Hi Gregory, > > gregory mitchell writes: > > > I was wondering if anyone has found a way to toggle cells so that > > formulas could be shown/hidden in place of calculated results in > > org-mode tables. > > This is not what you're looking for but perhaps it comes close: the > C-c ' key edits the cell at point in a separate buffer. > I currently use "C-u C-c =" to get the formula of the cell at point in the minibuffer, but it would be nice to extend this to other cells as well. > > Also, since the formulas are already shown below the table, I would > find it somewhat confusing to display them within the cell... > Most dedicated spreadsheets, i.e. excel, have an option to toggle the display of formulas/results in cells. Having all of the formulas at the bottom of a table can get even more confusing with large tables that contain lots of formulas on a single line. > > > Also wanted to test this list since I haven't posted to it yet. > > It works! > > -- Glad that this works! Thanks for the response. > > Bastien > --0016e6475eb43174fe046f8ffadc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Bastien,

On Sat, Jul 25, 2009 at 3:24= PM, Bastien <bastienguerry@googlemail.com> wrote:
Hi Gregory,

gregory mitchell <radiochic= kenwax@gmail.com> writes:

> I was wondering if anyone has found a way to toggle cells so that
> formulas could be shown/hidden in place of calculated results in
> org-mode tables.

This is not what you're looking for but perhaps it comes close: t= he
C-c ' key edits the cell at point in a separate buffer.

I currently use=A0 "C-u C-c =3D"=A0 to get the formula of the cel= l at point in the minibuffer, but it would be nice to extend this to other cells as well.
=A0

Also, since the formulas are already shown below the table, I would
find it somewhat confusing to display them within the cell...


Most dedicated spreadshee= ts, i.e. excel,=A0 have an option to toggle the display of formulas/results=A0 in cells.=A0 Having all of the formulas at the bottom of a table can get even more confusing with large tables that contain lots of formulas on a single line.=A0=A0

=A0

> Also wanted to test this list since I haven't posted to it yet.
It works!

--

Glad that this works!=A0 Thanks for the response. <= br>

=A0Bastien

--0016e6475eb43174fe046f8ffadc-- --===============0946876314== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============0946876314==--