This document is to record the status of OOXML export. The work will be first part of code(for basic spreadsheet objects) has been committed to branch OOXML. All the works are still on my local so far, hasn't been committed yet https://svn.apache.org/repos/asf/openoffice/branches/ooxml.

I will enable calc first, then writer and impress. Common objects/attributes/functions will be first, then advanced ones. Currently all achievements are for calc

Last Update: 02/2128/2014

Achievements:

• Spreadsheet

1. Basic cell contents can be exported correctly
2. Cell border can be exported correctly
3. Cell background color can be exported correctly, but hatch and gradient cannot. That's because of feature limitation, AOO doesn't support hatch and gradient as cell background. So that's not problem of OOXML export.
4. Font can be exported correctly
5. Text alignment can be exported correctly
6. Text rotation can be exported correctly
7. Most of number formats can be exported correctly, but some fraction number formats like 'as sixteenth', 'as tenth', 'as hundreds' cannot. The error happens on loading OOXML as well as loading XLS, seems core function doesn't support these kinds of number formats. So that's not problem of OOXML export.
8. Data validations can be exported correctly
9. Most of formulas can be exported correctly. I only find two formulas RIGHTB and DATEDIF export error so far. For RIGHTB it was already wrong when loading, so it's not problem of OOXML export. For DATEDIF, it is a unsupported formula in AOO, and doesn't exist in function list of Excel, when input it in input line of Excel, no tip for this formula, but Excel can calculate it.
10. Data filters can be exported
11. Shao Zhi is working on shape export of calc and impress. Now some basic shapes can be exported correctly.

• Presentation

1. PPTX framework enabled. But only a very simple structure of PPTX are exported so that MS Office 2010 cannot open it.

• Document

1. DOCX framework enabled(See Current Problems 3)

Ongoing:

1. Shape export by Shao Zhi.
2. Enabling framework of OOXML export for writer and impress

Current Problems:

1. Although some custom shapes can be exported but has some differences with the original ones. Shao Zhi is still working on it
2. When export advanced filter to XLSX, additional instant filter will be created in the source range.

...

1. When export a DOCX file, a error thrown, seems component register failed.

Other issues:

...

Because OOXML export is really a big project, now there are only two developers working on this. Need more volunteers.

Test Samples