This document is to record the status of OOXML export. The achievements record below have been committed to branch 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: 03/14/2014
- Basic cell contents can be exported correctly
- Cell border can be exported correctly
- 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.
- Font can be exported correctly
- Text alignment can be exported correctly
- Text rotation can be exported correctly
- 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.
- Data validations can be exported correctly
- 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.
- Data filters can be exported but has issue (in Current Problem 2)
- Simple conditional format can be exported but has issue (in Current Problem 3)
- Comments can be exported but has issue (in Current Problem 4)
- Some basic shapes can be exported.
- PPTX framework enabled. But only a very simple structure of PPTX are exported so that MS Office 2010 cannot open it.
- DOCX framework enabled(See Current Problems 3)
- Graphic and shape export.
- Although some custom shapes can be exported but has some differences with the original ones.
- When export advanced filter to XLSX, additional instant filter will be created in the source range.
- Current AOO core function only support simple conditional format, many Excel 2010 functions such as data bars, icons, are not supported neither by core function nor OOXML export
- Comments property position and size cannot be kept in OOXML export
- When export a DOCX file, a error thrown, seems component register failed.
Because OOXML export is really a big project, now there are only two developers working on this. Need more volunteers.
|First part of test samples for XLSX basic content||25 XLSXs for basic spreadsheet content|