From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Column Properties Date: Fri, 6 Feb 2009 16:25:21 +0100 Message-ID: References: Mime-Version: 1.0 (Apple Message framework v930.3) Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LVSa8-00040L-Pp for emacs-orgmode@gnu.org; Fri, 06 Feb 2009 10:25:28 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LVSa7-0003zM-8U for emacs-orgmode@gnu.org; Fri, 06 Feb 2009 10:25:28 -0500 Received: from [199.232.76.173] (port=39704 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LVSa6-0003zH-UH for emacs-orgmode@gnu.org; Fri, 06 Feb 2009 10:25:26 -0500 Received: from mail-ew0-f20.google.com ([209.85.219.20]:34267) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LVSa6-0000Ak-F1 for emacs-orgmode@gnu.org; Fri, 06 Feb 2009 10:25:26 -0500 Received: by ewy13 with SMTP id 13so1421110ewy.18 for ; Fri, 06 Feb 2009 07:25:25 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: =?ISO-8859-1?Q?Fl=E1vio?= Cc: emacs-orgmode@gnu.org On Feb 3, 2009, at 11:50 AM, Fl=E1vio 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=E7os > *** Estudo T=E9cnico (externo) > *** Suporte T=E9cnico > :CLOCK: > CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] =3D> 5:00 > CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] =3D> 0:41 > CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] =3D> 0:37 > CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] =3D> 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] =3D> 2:23 > CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] =3D> 0:12 > :END: > ***** 09.00698 - Technical Support > CLOCK: [2009-02-02 Mon 15:15]--[2009-02-02 Mon 16:56] =3D> 1:41 > > Then I decided to start with PROPERTIES for item "09.00698 - =20 > 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=E7os > *** Estudo T=E9cnico (externo) > > *** Suporte T=E9cnico > :CLOCK: > CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] =3D> 5:00 > CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] =3D> 0:41 > CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] =3D> 0:37 > CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] =3D> 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] =3D> 2:23 > CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] =3D> 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] =3D> 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 =20 > first column, > all clocked values are filled in the first column anyway, although =20 > it is > Estimate. So the solution for this problem was to consider the =20 > 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 =20= > of 20:00 > under item "09.00698 - Technical Support", I get an empty column =20 > under Sold in > the summary table. So the solution for this problem was to consider =20= > 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