From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bastien Subject: Re: [bug] Assigning "0:00" to cell gives an error Date: Tue, 01 May 2012 18:39:23 +0200 Message-ID: <874nrzonyc.fsf@gnu.org> References: <80pqc7id9u.fsf@somewhere.org> <095A94F6-D2B9-40BE-BF04-79F61A62BA02@gmail.com> <801un55laa.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([208.118.235.92]:37988) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SPG64-0001nW-FQ for emacs-orgmode@gnu.org; Tue, 01 May 2012 12:38:41 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SPG62-0008Od-Ci for emacs-orgmode@gnu.org; Tue, 01 May 2012 12:38:40 -0400 Received: from plane.gmane.org ([80.91.229.3]:42585) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SPG62-0008OZ-3O for emacs-orgmode@gnu.org; Tue, 01 May 2012 12:38:38 -0400 Received: from public by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1SPG5u-0005AR-7Y for emacs-orgmode@gnu.org; Tue, 01 May 2012 18:38:30 +0200 In-Reply-To: <801un55laa.fsf@somewhere.org> (Sebastien Vauban's message of "Mon, 30 Apr 2012 16:47:25 +0200") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Sebastien Vauban Cc: public-emacs-orgmode-mXXj517/zsQ@plane.gmane.org Hi Sébastien, "Sebastien Vauban" writes: > We can assign the value "0:00" to a cell via the string function: > > | Task | HH:MM | > |---------+-------| > | This | 1:23 | > | Nothing | 0:00 | > | That | 4:56 | > #+TBLFM: @2$2=1:23::@3$2=string("0:00")::@4$2=string("4:56") > > but, *when giving the value via the table formula* > > - we can't convert any time (0:00 or H:MM) to a fractional time: > > | Task | HH:MM | > |---------+-------| > | This | 0.00 | > | Nothing | na | > | That | na | > #+TBLFM: @2$2=1:23;t::@3$2=string("0:00");t::@4$2=string("4:56");t The :t and :T flags are not assigning a value to a cell. > - we can't confirm that its format must be H:MM > > | Task | HH:MM | > |---------+-------| > | This | 0:00 | > | Nothing | na | > | That | na | > #+TBLFM: @2$2=1:23;T::@3$2=string("0:00");T::@4$2=string("4:56");T ... same here. > Those problems do arise in both ways of assigning a time to a cell: > > - via the "common" way: @2$2=1:23 > > Results: 0.00 > > - via the "string" function: @4$2=string("4:56") The @4$2=string("4:56") works fine here, without any flag. -- Bastien