[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] [bug] spreadsheet does not replace some fields
From: |
Juan Pechiar |
Subject: |
Re: [O] [bug] spreadsheet does not replace some fields |
Date: |
Wed, 20 Jun 2012 10:47:58 -0300 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
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