Ask Your Question

Sugam Varshney's profile - activity

2018-02-28 00:25:25 +0100 received badge  Famous Question (source)
2018-02-28 00:25:25 +0100 received badge  Notable Question (source)
2016-07-06 06:55:02 +0100 received badge  Popular Question (source)
2016-07-06 06:54:50 +0100 received badge  Famous Question (source)
2016-06-29 17:33:22 +0100 received badge  Taxonomist
2016-06-20 13:41:30 +0100 received badge  Notable Question (source)
2016-06-20 13:15:23 +0100 received badge  Popular Question (source)
2016-06-20 13:04:01 +0100 asked a question Do you support IPV6

Dear Libo, Do you support IPV6 in headless mode? Can I simply run the script to start a Libo on a IPV6 machine? I have been doing it for my IPV4 for a very long time.

./soffice "--accept=socket,host="A IPV 6 Address",port=8100,tcpNoDelay=1;urp;StarOffice.ServiceManager" --headless --nofirststartwizard --norestore --nocrashreport --nologo &

2016-06-17 09:23:37 +0100 asked a question How to run soffice.bin in headless mode on a IPV6 machine

Hi, I have been running soffice.bin in headless mode on a IPV4 machine using -

./soffice "--accept=socket,host="172..18.*",port=8000,tcpNoDelay=1;urp;StarOffice.ServiceManager" --headless --nofirststartwizard --norestore --nocrashreport --nologo &

But now I am switching to IPV6 and ran the above script to run the LIBO, Now this process stopped somewhere on the way and never completed. It kept the CPU 100% busy all the time. The startup doesn't happen and port in never listened.

whats the problem? What am I doing wrong? Is there any change with the script for IPV6, Do you even support IPV6?

2015-09-03 03:53:06 +0100 received badge  Famous Question (source)
2015-09-03 03:53:06 +0100 received badge  Notable Question (source)
2015-01-22 13:01:00 +0100 received badge  Famous Question (source)
2014-08-11 11:30:24 +0100 received badge  Student (source)
2014-08-10 02:22:50 +0100 received badge  Self-Learner (source)
2014-08-10 02:22:50 +0100 received badge  Teacher (source)
2014-07-06 13:14:41 +0100 received badge  Popular Question (source)
2014-07-06 13:14:41 +0100 received badge  Notable Question (source)
2014-06-25 22:14:00 +0100 received badge  Popular Question (source)
2014-06-24 09:15:18 +0100 asked a question Can't Import XLS MACRO in LibreOffice ODS - using API

I have been using the following code to read the Macro Libraries in OpenOffice and trying some thing to work with LibreOffice as well,

XLibraryContainer libraryContainer = (XLibraryContainer)UnoRuntime.queryInterface(XLibraryContainer.class, propertySet.getPropertyValue("BasicLibraries")); XNameAccess nameAccess = (XNameAccess)UnoRuntime.queryInterface(XNameAccess.class, libraryContainer); libraryContainer.loadLibrary("Standard");

Here librarycontainer is not loading the "Standard", though it was fins with OO. Is there something different here? libraryContainer is not null but the libraryContainer.getElementNames().length is O. But the length was 1 when I was using the OpenOffice.

2014-02-25 11:46:27 +0100 received badge  Enthusiast
2014-02-20 12:58:51 +0100 asked a question API Usage to import calc Private:stream remains open

I am trying to use LibreOffice APIs to import and export an ods/xls. Every import request uses a connection with a running instance using ./soffice "--accept=socket,host=@$%^". Everytime after the import this stream remains open. number of open private:stream - LibreOffice calc keeps increasing with every import request {ScreenShot attched} . I have been using the openoffice for the same purpose and it doesn't show the stream like LibreOfice.

Is there a some issue with version 4.2? Am I doing anything wrong? Is this how it's supposed to be?

image description

2013-12-18 20:20:36 +0100 received badge  Famous Question (source)
2013-12-18 13:21:25 +0100 answered a question What are the limits and API differences between Apache OpenOffice and LibreOffice?

Thanks for the answers, After some research and trails I found that these are the limitations

Number of rows per sheet: 1048676 (1 million)
Number of columns per sheet: 1024 (Excel's limit is 16384)
Number of worksheets in workbook: 10000 (Theoretically up to 32000 but disabled due to problems with memory usage on 32 bit systems)
Number of rules in Conditional Formatting: Unlimited
Number of filter criteria that can be applied: NU API allows Unlimited numbers
Doesn't allow LaTeX Import and export OO allows export


BTW what are the other calc differences in limitations of LibreOffice and OpenOffice. Is it a good idea to use LibreOffice APIs instead of OO?

2013-12-18 11:51:41 +0100 received badge  Scholar (source)
2013-12-17 17:42:56 +0100 received badge  Notable Question (source)
2013-12-17 14:56:26 +0100 received badge  Popular Question (source)
2013-12-17 12:25:05 +0100 received badge  Famous Question (source)
2013-12-17 12:24:38 +0100 asked a question What are the limits and API differences between Apache OpenOffice and LibreOffice?

I Have been using OpenOffice APIs for a long time and now trying to switch to LibraOffice. What are the differences of maximum limits like

Number of rows in worksheet - 1 million Number of columns in worksheet - 1024 columns Number of worksheets in workbook - 10000 worksheets -am I right? what are the other limits of Number of rules in Conditional Formatting (3 in OpenOffice) Number of filter criteria that can be applied

2013-10-01 06:46:32 +0100 received badge  Notable Question (source)
2013-09-30 09:26:51 +0100 answered a question Exporting a calc with MACRO XSpreadsheetComponent returns NULL

I did some research and analysis and found out that my manifest.xml did not have manifest:full-path of Macro.xml. It started to work when I add the manifest:full-path of there three remaining xmls.

<manifest:file-entry manifest:media-type="text/xml" manifest:full-path="Basic/Standard/MyMacro.xml"/>
<manifest:file-entry manifest:media-type="text/xml" manifest:full-path="Basic/Standard/script-lb.xml"/>
<manifest:file-entry manifest:media-type="text/xml" manifest:full-path="Basic/script-lc.xml"/>

Is there a change in reading them in LibraOffice? As files were not giving any error even without these lines when I was using OpenOffice. Do I have to make these changes in manifest.xml?

2013-09-25 08:02:39 +0100 received badge  Popular Question (source)
2013-09-24 11:17:13 +0100 received badge  Organizer (source)
2013-09-24 11:09:58 +0100 received badge  Editor (source)
2013-09-24 10:45:30 +0100 asked a question Exporting a calc with MACRO XSpreadsheetComponent returns NULL

We have been using the OpenOffice APIs to import and export the sheet documents, Just tried to adopt LibraOffice. The control is giving the error at the creation of the XSpreadsheetComponent, The code flow has these lines

        loadProps[0]        = new PropertyValue();
        loadProps[0].Name   = "Hidden";
        loadProps[0].Value  = Boolean.TRUE;

        loadProps[1]         = new PropertyValue();
        loadProps[1].Name    = "InputStream";                                                   
        loadProps[1].Value  = oois;


        synchronized (xComponentLoader)
        {
            xSpreadsheetComponent = xComponentLoader.loadComponentFromURL("private:stream", "_blank", 0, loadProps);
        }

If i changes the port no to 8000(Thats where I am running java), the xSpreadsheetComponent generated but then it gives same nullpointerexception when I tries to get XSpreadsheetDocument.

XSpreadsheetDocument xDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class, xComponent);

The sheet export just fine when there is no MACRO in it. Only after creating/recording macros it gives these errors. The export doesn't make any different even after the deleting the created MACRO, The xSpreadsheetComponent returns null.

Is there some difference in OO and LibreOffice APIs?

Thanks in Advance.