Bug 67774

Summary: IMPORT XLS: Alignment shift is incorrect (also XLSX)
Product: LibreOffice Reporter: Vitaly Bevsky <delph1ct>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium    
Version: 3.3.0 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=67779
Whiteboard:
i915 platform: i915 features:
Attachments: archive
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64

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.