Build 3.5.0.100 of xlsgen adds support for rendering stacked charts.

xlsgen 3.5 has introduced the built-in rendering of all Excel charts. Not all combinations were supported yet, and in particular stacked bar charts, stacked line charts and stacked area charts were not supported. They were rendered as regular bar charts, line charts and area charts.

Beginning with this build, stacked and stacked 100% charts are rendered correctly. The chart types supported are bars, lines and areas which are the those supported by Excel.

Stacked charts are charts were data are accumulated instead of kept side by side. This is useful for financial cases. Stacked 100% charts is a variation of stacked charts where the scale is kept in percent rather than raw accumulated values.


Example of stacked bars

Build 3.5.0.99 of xlsgen preserves 10+ workbook-level properties from XLSX files (and their variants).

Among the preserved properties are :
- date1904
- showObjects / hideObjectd
- showBorderUnselectedTables
- filterPrivacy
- promptedSolutions
- showInkAnnotation
- backupFile
- saveExternalLinkValues
- updateLinks
- hidePivotFieldList
- showPivotChartFilter
- allowRefreshQuery
- publishItems
- checkCompatibility
- autoCompressPictures
- refreshAllConnections
- defaultThemeVersion

A number of those properties affect the performance and size of files depending on their values (most are boolean values). For instance, the saveExternalLinkValues property is checked by default in Excel which means Excel saves a cache of all external references, which can be arbitrarily big. Unchecking this property in Excel's user interface ensures no such cache is saved in the file.

Build 3.5.0.98 of xlsgen improves the speed of reading of XLSX files (and their variants, XLSM, XLST, ...).

What we have done in this build is pre-tokenize XML nodes so that the parsing phase is faster for loading the parts of the file which can be arbitrarily big.

This is an ongoing work. We won't be done until reading XLSX files is as fast as reading XLS files (even though there is more work due to the unencoded nature of data and formulas in XLSX files).

Build 3.5.0.97 of xlsgen fixes the rendering of custom data labels in charts.

Whenever series would have a single item of data, custom data labels of type value would ignore the "linked to source" number format, wherever applicable. This is now fixed.

Build 3.5.0.96 of xlsgen fixes the rendering of charts of type Area.

What is changed is how the bottom portion of the area surface gets rendered. Before this build, the plot area bottom would be the area bottom. Now this x axis (category axis) is the bottom, which means the area surface correctly crosses (if there is any negative data) or rests on the x axis instead of the bottom of the plot area.

This is mostly anecdotal change but it mimcs Excel.

Cela fait deux trimestres de suite que l'entreprise la plus capitalisée des états-unis, et bientôt de la planète, trafique ses chiffres publics on omettant de dire que l'essentiel de sa croissance provient de l'entrée de son iPhone sur le marché Chinois. Apple, la petite chérie des investisseurs, et de la NSA, ne vaut rien sinon.

Avec Microsoft, qui perd de l'argent à chaque vente d'un téléphone Lumia, on se dit que le réveil va être très difficile bientôt.