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.
Excel shows 26 rows, Calc shows 25 on one page.
Different page numbers.
Have matching page numbers.
User Profile Reset: No
Version: 220.127.116.11.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
Created attachment 175736 [details]
Example file from Excel with DefaulRowHeight_28.35pt
Created attachment 175737 [details]
Screenshot of the original document side by side in Excel and Calc
Created attachment 175738 [details]
Screenshot of the original document side by side in Excel and Calc layout view
Created attachment 175739 [details]
Screenshot of the original document side by side in Calc layout view
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":
tdf#145129 XLSX import: round down default row height
It will be available in 7.3.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Please mark this bug as resolved. I have verified it. It is like in excel.
Version: 18.104.22.168.alpha0+ / LibreOffice Community
Build ID: ca74611acfef50280a2c1f785448d9a09cca5a0d
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Version: 22.214.171.124.alpha1+ (x64) / LibreOffice Community
Build ID: 73334560b2dd2d60ac58d2cc2b1a5295490b03e1
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU