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