xlsgen bug fixes

Generate Excel files. Speed. Flexibility. Depth. Robustness.

 

xlsgen 2.9 build #45 : Fix pack (Jan 2010)


Build 2.9.0.45 includes no less than 15 fixes and improvements.

In details,

- support formulas of the form "=#REF! $B$1:$B$2" (i.e. including error tokens)
- support formulas of the form "=$A$1:$B$2 $B$1:$B$2" (i.e. intersections)
- support formulas of the form "=$A2:INDIRECT()..." (i.e. formula-based range construction)
- support formulas of the form "=ADDRESS(INDIRECT():INDIRECT())..." (i.e. left and right hand formula-based range construction)
- support multiple conditions for rendering conditional formattings. So far, the first condition evaluated to true would cancel evaluation (and therefore inclusion of styles) of other conditions.
- read existing XLSX comments
- combine vumeter and sparklines into the same component. No more vumeter.ocx in the installer.
- support CORREL and PEARSON functions in the calc engine.
- fix a GPF when resaving a XLSX file generated by xlsgen. The problem was a missing fragment for custom data labels in charts.
- write a default theme part in all new XLSX files. Necessary for improving the compatibility with OpenOffice, most notably charts.
- better preserve the print gridlines flag from XLSX files.
- better compute the bounding area of conditional formattings in XLS files.
- better handling of HYPERLINK records in XLS files.
- preserve the localSheetId attribute from defined names in XLSX files. This caused file errors in Excel.
- support GetSerieByName for charts using dynamic sources.

No source code changed are needed to take advantage of these.

Posted on 16-January-2010 07:29 | Category: xlsgen, Excel generator

 

 

<-- previous page