From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel E. Doherty <ded-law@ddoherty.net>
Subject: Bug?: Table spreadsheet: Inactive dates
Date: Tue, 25 Sep 2012 19:44:18 -0500
Message-ID: <87a9wdipel.wl%ded-law@ddoherty.net>
Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=US-ASCII
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:37276)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1TGfjl-00036n-U4
	for emacs-orgmode@gnu.org; Tue, 25 Sep 2012 20:44:26 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1TGfjl-0001uz-0M
	for emacs-orgmode@gnu.org; Tue, 25 Sep 2012 20:44:25 -0400
Received: from mail-ie0-f169.google.com ([209.85.223.169]:57992)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ddoherty03@gmail.com>) id 1TGfjk-0001ue-Qw
	for emacs-orgmode@gnu.org; Tue, 25 Sep 2012 20:44:24 -0400
Received: by ied10 with SMTP id 10so110721ied.0
	for <emacs-orgmode@gnu.org>; Tue, 25 Sep 2012 17:44:23 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Org-mode List <emacs-orgmode@gnu.org>


All,

I notice that in a table, I can use active timestamps, do arithmetic
with them, and get meaningful results.  However, if I use inactive
timestamps, I get different results.  I prefer the way active timestamps
work, since I can easily do date arithmetic with them.

The problem with active timestamps is that they pollute the agenda.
Imagine a table with 100 rows of timestammps, all the same date.

* Tables with dates
** Active timestamps
| Begin                  | End                    |     Days |
|------------------------+------------------------+----------|
| <2012-09-24 Mon>       | <2012-09-25 Tue>       |        1 |
| <2012-09-25 Tue 17:50> | <2012-09-25 Tue 19:37> | 0.074305 |
#+TBLFM: $3=@$2-@$1

** Inactive timestamps
| Begin                  | End                    | Days             |
|------------------------+------------------------+------------------|
| [2012-09-24 Mon]       | [2012-09-25 Tue]       | [-1, Tue - Mon]  |
| [2012-09-25 Tue 17:50] | [2012-09-25 Tue 19:37] | [0, 0, 321:1850] |
#+TBLFM: $3=@$2-@$1

It seems to me that they ought to behave the same, but I would normally
want inactiv timestamps when doing calculations.

Regards,

Dan