Bug 67779 - IMPORT: Wrong spacing in cells (XLS, XLSX)
Summary: IMPORT: Wrong spacing in cells (XLS, XLSX)
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-05 09:49 UTC by Vitaly Bevsky
Modified: 2014-07-28 08:13 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
archive (143.08 KB, application/zip)
2013-08-06 06:55 UTC, Vitaly Bevsky
Details
anoterfiles (6.93 KB, application/zip)
2013-08-08 06:38 UTC, Vitaly Bevsky
Details
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64 (250.25 KB, application/x-zip-compressed)
2013-08-08 11:12 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Vitaly Bevsky 2013-08-05 09:49:35 UTC
Top margin in cell is too large.
Comment 1 retired 2013-08-06 03:34:23 UTC
Vitaly, without a sample document there's really nothing that can be done.

Should you be able to attach a test document producing this error, please set this bug to UNCONFIRMED.
Comment 2 Vitaly Bevsky 2013-08-06 06:55:15 UTC
Created attachment 83694 [details]
archive

I'm sorry, i missed the attachment
Comment 3 Mike Kaganski 2013-08-08 04:09:54 UTC
This problem is caused by using "MS Shell Dlg" font. Please note that LO displays the font name in italics (and will show warning tooltip if you hover the mouse over it) indicating that the font is not available and is substituted.

According to Microsoft (http://msdn.microsoft.com/en-us/library/windows/desktop/dd374112.aspx), MS Shell Dlg is a "logical font" that map to different real fonts on different systems (system-specific). They are used in user interface elements, and should not be used in documents that are intended to look identically wherever used.

Naturally, MS software does support these mappings. But I feel that using these "fonts" is a bad thing per se, and should be avoided by document authors.

If you set the font manually to Microsoft Sans Serif (Font Mapping on Windows 2000, Windows XP, Windows Server 2003, Windows Vista and Windows 7), the rendering will be much better.

I mark this as "NOTABUG", but if you feel this incorrect, please reopen it with a description. It could be an enhancement request to support these MS-specific custom mappings (though it will be inherently system-dependent, and thus inappropriate in editing software).
Comment 4 Vitaly Bevsky 2013-08-08 06:38:25 UTC
Created attachment 83808 [details]
anoterfiles
Comment 5 Vitaly Bevsky 2013-08-08 06:38:39 UTC
I saved another report from 1C:Enterprise into .xls and .xlsx. The default font is   Arial. Almost nothing changed. Text in cells moved 1 pixel up.
Comment 6 Mike Kaganski 2013-08-08 11:11:00 UTC
Ok, reproducible with 3.3.0.4 - 4.1.0.4 under Win7x64.

Two problems in the attachment 83808 [details] can be seen:
1. The cells have spacing (0,35mm) that is absent in original spreadsheet (seems that Excel doesn't have this concept at all).
2. The shift from left in LO is much more than in Excel. According to ISO/IEC 29500-1, the "indent" attribute of "alignment" element is an integer that is number of triple spaces in the normal font of the cell. ODF expresses indent in normal length units. So, the conversion from Excel indent "1" triple spaces of Arial size 8 font to "12pt" seems to be incorrect.

The problems are identical both in XLS ans XLSX.
Comment 7 Mike Kaganski 2013-08-08 11:12:58 UTC
Created attachment 83827 [details]
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64
Comment 8 Mike Kaganski 2013-08-08 14:05:48 UTC
Shift problem is Bug 67774, so this one is only about wrong spacing in cells.
Comment 9 Vitaly Bevsky 2014-02-03 07:32:06 UTC
LO 4.2 hasn't this bug fix
Comment 10 Vitaly Bevsky 2014-07-28 08:13:23 UTC
The problem is resolved in LO 4.3. I mark as fixed