From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bastien <bzg@gnu.org>
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: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:37988)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <public@plane.gmane.org>) 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 <public@plane.gmane.org>) 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 <public@plane.gmane.org>) 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 <public@plane.gmane.org>) 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." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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 <public-wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@plane.gmane.org>
Cc: public-emacs-orgmode-mXXj517/zsQ@plane.gmane.org



Hi Sébastien,

"Sebastien Vauban"
<wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org> 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