Spire.XLS 7.9 adds new method to customize data label position

Spire.XLS

We are very happy to announce the release of Spire.XLS 7.9 today. In this version, we added new method to customize data label position and set the position of the comment and we have fixed 13 bugs to optimize the performance of Spire. XLS:

New Features:

Add new method to customize data label position.

ChartDataLabels format = chart.Series[i].DataPoints.DefaultDataPoint.DataLabels;
format.IsXMode = true;
format.IsYMode = true;
format.X = 1800;
format.Y = 2000;

Add new method to set the position of the comment.

ExcelComment comment = range.AddComment();
comment.SetCommentLocation(true,true);

Bug solutions:

Fixes the issue that caused the text font in the textbox bold when convert to PDF/XPS.
Fixes the issue that caused the TextRotationAngle of PrimaryCategoryAxis not working when converts to PDF.
Resolves the issue where the category label in chart is incorrect when convert to PDF.
Fixes the issue that caused the exception when combine multiple Excel files.
Resolves the issue that caused OverflowException when load Excel file.
Fixes the issue that caused shape lost when convert sheet to Image.
Fixes the issue that caused the richtext formatting lost when convert to Image.
Fixes the issues where the label colors and positions in images are not the same as in charts when save the charts from sheets as images.
Fixes the issue where the spreadsheet showed a right parenthesis on all fields when select the whole spreadsheet and click on the Comma button to format numbers with commas.
Fixes the issue that cause unusual formula calculation.
Fixes the issue where the category labels color in chart cannot changed.
Fixes the issue caused formatting Date not working in "dd/MM/yyyy" Format.
Fixes the issue caused exception when loading worksheet has password protected.

To enjoy a better experience of Spire.XLS 7.9, please download from:

http://www.e-iceblue.com/Download/download-excel-for-net-now.html