Build 3.0.0.26 of xlsgen improves text boxes formattings.

Before that build text boxes only supported a fill color and a border. Beginning with this build, text boxes can support ALL border formattings (style, width, color) and all area formattings (fill, gradients, texture, pattern and images).

This support is for XLS and XLSX files. And it supports both floating text boxes and chart text boxes.

Here is a preview of what can be created with build 3.0.0.26 with a few lines of code :


Border and area formattings for text boxes

And here is the corresponding source code :

xlsgen::IXlsTextBoxPtr textbox = worksheet->NewTextBox(2,3, 5,6, 0,200, 80,300);
textbox->Label = L"text box formattings";

textbox->Patterns->Borders->Type = xlsgen::chartbordertype_custom;
textbox->Patterns->Borders->Weight = xlsgen::chartborderweight_hairline;
textbox->Patterns->Borders->Style = xlsgen::chartborderstyle_dashdot;
textbox->Patterns->Borders->Color = xlsgen::colorRed;

textbox->Patterns->Area->Type = xlsgen::chartareatype_custom;
textbox->Patterns->Area->Gradient->SingleColor->GradientStyle = xlsgen::gradientstyle_diagonalUp1;
textbox->Patterns->Area->Gradient->SingleColor->Color = 0x0000DD;
textbox->Patterns->Area->Gradient->SingleColor->LightThreshold = 100;