My company is operating a series of tests on document conversion from Excel to PDF. Constantly we face few problems which block us in our tests. Mostly visual glitches on some part of the document.
I prepared a list with some conversion Errors that we faced while running our conversion test process. I noted file name and conversion error description. Finally, I will attach all source files to this thread.
1 - Cross.xls
Incorrect Shape Rendering : the resulted PDF has a trimmed shapes with a part of the check not shown.
2 - Checkbox.xls
Checkboxes are miss-aligned. On the source file checkbox is aligned on the left, while on the resulted PDF a strange behavior of alignment is occurring.
3 - text cropped bottom.xls
Text cropped: The title has been cropped on Line 8.
4 - arrows-text-margin.xls
A lot of errors!
Sheet 1
Page 1
Rectangle Shifted
Yellow arrow clockwise inverted
Text with numbers shifted
Text wrap : photo (1)
Page 2
Red arrow clockwise inverted
end text overlapped
Sheet 2
Triangle over text and not-aligned with text
Sheet 3
Page 1
Text missing : "Rapprocher"
Page 2
Red arrow clockwise inverted
Sheet 4
Red arrow clockwise inverted
5 - dotted.xls
Dotted lines are missing from resulted PDF
6 - text on drawing.xls
Text is not aligned in circle,triangle,hex…
That’s all for this thread, please take time to answer for all points mentioned above.
We have evaluated your presented scenarios on our end, and were able to replicate most of the issues mentioned issues. However, we are unable to find the text “Rapprocher” in the spreadsheet “arrows-text-margin.xls” worksheet “Feuil3”. Please provide the cell name containing this text for further evaluation on our side. Moreover, the problem related to the text getting cut-off in the resultant PDF for the spreadsheet “text cropped bottom.xls” is caused due to the reason that merged cells (containing the text) need to be auto fit vertically before rendering the results to the PDF format. Please check the below provided code snippet that should resolve this problem.
C#
Workbook book = new Workbook(myDir + “text+cropped+bottom.xls”);
AutoFitterOptions options = new AutoFitterOptions();
options.AutoFitMergedCells = true;
book.Worksheets[0].AutoFitRows(options);
book.Save(myDir + “text+cropped+bottom.pdf”, SaveFormat.Pdf);
Please also check the attached resultant PDF for your reference.
Rest of the reported issues were logged in the sequence as mentioned in your post. However, we have segregated the defects depending upon their nature, and have logged them in a separate tickets. Details of the logged tickets are as follow:
CELLSNET-42828: Incorrect shape rendering (Shape is trimmed-off in the resultant PDF) for spreadsheet "Cross.xls".
CELLSNET-42829: Check Box alignment problem in the resultant PDF for the spreadsheet "Checkbox.xls".
CELLSNET-42830: Arrow direction changed in the resultant PDF. We have logged this problem against every occurrence of the defect for the spreadsheet "arrows-text-margin.xls" by attaching separate snapshots for each problem.
CELLSNET-42831: Rectangle shape shifted down in the resultant PDF for the spreadsheet "arrows-text-margin.xls" worksheet "Feuil1".
CELLSNET-42832: Text outside the printing area is rendered in the PDF for the text "Photo (1)" of "spreadsheet arrows-text-margin.xls" worksheet "Feuil1".
CELLSNET-42833: Shape is overlapping the text in the resultant PDF for the spreadsheet "arrows-text-margin.xls" worksheet "Feuil2".
CELLSNET-42834: Horizontal dotted lines are missing in the resultant PDF for the spreadsheet "dotted.xls".
CELLSNET-42835: Text alignment problem in the resultant PDF for the spreadsheet "text+on+drawing.xls".
Please spare us little time to properly analyze these problem on our end, and to provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.
In case you have further questions or concerns, please feel free to write back.
Thanks for you prompt answer and time logging the tickets.
The text “Rapprocher” is located inside a text box, I just exported the PDF Using Microsoft Word 2013, you’ll see clearly the text box zone.
The problem of applying your correction is that we don’t work with document by document basis instead we have an automated process that convert thousands of documents on a client server.
We are not supposed to intervene on each document conversion!
Please keep me updated ASAP and thanks again for continuous support!
We are able to replicate the problem of missing text “Rapprocher” when spreadsheet “arrows-text-margin.xls” is rendered as PDF while using the latest version of Aspose.Cells for .NET 8.1.1.3. The problem has been logged in our bug tracking system under the ticket CELLSNET-42838 for further investigation and correction purposes.
Regarding the issue of text getting cropped in a merged cell of spreadsheet “text cropped bottom.xls”, please note that without any additional settings applied (such as auto fit cell/row height), Aspose.Cells renders the spreadsheet to PDF format as it is shown in the MS Excel preview. Moreover, MS Excel 2010 renders the text in question cropped from the top, as you may observe the results in attached PDF file. I am afraid, if you do not apply the auto fit row(s) operation on the spreadsheet, you may not be able to avoid this situation as it is the correct behavior of Aspose.Cells APIs to render the spreadsheet as shown in MS Excel application.
The issues you have found earlier (filed as CELLSNET-42835;CELLSNET-42833;CELLSNET-42829;CELLSNET-42831;CELLSNET-42830;CELLSNET-42828) have been fixed in this update.