From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rainer Stengele Subject: Bug in the sorting of clocktables with ":sort (4 . ?T)" for clock sums over "100:00" hours Date: Thu, 24 Aug 2017 16:26:22 +0200 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55679) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dkt60-0002CO-W2 for emacs-orgmode@gnu.org; Thu, 24 Aug 2017 10:26:58 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dkt5x-0000QX-Kl for emacs-orgmode@gnu.org; Thu, 24 Aug 2017 10:26:56 -0400 Received: from [195.159.176.226] (port=44622 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dkt5x-0000QB-72 for emacs-orgmode@gnu.org; Thu, 24 Aug 2017 10:26:53 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1dkt5R-0007Qw-V1 for emacs-orgmode@gnu.org; Thu, 24 Aug 2017 16:26:21 +0200 Content-Language: de-DE-1901 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@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Hi, I may have found a bug in the sorting of clocktables. I am summing up clocked time over time periods. As long as the clocksum is under "100:00" (6 characters including ":") sorting seems to be ok: #+BEGIN: clocktable :maxlevel 1 :properties ("CATEGORY") :fileskip0 t :scope agenda-with-archives :tstart "<2017-01-01 So 00:00>" :tend "<2017-01-20 Fr 00:00>" :sort (4 . ?T) #+CAPTION: Clock summary at [2017-08-24 Do 15:04] | File | CATEGORY | Headline | Time | |-----------------------+-------------+--------------+---------| | | ALL | *Total time* | *97:30* | |-----------------------+-------------+--------------+---------| | Projectmanagement.org | | *File time* | *96:45* | | | annonymised | annonymised | 24:45 | | | annonymised | annonymised | 17:45 | | | annonymised | annonymised | 10:45 | | | annonymised | annonymised | 8:00 | | | annonymised | annonymised | 7:45 | | | annonymised | annonymised | 5:00 | | | annonymised | annonymised | 4:00 | | | annonymised | annonymised | 3:45 | | | annonymised | annonymised | 2:00 | | | annonymised | annonymised | 2:00 | | | annonymised | annonymised | 1:45 | | | annonymised | annonymised | 1:45 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | |-----------------------+-------------+--------------+---------| | FILE2.org | | *File time* | *0:45* | | | annonymised | annonymised | 0:45 | #+END: As soon as the sum grows higher than 100:00 sorting is corrupted: #+BEGIN: clocktable :maxlevel 1 :properties ("CATEGORY") :fileskip0 t :scope agenda-with-archives :tstart "<2017-01-01 So 00:00>" :tend "<2017-01-23 Mo 00:00>" :sort (4 . ?T) #+CAPTION: Clock summary at [2017-08-24 Do 16:14] | File | CATEGORY | Headline | Time | |-----------------------+-------------+--------------+----------| | | ALL | *Total time* | *104:45* | |-----------------------+-------------+--------------+----------| | | annonymised | annonymised | 28:00 | | | annonymised | annonymised | 18:45 | | | annonymised | annonymised | 10:45 | | | annonymised | annonymised | 8:00 | | | annonymised | annonymised | 8:00 | | | annonymised | annonymised | 7:15 | | Projectmanagement.org | | *File time* | *104:00* | | | annonymised | annonymised | 4:00 | | | annonymised | annonymised | 3:45 | | | annonymised | annonymised | 2:00 | | | annonymised | annonymised | 2:00 | | | annonymised | annonymised | 1:45 | | | annonymised | annonymised | 1:45 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:30 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | |-----------------------+-------------+--------------+----------| | FILE2.org | | *File time* | *0:45* | | | annonymised | annonymised | 0:45 | #+END: Another example with a longer time period which is more corrupted and might help to identify the reason: #+BEGIN: clocktable :maxlevel 1 :properties ("CATEGORY") :fileskip0 t :scope agenda-with-archives :tstart "<2017-01-01 So 00:00>" :tend "<2017-03-23 Do 00:00>" :sort (4 . ?T) #+CAPTION: Clock summary at [2017-08-24 Do 16:23] | File | CATEGORY | Headline | Time | |-----------------------+-------------+--------------+----------| | | ALL | *Total time* | *432:45* | |-----------------------+-------------+--------------+----------| | | annonymised | annonymised | 75:00 | | | annonymised | annonymised | 50:00 | | | annonymised | annonymised | 37:00 | | Projectmanagement.org | | *File time* | *432:00* | | | annonymised | annonymised | 31:30 | | | annonymised | annonymised | 23:00 | | | annonymised | annonymised | 12:45 | | | annonymised | annonymised | 12:45 | | | annonymised | annonymised | 12:30 | | | annonymised | annonymised | 10:45 | | | annonymised | annonymised | 6:30 | | | annonymised | annonymised | 5:45 | | | annonymised | annonymised | 5:30 | | | annonymised | annonymised | 5:30 | | | annonymised | annonymised | 4:45 | | | annonymised | annonymised | 104:15 | | | annonymised | annonymised | 3:45 | | | annonymised | annonymised | 3:30 | | | annonymised | annonymised | 3:30 | | | annonymised | annonymised | 3:15 | | | annonymised | annonymised | 3:00 | | | annonymised | annonymised | 2:45 | | | annonymised | annonymised | 1:30 | | | annonymised | annonymised | 1:30 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 1:15 | | | annonymised | annonymised | 1:00 | | | annonymised | annonymised | 1:00 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:45 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | | | annonymised | annonymised | 0:15 | |-----------------------+-------------+--------------+----------| | DIPLAN.org | | *File time* | *0:45* | | | annonymised | annonymised | 0:45 | #+END: Org mode version 9.0.9 (release_9.0.9-795-gb47de2.dirty This worked in older versions, not sure maybe when it changed. Does anybody know if the sorting has changed? Any fix possible? Thank you. Regards, Rainer