Bug 92813 - PRINTING: Page format does not align when printing via Excel
Summary: PRINTING: Page format does not align when printing via Excel
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Print-Preview
  Show dependency treegraph
Reported: 2015-07-18 18:05 UTC by Drizzt
Modified: 2023-05-21 06:07 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Test document with margins set and rows numbered (9.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-07-30 12:54 UTC, Buovjaga
Test compared MSO and LO (143.36 KB, image/png)
2019-07-08 08:29 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description Drizzt 2015-07-18 18:05:56 UTC
When attempting to print a spreadsheet with 0.25" borders on all edges, the print preview shows 2 fewer rows to be printed than when using the same print settings in Microsoft Excel.  This is problematic, since I the spreadsheet layout has been setup to fit the entire page, but Calc doesn't print it the same way.  It would be great if Calc and Excel print the same .XSLX worksheet in the same way.
Comment 1 Buovjaga 2015-07-30 12:54:57 UTC
Created attachment 117534 [details]
Test document with margins set and rows numbered

0.25" = 0,635 cm (page margins)
55 rows in MSO print preview
53 rows in LibO print preview

Win 8.1 32-bit
MSO 2013
LibO 5.0 RC4
Comment 2 QA Administrators 2016-09-20 10:20:52 UTC Comment hidden (obsolete)
Comment 3 Mike 2018-07-07 18:30:14 UTC
Print Preview in Excel '13 shows 55 rows, LO 6.1b2 just 53 rows.

Version: (x64)
Build ID: 33b7319e2e08812a2f7d3126e4b1ec90875d6165
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:libreoffice-6-1, Time: 2018-07-03_04:13:19
Locale: de-DE (de_DE); Calc: group threaded
Comment 4 QA Administrators 2019-07-08 02:49:09 UTC Comment hidden (obsolete)
Comment 5 Timur 2019-07-08 08:29:41 UTC
Created attachment 152635 [details]
Test compared MSO and LO

Repro LO 6.4+. Was different with OO but not same as MSO.
Similar to bug 107999 but here there's mismatch even if Calibri font changed to Liberation. Let's keep separate so far.
Comment 6 QA Administrators 2021-11-14 04:00:45 UTC Comment hidden (obsolete)
Comment 7 BogdanB 2023-05-21 06:07:49 UTC
Also in
Version: (X86_64) / LibreOffice Community
Build ID: 4536694edb7e564ea1f4ae871e9107f52ed0972f
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

Print preview shows 53.