Build 5.0.0.56 of xlsgen fixes a problem related to duplicating shapes (including pictures). The name and alternate text are now duplicated as well. If this applies, a unique name for the shape is created to avoid conflicts.

Build 5.0.0.55 of xlsgen tightens the screws when generating Excel files in two areas : merged cells and custom sheet views. xlsgen makes sure that the file keeps consistent and Excel does not report that the resulting file is corrupt.

Build 5.0.0.54 of xlsgen adds support for 11 functions in the calculation engine (read/write was already supported) :

- TEXTAFTER(text;delimiter;[instance_num]; [match_mode]; [match_end]; [if_not_found])
Returns text that is after a delimit character

- TEXTBEFORE(text;delimiter;[instance_num]; [match_mode]; [match_end]; [if_not_found])
Returns text that is before a delimit character

- TEXTSPLIT(text;col_delimiter;[row_delimiter];[ignore_empty]; [match_mode]; [pad_with])
Splits text into rows or columns according using delimit characters

- XOR(logical1; [logical2],…)
Returns a logical exclusive OR of all arguments

- IFNA(value; value_if_na)
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

- DAYS(end_date; start_date)
Returns the number of days between two dates

- EDATE(start_date; months)
Returns the serial number of the date that is the indicated number of monts before or after the start date

- EOMONTH(start_date; months)
Returns the serial number of the last day of the month before or after a specified number of months

- ISOWEEKNUM(date)
Returns the number of the ISO week number of the year for a given date

- WEEKNUM(serial_number;[return_type])
Returns the week number in the year

- NETWORKDAYS(start_date; end_date; [holidays])
Returns the number of workdays between two dates with custom weekend parameters