Bug 79063

Summary: cell height of spreadsheet printed different after cut/paste to Writer as object when row height set using dialog
Product: LibreOffice Reporter: Raphael <raphael.biolluz>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: trivial    
Priority: low CC: cno, jmadero.dev, todventtu
Version: 4.2.4.2 release   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: 2 files to show the bug with lines when printing
2 new files with the same problem
PDF output file from LibO Writer 4.3.0.2 Pasted spreadsheet with line errors

Description Raphael 2014-05-22 08:33:30 UTC
Created attachment 99568 [details]
2 files to show the bug with lines when printing

I work with a spreadsheet that has these cell properties :
- border lines of 0.25pt
- content space : 0.49 mm

I use some lines as spacers (0.05mm height) between celles containing data.

- If I print from Calc, no problem, lines are ok on the paper.
- If I cut/paste a part of my spreadsheet to a Writer page, when printing it, some lines don't have the correct spacement, sometimes lines disapear (especially those on top of the spreadsheet parts).

I didn't had this problem with Libreoffice 4.1.
Comment 1 pierre-yves samyn 2014-05-25 13:55:26 UTC
Hi

Sorry I do not reproduce. I don't see any differences when I print your documents.
Tested on windows 7/64 & Version: 4.2.4.2
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8

Regards
Pierre-Yves
Comment 2 Raphael 2014-05-26 07:01:40 UTC
Created attachment 99833 [details]
2 new files with the same problem
Comment 3 Joel Madero 2014-07-21 17:28:39 UTC
@Raphael - please test with 4.2.5.2 or newer and provide an attachment that is the output of print to file (so it creates a pdf of what is printed on your side). Marking as NEEDINFO - once you attach a pdf showing what result you get in writer please set to UNCONFIRMED.

Thanks for helping us diagnose this.
Comment 4 Raphael 2014-07-22 06:46:58 UTC
Created attachment 103258 [details]
PDF output file from LibO Writer 4.3.0.2 Pasted spreadsheet with line errors

Testing with LibreOffice 4.3.0.2 I still have the problem.

See the attachment : the top lines thats shows on the PDF doesn't print and between the 2 reduced lines one doesn't respect the 0.05 spacement.
Comment 5 Beluga 2014-11-26 11:42:52 UTC
Reproduced partially. The vertical space of row 6 gets smaller when pasted to Writer, no need to print to see it. The top line doesn't disappear when printing.

If I redo it from scratch in Calc, the problem is reproduced when setting the row height in the dialog (select row, right-click the row number - Row height).

However, if I resize the row height with the mouse to 0,05 (a bit fiddly) and making sure I get it right, the table pasted into Writer is ok and prints out ok.

Setting to NEW. I also changed the title a bit and lowered severity per https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54
Comment 6 Raphael 2014-12-02 13:06:42 UTC
I made new tests with the 4.4 beta : I still have the spacement problem, but the disapearing top lines seem to have been resolved somwhere with the 4.4.0 beta version.
Comment 7 Raphael 2014-12-12 13:27:00 UTC
I found something interesting : when moving lines by hand to try to reduce their size to 0.05mm, it's impossible, Calc is limiting this gap to 0,07mm each time, I cannot go under this value.... but when choosing line height by entering a value, i can go under 0.07mm
There's a bug that allows to overrride the 0.07mm limit sometimes but not always.

Is there a way to modifiy the 0.07mm limit in the options panel ?

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.