From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" 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: 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." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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