Custom Margins

We have a customer with some spreadsheets that are using custom margins that are not getting converted to PDFs correctly.



The custom margin appears to be getting ignored when rendering to a paged PDF. OnePagePerSheet is being set or false so that it will use the page size definitions in the spreadsheet.



Is there something I should be setting prior to conversion the make sure the defined margins are getting used?



I’m testing with the cells 8.2.2.0 .Net 3.5 authenticode DLL.

Hi Dwight,


Thank you for contacting Aspose support.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 8.2.2.1, and we are able to notice the mentioned problem. When we saved the provided spreadsheet to PDF format with MS Excel application, the margins are kept so the pages are rendered fine. However, saving the spreadsheet with Aspose.Cells default PDF settings causes the page to cut-off from right side.

We have logged an investigative ticket in our bug tracking system to look further into this matter. The ticket Id for your future reference is CELLSNET-43123. Please spare us little time to properly analyze the problem cause. In the meanwhile, we will keep you posted with updates in this regard.

Hi Dwight,

Thanks for using Aspose.Cells.

We have fixed
this issue now. We will provide you a fix in couple of days after
incorporating other enhancements and fixes and conducting some extensive
testing. Once, it is available for you, we will let you know asap by
posting in this thread.

Hi Dwight,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.2.2.2 and let us know your feedback.

It works. Thanks.

When will this version be released?

Hi Dwight,


Thank you for the confirmation.

The fix will be included in the upcoming official release of Aspose.Cells for .NET 8.3.0, that is scheduled for the 2nd week of November 2014. As soon as the aforesaid release is available for public use, you will be automatically notified here with the download link to the upgraded API. In the meanwhile, you can use the assembly as attached in our previous response.

Please feel free to write back in case you have further concerns or questions.

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.