Bug 46884 - Calc: Font rendering problem, text becomes wrapped in cell when printed
Summary: Calc: Font rendering problem, text becomes wrapped in cell when printed
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
3.4.5 release
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2012-03-02 03:12 UTC by Eugenij Shkrigunov
Modified: 2021-02-28 10:15 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
sample document (10.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-02 03:12 UTC, Eugenij Shkrigunov
Details
normal view screenshot (9.41 KB, image/png)
2012-03-02 03:14 UTC, Eugenij Shkrigunov
Details
preview screenshot (9.15 KB, image/png)
2012-03-02 03:14 UTC, Eugenij Shkrigunov
Details
video demonstrating the problem (290.77 KB, video/x-matroska)
2012-04-03 22:57 UTC, Eugenij Shkrigunov
Details
shown in worksheet (66.14 KB, image/jpeg)
2017-11-10 10:00 UTC, Aridatopus
Details
shown in print preview and printed (44.39 KB, image/jpeg)
2017-11-10 10:01 UTC, Aridatopus
Details
Output from writer for various fonts (8.92 KB, image/png)
2018-08-30 09:38 UTC, John Talbut
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eugenij Shkrigunov 2012-03-02 03:12:56 UTC
Created attachment 57909 [details]
sample document

Hi!
Sorry for my English.

In an attachment, a document (and screenshots), which display on the screen and when printed are different. The text overlaps the adjacent cell.

Please, fix it.
Thank you.
Comment 1 Eugenij Shkrigunov 2012-03-02 03:14:11 UTC
Created attachment 57910 [details]
normal view screenshot
Comment 2 Eugenij Shkrigunov 2012-03-02 03:14:53 UTC
Created attachment 57911 [details]
preview screenshot
Comment 3 Eugenij Shkrigunov 2012-03-03 05:04:43 UTC
If you can't reproduce the problem, try to change the scale of the view that the contents of the cells could fit one line with minimal column width.
Comment 4 Eugenij Shkrigunov 2012-03-10 10:29:21 UTC Comment hidden (obsolete)
Comment 5 Eugenij Shkrigunov 2012-03-27 05:32:13 UTC Comment hidden (no-value)
Comment 6 Eugenij Shkrigunov 2012-03-31 13:13:32 UTC Comment hidden (obsolete)
Comment 7 Eugenij Shkrigunov 2012-04-03 22:57:24 UTC
Created attachment 59460 [details]
video demonstrating the problem

LibreOffice 3.5.2.2
350m1(Build:202)
Comment 8 Eugenij Shkrigunov 2012-04-23 05:49:00 UTC
The problem is that the similar documents was created by accounting program(many times per day) and macros set the optimal width of the columns. When you print the text is damaged.
Please, help.
Comment 9 Eugenij Shkrigunov 2012-05-12 01:26:43 UTC Comment hidden (no-value)
Comment 10 sasha.libreoffice 2012-05-29 10:48:18 UTC
Thanks for bugreport
> Are there any news?
Yes, but they are very bad.

What I see currently:
on Windows, in 3.5.2: initially after opening attachment, hight of rows is 0,73 cm. Print preview shows overlapped text. But when editing mode I right mouse click on any word, hight of rows immediately changes to 1,26 cm. It is strange. But when I change width of column so that text fits in cells, then Print preview shows all correct.

on Fedora 64 bit, in 3.5.3: initially after opening attachment, hight of rows is 1,31 cm. After changing width of column so that text fits in cells, then Print preview shows all correct.

on Fedora 64 bit, in 3.3.4: initially after opening attachment, hight of rows is 0,72 cm, text fits into cells in edit mode initially, no need to change width of column. Print preview shows overlapped text.

So, Calc behaves very different in different versions and OS.
Comment 11 Eugenij Shkrigunov 2012-05-30 10:22:21 UTC
(In reply to comment #10)
> Yes, but they are very bad.
> 
> What I see currently:
> on Windows, in 3.5.2: initially after opening attachment, hight of rows is 0,73
> cm. Print preview shows overlapped text. But when editing mode I right mouse
> click on any word, hight of rows immediately changes to 1,26 cm. It is strange.
> But when I change width of column so that text fits in cells, then Print
> preview shows all correct.
> 
> on Fedora 64 bit, in 3.5.3: initially after opening attachment, hight of rows
> is 1,31 cm. After changing width of column so that text fits in cells, then
> Print preview shows all correct.
> 
> on Fedora 64 bit, in 3.3.4: initially after opening attachment, hight of rows
> is 0,72 cm, text fits into cells in edit mode initially, no need to change
> width of column. Print preview shows overlapped text.
> 
> So, Calc behaves very different in different versions and OS.

The problem is on the amd64 and x86, Windows and Linux (various distro).
If you can't reproduce the problem, try to change the scale and width of column that
the contents of the cells could fit one line with minimal column width.
On different platforms, the problem may occur at different scales.
Comment 12 sasha.libreoffice 2012-05-31 01:19:46 UTC
> try to change the scale
Indeed, in edit mode distance from right text margin to right hand column edge differs depending of zoom. reproduced this in 3.5.4 on XP and Fedora

But in File->Page preview all looks correctly. And I have question:
In File->Page preview bug always seen or appears such situations that in File->Page preview all correct, but on Printer text is wrapped?

And another question: it reproducible with different fonts or with some specific font?
Comment 13 Eugenij Shkrigunov 2012-05-31 10:23:43 UTC
(In reply to comment #12)
> > try to change the scale
> Indeed, in edit mode distance from right text margin to right hand column edge
> differs depending of zoom. reproduced this in 3.5.4 on XP and Fedora
> 
> But in File->Page preview all looks correctly. And I have question:
> In File->Page preview bug always seen or appears such situations that in
> File->Page preview all correct, but on Printer text is wrapped?
> 
> And another question: it reproducible with different fonts or with some
> specific font?

Dependence on the scale (with a minimum width of a column): preview sometimes correct, sometimes not. I have always found such a scale at which the preview incorrect.
If preview incorrect - hard copy incorrect too.
I tried a dozen fonts - there is a problem with all.
Comment 14 sasha.libreoffice 2012-06-01 00:35:24 UTC
> If preview incorrect - hard copy incorrect too.
And opposite variant: preview correct - hard copy corrupted exists?

I interesting in this question, because can not reproduce this bug on Windows and Linux in 3.5.4 version. It may be because I not see bug, because in preview it not shown, but on printer appears.

Another question: bug reproducible namely in first attachment document or for testing used another document. And in 3.5.4 version bug still seen in PagePreview?
Comment 15 sasha.libreoffice 2012-06-01 00:37:35 UTC
Somehow resembles this:
Bug 45869 - PDF: PDF conversion different from original ODS
Comment 16 Eugenij Shkrigunov 2012-06-04 03:39:28 UTC
(In reply to comment #14)
> > If preview incorrect - hard copy incorrect too.
> And opposite variant: preview correct - hard copy corrupted exists?
I did not notice that.

> I interesting in this question, because can not reproduce this bug on Windows
> and Linux in 3.5.4 version. It may be because I not see bug, because in preview
> it not shown, but on printer appears.
To reproduce, try to reduce the column width so that the text does not fit and look preview.

> Another question: bug reproducible namely in first attachment document or for
> testing used another document. And in 3.5.4 version bug still seen in
> PagePreview?
Yes, in 3.5.4 there is a problem too.
Comment 17 Eugenij Shkrigunov 2012-06-04 03:40:41 UTC
(In reply to comment #15)
> Somehow resembles this:
> Bug 45869 - PDF: PDF conversion different from original ODS
Maybe it is somehow related to this bug.
Comment 18 sasha.libreoffice 2012-06-05 01:55:47 UTC
Problem appears (in page preview) only if I reduce column with so that last word becomes hidden and red triangle appears (in edit mode).
Comment 19 Eugenij Shkrigunov 2012-06-06 22:12:11 UTC
(In reply to comment #18)
> Problem appears (in page preview) only if I reduce column with so that last
> word becomes hidden and red triangle appears (in edit mode).

Actually, I have a problem with a minimum width of a column: LibreOffice-3.4.5.2, Gentoo amd64.
Comment 20 Eugenij Shkrigunov 2012-06-14 00:40:40 UTC
(In reply to comment #19)
> Actually, I have a problem with a minimum width of a column:
> LibreOffice-3.4.5.2, Gentoo amd64.

mistake in writing: LibreOffice-3.5.4.2
Comment 21 Eugenij Shkrigunov 2012-06-29 04:28:14 UTC Comment hidden (no-value)
Comment 22 sasha.libreoffice 2012-06-29 04:40:51 UTC
> Are there any news?
No, Sir!
Comment 23 Eugenij Shkrigunov 2012-08-05 07:55:25 UTC
Also LibreOffice-3.5.5.3
350m1(Build:3)
Comment 24 bfoman (inactive) 2012-08-08 08:47:11 UTC
Changed status to NEW.
Comment 25 QA Administrators 2015-01-05 17:51:54 UTC Comment hidden (obsolete)
Comment 26 Eugenij Shkrigunov 2015-01-14 06:19:15 UTC
The bug still present in versions: 4.2.8.2, 4.3.5.2
Comment 27 parchd 2015-03-23 13:14:51 UTC
Still present:
Version: 4.4.1.2
Build ID: 4.4.1.2 Arch Linux build-2

I suggest that this bug be classed as major. In my case, it causes the content of one cell to appear in the cell above it (or sometimes overlapping an adjacant cell).

The text apearing in the wrong cell without overlap can be extremely misleading.

The problem is not apparent when editing, but is apparent in both print preview and exported PDFs.

The spreadsheet I am working with is created from scratch in LibreOffice Calc, not exported from any other software.
Comment 28 QA Administrators 2017-03-06 14:16:06 UTC Comment hidden (obsolete)
Comment 29 Eugenij Shkrigunov 2017-03-07 06:44:38 UTC Comment hidden (obsolete)
Comment 30 Eugenij Shkrigunov 2017-03-13 12:03:28 UTC
LibreOffice-5.2.6.2: the bug still present
Comment 31 Aridatopus 2017-11-10 10:00:48 UTC
Created attachment 137656 [details]
shown in worksheet
Comment 32 Aridatopus 2017-11-10 10:01:36 UTC
Created attachment 137657 [details]
shown in print preview and printed
Comment 33 Aridatopus 2017-11-10 10:03:16 UTC
(In reply to Eugenij Shkrigunov from comment #30)
> LibreOffice-5.2.6.2: the bug still present

LibreOffice 5.3.6.1: The bug still present
Comment 34 Eugenij Shkrigunov 2017-11-18 17:18:09 UTC
(In reply to Aridatopus from comment #33)
> LibreOffice 5.3.6.1: The bug still present

Libreoffice-5.4.2.2: The bug still present
Comment 35 Eugenij Shkrigunov 2018-05-25 11:09:27 UTC
LibreOffice 6.0.3.2: the bug still present
Comment 36 John Talbut 2018-08-30 09:34:59 UTC
I am not sure if this is the same problem, but I am getting the character spacings messed up for proportional fonts in writer and calc.  Lireoffice 6.1.1.1 from Debian Testing.  Screenshot attached.
Comment 37 John Talbut 2018-08-30 09:38:09 UTC
Created attachment 144549 [details]
Output from writer for various fonts
Comment 38 Eugenij Shkrigunov 2019-01-09 13:28:14 UTC
With Libreoffice 6.1.4.2 I can't reproduce original problem anymore.
Comment 39 John Talbut 2019-01-09 20:08:58 UTC
Me neither.
Comment 40 QA Administrators 2021-02-28 04:00:38 UTC Comment hidden (obsolete)
Comment 41 Eugenij Shkrigunov 2021-02-28 07:37:33 UTC
The problem is fixed.
Thank you very much!