From: Carsten Dominik <dominik@science.uva.nl> To: Flávio <flaviostz@gmail.com> Cc: emacs-orgmode@gnu.org Subject: Re: Column Properties Date: Fri, 6 Feb 2009 16:25:21 +0100 [thread overview] Message-ID: <DACAE78A-8EAA-49AD-AA43-B5012E618847@uva.nl> (raw) In-Reply-To: <loom.20090203T101944-400@post.gmane.org> On Feb 3, 2009, at 11:50 AM, Flávio wrote: > I am using COLUMN VIEW to see a summary of worked and estimated hours. > But I am > getting some strange results. > > In one big org file I clocked all my work in different atomic tasks > (The file is mixed with English and Portuguese ). > For example: > > * Apontamento de Horas Gerais > ** Atendimentos / Serviços > *** Estudo Técnico (externo) > *** Suporte Técnico > :CLOCK: > CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] => 5:00 > CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] => 0:41 > CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] => 0:37 > CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] => 0:30 > :END: > **** My Customer > ***** Motor and valves problem ( go down ) > :CLOCK: > CLOCK: [2008-12-01 Mon 13:00]--[2008-12-01 Mon 15:24] => 2:23 > CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] => 0:12 > :END: > ***** 09.00698 - Technical Support > CLOCK: [2009-02-02 Mon 15:15]--[2009-02-02 Mon 16:56] => 1:41 > > Then I decided to start with PROPERTIES for item "09.00698 - > Technical Support", > and my file became: > > * Apontamento de Horas Gerais > :PROPERTIES: > :COLUMNS: %50ITEM %10CLOCKSUM(Clocked) %5Effort(Estimate){:} > %5HourSold(Sold){:} > :ID: apontamento_horas > :END: > ** Atendimentos / Serviços > *** Estudo Técnico (externo) > > *** Suporte Técnico > :CLOCK: > CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] => 5:00 > CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] => 0:41 > CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] => 0:37 > CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] => 0:30 > :END: > **** My Customer > ***** Motor and valves problem ( go down ) > :CLOCK: > CLOCK: [2008-12-01 Mon 13:00]--[2008-12-01 Mon 15:24] => 2:23 > CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] => 0:12 > :END: > ***** 09.00698 - Technical Support > :PROPERTIES: > :Effort: 20:00 > :HourSold: 21:00 > :END: > CLOCK: [2009-02-02 Mon 15:15]--[2009-02-02 Mon 16:56] => 1:41 > > Then I generate a table using the code: > > #+BEGIN: columnview :hlines 2 :vlines t :id "apontamento_horas" > :skip-empty-rows t > > #+END: > > The code works fine and my table is ok, but I have some errors when: > > 1) If I want my CLOCKED column to be the last one and Estimate at > first column, > all clocked values are filled in the first column anyway, although > it is > Estimate. So the solution for this problem was to consider the > CLOCKED always > as the first column. I don't seem to be able to reproduce this behavior. > > > 2) If I consider both Effort and HourSold Properties with the value > of 20:00 > under item "09.00698 - Technical Support", I get an empty column > under Sold in > the summary table. So the solution for this problem was to consider > the Effort > 20:00 and Sold 21:00 then I get the correct summary. Uhhh, very bad bug indeed. Fixed, thanks for finding that one! - Carsten
next prev parent reply other threads:[~2009-02-06 15:25 UTC|newest] Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top 2009-02-03 10:50 Flávio 2009-02-06 15:25 ` Carsten Dominik [this message] 2009-02-03 11:42 Giovanni Ridolfi
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=DACAE78A-8EAA-49AD-AA43-B5012E618847@uva.nl \ --to=dominik@science.uva.nl \ --cc=emacs-orgmode@gnu.org \ --cc=flaviostz@gmail.com \ --subject='Re: Column Properties' \ /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
Code repositories for project(s) associated with this 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).