99092 – LibreOffice 5.0.4: Filter of XLSX format is failing

Bug 99092 - LibreOffice 5.0.4: Filter of XLSX format is failing

Summary: LibreOffice 5.0.4: Filter of XLSX format is failing

Status:	CLOSED NOTABUG

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Calc (show other bugs)
Version: (earliest affected)	5.0.4.2 release
Hardware:	All All

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2016-04-05 05:11 UTC by jvchbabu
Modified:	2016-04-14 05:32 UTC (History)
CC List:	2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description jvchbabu 2016-04-05 05:11:26 UTC

I have installed LibreOffice_5.0.4_Win_x86 and converting xls to xlsx files through java.

The Filters I tried are :

1) Microsoft Excel 2007-2013 XML [https://ask.libreoffice.org/en/questi...]

2)MS Excel 2007 XML [https://ask.libreoffice.org/en/questi...]

None of the above filters works for XLSX but able to generate xls files. I use the below java code to save xlsx files;

XStorable xstorable = (XStorable) UnoRuntime.queryInterface(XStorable.class, doc);

 PropertyValue[] propertyvalue = new PropertyValue[2];
        propertyvalue[0] = new PropertyValue();
        propertyvalue[0].Name = "Overwrite";
        propertyvalue[0].Value = new Boolean(true);
        propertyvalue[1] = new PropertyValue();
        propertyvalue[1].Name = "FilterName";
        propertyvalue[1].Value =MS Excel 2007 XML;
  xstorable.storeAsURL(targetDocName, propertyvalue);

The error I got is below 2016-02-17 21:27:48,886 ERROR [ajp-bio-8009-exec-1] ExcelProcess [ExcelProcess.java:131] Error occured while saving spreadsheet to a new url name com.sun.star.task.ErrorCodeIOException: SfxBaseModel::impl_store <file: d:="" app="" apps="" abc="" modules="" temp="" 0.6911649132589721.xlsx=""> failed: 0x81a at com.sun.star.lib.uno.environments.remote.Job.remoteUnoRequestRaisedException(Job.java:160) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.environments.remote.Job.execute(Job.java:124) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:319) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.environments.remote.JobQueue.enter(JobQueue.java:288) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.environments.remote.JavaThreadPool.enter(JavaThreadPool.java:80) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.bridges.java_remote.java_remote_bridge.sendRequest(java_remote_bridge.java:617) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.request(ProxyFactory.java:144) ~[jurt-5.0.4.jar:na] at com.sun.star.lib.uno.bridges.java_remote.ProxyFactory$Handler.invoke(ProxyFactory.java:128) ~[jurt-5.0.4.jar:na] at com.sun.proxy.$Proxy81.storeAsURL(Unknown Source) ~[na:na]

Please help us to resolve this issue and let me know if you need more information.

Comment 1 Maxim Monastirsky 2016-04-05 08:51:17 UTC

(In reply to jvchbabu from comment #0)
> The Filters I tried are :
> 
> 1) Microsoft Excel 2007-2013 XML [https://ask.libreoffice.org/en/questi...]
> 
> 2)MS Excel 2007 XML [https://ask.libreoffice.org/en/questi...]
Both are wrong. I suppose "Calc MS Excel 2007 XML" is what you want.

List of all filters:

http://opengrok.libreoffice.org/xref/core/filter/source/config/fragments/filters/

(You can get the same list locally, by searching "org.openoffice.TypeDetection.Filter" in the expert configuration window.)

Comment 2 jvchbabu 2016-04-05 10:22:19 UTC

Thanks for your pointer. I verified the list at http://opengrok.libreoffice.org/xref/core/filter/source/config/fragments/filters/.
 The list no where specifies what is the filter I need to use for converting .xls document to .xlsx.

 Few filters talks about com.sun.star.sheet.SpreadsheetDocument which nothing but .xls/xlsx.
1)calc_MS_Excel_2007_XML.xcu
2)calc_MS_Excel_2007_Binary.xcu
3)calc_OOXML.xcu
4)MS_Excel_2003_XML.xcu
 It is unclear what to use?,. If you could let usexact filter name that would be very helpful to us.

Comment 3 Maxim Monastirsky 2016-04-05 16:57:57 UTC

(In reply to jvchbabu from comment #2)
> Thanks for your pointer. I verified the list at
> http://opengrok.libreoffice.org/xref/core/filter/source/config/fragments/
> filters/.
>  The list no where specifies what is the filter I need to use for converting
> .xls document to .xlsx.
If it's not obvious from its name, you can also check the "Type" property of a filter. It maps to an entry from filter/source/config/fragments/types/, and there you can find file extensions. (Remember to compare by oor:name attribute, not by file names!)

> 1)calc_MS_Excel_2007_XML.xcu
> 2)calc_MS_Excel_2007_Binary.xcu
> 3)calc_OOXML.xcu
> 4)MS_Excel_2003_XML.xcu
>  It is unclear what to use?,.
1) or 3) is what you're looking for (they both for xlsx).

> If you could let usexact filter name that would be very helpful to us.
Well, I gave it already in my previous comment, but I'll repeat it here - "Calc MS Excel 2007 XML".

Comment 4 Buovjaga 2016-04-13 11:14:15 UTC

Can this be closed or..?

Comment 5 jvchbabu 2016-04-14 05:31:55 UTC

This Filter Calc "MS Excel 2007 XML" for me for generating XLSX file. Thanks for your support.