This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Rebecca Kilulylen
Jul 7, 2014, 8:23 AM
4 Posts

Unable to read ODS spreadsheet using lotusscript in notes 9.0.1

  • Category: Symphony
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer,End User
  • Tags: ods,CreateObject,ServiceManager,error
  • Replies: 4

I have an agent which reads my lotus symphony spreadsheet (.ods) using lotusscript and update some field values. It was working on my notes v8.5.3 without any error and after migration to 9.0.1, code fails to initialize the symphony application. 

To be specific, it fails on below line with 'Cannot create automation object' error.

'Initialize Symphony Application
Set objServiceManager = CreateObject("com.sun.star.ServiceManager")
 

Does lotus notes 9.0.1 supports OpenOffice api?

Any help would be really appreciated!! Thanks

 
~Xagra Frolumarakol
Jul 14, 2014, 3:46 PM
2 Posts
Unable to read ODS spreadsheet using lotusscript in notes 9.0.1

Hi Karthikeyan

I am also facing same issue. did you find any solution for this issue.

Thanks

 

~Xagra Frolumarakol
Jul 20, 2014, 7:01 PM
2 Posts
Cannot create automation object' error - issue resolved

I found the cause for this issue. When lotus notes 9 is installed, it removes some files relates to open office. Because of this the code not able to created ODS object. The solution is uninstall the open office and reinstall it. it should work now

Thank you


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal