From mboxrd@z Thu Jan  1 00:00:00 1970
From: Juan Pechiar <juan@pechiar.com>
Subject: Re: [bug] spreadsheet does not replace some fields
Date: Wed, 20 Jun 2012 10:47:58 -0300
Message-ID: <20120620134758.GB2280@soloJazz.com>
References: <CALn3zoiBxr8HPT_akc0_Q-a2rTdwzDGWxJP-Uf2K6mbjA60O_w@mail.gmail.com>
Mime-Version: 1.0
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]:36189)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1ShLGZ-00052m-TR
	for emacs-orgmode@gnu.org; Wed, 20 Jun 2012 09:48:17 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1ShLGQ-0003Ni-0P
	for emacs-orgmode@gnu.org; Wed, 20 Jun 2012 09:48:15 -0400
Received: from oproxy8-pub.bluehost.com ([69.89.22.20]:39451)
	by eggs.gnu.org with smtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1ShLGP-0003Lb-GV
	for emacs-orgmode@gnu.org; Wed, 20 Jun 2012 09:48:05 -0400
Content-Disposition: inline
In-Reply-To: <CALn3zoiBxr8HPT_akc0_Q-a2rTdwzDGWxJP-Uf2K6mbjA60O_w@mail.gmail.com>
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: Michael Brand <michael.ch.brand@gmail.com>
Cc: Org Mode <emacs-orgmode@gnu.org>

On Wed, Jun 20, 2012 at 02:26:42PM +0200, Michael Brand wrote:
> Isn't there a nasty spreadsheet bug? I'm quite confused that it has
> not been discovered yet so I start to doubt on my reliability.

Hi, Michael.

This is a feature, not a bug.

>From the manual (section 3.5.6 Column Formulas):

  If the table contains horizontal separator hlines, everything before
  the first such line is considered part of the table header and will
  not be modified by column formulas.

So, you need to add a horizontal separator at the top of your table.
Otherwise the first 2 lines are considered as headers

Regards,
.j.

> - bug:
>   | this field is not replaced | 1 |
>   | this field is not replaced | 2 |
>   |----------------------------+---|
>   | 3                          | 3 |
>   #+TBLFM: $1 = $2
>
>   - last minutes' release_7.8.11-85-g62453c5
>   - at least back to release_7.8.09-555-g323836f
>   - emacs -q, 23.3.1
>
> - expected:
>   | 1 | 1 |
>   | 2 | 2 |
>   |---+---|
>   | 3 | 3 |
>   #+TBLFM: $1 = $2
>
> - this variation works as expected:
>   | 1 | 1 |
>   | 2 | 2 |
>   | 3 | 3 |
>   #+TBLFM: $1 = $2
>
> Michael