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