Incorrecct PDF Format

Aspose.Cells Product Family
1

Hi,

I am using smartmarker in the pre-designed template to generate pdf file.
When I am creating a file in the pdf format then the count of number of records and average of records is not coming proper.
Also some code data is visible in the pdf file.

Please find attached sample I have created to show errors and look for the image for the explanation…

Thanks,
Deepali

2

Hi,

Thank you for considering Aspose.

Please use Workbook.CalculateFormula() before saving the file to PDF. Please update your code as below:

WorkbookDesigner wbDesigner = new WorkbookDesigner();

wbDesigner.Open(designerFile);

Worksheet workSheet = wbDesigner.Workbook.Worksheets["Sheet1"];

// Put the data to report XL

wbDesigner.SetDataSource("Book1", GetBookList());

wbDesigner.Process();

wbDesigner.Workbook.CalculateFormula();

wbDesigner.Workbook.Save(outputFile, FileFormatType.Pdf);

Process.Start(outputFile);

Thank You & Best Regards,

3

Thanks it sorted out the problem !!!

4

Hi,

Before using this method charts were visible in the raw state i.e. as in design template but after using this method instead of charts blank pages are being shown in the pdf

Thanks,
Deepali

5

Any update on the chart issue

6

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We are working on your issue and will provide a fix within 1~2 days. Also, I have added your issue to our issue tracking system with issue id CELLSNET-11771.

Thank You & Best Regards,

7

Hi,

Thank you for considering Aspose.

We have replied to your issue in your following thread:

https://forum.aspose.com/t/68982

Thank You & Best Regards,