PlotEmptyCellsType.NotPlotted not working when converting to pdf

Aspose.Cells Product Family
1

I have an Excel Worksheet which has a chart with the PlotEmptyCellsType property set to PlotEmptyCellsType.NotPlotted. This works fine in Excel, there are gaps where they should be however when converting this workbook to PDF all the gaps have been replaced by zeros. Is there something I need to set in the PDF document or is this a bug with the conversion?

Thanks a lot

2

Hi,

Which versions of Aspose.Cells and Aspose.Pdf you are using? Could you try our latest version (4.4.2.0): http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry121168.aspx

If you still find the problem, Could you post your sample code, created .xls file and the output .pdf file here to show the issue, We will check it soon.

Thank you.

3

Hi,

I'm using the newest version of both Cells and PDF so there isn't a problem there, can I email you the file as its confidential and can't be displayed on a forum like this?

Thanks

4

Hi,

Yes you can email us at our team address i.e. nanjing@aspose.com , Kindly give us details of your problem and post your sample code, created .xls file and the output .pdf file to show the issue, We will check it soon.

Thank you.

5

Hi,

I emailed that address you sent on Wednesday but haven't got a response to acknowledge receipt of the email or that there is a problem. Is that email address you posted correct?

Thanks

6

Hi,

We will figure out your issue soon.

Thanks for being patient!

7

I get your email and forward it to our developers. We are still working on this issue.

8

Hi,
Please try this fix in

http://www.aspose.com/community/forums/122261/y-axis-label-resizes-in-pdf/showthread.aspx#122261