emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Bastien <bzg@gnu.org>
To: Sebastien Vauban
	<public-wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@plane.gmane.org>
Cc: public-emacs-orgmode-mXXj517/zsQ@plane.gmane.org
Subject: Re: [bug] Assigning "0:00" to cell gives an error
Date: Tue, 01 May 2012 18:39:23 +0200	[thread overview]
Message-ID: <874nrzonyc.fsf@gnu.org> (raw)
In-Reply-To: <801un55laa.fsf@somewhere.org> (Sebastien Vauban's message of "Mon, 30 Apr 2012 16:47:25 +0200")



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

  reply	other threads:[~2012-05-01 16:38 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2012-03-20 13:59 [bug] Assigning "0:00" to cell gives an error Sebastien Vauban
2012-03-20 14:06 ` Carsten Dominik
     [not found]   ` <095A94F6-D2B9-40BE-BF04-79F61A62BA02-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
2012-04-30 14:47     ` Sebastien Vauban
2012-05-01 16:39       ` Bastien [this message]
2012-05-02  9:30         ` Sebastien Vauban
2012-05-05 14:15           ` Bastien
2012-06-04 14:58             ` Sebastien Vauban

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=874nrzonyc.fsf@gnu.org \
    --to=bzg@gnu.org \
    --cc=public-emacs-orgmode-mXXj517/zsQ@plane.gmane.org \
    --cc=public-wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@plane.gmane.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).