Build 3.0.0.103 of xlsgen makes it possible to specify picture borders in XLS and XLSX files.

A Borders property appears in the IXlsPicture interface, which gives way to the usual suspects (width, color, style).

It goes like this (C++) :

xlsgen::IXlsPicturePtr pic1 = wksht->Pictures->Add(L"input\\aaadd.jpg");
pic1->TopCell = 2;
pic1->LeftColumn = 2;
pic1->Borders->Style = xlsgen::chartborderstyle_dashdot;
pic1->Borders->Color = xlsgen::colorRed;

Build 3.0.0.102 of xlsgen makes it possible to run scenarios now, not only create new scenarios in XLS and XLSX files.

The method call is straight forward. After the scenario of interest is set-up, all you need to get the corresponding value resulting from running the scenario is :

double result1 = scenario1.ScenarioValueAsFloat;

Build 3.0.0.101 of xlsgen has a fix related to calculating references in formulas where there is no content, i.e. outside a sheet's boundaries. xlsgen had a default behavior which did not mimic Excel.

Build 3.0.0.100 of xlsgen has fix related to formatting number formats during a render. There were cases where the third part( i.e. null part) was not taken in consideration due to the ieee value below a hardcoded threshold. Threshold fixed.

Build 3.0.0.99 of xlsgen adds support in the calculation engine for expressions of the form "<>"&"", which may be used as criteria in SUMIF() functions and the like. Such expressions actually are short for equality of data of type string, and is a case of passing an expression including an operator and no operand (empty string), which means any non-empty cell.