From mboxrd@z Thu Jan  1 00:00:00 1970
From: Guido Van Hoecke <guivho@gmail.com>
Subject: Unexpected relative reference behaviour
Date: Thu, 09 May 2013 11:04:30 +0200
Message-ID: <m2ppx0y15t.fsf@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:41748)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <guivho@gmail.com>) id 1UaMmF-0004Si-8H
	for emacs-orgmode@gnu.org; Thu, 09 May 2013 05:04:40 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <guivho@gmail.com>) id 1UaMm9-0006E2-Sb
	for emacs-orgmode@gnu.org; Thu, 09 May 2013 05:04:39 -0400
Received: from mail-we0-x22f.google.com ([2a00:1450:400c:c03::22f]:42374)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <guivho@gmail.com>) id 1UaMm9-0006Dj-K2
	for emacs-orgmode@gnu.org; Thu, 09 May 2013 05:04:33 -0400
Received: by mail-we0-f175.google.com with SMTP id p57so2734327wes.34
	for <emacs-orgmode@gnu.org>; Thu, 09 May 2013 02:04:32 -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: orgmode <emacs-orgmode@gnu.org>

Hi,

Using this table

| Grand total      | 19.55 |    |
|------------------+-------+----|
| <2013-05-09 Thu> |  1.23 | v2 |
| <2013-05-04 Sat> |  5.76 | v1 |
| <2013-05-14 Tue> |  3.78 | v1 |
| <2013-04-24 Wed> |  8.78 | v2 |
#+TBLFM: @1$2=vsum(@I..@>);%.2f

I want the formula to be relative to the first hline so, according to
the manual, it should be possible to change @1$2 into @I-1$2

| Grand total      | 19.55 |    |
|------------------+-------+----|
| <2013-05-09 Thu> |  1.23 | v2 |
| <2013-05-04 Sat> |  5.76 | v1 |
| <2013-05-14 Tue> |  3.78 | v1 |
| <2013-04-24 Wed> |  8.78 | v2 |
#+TBLFM: @I-1$2=vsum(@I..@>);%.2f

But this produces very strange results.
Hitting C-c * with the cursor in @>$2 produces:

| Grand total      | 19.55 |    |
|------------------+-------+----|
| <2013-05-09 Thu> |  1.23 | v2 |
| <2013-05-04 Sat> |  5.76 | v1 |
| <2013-05-14 Tue> |  3.78 | v1 |
| 2939977.00       | 19.55 | v2 |
#+TBLFM: @I-1$2=vsum(@I..@>);%.2f

Why does it change <2013-04-24 Wed> into 2939977.0, and 8.78 into 19.55?

Hitting C-u C-c * with the cursor in @>$2 messes up the complete table
and results in:
|       0.00 |  30.32 |    |
|------------+--------+----|
|       0.00 |  30.32 | v2 |
| 4409973.00 |  59.41 | v1 |
|       0.00 | 113.06 | v1 |
| 7349950.00 | 222.34 | v2 |
#+TBLFM: @I-1$2=vsum(@I..@>);%.2f

Am I correct to assume that this is at least unexpected, and probably
erroneous behaviour?


Guido

--
"Consider a spherical bear, in simple harmonic motion..."
		-- Professor in the UCB physics department