Chart labels mixed inside chart lines

Dear Aspose.
As you can see from example.
Bug-1539654-Chart-Labels-inside-Chart-Lines-difference.png (111.6 KB)

Please see the numbers in exported svg are inside chart lines - so the figure itself is mixed with the line.

  1. The position of data labels is not same in Excel and SVG export.
  2. The dashed line frequency is also not the same - see the peak in Excel for number 2794
    there is a line drawn on the top but there is a void part of dashed line drawn in exported SVG for that peak

Attaching sample application demonstrating the issue:
Bug-1539654-Chart-Labels-inside-Chart-Lines.zip (435.6 KB)

We have used Windows and latest Aspose.Cells 26.4 to produce the results.

Best Regards
Pavel

@ottap

Hello Pavel,

Thank you for providing the sample project and the associated files, including the source Excel workbook, the generated SVG output, and the comparison screenshots. We appreciate the detailed reproduction steps and the environment information provided.

We have successfully reproduced the issue using Aspose.Cells 26.4. Our analysis confirms that the data labels for the specified values are incorrectly positioned, causing them to overlap with the series line rather than maintaining the offset seen in Excel. Furthermore, we have observed the discrepancy in the dashed line rendering, where the dash-gap pattern in the SVG output does not accurately reflect the Excel styling.

We have logged this behavior for further investigation to ensure the SVG rendering engine handles label placement and line styles more consistently with Microsoft Excel.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-60079

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

Hi @ottap
Regarding the issue of dashed lines, we conducted research and found that when Excel changes the zoom settings, the frequency of the dashed lines also changes continuously in the interface.
For Excel print preview, when you select Chart compared to selecting Worksheet, due to the change in the print area causing a change in zoom, you can see that the frequency of the dotted lines in Excel’s print preview also changes.
Currently, we have optimized the frequency of the dashed lines based on the output result after Excel exporting the XLSX to PDF. Please refer to the image below.
compare.png (43.4 KB)

We have also optimized the position of the Datalabels. The current SVG output is as follows.
This file is the output result generated on the Windows platform using SkiaSharp, referencing the effect of Excel exporting the XLSX file to PDF.
Please compare it with the previous version and let us know your feedback. Thank you.
260420.zip (5.8 KB)

The issues you have found earlier (filed as CELLSNET-60079) have been fixed in this update. This message was posted using Bugs notification tool by leoluo