Some grid lines appear darker than others, resulting in it looking like a border was added. Sometimes this happens for horizontal grid lines, other times for vertical grid lines.
please post a test file and a screenshot
I wish I could, but my clients would fire me! I'll do the second best thing, which is describe it. They say a picture is worth 1000 words. I'll try to do it in fewer! One single vertical or horizontal gridline will be thicker than the others. It looks very similar to the effect generated when adding a border to a row or column, except none has been added. Imagine everything looking normal, except one column gridline or one row gridline is emphasized. The thickness applies to the entire gridline, and not just for a specific cell. It is purely aesthetic, and seems to have no effect on functionality. It happens on multiple spreadsheets, but not every one. It does not happen on a blank spreadsheet ever. I'm guessing it's an artifact of cell formatting or custom cell width. Purely a guess.
a simple screenshot of part of the file with no sensible data showed in it would be the best thing. just drop a picture of some cells with that issue.
Yeah we need some kind of a test document here. One thing that people with confidential stuff have done is replace all characters with x so that nothing is legible. Please attach a test document and mark file as UNCONFIRMED. We cannot confirm (and thus cannot move forward with fixing) without such a document.
I'll post a screenshot the next time it occurs. That might be a couple days or several months, depending on when I see it again. It is fairly random in nature.
Created attachment 103488 [details] Demonstation of bug
Okay. I have a great screenshot of this bug. It shows one horizontal gridline error and two vertical gridline errors all in one screenshot. In this particular example, the steps to reproduce were: 1) View -> Page Break Preview 2) View -> Normal Happens every time. I cannot attach the actual spreadsheet, but I have attached a screenshot of the relevant area to demonstrate and document the error. This bug happens under a variety of different circumstances, not just the method above. Actually, I rarely use the above functionality, yet have seen the bug hundreds of times. I'm not sure who should change this from NEEDINFO. Let me know if that's my job or if someone else should do it.
I had a colleague look at this bug, and sometimes 4 eyes are better than 2. We both think this has something to do with page breaks, and may actually represent two different bugs. The first bug is that the value of Options -> LibreOffice Calc -> View -> Page Breaks is not saved between sessions. Other values on that settings page are saved between sessions, but not that one. The second is that page break markers are not consistent. They appear in certain cases when editing a spreadsheet and not in others. It is so inconsistent that I didn't realize that those darker lines are most likely page break markers. This is partly due to the first bug above, and partly due to them not appearing in a spreadsheet until certain types of edits are performed. When they suddenly appear, it looks like an error. So if these are page break markers (and with the help of my colleague, I think we've determined that they are), the real bugs are (1) that the Page Break value needs to be saved across sessions, and (2) that page break markers should appear at consistent times, most likely when a file is loaded or as soon as a loaded file is scrolled in either direction. Having them appear at seemingly random times can give the impression of an error.
(1) that the Page Break value needs to be saved across sessions -> it is bug 81773
(In reply to helplibreoffice from comment #8) > the real bugs are (1) that the Page > Break value needs to be saved across sessions, (In reply to raal from comment #9) >.. it is bug 81773 So that part's done. > and (2) that page break > markers should appear at consistent times, Changing summary to match part (2). My guess is that this is not Windows-specific, so changing OS -> All. > most likely when a file is loaded > or as soon as a loaded file is scrolled in either direction. Those sound like reasonable suggestions. Severity -> Enhancement Status -> NEW