• 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.

<?xml version="1.0" encoding="UTF8"?>
<Bookstore>
   <!--J&R Booksellers Database-->
   <Book Genre="" In_Stock="Yes">
      <Title>The Round Door</Title>
      <Author>Tom Evans</Author>
      <Year_Published>1996</Year_Published>
      <ISBN>0-9546-0274-3</ISBN>
      <Price>$23.00</Price>
      <Review>An Intriguing Tale Of A Round Door In A Wall</Review>
   </Book>
   <Book Genre="Non-Fiction" In_Stock="Yes">
      <Title>Creating Real Xml Applications</Title>
      <Author>Bill Eaton</Author>
      <Year_Published>1998</Year_Published>
      <ISBN>7-4562-0167-8</ISBN>
      <Price>$35.00</Price>
      <Review>A Look At How To Build Real Xml Applications</Review>
   </Book>
   <Book Genre="Fiction" In_Stock="No">
      <Title>Over The Hills Of Yukon2</Title>
      <Author>Bert Colewell</Author>
      <Year_Published>1993</Year_Published>
      <ISBN>5-6524-3054-1</ISBN>
      <Price>$22.00</Price>
      <Review>A Warm Story About A Man And A Moose In Yukon</Review>
   </Book>
   <Book Genre="Fiction" In_Stock="Yes">
      <Title>The Lion's Gold</Title>
      <Author>Daphne Griswald</Author>
      <Year_Published>1989</Year_Published>
      <ISBN>6-7896-2498-2</ISBN>
      <Price>$15.00</Price>
      <Review>One Of The Most Compelling Books Since "The Tiger's Silver".</Review>
   </Book>
</Bookstore>

Dim engine
Set engine = CreateObject("ExcelGenerator.ARsTdesign")

Dim wbk As IXlsWorkbook 
Set wbk = engine.Open "C:\tmp\Bookstore.xml", "output.xlsx"
wbk.Close

• /Bookstore/Book
  

  Fully qualified path to the XML elements of interest. In the example above, this is the list of all 4 books.

  
  
• //Book
  

  XML elements of interest that are direct or indirect descendant. In the example above, this is the list of all 4 books.

  
  
• /Bookstore/Book[2]
  

  2nd element of the XML element list of interest. In the example above, this selection includes the book by Bill Eaton

  
  
• /Bookstore/Book[2,3]
  

  2nd and 3rd elements of the XML element list of interest. In the example above, this selection includes the books by Bill Eaton and Bert Colewell

  
  

Dim engine
Set engine = CreateObject("ExcelGenerator.ARsTdesign")

Dim wbk As IXlsWorkbook 
Set wbk = engine.New( "output.xlsx" )

Dim wksht As IXlsWorksheet 
Set wksht = wbk.AddWorksheet( "Sheet1" )

wksht.Import.XML.Options.XPath = "/Bookstore/Book"
wksht.Import.XML.ImportFile( "C:\\tmp\\Bookstore.xml" )

wbk.Close

• 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

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

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. "