Setting the location and hyperlink of picture in chart is supported by Spire.XLS 7.8
It's my great pleasure to announce the release of Spire.XLS 7.8. With the hard work of our development team, we have added 2 new features to increase the functionality of Spire.XLS and have provided 10 bug solutions to improve the performance of Spire.XLS.
New features:
Add new feature to add a picture to chart at a location, and then assign a hyperlink to it.
IPictureShape ps = chart.Shapes.AddPicture(GetInputFile(@"90.png");
ps.Top = 50;
ps.Left = 60;
ps.Width = 230;
ps.Height = 290;
(ps as XlsBitmapShape).SetHyperLink("http://www.baidu.com",true);
Add new feature to set dataField position in pivotTable.
pt.Options.DataPosition =0//default is -1, which is in the last.
Bug Solutions:
- Fix the issue where Strong encryption algorithms were not supported when loaded encrypted Excel document.
- Fix the issue that caused Excel document to PDF conversion failed.
- Fix the issue that caused content incorrect when converted Excel document to PDF.
- Reduce the generated PDF document size when convert Excel document to PDF.
- Address the issue that caused the ArgumentOutOfRangeException when inserted image into footer.
- Fix the issue where it was unable to read complete Excel file.
- Resolve the issue that caused the .xlsm/.xlsx document failed to be loaded.
- Fix the issue that caused the exception that "The number must be between 10 and 400" when loaded .xlsx file.
- Fix the issue that caused IndexOutOfRangeException when loaded .xlsx file via stream.
- Reduce the elapsed time while converted Excel document to image.
To enjoy a better experience, please download it from the following link:
http://www.e-iceblue.com/Download/download-excel-for-net-now.html