Spire.XLS 11.9.2

Spire.XLS 11.9.2 supports converting group pictures/charts into an image

We are glad to announce the release of Spire.XLS 11.9.2. This version supports converting group pictures/charts into an image, as well as setting the "Values" field generated by the pivot table in Excel as a row label. In addition, it also enhances the conversions from Excel to SVG/images/PDF and other formats. More details are given below.

Here is a list of changes made in this release

Category ID Description
New feature SPIREXLS-3348 Setting the "Values" field generated by the pivot table in Excel as a row label.
pivottable.ShowDataFieldInRow = true;
pivottable.CalculateData();
New feature SPIREXLS-3392 Supports converting group pictures/charts into an image.
List images = sheet.SaveShapesToImage(new SaveShapeTypeOption());
for (int i = 0; i < images.Count; i++)
{
    images[i].Save(string.Format(outputFile + "{0}.png", i), ImageFormat.Png);
}
Bug SPIREXLS-3337 Fixes the issue that the content in the chart was incorrect after converting Excel to SVG files or images.
Bug SPIREXLS-3335 Fixes the issue that the generated image was incomplete after converting Excel to SVG files.
Bug SPIREXLS-3343 Optimizes the content layout of converting HTML to Excel.
Bug SPIREXLS-3344 Fixes the issue that the generated image was incorrect after converting charts in Excel to images.
Bug SPIREXLS-3359 Fixes the issue that the generated image was incorrect after converting charts in Excel to images.
Bug SPIREXLS-3361 Fixes the issue that the program threw an exception when converting Excel to EMF streams.
Bug SPIREXLS-3366 Fixes the issue that the IsPasswordProtected() method only returned "true" after converting .XLSX files to .XLS formats.
Bug SPIREXLS-3367 Fixes the issue that the program threw an exception when using the CalculateAllValue() method.
Bug SPIREXLS-3374 Fixes the issue that the vertical page breaks in the generated file was incorrect after converting Excel to PDF.
Bug SPIREXLS-3377 Fixes the issue that the fonts used in the generated file was different with the original file after converting Excel to PDF.
Bug SPIREXLS-3378 Fixes the issue that the program threw an exception when getting the data range of the chart in Excel files.
Bug SPIREXLS-3380 Fixes the issue that the filter of the pivot table in Excel did not take effect after changing it.
Bug SPIREXLS-3387 Fixes the issue that the program threw an exception when converting Excel to PDF.
Click the link to download Spire.XLS 11.9.2:
More information of Spire.XLS new release or hotfix: