Any idea of when these problems with exporting workbooks to pdf will be fixed?
We are currently working on a project that will involve sending reports to our customers, and it is using aspose cells to generate both the excel sheets and pdf reports.
It is extremely important to us to have total control over the layout of the excel and pdf files, and that the generated pdf file looks exactly like the origin excel file, especially the charts.
Any news on this issue? I'm having some problems with this chart, not only when I try to export to pdf, but also when I'm generating the chart.
The chart has two types of series: bars and points
Here are the issues I noticed:
The chart looks different from when I save it straight to pdf than when I save it to excel then open the excel file and save it to pdf. It looks totally different when I save it to excel then reopen the file and save it to pdf. When I save it straight to pdf it looks a little better.
The axis look different when I create it using aspose: both primary and secondary category axis stay on top of the chart. When I create the axis on excel one axis is on top and one is on the botton of the chart. (I'm sending sample files to show the difference)
The chart looks different on the pdf depending if I print the secondary category axis or not. Apparently the point series is only shown on the pdf when I show the secondary axys (only when saving straight to pdf)
I'm also sending attached the code I'm using to populate the chart to help with this issue.
I can send more examples to illustrate the problems above if you want.
Thanks for providing us further details and sample code plus files.
I am afraid, your issue is still not resolved. Once we have any update on it, we will let you know here.
Also, I have logged your comments with details/sample files to attach with your existing issue id “CELLSNET-41324”. Our concerned developer will look into it as well.
I tested the fix you mentioned, and I noticed the issue is still there.
The desired appearance of the chart generated by aspose is the same of the chart generated by excel.
But in this case, the axis generated by Aspose are on the same side, and the axis created by Excel are on different sides. (Chart Tools > Layout > Axis > Secondary Horizontal Axis > Show standard Axis)
Please provide us your sample project replicating this issue with the latest version: Aspose.Cells
for .NET v7.4.3.3. We will look into your project and help you asap.
Thanks for your posting and using Aspose.Cells for .NET.
We were able to replicate this issue using your sample code with the latest version. In your manually created Excel file, axis are on both sides while in the excel file created by Aspose, both axis are on the same side.
Please add chart.SecondValueAxis.IsPlotOrderReversed = false; at the last line of createChart() method to make the SecondCategoryAxis lay on bottom side.