• read existing pivot tables
• write pivot charts (introduced in libre office 5.4.1)
• read cell data validations
• read auto filter and custom filters
• improved writing of custom filters

• for reading and creating XLS files, memory consumption much lowered by defaulting to 4KB blocks instead of 64KB blocks
• for reading chart formatting details from any Excel file, memory leak removal

• Rendering of treemaps and sunbursts. (outputs : PNG, PDF, SVG)
• Avoid chart element overlap wherever possible, for instance make sure the legend never overlaps with the plot area
• Additional chart element formatting that were not supported in past xlsgen versions

xlsgen::IXlsChartPtr chartTreemap = worksheet->NewChart(xlsgen::charttype_treemap,
                                                     9, //row1
                                                     2, //col1
                                                     25, //row2
                                                     9 //col2
                                                     );

chartTreemap->MainTitle->Label = L"treemap";
xlsgen::IXlsChartDynamicDataSourceSeriesPtr s1 = chartTreemap->DynamicDataSource->AddSerie();
s1->SeriesValuesFormula = L"=Sheet1!$D$2:$D$6";
s1->DataLabelsFormula   = L"=Sheet1!$A$2:$C$6"; // Categories with 3 levels of depth

chartTreemap->ExtractAsPNG(L"treemap.png");

xlsgen::IXlsChartPtr chartSunburst = worksheet->NewChart(xlsgen::charttype_sunburst,
                                                     27, //row1
                                                     2, //col1
                                                     43, //row2
                                                     9 //col2
                                                     );

chartSunburst->MainTitle->Label = L"sunburst";
xlsgen::IXlsChartDynamicDataSourceSeriesPtr s2 = chartSunburst->DynamicDataSource->AddSerie();
s2->SeriesValuesFormula = L"=Sheet1!$D$2:$D$6";
s2->DataLabelsFormula   = L"=Sheet1!$B$2:$C$6";  // Categories with 2 levels of depth

chartSunburst->ExtractAsSVG(L"sunburst.svg");

xlsgen::IXlsTextBoxPtr textbox001s0 = wksht001->NewTextBox(4, 3, 9, 7, 38, 208, 128, 896);
xlsgen::IXlsRichLabelPtr richLabel001s000c0 = wksht001->NewRichLabel();
richLabel001s000c0->HtmlLabel = L"<font color=#000000 size=11 name=\"Calibri\"><b>This is </b></font><font color=#00B0F0 size=11 name=\"Calibri\"><b>blue </b></font>" \
L"<font color=#000000 size=11 name=\"Calibri\"><b>text</b></font>";
textbox001s0->RichLabel = richLabel001s000c0;

xlsgen::IXlsTextBoxPtr textbox001s0 = wksht001->NewTextBox(4, 3, 9, 7, 38, 208, 128, 896);

xlsgen::IXlsStylePtr styleDefault = wksht001->NewStyle();
styleDefault->Font->Bold = TRUE;
styleDefault->Apply();

xlsgen::IXlsStylePtr styleBlue = styleDefault->Duplicate();
styleBlue->Font->Color = 0x0000FF;
styleBlue->Apply();

xlsgen::IXlsRichLabelPtr richLabel001s000c0 = wksht001->NewRichLabel();
richLabel001s000c0->Label(L"This is ", styleDefault);
richLabel001s000c0->Label(L"blue ", styleBlue);
richLabel001s000c0->Label(L"text", styleDefault);

textbox001s0->RichLabel = richLabel001s000c0;

• Unicode fonts : prior to this, only ANSI characters in Excel files would be encoded correctly in PDF files. That would leave much of eastern languages unsupported. With Unicode fonts, PDF files use whatever character from whatever encoding.

• Font embedding : the embedding of the subset of fonts actually used in the Excel file ensures that PDF readers can accurately display characters for viewing and printing purposes. This is activated by default, meaning that such PDF files are bigger in size from those not embedding the fonts. For this reason, font embedding can be disabled by setting the boolean value to the corresponding export option :
  
  

  C/C++ code

  worksheet->Export->Options->FontEmbedding = FALSE;

• improved character spacing : even though PDF is character-based, fonts are not. Accurate spacing depends on actual glyph bounding boxes and this is taken care of to improve the reading of words in PDF files.

Single thread calculations (notice the 24% overall usage and the bottom right chart)

Mlutithread calculations (notice the 100% overall usage and all charts)

int nbCores = workbook->CalculationOptions->MultithreadCores;

And then, creating n worker threads for next calculations is just as simple :

workbook->CalculationOptions->MultithreadCores = n;

workbook->CalculateFormulas();