OpenOffice output (.ODS files from the OpenOffice Calc application) has been available since xlsgen 2.9. But xlsgen 4.5 improves the output in more than twenty ways :
- OpenOffice output support for conditions in number formats (such as [>100]##0).
- write all conditional formattings in OpenOffice files (including databars, time condition, top, ...)
- shapes in OpenOffice files have a proper width and height.
- rich strings in cells are now created in OpenOffice files.
- write vector shapes in OpenOffice files. And proper border styles for text boxes.
- compatibility between LibreOffice and Apache's OpenOffice.
- fixed position of comments in OpenOffice files.
- fix for correctly creating pictures in OpenOffice files. The implementation could create negative offsets.
- fix for correctly creating stand-alone charts in OpenOffice files.
- improved default col width and row height and styles for OpenOffice files.
- write row repeats when writing OpenOffice files instead of iterating over single rows (performance problems).
- support text reading order in cells in OpenOffice files.
- better chart position and size in OpenOffice files. Also pie3D can be created.
- correct chart types in OpenOffice files.
- axis formatting in charts in OpenOffice files.
- support data label and marker formatting in charts in OpenOffice files.
- data points in charts in OpenOffice files.
- support for trendlines and error bars in charts in OpenOffice files.
- support for secondary axis and chart types in OpenOffice files.
- pivot tables for OpenOffice files.
- support for in-memory scenarios for OpenOffice files.
- more versatile shape border width for the OpenOffice ODS output.
