Hello everyone,
Running into an issue, would really appreciate some help.
I have to files. One has a method with arguments defined for the Open
Office Calc code like so:
firstscript.rb:
class FirstTest
def test(id)
noArgs = []
file_uri = "file:///c:/test.ods"
serviceManager = WIN32OLE.new("com.sun.star.ServiceManager")
coreReflection = serviceManager.createInstance
("com.sun.star.reflection.CoreReflection")
desktop = serviceManager.createInstance
("com.sun.star.frame.Desktop")
spreadsheet = desktop.loadComponentFromURL(file_uri, "_blank",
0,
noArgs)
sheetsCollection = spreadsheet.Sheets
sheet1 = sheetsCollection.getByIndex(0)
$browser.text_field(:id,
'position_req_id').value = sheet1.getCellByPosition(id).Formula
end
end
My other script sets the id:
require "firstscript"
FirstTest.new.test (1, 0)
results in an error:
method_missing': getCellByPosition (WIN32OLERuntimeError)
OLE error code:1001 in [automation bridge]
InterfaceOleWrapper_Impl::Invoke :
[automation bridge]UnoConversionUtilities<T>::variantToAny
Cannot convert the value of vartype :"8" to the expected UNO type
of type class: 6
HRESULT error code:0x80020009
Any ideas?
Thank you.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines:
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
