<html> <head> <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> Dear Michael, Many thanks for quick response. See our answers in green. Best Regards [Nick] & Team On 3/6/2012 7:38 PM, Michael Meeks wrote: <blockquote cite="mid:1331048333.2917.59.camel@linux-yjtf.site" type="cite"> <pre wrap="">Hi there, On Tue, 2012-03-06 at 19:23 +0400, <a class="moz-txt-link-abbreviated" href="mailto:libreoffice.ge@gmail.com">libreoffice.ge@gmail.com</a> wrote: </pre> <blockquote type="cite"> <pre wrap="">We are working on Open source Project where OOO Calc was used for report designer. Now we are going to migrate from OOO calc to LO Calc and need your help with following: </pre> </blockquote> <pre wrap=""> Great - where is your source code out of interest ? :-) </pre> </blockquote> [Nick] Old code hosted on Sourceforge CVS can be found here: <a class="moz-txt-link-freetext" href="http://fina.cvs.sourceforge.net/viewvc/fina">http://fina.cvs.sourceforge.net/viewvc/fina</a> Code related with OOO addin is here: <a class="moz-txt-link-freetext" href="http://fina.cvs.sourceforge.net/viewvc/fina/addin/">http://fina.cvs.sourceforge.net/viewvc/fina/addin/</a> Old project is here: <a href="http://sourceforge.net/projects/fina">http://sourceforge.net/projects/fina</a> New code hosted on Atlasian SVN is here: <a class="moz-txt-link-freetext" href="https://fina2net.atlassian.net/svn/FINA/trunk">https://fina2net.atlassian.net/svn/FINA/trunk</a> ( current version is 0.2) New Project is here: jira.fina2.net <blockquote cite="mid:1331048333.2917.59.camel@linux-yjtf.site" type="cite"> <pre wrap=""> </pre> <blockquote type="cite"> <pre wrap="">1. We are using OOO SDK 2.1 to register Calc Add in. · Was new LO SDK changed significantly? </pre> </blockquote> <pre wrap=""> It should not have been. One thing to bear in mind is that our xcu (configuration data) parser is a lot stricter, so you need well formed XML that matches the schema (which was not true in older versions). But if you get that right things should be ok I hope. </pre> </blockquote> [Nick] Do you think we need to rewrite the code? Or XML configuration / customization will be enough? <blockquote cite="mid:1331048333.2917.59.camel@linux-yjtf.site" type="cite"> <blockquote type="cite"> <pre wrap="">· Where is a docs we need to read before development? </pre> </blockquote> <pre wrap=""> Assume that the docs are the same as before I guess, but they are here: <a class="moz-txt-link-freetext" href="http://api.libreoffice.org/">http://api.libreoffice.org/</a> bug reports / patches to the docs much appreciated.</pre> </blockquote> [Nick] Thanks. <blockquote cite="mid:1331048333.2917.59.camel@linux-yjtf.site" type="cite"> <blockquote type="cite"> <pre wrap="">2. We have used OOOBean [officebean.jar] for opening OOO Calc in Java Environment . Are you planning to develop officebean project? Where can we find docs and/or wiki materials? </pre> </blockquote> <pre wrap=""> The bean should still exist, is still packaged, etc. There are a few reports of problems with it, again fixes appreciated for that.</pre> </blockquote> [Nick] Thanks. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">  Can we generate HTML file without opening OOO (LO). Right now (in old version) we are using the method - please see here: <a class="moz-txt-link-freetext" href="https://fina2net.atlassian.net/source/browse/FINA/trunk/fina/fina-server/src/main/java/net/fina/server/ooo/OOSheet.java?hb=true">https://fina2net.atlassian.net/source/browse/FINA/trunk/fina/fina-server/src/main/java/net/fina/server/ooo/OOSheet.java?hb=true</a> (or see code below). Connection with OOO takes allot of time: 2-3 sec. <o:p></o:p> <meta name="ProgId" content="Word.Document"> <meta name="Generator" content="Microsoft Word 14"> <meta name="Originator" content="Microsoft Word 14"> <link rel="File-List" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"> <link rel="themeData" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"> <link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"> <style>  <big>We would like to write an extension for LO which will exchange data with web services. We are planning to link it with JBoss. Will send you more infomration and screenshot on what we are discussing.<o:p></o:p></big> <meta name="ProgId" content="Word.Document"> <meta name="Generator" content="Microsoft Word 14"> <meta name="Originator" content="Microsoft Word 14"> <link rel="File-List" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"> <link rel="themeData" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"> <link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Croot%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"> <style>  </style> <blockquote cite="mid:1331048333.2917.59.camel@linux-yjtf.site" type="cite"> <pre wrap=""> </pre> <blockquote type="cite"> <pre wrap="">4. UNO Interface - was it significantly changed? </pre> </blockquote> <pre wrap=""> In a nutshell we should be backwards compatible with OpenOffice.org - at least, this is what we try to be. Of course, there are always bugs we need to find out :-) Hope that helps ! Michael. </pre> </blockquote> CODE HOW TO SAVE OOO to HTML public byte[] exportAsHtml(byte[] tempReportContent) { byte[] htmlContent = null; try { log.info("Exporting As Html"); XStorable xStorable = null; Object desktop = null; XComponent document = null; xRemoteContext = getRemoteContext(); xRemoteServiceManager = xRemoteContext.getServiceManager(); // Get a desktop instance desktop = xRemoteServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", xRemoteContext); // Get a reference to the desktop interface that can load files XComponentLoader loader = (XComponentLoader) UnoRuntime.queryInterface(XComponentLoader.class, desktop); XInputStream xStream = new ByteArrayToXInputStreamAdapter(tempReportContent); PropertyValue[] args = new PropertyValue[2]; args[0] = new PropertyValue(); args[0].Name = "InputStream"; args[0].Value = xStream; args[0].State = PropertyState.DIRECT_VALUE; args[1] = new PropertyValue(); args[1].Name = "Hidden"; args[1].Value = new Boolean(true); document = loader.loadComponentFromURL("private:stream", "_blank", 0, args); ByteArrayOutputStream out = new ByteArrayOutputStream(); XOutputStream xOut = new OutputStreamToXOutputStreamAdapter(out); PropertyValue[] args1 = new PropertyValue[2]; args1[0] = new PropertyValue(); args1[0].Name = "OutputStream"; args1[0].Value = xOut; args1[0].State = PropertyState.DIRECT_VALUE; args1[1] = new PropertyValue(); args1[1].Name = "FilterName"; args1[1].Value = "HTML (StarCalc)"; xStorable = (XStorable) UnoRuntime.queryInterface(XStorable.class, document); xStorable.storeAsURL("private:stream", args1); xOut.flush(); htmlContent = out.toByteArray(); xOut.closeOutput(); } catch (Exception ex) { log.error(ex.getMessage(), ex); } return htmlContent; } </body> </html>