Re: [O] [bug] Assigning 0:00 to cell gives an error
Hi Bastien, Bastien wrote: Sebastien Vauban writes: Let's come back to time values: @2$2=1:23;t means, for me, that: - the value 1:23 should be assigned to the cell - that value should be formatted as a fraction. Hence, I'd expect to see `1.38' (and not `0:00'). This works correctly now, thanks. I confirm that the above case works correctly now, as shown here: | Task| HH:MM | |-+---| | Foo | 1:23 | | Bar | 1.38 | | Nothing | 0:00 | #+TBLFM: @2$2=1:23::@3$2=@2$2;t::@4$2=string(0:00) Thanks. Best regards, Seb -- Sebastien Vauban
Re: [O] [bug] Assigning 0:00 to cell gives an error
Hi Sébastien, Sebastien Vauban wxhgmqzgwmuf-genee64ty+gs+fvcfc7...@public.gmane.org writes: Let's come back to time values: @2$2=1:23;t means, for me, that: - the value 1:23 should be assigned to the cell - that value should be formatted as a fraction. Hence, I'd expect to see `1.38' (and not `0:00'). This works correctly now, thanks. -- Bastien
Re: [O] [bug] Assigning 0:00 to cell gives an error
Hi Bastien, Bastien wrote: 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. I did not express myself clearly, then. Sorry for that. The assignment is done through the `=' sign. This is the what part of the equation, that is the value which is assigned to the cell. The flags are the how part of the assignment. At least, they should tell about the formatting of the value (like for numeric assignments), but they don't (for time assignments). Let's compare with numerics: @2$2=3.141592;%.2f The value just follows the equal sign: pi is *what* to output in the cell. The flag (here, `%.2f') says *how* to output it, in this case limited to 2 decimals. Let's come back to time values: @2$2=1:23;t means, for me, that: - the value 1:23 should be assigned to the cell - that value should be formatted as a fraction. Hence, I'd expect to see `1.38' (and not `0:00'). - 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. Best regards, Seb -- Sebastien Vauban
Re: [O] [bug] Assigning 0:00 to cell gives an error
Hi Sébastien, Sebastien Vauban wxhgmqzgwmuf-genee64ty+gs+fvcfc7...@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
Re: [O] [bug] Assigning 0:00 to cell gives an error
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
[O] [bug] Assigning 0:00 to cell gives an error
Hello, 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 Best regards, Seb -- Sebastien Vauban
Re: [O] [bug] Assigning 0:00 to cell gives an error
Hi Sebastien, you can use @3$2=string(0:00) - Carsten On 20.3.2012, at 14:59, Sebastien Vauban wrote: Hello, 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 Best regards, Seb -- Sebastien Vauban