From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?ISO-8859-1?Q?Gustav_Wikstr=F6m?= Subject: Bug in calculations with durations and time values in tables Date: Thu, 1 Sep 2011 11:50:14 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001517402bfaeb54ae04abde2be8 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:40054) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qz3ub-000717-D0 for emacs-orgmode@gnu.org; Thu, 01 Sep 2011 05:50:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Qz3ua-0001Z3-DF for emacs-orgmode@gnu.org; Thu, 01 Sep 2011 05:50:17 -0400 Received: from mail-fx0-f41.google.com ([209.85.161.41]:33996) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qz3ua-0001Ys-6y for emacs-orgmode@gnu.org; Thu, 01 Sep 2011 05:50:16 -0400 Received: by fxg9 with SMTP id 9so607080fxg.0 for ; Thu, 01 Sep 2011 02:50:14 -0700 (PDT) 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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --001517402bfaeb54ae04abde2be8 Content-Type: text/plain; charset=ISO-8859-1 Hello, just a small bug-report. The following does not seem right: | First | Second | Result | |----------+-----------+-----------| | 00:00:00 | -00:10:10 | -01:49:50 | #+TBLFM: $3='(+ $1..$2);T | First | Second | Result | |----------+-----------+--------| | 00:00:00 | -00:10:10 | -0.17 | #+TBLFM: $3='(+ $1..$2);t | First | Second | Result | |----------+-----------+-----------| | 00:00:00 | -02:01:00 | -03:59:00 | #+TBLFM: $3='(+ $1..$2);T | First | Second | Result | |----------+-----------+--------| | 00:00:00 | -02:01:00 | -2.02 | #+TBLFM: $3='(+ $1..$2);t Somehow, when the result of a time-calculation with minutes and seconds goes negative the result gets an additional negative two hours added (with the minutes and seconds removed from these two hours)... This seems to be a problem when doing calculations with the suffix ;T. ;t works as intended in this respect. Regards Gustav --001517402bfaeb54ae04abde2be8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello, just a small bug-report. The following does not seem right:

=
| =A0 =A0First | =A0 =A0Second | =A0 =A0Result |
<= div>|----------+-----------+-----------|
| 00:00:00 | -00:10:10 |= -01:49:50 |
#+TBLFM: $3=3D'(+ $1..$2);T

=
| =A0 =A0First | =A0 =A0Second | Result |
|----------+-----------+--------|
| 00:00:00 | -00:10:10 | = =A0-0.17 |
#+TBLFM: $3=3D'(+ $1..$2);t

| =A0 =A0First | =A0 =A0Second | =A0 =A0Result |
|----------+-= ----------+-----------|
| 00:00:00 | -02:01:00 | -03:59:00 |
#+TBLFM: $3=3D'(+ $= 1..$2);T

| =A0 =A0First | =A0 =A0Second | Result |=
|----------+-----------+--------|
| 00:00:00 | -02:01:= 00 | =A0-2.02 |
#+TBLFM: $3=3D'(+ $1..$2);t

=

Somehow, when the result of= a time-calculation with minutes and seconds goes negative the result gets = an additional negative two hours added (with the minutes and seconds remove= d from these two hours)... This seems to be a problem when doing calculatio= ns with the suffix ;T.

;t works as intended in this respect.
<= font class=3D"Apple-style-span" face=3D"arial, helvetica, sans-serif">
Regards
Gustav
--001517402bfaeb54ae04abde2be8--