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 are using an older version of R(D)Com
from the bundle RDACCSDSetup2031V1.62.exe on the Rcom website. Unfortunately,
due to circumstances beyond my control I cannot quickly distribute a new
version of R(D)Com to the users were the bug may be fixed. Neither can I reset
the computer clocks as was the quick fix used by Andrew as specified in his
mail post.
One of the users has found a quick fix, namely, change the RExcel.xla code when
he opens the application in the getarray procedure from
' If AllIsDates Then
TimeOffset = Str(GMTOffset() * 3600)
to the following:
' If AllIsDates Then
TimeOffset = Str(GMTOffset() * clng(3600))
the clng VBA function converts a value to a long int. At present the users have
to do this fix everytime they restart the application.
Is it possible to change the code in the RExcel.xla file to this new fix
permanently? If so, is it just a case of opening up RExcel.xla from C:\Program
Files\R\(D)COM Server\xls changing the code and saving it off?
Normally, I would not advocate this at all! But due to the circumstances......
Or does anyone else have any suggestions for another fix?
Regards
Wayne
----------------------------------------------------------------------------------------
Wayne Jones
Statistical Consultant
Shell Global Solutions (UK)
Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom
Tel: +44 (0) 151 373 5977
Fax: +44 (0) 151 373 5384
Mobile: +44 (0) 7896 536026
Email: [EMAIL PROTECTED]
Internet: www.shell.com/globalsolutions/statisticsandchemometrics
Shell Global Solutions (UK) is a division of Shell Research Limited which has
its Registered Office at Shell Centre, London SE1 7NA and is registered in
England & Wales with No.539964.
_______________________________________________
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
