Dear Erich and Scott, Concerning the third point the LegalRandRangeNameFrom function of the RInterfaceSupport module causes the problem. It contains a 'do--loop until' construct which assumes that the name is at least two character long. One possibility is to change it 'while--wend' loop, it does not do anything if length is 1, otherwise the same as it is now. The other possible work around is to define the empty string as non digit in the isdigit function of the same module.
-- Vilmos Prokaj Eötvös Loránd University, Department of Probability and Statistics Pázmány Péter sétány 1/C Budapest, 1117 Hungary e-mail:[EMAIL PROTECTED] > Thanks for your help everybody... the tips to load the rcom package and > hit > return a few times to clear up a freeze did the trick. I'm now able to > get > RExcel in a usable state with ESS. > > I've noticed a few strange things as I was playing around, I wonder if you > might have any thoughts on them: > 1) It doesn't seem possible to select Foreground server right away. When > I > open Excel, then go to RExcel->Set R Server, the Foreground Radio Box is > greyed out. The two ways I've been able to get RExcel to work are to (a) > choose Background and check the Remote checkbox, then either leave Server > address blank, or put in my local machine's name, then click save, then > click close and go about using RExcel or (b) Click on the Remote check > box, > click "Save" (this activates the Foreground radio box), select Foreground, > uncheck Remote, then check RGui visible, then click Save (this greys out > Foreground, but it is still selected), then click close and go about using > RExcel. > > 2) The R Server settings don't seem to be persistent from Excel session to > Excel session, so every time I open up a new excel, I have to redo the > server settings > > 3) If I try to put a dataframe into the R session and name it with a > single-character name, I get an unhandled error in the VBA code; if I try > to > name it with a number as the last character, and the second to last > character is not an underscore, I get a dialog box informing me that the > name I've chosen is not a valid dataframe name. > > I should mention that these problems are relatively minor, and even if > these > problems aren't fixable, RExcel is still going to be incredibly useful for > me; thanks so much for creating it. > > > -- Scott > > On Sat, Aug 9, 2008 at 5:29 PM, Erich Neuwirth > <[EMAIL PROTECTED]>wrote: > >> This essentially works, but there is a small bug which still needs to be >> fixed. >> Sometimes (especially immediately after Excel tries to connect to such >> an R >> process) >> Excel seems to hang. >> Typing a few returns in the Emacs window ussualy helps. >> >> >> On Aug 7, 2008, at 7:33 PM, Prokaj Vilmos wrote: >> >> Hi Scott, >>> >>> Try to load the rcom package in the ESS terminal before connecting from >>> EXCEL. >>> >>> Scott Stephens írta: >>> >>>> Greetings, >>>> >>>> My preferred way of using R at the command line is through Emacs with >>>> the >>>> ESS add-on. I would love to be able to use RExcel with ESS in the >>>> same way >>>> that it's possible to use RExcel with the usual Rgui. I followed the >>>> usual >>>> installation instructions using ESS as my R terminal, and it seemed to >>>> install correctly. However, when within Excel I choose RExcel->R >>>> Start, >>>> rather than detecting my existing ESS terminal, it instead starts a >>>> brand >>>> new Rgui terminal to connect to. >>>> >>>> Has anyone else tried this? Anyone know how to get it working/if it's >>>> possible? >>>> >>>> >>>> Thanks, >>>> >>>> Scott >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> Rcom-l mailing list >>>> Rcom-l@mailman.csd.univie.ac.at >>>> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l >>>> More information (including a Wiki) at http://rcom.univie.ac.at >>>> >>>> >>>> >>>> -- >>> Vilmos Prokaj >>> Eötvös Loránd University, >>> Department of Probability and Statistics >>> Pázmány Péter sétány 1/C >>> Budapest, 1117 >>> Hungary >>> >>> e-mail:[EMAIL PROTECTED] <[EMAIL PROTECTED]> >>> _______________________________________________ >>> Rcom-l mailing list >>> Rcom-l@mailman.csd.univie.ac.at >>> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l >>> More information (including a Wiki) at http://rcom.univie.ac.at >>> >>> >> Erich Neuwirth >> Didactic Center for Computer Science and Institute for Scientiic >> Computing >> University of Vienna >> >> >> >> >> _______________________________________________ >> Rcom-l mailing list >> Rcom-l@mailman.csd.univie.ac.at >> http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l >> More information (including a Wiki) at http://rcom.univie.ac.at >> > _______________________________________________ > Rcom-l mailing list > Rcom-l@mailman.csd.univie.ac.at > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > More information (including a Wiki) at http://rcom.univie.ac.at _______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
