Bug 67774 - IMPORT XLS: Alignment shift is incorrect (also XLSX)
Summary: IMPORT XLS: Alignment shift is incorrect (also XLSX)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.0 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-05 08:58 UTC by Vitaly Bevsky
Modified: 2014-02-03 07:35 UTC (History)
0 users

See Also:
i915 platform:
i915 features:


Attachments
archive (106.56 KB, application/x-zip-compressed)
2013-08-05 08:58 UTC, Vitaly Bevsky
Details
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64 (201.64 KB, application/x-zip-compressed)
2013-08-05 11:33 UTC, Mike Kaganski
Details

Description Vitaly Bevsky 2013-08-05 08:58:37 UTC
Created attachment 83649 [details]
archive

1. Some cells are shifted right, but not all.
2. Cell's lines are not hided behid the text.
See screen
Comment 1 Mike Kaganski 2013-08-05 11:32:00 UTC
Well, it is reproducible with 3.3.0.4 - 4.1.0.4 and AOO 4.0 under Win7x64.

The spreadsheet is formatted manually. The text that looks shifted compared to MS Excel, is actually written all in the column B, and is formatted as aligned to left with shift. The shift value in MS Excel is 5.

LO imports it with shift value 50pt. It looks like these values are not in a good accordance. This is the bug.

The text in row 9 is in two cells: B9 and C9.
The text in rows 21-22 is in cells B22 and B23, but is aligned left without shift, and there is a number of spaces before text in each cell.
Comment 2 Mike Kaganski 2013-08-05 11:33:02 UTC
Created attachment 83658 [details]
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64
Comment 3 Mike Kaganski 2013-08-08 14:04:40 UTC
The same problem with incorrect shift is reported for XLSX (see bug 67779).
Comment 4 Vitaly Bevsky 2014-02-03 07:35:00 UTC
LO 4.2 hasn't this bug fix


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.