emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Crashing bug in spreadsheet
@ 2011-07-22 18:48 Ken.Williams
  2011-07-22 21:35 ` Juan Pechiar
  0 siblings, 1 reply; 4+ messages in thread
From: Ken.Williams @ 2011-07-22 18:48 UTC (permalink / raw)
  To: emacs-orgmode

Hi,  I had the following text in a table, and hit <tab> in the
bottom-right cell:

| Who |     Amt     |
|-----+---------|
| A   |   36.70 |
| A   |  679.96 |
| B   |  192.31 |
| B   | 2500.03 |
| B   |   74.47 |
| C   |   26.64 |
| D   |   82.00 |
|-----+---------|
|     | :=vsum(@II..@III)       |



This caused CPU usage to peg to 100%, and Emacs to hang until killed.
Probably because of the invalid reference, I guess.

I'm using a fairly recent snapshot of org-mode 7.6, and Aquamacs 2.2 on OS
X Snow Leopard.


--
Ken Williams
Senior Research Scientist
Thomson Reuters
http://labs.thomsonreuters.com

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Crashing bug in spreadsheet
  2011-07-22 18:48 Crashing bug in spreadsheet Ken.Williams
@ 2011-07-22 21:35 ` Juan Pechiar
  2011-07-22 21:43   ` Ken.Williams
  0 siblings, 1 reply; 4+ messages in thread
From: Juan Pechiar @ 2011-07-22 21:35 UTC (permalink / raw)
  To: Ken.Williams; +Cc: emacs-orgmode

Hi,

'@II..@III' means all rows between the second and third h-lines. In
your case, this is the same vsum(), so you get a circular reference.

Try @I..@II instead

Regards,
.j.

On Fri, Jul 22, 2011 at 06:48:36PM +0000, Ken.Williams@thomsonreuters.com wrote:
> Hi,  I had the following text in a table, and hit <tab> in the
> bottom-right cell:
>
> | Who |     Amt     |
> |-----+---------|
> | A   |   36.70 |
> | A   |  679.96 |
> | B   |  192.31 |
> | B   | 2500.03 |
> | B   |   74.47 |
> | C   |   26.64 |
> | D   |   82.00 |
> |-----+---------|
> |     | :=vsum(@II..@III)       |
>
> This caused CPU usage to peg to 100%, and Emacs to hang until killed.
> Probably because of the invalid reference, I guess.

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Crashing bug in spreadsheet
  2011-07-22 21:35 ` Juan Pechiar
@ 2011-07-22 21:43   ` Ken.Williams
  2011-07-23 15:23     ` Bastien
  0 siblings, 1 reply; 4+ messages in thread
From: Ken.Williams @ 2011-07-22 21:43 UTC (permalink / raw)
  To: juan; +Cc: emacs-orgmode



On 7/22/11 4:35 PM, "Juan Pechiar" <juan@pechiar.com> wrote:

>Hi,
>
>'@II..@III' means all rows between the second and third h-lines. In
>your case, this is the same vsum(), so you get a circular reference.
>
>Try @I..@II instead


Yeah, I get that, but I was hoping a circular reference (or alternatively
a seemingly invalid reference, since I have no third h-line) would cause
an error rather than force me to kill Emacs.

--
Ken Williams
Senior Research Scientist
Thomson Reuters
http://labs.thomsonreuters.com

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Crashing bug in spreadsheet
  2011-07-22 21:43   ` Ken.Williams
@ 2011-07-23 15:23     ` Bastien
  0 siblings, 0 replies; 4+ messages in thread
From: Bastien @ 2011-07-23 15:23 UTC (permalink / raw)
  To: Ken.Williams; +Cc: juan, emacs-orgmode

Hi Ken,

<Ken.Williams@thomsonreuters.com> writes:

> Yeah, I get that, but I was hoping a circular reference (or alternatively
> a seemingly invalid reference, since I have no third h-line) would cause
> an error rather than force me to kill Emacs.

Right.  This is now the case.  Thanks for bringing this up.

-- 
 Bastien

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2011-07-23 15:23 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2011-07-22 18:48 Crashing bug in spreadsheet Ken.Williams
2011-07-22 21:35 ` Juan Pechiar
2011-07-22 21:43   ` Ken.Williams
2011-07-23 15:23     ` Bastien

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).