Apache OpenOffice (AOO) Bugzilla – Issue 125925
Convert Excel to PDF not working for big images
Last modified: 2015-09-29 12:42:24 UTC
Created attachment 84277 [details] contains excels related to this problem This is with reference to Issue 125845. Previously, the resolution was given that we can switch to landscape mode to fix it. But this is not working for us as for some cases when image size are even bigger then we face the same issue. We found a strange behavior. PFA excels.zip file which contains 3 excels. "1.xlsx" file is the original file on which problem with conversion was found. In this exported pdf still has image issue. In "2.xlsx", i increased the size of images even further. In this exported pdf still has image issue. In "3.xlsx", image size is greater than "1.xlsx" still the Export to PDF is done perfectly. So it seems that its not the image size that is creating the issue. Please check it and tell us if there is a better resolution for this problem.
For 1.xlsx, you must switch to landscape _and_ adapt scaling mode. In Format > Page dialog, go to Sheet tab and choose "reduce/enlarge printout" with "60%". But as your previous question, you are in wrong place here. This is a bug tracking system and not a help desk. Thanks to post directly to the support forum: https://forum.openoffice.org If other users can confirm that you find a problem located in the application, every reproducible bug report is welcome.
"3.xlsx" is exported properly and "1.xlsx" export has problem. Both of them share same "page setup". So it seems to me like a bug, isn't it so?
Created attachment 84964 [details] Example1
Created attachment 84965 [details] Example2
Created attachment 84966 [details] Example 3
Created attachment 84967 [details] Google.jpeg
Version : 4.1.1 I used two different configurations on two separate computers and still saw the same discrepancy. I had one machine on Windows 7 and one machine running Windows 10. 1.)I downloaded the Calc files from the bug report and opened them in Calc. 2.)I then used the “Export as PDF” under the file menu. I used default magnification and page layout. I used the same settings for all three files. The first example shows the exporting issue. (Example 1.jpeg) On the left is the Calc file and on the right is the PDF made from the file it can be seen the PDF is cut off. On Example2.jpeg the image was made larger and the PDF cut off less but still did not include all the information. On Example3.jpeg the image is made even larger than in example three and the page is resized to fit the information. I was able to export the file in Google Docs and did not see the issue above (Google.jpeg).