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.

Devant la folie délatrice qui s'est emparée des médias, pour lesquels pourtant d'habitude Twitter n'est qu'un déversoir à fiel, cette histérie qui vise à condamner par média interposé ce qui aurait dû faire l'objet d'une lutte verbale au moment du dit acte d'abord, et ensuite éventuellement d'un dépôt de plainte, je suis réjoui pour ma part de l'intervention d'un geek du web comme Robert Scoble.

Pourquoi? D'abord parce que sa recension des faits montre un partage des responsabilités et dans certains cas une dénonciation du caractère mensonger des actes d'agression sexuelle ou harcèlement sexuel qui ne sont là que comme cache-sexe d'une vengeance ou d'une volonté de nuire.

Mais mieux encore, sur la définition du harcèlement sexuel car Robert Scoble insiste sur le fait que les personnes concernées n'étaient pas ses employées et qu'elles n'avaient aucun lien de subordination ou de capacité de défaire leur carrière.

extrait : "I have rejected my lawyer’s advice to not make a statement and in a spirit of healing I would like to address the issue head on with open and honest dialogue. (...) None of the women who came forward were ever in a position where I could make or break their careers. Sexual Harassment requires that I have such power. "

Evidemment, ça change tout. L'affaire Weinstein est claire, car les actrices sont dans une relation de subordination. Weinstein est leur patron pour un certain nombre d'entre elles.

Mais utiliser un cas particulier pour lancer un meme hystérique et délatoire, il y a pourtant un pas que l'intelligence des femmes devraient pourtant inciter à ne pas franchir. Faut-il en déduire que les femmes d'aujourd'hui sont en fait plus connes que leurs mères? Qu'en fait, à force de vouloir être l'égal des hommes, les femmes y perdent?

Et là dedans, pourquoi les médias tiennent-ils ce rôle? Pourquoi versent-ils de l'huile sur le feu en reprenant les tweets et en fabriquant des talk shows à leur gloire?

A new major upgrade to xlsgen is about to ship.

In xlsgen 4.0, support for a number of additional objects was added. Because those objects came often with a few tweek capabilities, this caused a lot of new API to be made public, which you can review in our page over at what's new in 4.0?

In 4.5 a number of objects are added. It happens that many of those objects require a lot less API and it has therefore become the general theme in 4.5. For instance, whenever a new input file format is supported, no new API is exposed and there is nothing new to learn. Ditto for an output format. Ditto for general advances in core xlsgen engines such as the rendering, or whenever we are adding new engines which happen to rely on standard third-parties.

There is hope that xlsgen becomes seen for what it is, that is more than a general purpose Excel file generator. It has been such a thing for a number of years, but it so happens that every new customer has a different need and it is perhaps not always obvious what products can do to meet your needs and how far they can push you.