xlsgen 4.5 can read OpenOffice files whether they are generated from Apache's OpenOffice, The document foundation's LibreOffice and third parties. By OpenOffice files is meant OpenOffice calc files, which are .ODS files. Of course xlsgen supports the in-memory variants, so it can read a memory buffer storing the contents of an .ODS file.

Support for objects from .ODS files is fairly extensive :

• cells
• formatting (number format, alignment, borders, fill, font, other properties)
• rich strings
• formulas
• defined names and external references
• row and column formatting, merged cells
• conditional formattings (cell, formula, date-based, text-based, time-based, top/bottom, duplicate, error-based)
• advanced conditional formattings from LibreOffice (data bars, iconsets and color scales)
• worksheet properties (selection, hidden, ...)
• freeze / split, page breaks
• header and footer
• hyperlinks
• pictures
• charts (all chart types and subtypes, all formatting properties)
• comments, text boxes, vector shapes, complete with their formatting properties

.ODS files, whether created from The document foundation's LibreOffice or Apache's OpenOffice, are evolving at their own pace. The document foundation's LibreOffice is more advanced than Apache's OpenOffice in a number of ways, most notably conditional formattings, where Apache's OpenOffice has support for only the two conditional formatting types (cell-based and formula-based). It's up to the corresponding open source project contributors to try to put the two on par. xlsgen reads as much as it can from those files.

Another scenario that is supported is the update of existing .ODS files using xlsgen, by reading and writing back to an .ODS file or memory buffer, as in :

VB code

Dim engine As CoXlsEngine Set engine = CreateObject("ExcelGenerator.ARsTDesign") ' read and write an existing .ODS file Dim wbk As IXlsWorkbook Set wbk = engine.Open "MyFile.ods", "MyFile.ods" wbk.Close Set engine = Nothing

xlsgen can also migrate an .ODS file to a .XLSX file for instance and vice versa.