Deimos
5 years agoOccasional Visitor
Solved
Trying to write in a LibreOffice Calc document With OleObject
Hello!
I'm trying to write in a xls doc with LibreOffice, using TestComplete, but I'm having an error message like that:
"[automation bridge] UnoConversionUtilities<T>::dispatchExObject2Sequence \nConversion of dispatch object to Sequence failed!"
The Javascript code is:
function Main() { try{ var oServiceManager = Sys.OleObject("com.sun.star.ServiceManager"); var oDesktop = oServiceManager.createInstance("com.sun.star.frame.Desktop"); var VariantArray = new Array(); var myStruct = oServiceManager.Bridge_GetStruct("com.sun.star.beans.PropertyValue"); myStruct.Name = "Hidden"; myStruct.Value = true; VariantArray[0] = myStruct; var oDoc = oDesktop.LoadComponentFromURL("private:factory/scalc", "_blank", 0, VariantArray); var oSheet = oDoc["getSheets"]().getByIndex(0); }catch(e){ Log.Error(e); } }
In this line var oDoc = oDesktop.LoadComponentFromURL("private:factory/scalc", "_blank", 0, VariantArray); I'm having this problem.
Please, Help me!
The only LibreOffice discussion that I can find is here, and it may or may not help.
https://community.smartbear.com/t5/TestComplete-Functional-Web/OleObject-Libre-Office/td-p/58431
I suggest contacting Support directly with your question. Here's the link: