* [BUG] Table not recomputed (incorrect results)
@ 2013-09-10 2:32 Sebastien Vauban
2013-09-10 3:44 ` Carsten Dominik
0 siblings, 1 reply; 4+ messages in thread
From: Sebastien Vauban @ 2013-09-10 2:32 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [BUG] Table not recomputed (incorrect results)
2013-09-10 2:32 [BUG] Table not recomputed (incorrect results) Sebastien Vauban
@ 2013-09-10 3:44 ` Carsten Dominik
2013-09-10 7:49 ` Sebastien Vauban
0 siblings, 1 reply; 4+ messages in thread
From: Carsten Dominik @ 2013-09-10 3:44 UTC (permalink / raw)
To: Sebastien Vauban; +Cc: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1720 bytes --]
On 10.9.2013, at 04:32, "Sebastien Vauban" <sva-news@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
>
>
[-- Attachment #2: Message signed with OpenPGP using GPGMail --]
[-- Type: application/pgp-signature, Size: 163 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [BUG] Table not recomputed (incorrect results)
2013-09-10 3:44 ` Carsten Dominik
@ 2013-09-10 7:49 ` Sebastien Vauban
2013-09-10 7:52 ` Carsten Dominik
0 siblings, 1 reply; 4+ messages in thread
From: Sebastien Vauban @ 2013-09-10 7:49 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
Hi Carsten,
Carsten Dominik wrote:
> On 10.9.2013, at 04:32, "Sebastien Vauban" <sva-news-D0wtAvR13HarG/iDocfnWg@public.gmane.org> 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
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: [BUG] Table not recomputed (incorrect results)
2013-09-10 7:49 ` Sebastien Vauban
@ 2013-09-10 7:52 ` Carsten Dominik
0 siblings, 0 replies; 4+ messages in thread
From: Carsten Dominik @ 2013-09-10 7:52 UTC (permalink / raw)
To: Sebastien Vauban; +Cc: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1508 bytes --]
On 10.9.2013, at 09:49, Sebastien Vauban <sva-news@mygooglest.com> wrote:
> Hi Carsten,
>
> Carsten Dominik wrote:
>> On 10.9.2013, at 04:32, "Sebastien Vauban" <sva-news@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
>
>
[-- Attachment #2: Message signed with OpenPGP using GPGMail --]
[-- Type: application/pgp-signature, Size: 163 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2013-09-10 7:52 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2013-09-10 2:32 [BUG] Table not recomputed (incorrect results) Sebastien Vauban
2013-09-10 3:44 ` Carsten Dominik
2013-09-10 7:49 ` Sebastien Vauban
2013-09-10 7:52 ` Carsten Dominik
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.