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: crashreport.libreoffice.org/stats/crash_details/72524916-82ae-4d39-bbdc-a5646d884965
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.
- 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).
User Profile Reset: Yes
OpenGL enabled: Yes
It should have correctly displayed and printed the table.
Created attachment 150480 [details]
Screen shot of the incorrect effect of editing diagonals
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 https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F 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.
Created attachment 150482 [details]
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.
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 ***
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.
(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.
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.
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
Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I downloaded and installed version 18.104.22.168.alpha0+.
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.
Created attachment 150498 [details]
Preview with alpha version 22.214.171.124
Created attachment 150499 [details]
Preview of page 4 with alpha 126.96.36.199
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).
You can find more information there https://ask.libreoffice.org/de/question/188471/calc-seit-lo-62-fehler-bei-diagonalen-linien-in-zellen/
I have tested with LO Version: 188.8.131.52 (x64), but the error is still present.
Created attachment 152264 [details]
I have the same situation as you do in LibreOffice 184.108.40.206.beta1.
As this problem is very disruptive for me, I quit using LibreOffice Calc, and went to OpenOffice calc, which has this feature working correctly.