Hi,

I have created a chart and changed the major gridline style, but after saving the spreadsheet in FileFormatType.Excel2007Xlsx format, the chart reverts back to a solid line.

This is not a problem if I save it as Excel2003.

int chartIndex = sheet.Charts.Add(this.ChartType, 15, 0, 35, 10);
Aspose.Cells.Chart chart = sheet.Charts[chartIndex];
chart.ValueAxis.MajorGridLines.Style = Aspose.Cells.LineType.Dash;

chart.NSeries.Add("B2:D2", false);
chart.NSeries[0].Name = sheet.Cells["A2"].StringValue;

chart.NSeries.Add("B3:D3", false);
chart.NSeries[1].Name = sheet.Cells["A3"].StringValue;

chart.NSeries.CategoryData = "A1:D1";

Aspose.Cells.ChartFrame plotarea = chart.PlotArea;
plotarea.Area.BackgroundColor = Color.White;
plotarea.Area.ForegroundColor = Color.White;

workbook.Save(datasheetFilename, Aspose.Cells.FileFormatType.Excel2007Xlsx);

Hi,

Yes, we found the issue with MajorGridLines' line style that is not rendered fine for MS Excel 2007 xlsx file format, we will look into it and get back to you soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will fix it and get back to you soon.

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Thank you for your quick response.

I've also discovered that there are many other formatting options that aren't being saved, and some of these aren't even being saved in Excel2003 format, for example the plot area border color.

Hi,

Please try the attached version as I have tested setting plotarea's border color and it works fine in both 2003xls and 2007xlsx files. Could you give us details which other formatting attributes are not working in 2007xlsx files.

And will continue to look into your previous (MajorGridLines line styles issue in 2007 xlsx files) and get back to you soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Please try the attached version. We have fixed the issue for 2007 xlsx file format i.e.., “Chart major gridlines does not retain dash type when saving as .xlsx”.

Thank you. 

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Amjad Sahi:

Please try the attached version as I have tested setting plotarea's border color and it works fine in both 2003xls and 2007xlsx files. Could you give us details which other formatting attributes are not working in 2007xlsx files.

Thanks for that. Another formatting feature that does not work is the rotation of the category axis labels:

chart.CategoryAxis.TickLabels.Rotation = 45;

Just like the with the previous issue, this works when saving as .xls but not .xlsx

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon.

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

 

Thank you for considering Aspose

 

Please try the attached latest version. We have fixed the tick label rotation issue you have mentioned. Please let us know if you still face a problem.

 

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

The issues you have found earlier (filed as 9554) have been fixed in this update.

---

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

Note: Just for your knowledge. In the new release v4.8.0, we have merged Aspose.Grid suite to Aspose.Cells for .NET msi installer as Aspose.Grid would be no longer offered as a separate product now. You need to install the installer (uninstall older one first if you have) and use only Aspose.Cells.dll library in your project for your need. You may also take advantage using Aspose.Cells Grid suite though.