Bug 112561 - XLS/XLSX/ODS - Excel uses a 1.12 line spacing for multiline text
Summary: XLS/XLSX/ODS - Excel uses a 1.12 line spacing for multiline text
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX XLS Cell-Line-Spacing
  Show dependency treegraph
 
Reported: 2017-09-22 06:08 UTC by Yousuf Philips (jay) (retired)
Modified: 2018-10-10 12:37 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
sample (13.50 KB, application/wps-office.xls)
2017-09-22 06:08 UTC, Yousuf Philips (jay) (retired)
Details
Excel 2003 vs Calc (37.88 KB, image/png)
2017-09-22 06:11 UTC, Yousuf Philips (jay) (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2017-09-22 06:08:51 UTC
Created attachment 136448 [details]
sample

If you open an xls/xslx file that has wrapped text in a cell, it will not look the same in Calc as it does in Excel, as Calc renders the text with single line spacing and Excel renders it with 1.12 line spacing. Similarly, if you open an ods from LO in Excel, it also will look different as Excel will expand the height of the row to fit the 1.12 line spacing it uses.

@Eike: any thoughts on what can be done about this interoperability issue?
Comment 1 Yousuf Philips (jay) (retired) 2017-09-22 06:11:25 UTC
Created attachment 136449 [details]
Excel 2003 vs Calc

Version: 6.0.0.0.alpha0+
Build ID: 7315f325ff7ada3d6bd85a471058fdaeaff8cdb0
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-09-17_06:58:21
Locale: en-US (en_US.UTF-8); Calc: group
Comment 2 V Stuart Foote 2017-09-22 07:22:43 UTC
Guess adding support for a line height scaling multiplier as for bug 108555 would allow setting a default other than the 100% line height, as Thomas was suggesting in bug 112497.

Do need to check Excel 2013 and 2016 for the line spacing (is it 108% as in Word's normal.dotm for those releases)?

Otherwise selecting 115% (or 108%) to match the MS Office wrapped line spacing might also lend some consistency to our UI. 

We had added LLINESPACE_115 at 5.3 as a drop list item available for paragraph line spacing (bug 85949). And we were discussing 115% as a replacement default for the Text Body paragraph style, currently at 120% (bug 94464). If used for the wrapped line spacing by Excel 2013-2016 we could shift all of LO use to 108%--better interoperability and some would be happier with the spacing aesthetics.
Comment 3 Yousuf Philips (jay) (retired) 2017-09-22 13:07:43 UTC
(In reply to V Stuart Foote from comment #2)
> Do need to check Excel 2013 and 2016 for the line spacing (is it 108% as in
> Word's normal.dotm for those releases)?

I tested excel 2003, 2007, 2010, and 2013 and they all use the 1.12, so its not related to the line spacing changes that have been happening in word.