Re: [Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Erich Neuwirth
There are problems with saving when you have multiple Excel files open. So the first thing to do is to close all but one Excel files. [EMAIL PROTECTED] wrote: > Hi Erich, > > Thanks for the quick reply. I will forward this on to the users who are > affected by the problem. > > However, can yo

RE: [Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Wayne.W.Jones
Hi Erich, Thanks for your very quick response. This should now solve the problem. Has this issue been resolved in the most recent version of R(D)Com? Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirthnks Sent: 16 November 200

Re: [Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Erich Neuwirth
This issue is unsolvable. As soon as you open multiple Excel files, with RExcel activated. RExcel is available for all the workboosk and therefore cannot be changed AND saved. I will integrate the timezone change in the next release of RExcel, and in the near future RExcel will become an R package

Re: [Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Erich Neuwirth
Could you please git into Class Module CTime and change Property Get TimeZoneOffset() As Integer to Property Get TimeZoneOffset() As Long and check if that also solves the problem,. Then I would commit that change. > > Hi Everyone, > > I am being faced with the same bug as as a previous post

RE: [Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Wayne.W.Jones
Hi Erich, Thanks for the quick reply. I will forward this on to the users who are affected by the problem. However, can you advise me what is the best way to permanently change the RExcel.xla add-in. They seem to have problems saving the changes. Regards Wayne -Original Message-

[Rcom-l] Workaround Time Zone bug RExcel

2007-11-16 Thread Wayne.W.Jones
Hi Everyone, I am being faced with the same bug as as a previous post on the rcom mailing list: see http://mailman.csd.univie.ac.at/pipermail/rcom-l/2006-November/001332.html . Namely, an RExcel application I have deployed is having trouble coping with different time zones. We here at Shell a