Issue 95102 - Document Converter wizard doesn't see Excel 2007 .xlsx
Summary: Document Converter wizard doesn't see Excel 2007 .xlsx
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: 4.1.0
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-10-18 01:49 UTC by angeldeath82
Modified: 2017-05-20 10:35 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
To support Office 2007 file types for ImportWizard (4.04 KB, patch)
2012-09-29 08:42 UTC, hanya
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description angeldeath82 2008-10-18 01:49:32 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)".
Comment 1 Regina Henschel 2008-10-18 18:47:00 UTC
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.
Comment 2 hanya 2012-09-29 08:42:19 UTC
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.
Comment 3 SVN Robot 2014-01-18 13:21:35 UTC
"hanya" committed SVN revision 1559342 into trunk:
#i95102# support Office 2007 file extensions on the Document Converter
Comment 4 hanya 2014-01-18 13:28:55 UTC
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
Comment 5 liuping 2014-04-10 02:22:09 UTC
verified on windows7 on AOO410m15(Build:9761)  -  Rev. 1583666
2014-04-01 13:53:14 (Di, 01 Apr 2014)