Build 4.0.0.47 of xlsgen improves the handling as well as the exposure of header/footer in spreadsheets.
Namely,
- XLSB files correctly read even header/footer as well as first page header/footer. In Excel 2007, two additional header/footers were introduced on top of the regular header/footer : even header/footer for specifying a header/footer for even pages (2, 4, ...), and a first page header/footer which is a header/footer applied only to the first page of a sheet.
- rendering of even header/footer as well as first page header/footer in all rendering scenarios (print, preview, PDF, XPS, ...)
- exposure of even header/footer and first page header/footer in the xlsgen object model. See the
IXlsPageSetup interface, namely PageEvenHeader, PageEvenFooter, PageFirstHeader and PageFirstFooter properties.
- fix for default gridlines when writing XLSB files. That was defaulting to a yes and it was inconsistent with XLSX files as well as what Excel does.
- parsing of font color tags (&K + rgb color and &K + theme color).