[Libreoffice-bugs] [Bug 144642] New: FILEOPEN XLSX Number of rows on a page different in Excel than in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144642

            Bug ID: 144642
           Summary: FILEOPEN XLSX Number of rows on a page different in
                    Excel than in Calc
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu,
                    varga.balazs3 at nisz.hu
            Blocks: 108897

Created attachment 175169
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175169&action=edit
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.

Actual results:
Excel shows 26 rows, Calc shows 25 on one page.

Expected results:
Probably Calc should do this kind of cheating somehow for Excel-made files.

LibreOffice details:
Version: 7.3.0.0.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
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210921/9d6894ad/attachment.htm>