Download it now!
Bug 124496 - Adding diagonal borders to cells while EDITING calc file messes the file
Summary: Adding diagonal borders to cells while EDITING calc file messes the file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Border
  Show dependency treegraph
Reported: 2019-04-02 10:58 UTC by Michael@Paris
Modified: 2020-08-25 18:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Screen shot of the incorrect effect of editing diagonals (66.78 KB, image/jpeg)
2019-04-02 10:59 UTC, Michael@Paris
Sample document (22.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-04-02 12:16 UTC, Michael@Paris
Preview with alpha version (129.18 KB, image/jpeg)
2019-04-03 09:37 UTC, Michael@Paris
Preview of page 4 with alpha (160.61 KB, image/jpeg)
2019-04-03 09:41 UTC, Michael@Paris
sample file (27.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-18 08:38 UTC, aizuwakamatsu

Note You need to log in before you can comment on or make changes to this bug.
Description Michael@Paris 2019-04-02 10:58:30 UTC
I have a simple calc file with text, dates, and a simple formula (for numbering the lines, "=LINE() -1". All the cells have simple thinest borders (except the title line which has a double bottom border).
I started adding two diagonal borders to select cells in one column: it messed up randomly other borders - of this cell, of other cells in that column: deleting them or making them thicker. Preview and print showed the diagonal lines of the bottom/top cells on a page incorrectly positioned, below or above the table.
When I selected all that column in order to remove the diagonal borders, calc crashed (note: it was before doing the modification).
It systematically occurred, even upon recreating the file. Here is a link to one of the crashes report:

Steps to Reproduce:
1. Create a table.
2. Add horizontal and vertical borders to all cells.
3. Add diagonal borders to selected cells in a column.

Actual Results:
- Some preexisting horiz. and vert. borders are modified (become thicker or disappear).
- Preview and print are incorrect (see screenshot of one page of the document : the borders of that column became thicker; the diagonals of the last cell of the previous page and the top cell of the next page are displayed above and below the table).

Expected Results:

Reproducible: Always

User Profile Reset: Yes

OpenGL enabled: Yes

Additional Info:
It should have correctly displayed and printed the table.
Comment 1 Michael@Paris 2019-04-02 10:59:42 UTC
Created attachment 150480 [details]
Screen shot of the incorrect effect of editing diagonals
Comment 2 Xisco Faulí 2019-04-02 11:31:32 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 3 Michael@Paris 2019-04-02 12:16:15 UTC
Created attachment 150482 [details]
Sample document
Comment 4 Michael@Paris 2019-04-02 19:56:26 UTC
I can now explain when it crashes: it happens when I select two or more adjacent cells with diagonal borders, the moment I hit CTRL-1 (in order to remove the diagonals). So I have to remove them cell by cell. Once having done that, not only all the previous (vertical and horizontal) borders are back to the setting I had chosen, but also I can select any number of neighboring cells and hit CTRL-1 without a problem.
Comment 5 Xisco Faulí 2019-04-03 08:56:51 UTC
Thanks for the explanation.
It seems like a duplicate of bug 124410, which will be included in LibreOffice 6.2.3.

*** This bug has been marked as a duplicate of bug 124410 ***
Comment 6 Michael@Paris 2019-04-03 09:03:19 UTC
I am afraid this is NOT a total duplicate of bug 124410: the incorrect layout for preview and print is NOT mentioned in that bug.
Comment 7 Xisco Faulí 2019-04-03 09:11:46 UTC
(In reply to Michael@Paris from comment #6)
> I am afraid this is NOT a total duplicate of bug 124410: the incorrect
> layout for preview and print is NOT mentioned in that bug.

How can I reproduce it. I open the attached file, go to cell C2, Format Cells, Borders and I change it ?
Please provide the detailed steps to reproduce it.
Comment 8 Michael@Paris 2019-04-03 09:15:28 UTC
As I mentioned, and showed in the attached jpg file: there is no problem per se in setting/removing the diagonals, but when you PREVIEW the file (or PRINT it), the diagonals of the top cell appear under the table on the previous page, and the diagonals of the bottom cell appear on the top of the next page, above the table. The crash is a different procedure.
Comment 9 Xisco Faulí 2019-04-03 09:19:41 UTC
I can't reproduce the print preview problem in

Build ID: 93f1c3665fcdc31c36078f179ac37fd69d3ebb00
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

Could you please try to reproduce it with a master build from ?
You can install it alongside the standard version.
Comment 10 Michael@Paris 2019-04-03 09:35:41 UTC
I downloaded and installed version
While the crash seems to have disappeared, the preview problem is still there. There is no way I can add here a screenshot, but doing a preview of the FIRST page of the file I had uploaded shows diagonals UNDER the table on the first page of the preview. Page 4 of the preview shows diagonals ABOVE the table.
Comment 11 Michael@Paris 2019-04-03 09:37:24 UTC
Created attachment 150498 [details]
Preview with alpha version
Comment 12 Michael@Paris 2019-04-03 09:41:02 UTC
Created attachment 150499 [details]
Preview of page 4 with alpha

You can see here that the two top diagonals are not only above the table, but above the page!
Also, the vertical borders have become thicker than what I set them (and didn't change them when I put the diagonals in; they don't show that way in the file, only in the preview and print).
Comment 13 Steffen 2019-04-03 15:18:04 UTC
You can find more information there

I have tested with LO Version: (x64), but the error is still present.
Comment 14 aizuwakamatsu 2019-06-18 08:38:17 UTC
Created attachment 152264 [details]
sample file
Comment 15 aizuwakamatsu 2019-06-18 08:39:36 UTC
I have the same situation as you do in LibreOffice
Comment 16 Michael@Paris 2019-06-18 08:45:21 UTC
As this problem is very disruptive for me, I quit using LibreOffice Calc, and went to OpenOffice calc, which has this feature working correctly.