Description: 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. 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: Crash Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: 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] Sample document
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 Version: 6.3.0.0.alpha0+ 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 http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version.
I downloaded and installed version 6.3.9.9.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 6.3.0.0
Created attachment 150499 [details] Preview of page 4 with alpha 6.3.0.0 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: 6.2.3.1 (x64), but the error is still present.
Created attachment 152264 [details] sample file
I have the same situation as you do in LibreOffice 6.3.0.0.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.
Dear Michael@Paris, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This seems to have been fixed since 7.3. I can't reproduce in: Version: 7.3.7.2 / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded But I could in: Version: 7.2.7.2 / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
I found the fix and corresponding bug report. *** This bug has been marked as a duplicate of bug 126269 ***