Issue 125925 - Convert Excel to PDF not working for big images
Summary: Convert Excel to PDF not working for big images
Status: UNCONFIRMED
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-02 10:53 UTC by ankit
Modified: 2015-09-29 12:42 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
contains excels related to this problem (392.40 KB, application/octet-stream)
2014-12-02 10:53 UTC, ankit
no flags Details
Example1 (245.46 KB, image/jpeg)
2015-09-29 12:36 UTC, patrick.s.merker
no flags Details
Example2 (278.19 KB, image/jpeg)
2015-09-29 12:36 UTC, patrick.s.merker
no flags Details
Example 3 (399.79 KB, image/png)
2015-09-29 12:37 UTC, patrick.s.merker
no flags Details
Google.jpeg (220.23 KB, image/jpeg)
2015-09-29 12:37 UTC, patrick.s.merker
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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).