* Strange problem with spreadsheet
@ 2007-06-21 8:32 Cecil Westerhof
2007-06-21 8:45 ` Cecil Westerhof
0 siblings, 1 reply; 2+ messages in thread
From: Cecil Westerhof @ 2007-06-21 8:32 UTC (permalink / raw)
To: org-mode
I have the following tables:
|-------------------|
| 22.50 |
| 16.50 |
|-------------------|
| :=vsum(@-II..@-I) |
|-------------------|
#+TBLFM: @3$1=vsum(@-II..@-I)
|------------------------|
| 22.50 |
| 16.50 |
|------------------------|
| :=vsum(@-II..@-I);%.2f |
|------------------------|
#+TBLFM: @3$1=vsum(@-II..@-I);%.2f
With the first I get '39.' when I let the table be evaluated.
But I want 39.00. That is why I created the second table. But here I get
on evaluation: 'Args out of range: 15,16'.
I have the feeling that it could have something to do with the upgrade
to 4.78, but I am not sure. (Before I was using 4.71.)
--
Cecil Westerhof <CecilWesterhof@xs4all.nl>
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: Strange problem with spreadsheet
2007-06-21 8:32 Strange problem with spreadsheet Cecil Westerhof
@ 2007-06-21 8:45 ` Cecil Westerhof
0 siblings, 0 replies; 2+ messages in thread
From: Cecil Westerhof @ 2007-06-21 8:45 UTC (permalink / raw)
To: org-mode
Op do, 21-06-2007 te 10:32 +0200, schreef Cecil Westerhof:
> I have the following tables:
> |-------------------|
> | 22.50 |
> | 16.50 |
> |-------------------|
> | :=vsum(@-II..@-I) |
> |-------------------|
> #+TBLFM: @3$1=vsum(@-II..@-I)
>
> |------------------------|
> | 22.50 |
> | 16.50 |
> |------------------------|
> | :=vsum(@-II..@-I);%.2f |
> |------------------------|
> #+TBLFM: @3$1=vsum(@-II..@-I);%.2f
>
> With the first I get '39.' when I let the table be evaluated.
> But I want 39.00. That is why I created the second table. But here I get
> on evaluation: 'Args out of range: 15,16'.
>
> I have the feeling that it could have something to do with the upgrade
> to 4.78, but I am not sure. (Before I was using 4.71.)
There is definitly something broken between 4.71 and 4.78. In a table I
have
:=vsum(@II..@-I);%.2f
This worked without a problem. Now I get:
Args out of rang: 14, 15
Also here when I remove the ';%.2f', it works. (But is not displayed the
way I want.)
--
Cecil Westerhof <CecilWesterhof@xs4all.nl>
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2007-06-21 8:45 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2007-06-21 8:32 Strange problem with spreadsheet Cecil Westerhof
2007-06-21 8:45 ` Cecil Westerhof
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).