From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: Re: Referencing a cell from a clockview table looks impossible Date: Tue, 20 Mar 2012 14:18:11 +0100 Message-ID: <80ty1jif70.fsf@somewhere.org> References: <80zkbb1pfg.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: 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 Hello, I just found the reason: it's because *the "Total time" is in bold*, with `*' before and after the total (for example: *3:33*). * Design Some tasks with CLOCK lines, for showing the problem. ** TODO Do this :LOGBOOK: CLOCK: [2012-03-19 Mon 09:00]--[2012-03-19 Mon 10:11] => 1:11 :END: * Develop ** TODO Do that :LOGBOOK: CLOCK: [2012-03-19 Mon 10:00]--[2012-03-19 Mon 12:22] => 2:22 CLOCK: [2012-03-20 Tue 10:01]--[2012-03-20 Tue 12:35] => 2:34 :END: * Report ** Dynamic block The dynamic block captures the fact that I've worked 3:33 hours yesterday, on 2 different tasks. #+TBLNAME: hours-yesterday #+BEGIN: clocktable :maxlevel 4 :scope file :block yesterday Clock summary at [2012-03-20 Tue 14:12], for Monday, March 19, 2012. | Headline | Time | | |--------------+------+------| | *Total time* | *3:33* | | |--------------+------+------| | Design | 1:11 | | | TODO Do this | | 1:11 | | Develop | 2:22 | | | TODO Do that | | 2:22 | #+END: ** Table with remote reference As said above, referencing an "regular" (not bold) total does work, as in: | Tasks | HH:MM | Float | USD | |-----------+-------+-------+---------| | Yesterday | 1:11 | 1.18 | 30:11 | |-----------+-------+-------+---------| | | Time | 1.18 | 30 Time | #+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::$4=$2*30::@2$2=remote(hours-yesterday,@3$2)::@3$3=vsum(@-I..@-II) But the real grand total is not referencable: | Tasks | HH:MM | Float | USD | |-----------+--------+-------+--------| | Yesterday | #ERROR | 0.00 | #ERROR | |-----------+--------+-------+--------| | | | 0. | 0 | #+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::$4=$2*30::@2$2=remote(hours-yesterday,@2$2)::@3$3=vsum(@-I..@-II) Any idea how to work around this? Best regards, Seb -- Sebastien Vauban