Re: [O] [BUG] Table not recomputed (incorrect results)
Hi Carsten, Carsten Dominik wrote: On 10.9.2013, at 04:32, Sebastien Vauban sva-n...@mygooglest.com wrote: I'm loosing my latin with the following table, which Org declares as converged or already stable. --8---cut here---start-8--- #+TITLE: Birthday * Commande | mini sandwiches | 261 | 1.00 | 260.00 | | rauwkostchotels | 2 | 36. | 72.00 | | koude hapjes| 130 | | 0.00 | | dessertjes (in hapjes glaasjes) | 90 |3 | 0.00 | |-+-+--+| | total | | | 332. | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) --8---cut here---end---8--- Obviously, if you look at the amounts, it isn't correct... The first four lines are all above the first hline and are therefore treated as header and are exempt from calculation. Formular applying to these fields are ignored. Whoa. Did not know that... (or already forgotten about!) Add a header line to the table: OK, thanks! Best regards, Seb -- Sebastien Vauban
Re: [O] [BUG] Table not recomputed (incorrect results)
On 10.9.2013, at 09:49, Sebastien Vauban sva-n...@mygooglest.com wrote: Hi Carsten, Carsten Dominik wrote: On 10.9.2013, at 04:32, Sebastien Vauban sva-n...@mygooglest.com wrote: I'm loosing my latin with the following table, which Org declares as converged or already stable. --8---cut here---start-8--- #+TITLE: Birthday * Commande | mini sandwiches | 261 | 1.00 | 260.00 | | rauwkostchotels | 2 | 36. | 72.00 | | koude hapjes| 130 | | 0.00 | | dessertjes (in hapjes glaasjes) | 90 |3 | 0.00 | |-+-+--+| | total | | | 332. | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) --8---cut here---end---8--- Obviously, if you look at the amounts, it isn't correct... The first four lines are all above the first hline and are therefore treated as header and are exempt from calculation. Formular applying to these fields are ignored. Whoa. Did not know that... (or already forgotten about!) It has to be like this, otherwise any column formula would destroy the header! - Carsten Add a header line to the table: OK, thanks! Best regards, Seb -- Sebastien Vauban signature.asc Description: Message signed with OpenPGP using GPGMail
[O] [BUG] Table not recomputed (incorrect results)
Hello, I'm loosing my latin with the following table, which Org declares as converged or already stable. --8---cut here---start-8--- #+TITLE: Birthday * Commande | mini sandwiches | 261 | 1.00 | 260.00 | | rauwkostchotels | 2 | 36. | 72.00 | | koude hapjes| 130 | | 0.00 | | dessertjes (in hapjes glaasjes) | 90 |3 | 0.00 | |-+-+--+| | total | | | 332. | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) Total paid: *580 EUR*... --8---cut here---end---8--- Obviously, if you look at the amounts, it isn't correct... What am I not seeing? Best regards, Seb -- Sebastien Vauban
Re: [O] [BUG] Table not recomputed (incorrect results)
On 10.9.2013, at 04:32, Sebastien Vauban sva-n...@mygooglest.com wrote: Hello, I'm loosing my latin with the following table, which Org declares as converged or already stable. --8---cut here---start-8--- #+TITLE: Birthday * Commande | mini sandwiches | 261 | 1.00 | 260.00 | | rauwkostchotels | 2 | 36. | 72.00 | | koude hapjes| 130 | | 0.00 | | dessertjes (in hapjes glaasjes) | 90 |3 | 0.00 | |-+-+--+| | total | | | 332. | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) Total paid: *580 EUR*... --8---cut here---end---8--- Obviously, if you look at the amounts, it isn't correct... Hi Sebastien, The first four lines are all above the first hline and are therefore treated as header and are exempt from calculation. Formular applying to these fields are ignored. Add a header line to the table: | a | b |c |d | |-+-+--+--| | mini sandwiches | 261 | 1.00 | 261. | | rauwkostchotels | 2 | 36. | 72. | | koude hapjes| 130 | |0 | | dessertjes (in hapjes glaasjes) | 90 |3 | 270 | |-+-+--+--| | total | | |0 | #+TBLFM: $4=$2*$3;%.2f::@2$3=30*1.2::@5$4=vsum(@1..@-1) Cheers - Carsten What am I not seeing? Best regards, Seb -- Sebastien Vauban signature.asc Description: Message signed with OpenPGP using GPGMail