Created attachment 175169 [details]
Example file from Excel with 28.35 pt (1cm) row heights saved, but displayed as smaller values
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 120288
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.
Probably Calc should do this kind of cheating somehow for Excel-made files.
Version: 22.214.171.124.alpha0+ (x64) / LibreOffice Community
Build ID: 770dcb1f717d576facf31efed14bee403e1a7155
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Created attachment 175170 [details]
Screenshot of the original document side by side in Excel and Calc: displayed row height is smaller in Excel
Created attachment 175171 [details]
Example file from Excel in Normal view: displayed row height is 0.1 pt smaller
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":
tdf#144642 XLSX import: round down row height to 0.75 pt
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.
Version: 126.96.36.199.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