| Summary: | IMPORT XLS: Alignment shift is incorrect (also XLSX) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Vitaly Bevsky <delph1ct> |
| Component: | Spreadsheet | Assignee: | 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 |
||
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. Created attachment 83658 [details]
Screenshots of MS Excel and LO 4.1.0.4 under Win7x64
The same problem with incorrect shift is reported for XLSX (see bug 67779). 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.
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