We encountered 2 issues when we are using aspose to generate files.
- When we are getting height from aspose code then it is giving us 15, while when we are opening the file in excel then the row height is totally different.
- There should be a bottom border on each page when we are generating the PDF, as we can check from the print preview in excel.
Below are the steps to reproduce issue 1 (please follow these steps while try to generate file from aspose code)
Step 1. Open a workbook
Step 2. Set the column width to less than the contents, so that the complete column content can’t be displayed properly.
Step 3. Autofit the rows
Step 4. Wrap the text
Step 5. Save the file to another file
Step 6. Open the newly saved file using aspose, try to find out the row height, height reported by excel would be 15.
Step 7. Now open the same workbook in excel and check for the row height, it should be some other value.
To reproduce issue 2 please follow below steps
Step 1. Open a workbook with merged cells and some border setup
Step 2. Save it as PDF
Step 3. Open the print preview of the workbook in excel, there would be border on all the pages
Step 4. Now open the PDF generated by aspose, set zoom to 100%, the bottom border would be missing on all the pages, except the last page.
This issue is impacting our production environment and user are complaining about the formatting issues, would really appreciate if we can get those fixed ASAP.
We had already attached the sample code, sample files and screenshot for your kind reference, please let us know in case any further details are needed from our side.
Sample Files.zip (13.7 KB)
Sample Images.zip (108.0 KB)
Sample Code.zip (21.7 KB)