Good day
Hi Ian,
Thank you for sharing the sample.
I have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 17.2.0, and I was not able to see any layout problem in the resultant PDF document. However, I have noticed that one of the charts “10 day tonnes history” is missing completely in the PDF. I have raised this incident as CELLSNET-45147 in our bug tracking system for further investigation. Please spare us little time to properly analyze the case and revert back with updates in this regard. In the meanwhile, please give a try to the latest version (available in Aspose download section) and see if your can find any other issue(s) which I may have missed.
Hi Ian,
- I have noticed that you haven’t given the latest version a try on your end because your recently shared PDF is again generated with Aspose.Cells version 16.11.1.
- The provided code snippet is not setting the PDF compliance whereas the shared PDF comply with PDF/A standards.
- The screenshot shared here shows completely different graphs which seem not to be present in the sample spreadsheet shared in this thread.
Hi how do I accomplish the following
Sorry I attached the incorrect files. Sorry for that last post has the correct files
Hi Ian,
Thank you for sharing the fresh sample.
I have reevaluated the presented scenario while using the latest version of Aspose.Cells for .NET 17.2.0, and I am able to notice the said problem, that is; charts from the sample loose formatting/layout when spreadsheet renders to PDF format. I have raised this incident with the product team under the ticket CELLSNET-45151. Please spare us little time to properly analyze the scenario and get back with updates in this regard.
C#
book.Settings.CreateCalcChain = false;
book.CalculateFormula();
book.Save(dir + “output.pdf”, SaveFormat.Pdf);
Hi again,
ian@mineware.co.za:how do I check what version was used to generate the PDF
You can check the “PDF Producer” tag from the PDF document properties in Adobe Acrobat Reader (Ctrl+D). Please check the attached snapshot for your reference.
ian@mineware.co.za:how do I accomplish the followingThe provided code snippet is not setting the PDF compliance whereas the shared PDF comply with PDF/A standards
Please use the PdfSaveOptions.Compliance property as demonstrated ahead.
C#
book.Settings.CreateCalcChain = false;
book.CalculateFormula();
book.Save(dir + “output.pdf”, new PdfSaveOptions() { Compliance = PdfCompliance.PdfA1b});
Thanks
Hi Ian,
I understand.
Good day
Hi Ian,
Hi Ian,
Good day
Hi Ian,
The issues you have found earlier (filed as CELLSNET-45151;CELLSNET-45147) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.