Bug 35510 - Incorrect import of .xls document (black diagonal lines)
Summary: Incorrect import of .xls document (black diagonal lines)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected)
3.3.1 release
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: XLS
  Show dependency treegraph
Reported: 2011-03-21 10:32 UTC by Daniil Bratashov
Modified: 2021-01-17 06:05 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

screnshot of incorrect behaviour (125.23 KB, image/png)
2011-03-21 10:32 UTC, Daniil Bratashov
screenshot of right variant from MSO2003 (28.40 KB, image/png)
2011-03-22 11:30 UTC, Daniil Bratashov
screen with diagonal lines (151.71 KB, image/png)
2015-01-05 21:41 UTC, Daniil Bratashov
Example of misplaced diagonal line (57.50 KB, application/vnd.ms-excel)
2018-12-30 19:25 UTC, Daniil Bratashov

Note You need to log in before you can comment on or make changes to this bug.
Description Daniil Bratashov 2011-03-21 10:32:44 UTC
Created attachment 44675 [details]
screnshot of incorrect behaviour

There is a problem with displaying this document (black diagonal lines everywhere): http://www.vstu.ru/student/schedule/vecher/v_all.xls
Comment 1 vitruss 2011-03-21 22:10:03 UTC
Windows 7 x64 and Arch Linux amd64 the same. LO 3.3.1
Comment 2 Daniil Bratashov 2011-03-22 11:30:52 UTC
Created attachment 44719 [details]
screenshot of right variant from MSO2003
Comment 3 tester8 2011-03-22 13:03:22 UTC
Reproduced with
LibreOffice 3.3.2 RC2 (1:3.3.0-1lucid1) - Ubuntu 10.04 x86 Linux 2.6.32-28-generic Russian UI
Comment 4 Rinat 2011-03-23 04:21:28 UTC
Found easier way to reproduce:

1. Open a new spreadsheet.
2. Right-click on A1 cell, select 'Format cells...'
3. On 'borders' tab create borders (1pt, outline)
4. On 'alignment' tab set text rotation to 1 degree
5. Press ok.
Comment 5 Vladimir 2011-11-11 10:12:00 UTC
confirming in 3.4.3, Archlinux.
Comment 6 Björn Michaelsen 2011-12-23 11:43:01 UTC Comment hidden (obsolete)
Comment 7 Daniil Bratashov 2011-12-26 09:37:29 UTC
Mostly fixed in 3.5.0beta2, diagonal lines are slightly misplaced.
Comment 8 Florian Reisinger 2012-08-14 13:57:17 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.


Comment 9 Florian Reisinger 2012-08-14 13:58:39 UTC Comment hidden (obsolete)
Comment 10 Florian Reisinger 2012-08-14 14:03:12 UTC Comment hidden (obsolete)
Comment 11 Florian Reisinger 2012-08-14 14:05:26 UTC Comment hidden (obsolete)
Comment 12 sasha.libreoffice 2012-08-24 11:15:46 UTC
reproduced in 3.6.0 on Fedora 64 bit using original description
Comment 13 QA Administrators 2015-01-05 17:51:00 UTC Comment hidden (obsolete)
Comment 14 Daniil Bratashov 2015-01-05 21:40:32 UTC
It is mostly fixed with LO, but diagonal lines looks not so good, see
and new screen attached.
Comment 15 Daniil Bratashov 2015-01-05 21:41:21 UTC
Created attachment 111792 [details]
screen with diagonal lines
Comment 16 QA Administrators 2016-01-17 20:01:46 UTC Comment hidden (obsolete)
Comment 17 QA Administrators 2017-03-06 13:43:03 UTC Comment hidden (obsolete)
Comment 18 Daniil Bratashov 2017-03-06 18:03:54 UTC
The bug is still present on (Slackware linux x86_64). It is slightly better (the lines are not everywhere, it just looks like ugly non-antialiased diagonal lines near the right places to be. 

The document to test: http://www.vstu.ru/files/uo/2017-02/15764/ochnaya_forma_obucheniya_sokrashchennye_sroki-123_ftkmsv.xls
Comment 19 QA Administrators 2018-11-07 04:01:59 UTC Comment hidden (obsolete)
Comment 20 Markus Mohrhard 2018-12-05 12:12:01 UTC
Please attach the correct file to the bug report.
Comment 21 Xisco Faulí 2018-12-06 13:12:57 UTC
Dear Daniil Bratashov,
Please provide the file to reproduce this issue. The links no longer contain the files...
Comment 22 Daniil Bratashov 2018-12-30 19:25:22 UTC
Created attachment 147901 [details]
Example of misplaced diagonal line
Comment 23 Daniil Bratashov 2018-12-30 19:28:31 UTC
The example file was taken here: http://www.vstu.ru/upload/raspisanie/z/%D0%9E%D0%A1_%D0%A4%D0%A2%D0%9A%D0%9C_1%20%D0%BA%D1%83%D1%80%D1%81.xls

The bug is still present in the reduced form: the diagonal lines are slightly misplaced. LO Version:, Slackware linux 14.2 x86_64, repackage of official binaries by slackbuilds.org.
Comment 24 Xisco Faulí 2019-01-17 11:47:25 UTC
Hello Daniil Bratashov,
Thanks for attaching the document. Setting it back to NEW...
Comment 25 QA Administrators 2021-01-17 04:12:18 UTC Comment hidden (obsolete)
Comment 26 Daniil Bratashov 2021-01-17 06:05:34 UTC
This bug is still present in the reduced form (line is misplaced) in version (Slackware linux, official binaries repacked by slackbuilds.org)