From schiessler at agere.com  Wed Dec  3 17:11:35 2003
From: schiessler at agere.com (Schiessler, Gary E (Gary))
Date: Wed Dec  3 17:10:26 2003
Subject: [Rd] memory leak (PR#5476)
Message-ID: <3FCE0B37.89A2D4C7@agere.com>

Prof Ripley,

I have attached a sample Excel spreadsheet
containing approx 500 RApply("qnorm"...
references. When I repeatedly re-calc
cell references, either automatically or manually
(F9), the memory usage on my system increases
with each re-calc seemingly without bound.
The more RApply references the greater the
incremental memory consumption.

I'm using Excel 2000 (9.0.4402 SR-1)
runnning under Microsoft Windows 2000
5.00.2195 SP3 on an IBM T21 laptop
with 256MB of memory.

I'm running R 1.8.1
> version
         _
platform i386-pc-mingw32
arch     i386
os       mingw32
system   i386, mingw32
status
major    1
minor    8.1
year     2003
month    11
day      21
language R

with RExcel version 1.0

and R DCOM server version 1.2

If you need any additional information
please let me know.

Thanks,
Gary Schiessler
Agere Systems

Prof Brian Ripley wrote:

> That appears to have been garbled en route.
> Could you please take a look at the FAQ and submit
> a reproducible example along the lines suggested there.
>
> On the face of it this appears to be a bug report on Excel 2000,
> but you may be using an R addin without mentioning it.
>
> On Wed, 3 Dec 2003 schiessler@agere.com wrote:
>
> > Full_Name: g. schiessler
> > Version: 1.8.1
> > OS: Windows 2000 Pro
> > Submission from: (NULL) (24.229.106.55)
> >
> >
> > Appears to be memory leak with
> > =RApply("qnorm",K56)*-1 function
>
> Is that line really correct?  If so, what does it have to do with R?
>
> > from within Excel 2000.
> > Have spreadsheet with between
> > 100 and 500 of above references.
> > When spreadsheet first opened
> > system using about 200MB but
> > very quickly grows to over 600MB
> > and appears to be unlimited.
> > Is there another way to run qnorm
> > from within Excel with less memory?
> >
> > ______________________________________________
> > R-devel@stat.math.ethz.ch mailing list
> > https://www.stat.math.ethz.ch/mailman/listinfo/r-devel
> >
> >
>
> --
> Brian D. Ripley,                  ripley@stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595


[Rd] memory leak (PR#5476)
Schiessler, Gary E (Gary