https://bugs.documentfoundation.org/show_bug.cgi?id=145129
Bug ID: 145129
Summary: FILEOPEN XLSX Default row height about to page number
difference
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Attached file was made in Excel by setting 2 cm margins and 1 cm row heights.
This results on screen 26 visible rows on one A4 page: 29.7 cm – 4 cm margins =
25.7 cm. But: 26 1 cm rows mathematically should not fit in 25.7 cm space, yet
they do.
In Calc however only 25 rows are visible in page layout view / print.
This is related to bug 144642
What really happens there is that Excel displays row heights in 0.75 point
increments, so 1 cm becomes 9.79 mm.
On the other hand, it writes to XLSX files the user input value, this is what
Calc displays.
This is a bit of cheating (also happens with Calc-saved XLSX files in Excel),
this results in more rows being displayed than what could fit in the available
vertical space.
Steps to Reproduce:
1.Open attached file in Excel and Calc, go to layout view.
Actual Results:
Excel shows 26 rows, Calc shows 25 on one page.
Different page numbers.
Expected Results:
Have matching page numbers.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c998691e22ceda15c89d55cf7005201f0392dadb
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
