We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel Chart Series: Dash Types not correctly designed in excel

Using the Aspose libraries to change the dash type of line graph series in excel (e.g. Solid, Dash, Dash Dot) from a web application compiled in C#, on the excel file we encounter a dash type that is inconsistent with the style defined in the Front End.
Some examples are given in the attached document.Excel Chart Series_Dash Types not correctly designed in excel_Examples.docx (564.7 KB)

@alice.sartori,

Please note, Aspose.Cells follows MS Excel standards and specifications when creating or rendering charts. We are not sure about your issue. Could you please elaborate your issue in details and provide sample code (runnable) and Excel file(s) to reproduce the issue on our end, we will check it soon.

PS. please zip the files prior attaching here.

Hi,
attached you can find the sample code, in order to allow you to reproduce the reported anomaly.Chart editing code.zip (781 Bytes)

@alice.sartori,

Thanks for the sample code segment.

We also need your Excel files (input file (if any) and output file) to evaluate your issue precisely. We also appreciate if you could create a standalone VS.NET application (complete sample code without compile time errors), zip the project and post us, we will check it soon.

PS. please exclude Aspose.Cells.Dll to minimize the size of the application archive prior attaching.

Hello,

please find attached the output file generated.
In the file you can see the pink serie “Serie 3” dash, as you can see even if the property of the Serie “Dash” is formatted like “Dash Dot” in the Chart Area the line is partially plotted as dotted and partially with continuos dash.
Unfortunatly we cannot provide a standalone VS.NET application.
Can you please help?
ThanksOutput_Chart.zip (22.4 KB)

@alice.sartori,

It is hard to evaluate your issue based on your output file. In the chart, the dash type is set as “Dash Dot” for series line. We are also not sure your complete source code that you used, your provided code segment may not be compiled/evaluated and we are not sure what data/values you are using for different objects/variables. We request you to kindly create a separate and standalone console VS.NET application using latest version of Aspose.Cells for .NET v22.1, zip the project with the resource files (please exclude Aspose.Cells.Dll to minimize the size of the archive) and attach the archive here, so we could evaluate your issue precisely on our end. Once we reproduce the issue, we will go on to figure it out soon (we may log appropriate ticket) or help you to fix it in code (if appropriate).