Issue 125925

Summary: Convert Excel to PDF not working for big images
Product: General Reporter: ankit <ankitrungta001>
Component: uiAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: oooforum, patrick.s.merker
Version: 4.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
contains excels related to this problem
none
Example1
none
Example2
none
Example 3
none
Google.jpeg none

Description ankit 2014-12-02 10:53:18 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.
Comment 1 oooforum (fr) 2014-12-02 14:10:34 UTC
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.
Comment 2 ankit 2014-12-03 06:47:08 UTC
"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?
Comment 3 patrick.s.merker 2015-09-29 12:36:38 UTC
Created attachment 84964 [details]
Example1
Comment 4 patrick.s.merker 2015-09-29 12:36:53 UTC
Created attachment 84965 [details]
Example2
Comment 5 patrick.s.merker 2015-09-29 12:37:32 UTC
Created attachment 84966 [details]
Example 3
Comment 6 patrick.s.merker 2015-09-29 12:37:47 UTC
Created attachment 84967 [details]
Google.jpeg
Comment 7 patrick.s.merker 2015-09-29 12:42:24 UTC
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).