extrait : "La Commission européenne a lancé mardi un ultimatum à la Belgique pour qu'elle donne vendredi son feu vert au Ceta, traité de libre-échange avec le Canada, lors d'un sommet européen à Bruxelles."

Ultimatum? Ca fait partie du champ lexical de la soumission, non ?

Build 4.0.0.52 of xlsgen adds support for rendering histograms created by Excel 2016 (and by xlsgen).


Histogram rendered by xlsgen (number-based histogram with 4 bins including an overflow bin)

Histograms as defined by Excel 2016 are in fact two histograms depending on whether the data is string-based or number-based.

For strings, histograms group them in categories (strict string match with case sensitivity, etc.), sum up their associated values and show them. It's the equivalent of a stacked bar chart except the fact with stacked charts the visual representation keeps the summed up values separated.

For numbers, histograms automatically or programmatically creates groups known as bins, and associate it with the total of numbers for each bin, i.e. frequency, thereby showing the frequency of each bin. The bin width can be customized, the bin count as well as two special bins, which are the overflow bin and the underflow bin. All of those parameters are optional.

This build also introduced the HistogramByCategory boolean property which allows to manually tell if the histogram is to be written/read/rendered as a string-based histogram or a number-based histogram.

By providing an API for creating and rendering histogram Excel 2016 charts, xlsgen allows such scenarios without Excel 2016 installed on the computer.