https://bugs.documentfoundation.org/show_bug.cgi?id=120288
Bug ID: 120288
Summary: FILESAVE XLSX Default font style affects the height of
rows in Excel
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 145352
--> https://bugs.documentfoundation.org/attachment.cgi?id=145352&action=edit
The original XLSX file saved with the default font style settings.
Custom row heights in Microsoft Excel are affected by the default text style
set in LibreOffice Calc. LibreOffice Calc uses 10 pt Liberation Sans as its
default font. When a spreadsheet created in Calc is saved as XLSX and opened in
Microsoft Excel, the row heights appear a bit smaller. The difference isn't
obvious at first sight, but it can cause 1-2 cm difference in how the same
spreadsheet is rendered by the end of the first page.
The strange thing is, that when the height of the row is checked manually in
Excel, it shows (almost) the correct value (with some rounding differences),
for example 0,99 cm instead of 1 cm. Printing the document and measuring the
rows with a ruler makes it obvious, that in reality the real height of a row is
close to 0,93 cm, so the displayed value in Microsoft Excel is incorrect.
If we change the default font style in LibreOffice Calc to Calibri 11pt, save
the same spreadsheet again as XLSX, and open it in Excel, the rows are rendered
(and printed) exactly as in Calc. It doesn't matter what characters and font
sizes are actually used in the spreadsheet, changing the default is enough,
even when the default style is not actively used in any cells with content.
Steps to reproduce:
1. Create a new spreadsheet in LibreOffice Calc. Write something in the
first ten rows (like numbers from 1 to 10).
2. Change the row height for the first then rows to 1 cm.
3. Save the file as XLSX.
4. Print the file from LibreOffice Calc and Microsoft Excel and compare the
results.
5. Open the XLSX again in Calc, change the default font style in the Styles
and formatting sidebar to Calibri 11.
6. Save the document again as XLSX, preferably with a new filename to keep
the original file for comparison.
7. Print the spreadsheet from LibreOffice Calc and Microsoft Excel and
compare the results again.
Actual results:
The default font style set in LibreOffice Calc affects the height of the rows
in Microsoft Excel.
Expected results:
The default font style set in LibreOffice Calc shouldn't affect the height of
the rows in Microsoft Excel.
LibreOffice details:
Version: 6.2.0.0.alpha0+
Build ID: 52cb73911e661fb636085337374e09845f07783b
CPU threads: 1; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:master, Time: 2018-10-02_01:05:50
Locale: hu-HU (hu_HU); Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
