Build 3.5.0.57 of xlsgen improves how custom dates are inserted. Before this build, if you ran a statement such as :

worksheet.Date[row][col] = "15 august 2014";

xlsgen would actually parse the date by using the user's regional settings (Windows / Control panel / Regional settings), which means a date such as the one above would parse correctly ONLY if the user was using a US or UK regional settings. Otherwise this would return an error.

There was no way to specify a date format to help the parser.

Beginning with this build, xlsgen takes into account the existing style in the target cell when it parses a date to be inserted in that cell.

So if you pass a date format such as,

IXlsStyle s = worksheet.NewStyle();
s.NumberFormat = "dd-MMMM-yyyy";
s.Apply();

You can then use this :

worksheet.Date[row][col] = "15-august-2014";

and this date will be parsed correctly.

Build 3.5.0.56 of xlsgen better preserves boolean values in XLSX files. Before this build, a value such as TRUE would be replaced by 1.

Build 3.5.0.55 of xlsgen ensures that whenever the new chart engine introduced in 3.5 encounters a gap in data series, the chart rendering does not render any value at this point. This is corresponding expected behavior whenever the chart is setup as such chart.CustomProperties.ChartInterpolateEmptyCells = chartinterpolate_no;

Build 3.5.0.54 of xlsgen supports a local implementation of the TEXT() function in the calculation engine which indeed takes into account the user's regional settings for date/time passing.

In particular, the TEXT() function makes it possible to convert, if you are using a German settings, a date using the following date format "tt-mm-jjjjj" instead of "dd-mm-yyyy" which is the ISO 8601 form of the date format.

The TEXT() function supports the 6 country settings available in formulas in xlsgen which are : English-US, French, German, Spanish, Italian, Portuguese.

Build 3.5.0.53 of xlsgen makes it possible to copy tables when worksheets are duplicated, and to delete any existing table.

By table we mean the table object intriduced in Excel 2007, which is a contiguous range area, made of headers of rows of data, plus an associated table style.