Apache OpenOffice (AOO) Bugzilla – Issue 95102
Document Converter wizard doesn't see Excel 2007 .xlsx
Last modified: 2017-05-20 10:35:16 UTC
Document Converter does not see Excel 2007's .xlsx files as a file to be converted. While Calc can open the files, there are problems due to which functions Calc 3.0.0 supports and which functions Excel 2007 supports (and the formatting used in each). Example: Calc offers SUMIF which appears to function regardless of sorting of the source data, however Excel offers SUMIF which relies on the source data being sorted and SUMIFS which functions regardless of sorting. What I'm hoping to see is the ability for the Document Converter to read these files, and be able to convert instances of "SUMIFS(SumRange,SearchRange,Criteria)" to "SUMIF (SearchRange,Criteria,SumRange)".
I confirm, that the document converter wizard doesn't convert xlsx-files although OOo3.0 is able to open such files. I use OOo3.0 on WinXP. We can only handle issues with one problem. Please file a new issue for problems with converting functions. Be aware, that OOo tries to fulfill the standard ODF, but not all the functions mentioned there are implemented yet. SUMIFS is not in the ODF specification. Please submit an enhancement request for that function. SUMIF has been adapted to some of Excel's behavior, see issue 85000. Please use the newest OOo version to test it. If you find another problem with SUMIF, please submit a new issue.
Created attachment 79678 [details] To support Office 2007 file types for ImportWizard I wrote a patch for supporting Office 2007 file types by ImportWizard and tried to convert files with it. But it seems filters for these files are not good.
"hanya" committed SVN revision 1559342 into trunk: #i95102# support Office 2007 file extensions on the Document Converter
The Document Converter can find the following file extensions and converted into corresponding ODT format also: - Word docx, docm -> odt - Excel xlsx, xlsm -> ods - PowerPoint pptx, pptm -> odp - Word template dotx, dotm -> ott - Excel template xltx, xltm -> ots - PowerPoint template potx, potm -> otp
verified on windows7 on AOO410m15(Build:9761) - Rev. 1583666 2014-04-01 13:53:14 (Di, 01 Apr 2014)