This project has moved. For the latest updates, please go here.

Graph on OpenOffice

Jun 6, 2013 at 8:35 PM
I'm creating a spreadsheet with EPPlus library on a .NET 4.0 command line application.

I successfully loaded all the data from the data base, at the end I'm creating a graphic, this is my code:
var chart = sheet.Drawings.AddChart("Revenue", OfficeOpenXml.Drawing.Chart.eChartType.ColumnClustered);

chart.SetPosition(2, 0, 4, 0);
chart.SetSize(650, 400);

chart.Series.Add(ExcelRange.GetAddress(3, 2, 14, 2),ExcelRange.GetAddress(3, 1, 14, 1));
chart.Title.Text = "Revenue";
I open the generated file in MS Office 2010 and everything looks fine, the data the graphic, etc.. but if I open the same generated file in OpenOffice 3.3 the graphics are empty.

The weird thing is, if I open the file in Office 2010 and make a copy (Save As).. and I open the copy in OpenOffice, the graphics are good... so I'm wondering if I'm missing something in my code to make it compatible with both Office2010 and OpenOffice

Thanks for the help!
Aug 5, 2013 at 8:24 AM
Hi,

I have exactly the same problem. Did you get any solution or can someone help us ?

Thanks !
Aug 5, 2013 at 9:43 AM
I just tried the Sample5 from the latest source code and the same problem appears.

The pie chart is ok under Excel but nothing is displayed in OpenOffice !

Thanks,
Paul