Hi ,
I have an excel sheet which we are converting to PDF. We have some rows where the data is grouped but when we are converting the excel to pdf we don’t see values in the grouped rows. I tried ungrouping the rows but that didnt help. Could you please let me know any other way i can approach the problem.
Thanks for providing us some details.
Please note, both Aspose.Cells and MS Excel render the Excel file to PDF as data is shown (for different sheets) in print preview of MS Excel. So, you should open the Excel file and take the print preview of the sheet and then compare it with the output PDF page(s) by Aspose.Cells. If you see anything different, then you can relate it as an issue in Aspose.Cells. In this case, we need your template Excel file and output PDF file to evaluate your issue on our end. If you do not see any difference in comparisons, then you should consider that it is not an issue in Aspose.Cells by any means.
Please do the needful as suggested and let us know if you still have any issue or confusion.
@Amjad_Sahi : Yes that is the issue in the print preview i could see the grouped rows values but when i generate the pdf the grouped rows don’t show any value and are empty. So i thought there could be something i am missing. thanks.
Please do the needful as requested:
So, kindly do attach your template Excel file and output PDF file by Aspose.Cells API.
Hi Amjad, i tried replicating the issue when i created a sample file the pdf rendered correctly but when i tried with my actual file the grouped data is not getting rendered in the pdf. So if you have any idea related to this or you can guide me in anyway that would be really very helpful.
I am afraid, I have no clue why this is happening with your original file. May be you could open the file into MS Excel and save it as PDF by built-in MS Excel renderer if the output PDF is fine tuned or not.
We are very sorry but unless we have your template file, we might not evaluate your issue precisely, so can’t help you much.
@Amjad_Sahi: I am able to ungroup the rows but what is happening is that the group rows have a row in the end which has a calculated number in bold, that number is not showing up in my original file. PFA the attached PDF file.
In the attached pdf as u can see after every three or four rows there is a row with bold values. When I render my original sheet in the same format the bold values are not visible.
Thanks for the PDF file.
Could you try to call Workbook.CalculateFormula() method before rendering to PDF file format if it figures out your issue.
