Build 3.0.0.56 of xlsgen fixes a number of issues :
- ensure to copy advanced conditional formattings such as color scales, icon sets, time-based conditions, ... during a worksheet duplicate (works also when the source worksheet is from another workbook).
- expose the VBA macros sheet names and workbook name since these can differ from the regular sheet names and workbook name. The VBA names in Excel are available in the VBA editor in the Project properties window. In xlsgen, those names are exposed in the corresponding IXlsWorksheet and IXlsWorkbook interfaces, under properties VBASheetName and VBAWorkbookName, respectively.
- ensure that Excel-2010 marked files are preserved as such, particularly in case of moving legacy objects such as OLE embeddings. Not doing so could have triggered an error message in Excel next time the file is opened.
- optimizing how conditional formattings are written in XLSX files, avoiding XML fragments that serve no need.