From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?b?RmzDoXZpbw==?= Subject: Column Properties Date: Tue, 3 Feb 2009 10:50:13 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LUIrT-0007up-EU for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 05:50:35 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LUIrQ-0007uZ-Qg for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 05:50:34 -0500 Received: from [199.232.76.173] (port=58388 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LUIrQ-0007uW-DD for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 05:50:32 -0500 Received: from main.gmane.org ([80.91.229.2]:34818 helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LUIrP-0007Nx-Rb for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 05:50:32 -0500 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1LUIrG-0002bC-Kf for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 10:50:23 +0000 Received: from 200-225-219-189.static.ctbctelecom.com.br ([200.225.219.189]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 03 Feb 2009 10:50:22 +0000 Received: from flaviostz by 200-225-219-189.static.ctbctelecom.com.br with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 03 Feb 2009 10:50:22 +0000 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: emacs-orgmode@gnu.org 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. 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. I am using org-mode 6.12b and emacs 22.2.1. Is it a real problem or I am doing anything wrong? Regards, Flávio.