Bug 79063 - cell height of spreadsheet printed different after cut/paste to Writer as object when row height set using dialog
Summary: cell height of spreadsheet printed different after cut/paste to Writer as obj...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: low trivial
Assignee: Not Assigned
Keywords: regression
Depends on:
Blocks: Paste Calc-Cells
  Show dependency treegraph
Reported: 2014-05-22 08:33 UTC by Raphael
Modified: 2018-07-07 16:51 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

2 files to show the bug with lines when printing (24.37 KB, application/zip)
2014-05-22 08:33 UTC, Raphael
2 new files with the same problem (29.65 KB, application/zip)
2014-05-26 07:01 UTC, Raphael
PDF output file from LibO Writer Pasted spreadsheet with line errors (7.12 KB, application/pdf)
2014-07-22 06:46 UTC, Raphael

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

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

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 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 Pasted spreadsheet with line errors

Testing with LibreOffice 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 Buovjaga 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:
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 ?
Comment 8 tommy27 2016-04-16 07:22:42 UTC Comment hidden (obsolete)
Comment 9 Raphael 2016-04-18 08:32:25 UTC

the bug is still here, I work with the following version :

Build ID: d3bf12ecb743fc0d20e0be0c58ca359301eb705f
Threads CPU : 4; Version de l'OS :Windows 6.1; UI Render : par défaut; 
Locale : fr-FR (fr_FR)

I tried with the same file on LibreOffice 3.3 and the cut/paste is working fine, line heights are correct.
LibreOffice 3.3.4 
OOO330m19 (Build:401)
tag libreoffice-
Comment 10 Xisco Faulí 2016-09-12 12:19:16 UTC
Adding keyword 'bibisectRequest'.
Comment 11 QA Administrators 2018-06-30 02:40:55 UTC Comment hidden (obsolete)
Comment 12 Buovjaga 2018-07-07 16:51:45 UTC
Re-tested per my old comment 5 and the row heigh no longer appears smaller (compared with the old .odt attachment to be sure).


Arch Linux 64-bit
Build ID: 2cff0e2ceb53b2986be8788c7505cabbd04d0288
CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on July 7th 2018