Issue 123606 - tables in generated Pdf have different row heights for one-line values
Summary: tables in generated Pdf have different row heights for one-line values
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.0.1
Hardware: All All
: P2 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-01 11:42 UTC by Vladimir
Modified: 2013-12-14 19:43 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Attachments
Sample ods document for PDF generation (37.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-01 11:42 UTC, Vladimir
no flags Details
PDF of original attachment (55.18 KB, application/zip)
2013-11-04 10:21 UTC, Edwin Sharp
no flags Details
generated on Ubuntu Ubuntu 11.04 with AOO401m5(Build:9714) (53.71 KB, application/pdf)
2013-11-04 11:00 UTC, Vladimir
no flags Details
same row viewed with zoom levels 100%, 90% and 80% (27.83 KB, image/png)
2013-11-04 12:43 UTC, Prosper Uniger
firstofnone: review-
Details

Note You need to log in before you can comment on or make changes to this issue.
Description Vladimir 2013-11-01 11:42:49 UTC
Created attachment 81861 [details]
Sample ods document for PDF generation

Some rows have different heights, and that on one sheet. All rows have same styles, so the problem should be in export. Just try the attached file.
I see, that the reason for that could be in adjusting the table, so that the sheet has no gaps, but I think that the gap space should be distributed over all the raws of the sheet.
Comment 1 Vladimir 2013-11-01 11:44:16 UTC
some overseen fields changed
Comment 2 Edwin Sharp 2013-11-02 20:25:47 UTC
No visible problem when export as PDF with
AOO401m5(Build:9714)  -  Rev. 1524958
2013-09-20 11:54 - Linux x86_64
Debian

Please advise.
Comment 3 Vladimir 2013-11-04 10:17:10 UTC
Hi!!

can you please attach the generated PDF? The point is - different OOO produce different PDF... Maybe I just should use your version...
Comment 4 Edwin Sharp 2013-11-04 10:21:42 UTC
Created attachment 81875 [details]
PDF of original attachment

AOO410m1(Build:9750)  -  Rev. 1536093
Rev.1536093
Win 7
Comment 5 Vladimir 2013-11-04 10:40:12 UTC
you right, I'll test the latest version
Comment 6 Vladimir 2013-11-04 10:58:06 UTC
I just tried the new version, AOO401m5(Build:9714)  -  Rev. 1524958
2013-09-20 11:54 - Linux x86_64

The generated file has problems (see the 2nd sheet, 3rd row in attach)...
Comment 7 Vladimir 2013-11-04 11:00:30 UTC
Created attachment 81876 [details]
generated on Ubuntu Ubuntu 11.04 with AOO401m5(Build:9714)
Comment 8 Prosper Uniger 2013-11-04 11:32:47 UTC
(In reply to Vladimir from comment #6)
> I just tried the new version, AOO401m5(Build:9714)  -  Rev. 1524958
> 2013-09-20 11:54 - Linux x86_64
> 
> The generated file has problems (see the 2nd sheet, 3rd row in attach)...

In the normal view the row has 2 lines of text.
In the page preview it has only 1 line of text, but still the height for 2 lines.

AOO 3.4.1 shows the same behavior.

I think the text lines in normal view and pageview should be the same, so no one gets unexpected print results.
Comment 9 Vladimir 2013-11-04 11:50:01 UTC
(In reply to Prosper Uniger from comment #8)
> (In reply to Vladimir from comment #6)
> > I just tried the new version, AOO401m5(Build:9714)  -  Rev. 1524958
> > 2013-09-20 11:54 - Linux x86_64
> > 
> > The generated file has problems (see the 2nd sheet, 3rd row in attach)...
> 
> In the normal view the row has 2 lines of text.
> In the page preview it has only 1 line of text, but still the height for 2
> lines.
> 
> AOO 3.4.1 shows the same behavior.
> 
> I think the text lines in normal view and pageview should be the same, so no
> one gets unexpected print results.

On my Computer the Document in normal view has 1 text line for the problem row... Nevertheless - what could be done about that? Is the issue confirmed?
Comment 10 Vladimir 2013-11-04 11:54:11 UTC
Correct me, if I wrong, but in my opinion it is wrong that the same document for the same Office version produces different PDF. That is surely a bug. And that bug is triggering another one, with table-raw calculation for the printing...
Comment 11 Prosper Uniger 2013-11-04 12:43:44 UTC
Created attachment 81879 [details]
same row viewed with zoom levels 100%, 90% and 80%

This is a real odd one.

The number of lines seems to depend on the zoom level.
When play with the zoom lever in the bottom right corner, the lines in the row switch form 1-2 all the time. The cell height stays the same (2 lines).

(In reply to Vladimir from comment #9)
> On my Computer the Document in normal view has 1 text line for the problem
> row... Nevertheless - what could be done about that? Is the issue confirmed?
I'm no dev or qa member. Just a normal user trying to narrow the problem down. No Idea what could be done.

Does your pdf look the same as in the print preview? If so, try to adjust the cells dimensions till it looks good.
Comment 12 Vladimir 2013-11-04 12:58:20 UTC
(In reply to Prosper Uniger from comment #11)

> Does your pdf look the same as in the print preview? If so, try to adjust
> the cells dimensions till it looks good.
The pdf in preview looks like on PDF, but cell dimensions adjusting is not an option - the file is generated dynamically, so the content can change, but the document should look OK for A4 sheet, and for PDF
Comment 13 Prosper Uniger 2013-11-04 13:39:47 UTC
(In reply to Vladimir from comment #12)
> (In reply to Prosper Uniger from comment #11)
> 
> > Does your pdf look the same as in the print preview? If so, try to adjust
> > the cells dimensions till it looks good.
> The pdf in preview looks like on PDF, but cell dimensions adjusting is not
> an option - the file is generated dynamically, so the content can change,
> but the document should look OK for A4 sheet, and for PDF

I was digging in old bug reports a bit and found bug 51508 which describes a similar problem with spacings.

try the workaround from bug 51508, comment 15

when I set "Use printer metrics for text formatting" checked, there lines stay the same for all zoom levels and the print preview and pdf look good too.
Comment 14 Vladimir 2013-11-04 16:48:58 UTC
(In reply to Prosper Uniger from comment #13)
> try the workaround from bug 51508, comment 15
> 
> when I set "Use printer metrics for text formatting" checked, there lines
> stay the same for all zoom levels and the print preview and pdf look good
> too.

You are my hero!!
That helped to solve the problem. Nevertheless, this is the bug, 'cause different heights for rows with same quantity of strings is nonsense. They should have same height out-of-box, without digging bug reports ;-)
By the way - on Windows this workaround doesn't work...
Comment 15 Edwin Sharp 2013-12-14 19:43:55 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7