Issue 120391

Summary: need filter to import file format Office Open XML strict
Product: Calc Reporter: Regina Henschel <rb.henschel>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: andrew, damjan, elish, mseidel, oooforum
Version: 4.0.0-devKeywords: interop_OOXML
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
format OOXML by Excel 2013 preview none

Description Regina Henschel 2012-07-27 16:36:04 UTC
Created attachment 78760 [details]
format OOXML by Excel 2013 preview

The upcoming Excel 2013 will be able to save to format "Office Open XML strict", in their UI "Strict Open XML". Those files will have the file extension "xlsx", which is the same as for OOXML in Excel 2007. AOO cannot read this "strict" format.

I'll add a simple file, which was generated by Excel 2013 Preview on Windows 7.
Comment 1 Edwin Sharp 2013-12-19 08:20:21 UTC
Can not open attachment with
AOO410m1(Build:9750)  -  Rev. 1551017
Rev.1551017
Win 7
Had to install OOXML Strict Converter for Office 2010 in order to open attachment in Excel 2010.
Comment 2 oooforum (fr) 2017-08-11 15:40:33 UTC
*** Issue 127496 has been marked as a duplicate of this issue. ***
Comment 3 damjan 2023-01-08 16:54:46 UTC
Still the case in the latest Git.

It doesn't seem that difficult to add support for this "Strict Open XML". The attached file opens if you just change:

http://purl.oclc.org/ooxml/officeDocument/relationships/officeDocument
to
http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument

in _rels/.rels inside the .xlsx file.

Although opened like that, the spreadsheet is completely empty, further namespaces have to change to be able to actually load the data.