Re: [O] funny remote time/duration values
On Mon, 7 Jan 2019 11:29:15 +0100, Robert Klein wrote: > > Hi, > > when using values (time/duration) from a remote table I sometimes get > funny values: > > > #+name: teta > | 4:50 | > > > | 2:25 | > #+TBLFM: @1$1=remote(teta,@1$1) > > > When I set e.g. 7:50 in “teta” the same value shows up in the second > table (after C-u C-c C-c). > > For 1:00 in “teta” I get #ERROR in the second table. same in all cases > with a 0 in front (04:50, 07:50, 01:00). > > > Org-version is 9.2 > > Any ideas? It seems they are treated as (calc) fractions and simplified. -- Michał Politowski
Re: [O] funny remote time/duration values
On Mon, 7 Jan 2019 11:29:15 +0100, Robert Klein wrote: > > Hi, > > when using values (time/duration) from a remote table I sometimes get > funny values: > > > #+name: teta > | 4:50 | > > > | 2:25 | > #+TBLFM: @1$1=remote(teta,@1$1) > > > When I set e.g. 7:50 in “teta” the same value shows up in the second > table (after C-u C-c C-c). > > For 1:00 in “teta” I get #ERROR in the second table. same in all cases > with a 0 in front (04:50, 07:50, 01:00). > > > Org-version is 9.2 > > Any ideas? It seems you need the 'T' flag here, as described in "Duration and time values" in the org manual: #+TBLFM: @1$1=remote(teta,@1$1);T -- Michał Politowski
Re: [O] funny remote time/duration values
On Monday, 7 Jan 2019 at 10:58, Robert Klein wrote: > Hi, > > when using values (time/duration) from a remote table I sometimes get > funny values: > > #+name: teta > | 4:50 | > > | 2:25 | > #+TBLFM: @1$1=remote(teta,@1$1) Note that x:y in Emacs calc (which is what org uses for the spreadsheet elements of tables) is a ratio so 4:50 *is* the same as 2:25. If you have times, you'll need to use different notation (@,',", I believe). -- Eric S Fraga via Emacs 27.0.50, Org release_9.1.14-1035-gfeb442
[O] funny remote time/duration values
Hi, when using values (time/duration) from a remote table I sometimes get funny values: #+name: teta | 4:50 | | 2:25 | #+TBLFM: @1$1=remote(teta,@1$1) When I set e.g. 7:50 in “teta” the same value shows up in the second table (after C-u C-c C-c). For 1:00 in “teta” I get #ERROR in the second table. same in all cases with a 0 in front (04:50, 07:50, 01:00). Org-version is 9.2 Any ideas? Thanks and best regards Robert -- Robert Klein UNIX Operations Max Planck-Institut für Polymerforschung Anschrift: Ackermannweg 10, 55128 Mainz
[O] funny remote time/duration values
Hi, when using values (time/duration) from a remote table I sometimes get funny values: #+name: teta | 4:50 | | 2:25 | #+TBLFM: @1$1=remote(teta,@1$1) When I set e.g. 7:50 in “teta” the same value shows up in the second table (after C-u C-c C-c). For 1:00 in “teta” I get #ERROR in the second table. same in all cases with a 0 in front (04:50, 07:50, 01:00). Org-version is 9.2 Any ideas? Thanks and best regards Robert