Bug 107999 - Printout height differences between Excel with 50 and Calc with 48 items of XLSX with Microsoft fonts
Summary: Printout height differences between Excel with 50 and Calc with 48 items of X...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
Depends on:
Blocks: Font-Rendering
  Show dependency treegraph
Reported: 2017-05-22 11:48 UTC by Yunus ÖNER
Modified: 2022-06-10 09:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Printout differences between ms office and calc (1.10 MB, image/jpeg)
2017-05-22 11:48 UTC, Yunus ÖNER
Printout differences between ms office and calc (822.02 KB, image/jpeg)
2017-05-26 10:53 UTC, Yunus ÖNER
Original File (8.61 KB, application/zip)
2017-05-29 05:16 UTC, Yunus ÖNER
LO export to PDF (17.05 KB, application/pdf)
2017-05-29 05:18 UTC, Yunus ÖNER
MSO export to PDF (169.27 KB, application/pdf)
2017-05-29 05:19 UTC, Yunus ÖNER

Note You need to log in before you can comment on or make changes to this bug.
Description Yunus ÖNER 2017-05-22 11:48:55 UTC
Created attachment 133449 [details]
Printout differences between ms office and calc

In printouts in Calc. line height is different than in MsOffice.This is cuasing problems in using LibreOffice. Please see picture in attachment, it is generated in MS-Office 2016 and taken printout; same file opened in Calc(Libre ver. and taken printout from same printer. Calc print out is 1,5 cm longer and overlapped in second page.
Comment 1 Yunus ÖNER 2017-05-26 10:53:29 UTC
Created attachment 133612 [details]
Printout differences between ms office and calc
Comment 2 Timur 2017-05-26 18:02:49 UTC Comment hidden (obsolete)
Comment 3 Yunus ÖNER 2017-05-29 05:16:21 UTC
Created attachment 133685 [details]
Original File
Comment 4 Yunus ÖNER 2017-05-29 05:18:49 UTC
Created attachment 133686 [details]
LO export to PDF
Comment 5 Yunus ÖNER 2017-05-29 05:19:28 UTC
Created attachment 133687 [details]
MSO export to PDF
Comment 6 Yunus ÖNER 2017-05-29 05:28:19 UTC
Original file is attached, it's name is Book1.xlsx
Added MSO and LO PDF output
Comment 7 Buovjaga 2017-08-07 08:40:05 UTC
Confirmed with PDF export.
Same result on Linux even though the font is substituted.
It is already wrong in older versions (results vary per version), tested 3.5 and 4.4 on Win, 3.6 on Linux.

Win 10
Version: (x64)
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 4; OS: Windows 6.19; UI render: default; 
Locale: fi-FI (fi_FI); Calc: group

Arch Linux 64-bit, KDE Plasma 5
Build ID: 5.4.0-1
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 8 Timur 2017-08-08 12:39:03 UTC
Difference happens with Calibri or TNR font, and not with Liberation. 
Can't say whether this would help, but it's Writer only, not in Calc: https://help.libreoffice.org/index.php?title=Common/Compatibility
Comment 9 QA Administrators 2018-08-09 02:36:07 UTC Comment hidden (obsolete)
Comment 10 Timur 2018-08-17 09:03:03 UTC
Same with 6.2+.
Related issue with table height  attachment 82529 [details] from Bug 66989.
Comment 11 QA Administrators 2022-06-10 03:33:19 UTC Comment hidden (obsolete)
Comment 12 Timur 2022-06-10 09:18:18 UTC Comment hidden (obsolete)