Re: [bug] spreadsheet does not replace some fields

[Juan Pechiar <juan@pechiar.com>]

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