emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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).