This document is to record the status of OOXML export. The work will be committed to branch OOXML. All the works are still on my local so far, hasn't been committed yet.
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/21/2014
Achievements:
- 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
- Shao Zhi is working on shape export of calc and impress. Now some basic shapes can be exported correctly.
Ongoing:
- Shape export by Shao Zhi.
- Enabling framework of OOXML export for writer and impress
Current Problems:
- Although some custom shapes can be exported but has some differences with the original ones. Shao Zhi is still working on it
- When export advanced filter to XLSX, additional instant filter will be created in the source range.
Other issues:
None