From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
Subject: Re: [bug] Assigning "0:00" to cell gives an error
Date: Mon, 30 Apr 2012 16:47:25 +0200
Message-ID: <801un55laa.fsf@somewhere.org>
References: <80pqc7id9u.fsf@somewhere.org>
	<095A94F6-D2B9-40BE-BF04-79F61A62BA02@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org>
In-Reply-To: <095A94F6-D2B9-40BE-BF04-79F61A62BA02-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> (Carsten
	Dominik's message of "Tue, 20 Mar 2012 15:06:24 +0100")
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-mXXj517/zsQ@public.gmane.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode-mXXj517/zsQ@public.gmane.org>
List-Help: <mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org

Hi,

Carsten Dominik wrote:
> On 20.3.2012, at 14:59, Sebastien Vauban wrote:
>> 
>> As shown by this example, we can't assign the value "0:00" to a cell:
>> 
>> | Task    |  HH:MM |
>> |---------+--------|
>> | This    |   1:23 |
>> | Nothing | #ERROR |
>> | That    |   1:23 |
>> #+TBLFM: @2$2=1:23::@3$2=0:00::@4$2=4:56
>
> you can use @3$2=string("0:00")
>
> - Carsten

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

- 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

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")

  Results: org-table-time-seconds-to-string:
  Wrong type argument: stringp, (0 "Number expected")

  (I've explicitly written "na" strings which never got replaced, because of
  this error)

Best regards,
  Seb

-- 
Sebastien Vauban