From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: [bug] Negating time changes its value Date: Mon, 30 Apr 2012 16:25:49 +0200 Message-ID: <80ehr55maa.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: 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-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hello, Taking the opposite of a time (that is, "putting" a minus sign in front of it) changes its value... Here, a quick ECM to demonstrate the above: * Grand total #+TBLNAME: GrandTot | Total | 232:11 | * Other total #+TBLNAME: OtherTot | Total | 158:07 | * Computation ** OK The "other total time" is to be divided by 2, and substracted from the "grand total time". | | Time | |--------------------------+--------| | Grand total | 232:11 | | - Other total / 2 | 79:03 | |--------------------------+--------| | = Total to be considered | 153:08 | #+TBLFM: @2$2=remote(GrandTot,@1$2);T::@3$2=remote(OtherTot,@1$2)/2;T::@4$2=@2-@3;T That's correct. ** Not OK However, I would like to clearly state that the amounts do no add, by having a minus sign in the time column: | | Time | |--------------------------+--------| | Grand total | 232:11 | | - Other total / 2 | -80:56 | |--------------------------+--------| | = Total to be considered | 151:15 | #+TBLFM: @2$2=remote(GrandTot,@1$2);T::@3$2=-remote(OtherTot,@1$2)/2;T::@4$2=@2+@3;T Whoops! Not the same results... Other variations also fail: | | Time | |--------------------------+--------| | Grand total | 232:11 | | - Other total / 2 | -80:56 | |--------------------------+--------| | = Total to be considered | 151:15 | #+TBLFM: @2$2=remote(GrandTot,@1$2);T::@3$2=remote(OtherTot,@1$2)/-2;T::@4$2=@2+@3;T or | | Time | |--------------------------+--------| | Grand total | 232:11 | | - Other total / 2 | -80:56 | |--------------------------+--------| | = Total to be considered | 151:15 | #+TBLFM: @2$2=remote(GrandTot,@1$2);T::@3$2=remote(OtherTot,@1$2)/2*-1;T::@4$2=@2+@3;T Best regards, Seb -- Sebastien Vauban