• specialcells_type_allformatconditions : cells with conditional formatting(s)
• specialcells_type_allvalidation : cells with data validation(s)
• specialcells_type_blanks : blank (empty) cells
• specialcells_type_comments : cells with comment notes
• specialcells_type_constants : cells with non-formula values (*)
• specialcells_type_formulas : cells carrying formulas (*)
• specialcells_type_lastcell : last cell of the range (bottom right corner)
• specialcells_type_sameformatconditions : cells with the same conditional formatting
• specialcells_type_samevalidation: cells with the same data validation
• specialcells_type_visible : visible cells (neither row nor column are hidden)

(*) : If the chosen condition is either constants or formulas, then the application may filter according to the literal data type, one or more of the following :

• specialcells_value_na : not applicable (no filter)
• specialcells_value_error : cells with formula errors
• specialcells_value_logical : cells with a logical (boolean) value
• specialcells_value_number : cells with numbers (integer, float, date)
• specialcells_value_text : cells with text

// find cells with a formula, turn them red
XlsRange r = workbook.getWorksheetByIndex(1).
    getUsedRange().getSpecialCells(xlsgen.specialcells_type_formulas, xlsgen.specialcells_value_na);
r.getStyle().getPattern().putBackgroundColor(0xFF0000);
r.Apply();

xlsgen::IXlsWorkbookPtr wbk = engine->New( L"output.xlsx" );

xlsgen::IXlsWorksheetPtr wksht = wbk->AddWorksheet( L"Sheet1" );

wksht->Import->HTML->Options->ColumnDataMappingFormatByIndex[3] = L"0 \"kms\""; // note the use of double-quotes

wksht->Import->HTML->ImportFile(L"input\\data.html");

wbk->Close();

• 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