Matthew Jenkins created JRUBY-6321:
--------------------------------------
Summary: win32ole can not insert excel strings/inconsistent
behavior, win32ole 0.8.5
Key: JRUBY-6321
URL: https://jira.codehaus.org/browse/JRUBY-6321
Project: JRuby
Issue Type: Bug
Components: win32ole
Affects Versions: JRuby 1.6.5
Environment: Windows 7 x64 Pro
Reporter: Matthew Jenkins
Assignee: Thomas E Enebo
require 'win32ole'
excel = WIN32OLE.new('Excel.Application')
excel.visible = true
workbook = excel.Workbooks.Add()
worksheet = workbook.Worksheets(1)
worksheet.Range("A1:D1").value = "a"
will insert "a" into cells A1, B1, C1 and D1. Which is identical to ruby main.
Changing the last line to = "a","b"
will insert blanks into A1 and B1 and #N/A into C1 and D1. In ruby main a is
inserted into A1 and b is inserted into B1 with #N/A inserted into C1 and D1
Changing the last line to = "a","b","c","d"
will result in blanks in A1 to D1 and on ruby main they are properly inserted
into A1 through D1 respectively.
My Jruby version is "jruby 1.6.5.1 (ruby-1.8.7-p330) (2011-12-27 1bf37c2) (Java
HotSpot(TM) 64-Bit Server VM 1.7.0_01) [Windows 7-amd64-java]" and my Ruby main
version is ruby 1.9.3p0 (2011-10-30) [i386-mingw32]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
