Bug 81088 - Page break markers (i.e. bold weight) in gridlines should appear at consistent times
Summary: Page break markers (i.e. bold weight) in gridlines should appear at consisten...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Page-Break
  Show dependency treegraph
 
Reported: 2014-07-09 07:50 UTC by helplibreoffice
Modified: 2017-07-14 20:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstation of bug (4.21 KB, image/png)
2014-07-26 04:55 UTC, helplibreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description helplibreoffice 2014-07-09 07:50:14 UTC
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.
Comment 1 tommy27 2014-07-17 18:45:46 UTC
please post a test file and a screenshot
Comment 2 helplibreoffice 2014-07-17 19:56:34 UTC
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.
Comment 3 tommy27 2014-07-18 07:32:50 UTC
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.
Comment 4 Joel Madero 2014-07-19 06:43:23 UTC
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.
Comment 5 helplibreoffice 2014-07-19 10:09:18 UTC
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.
Comment 6 helplibreoffice 2014-07-26 04:55:18 UTC
Created attachment 103488 [details]
Demonstation of bug
Comment 7 helplibreoffice 2014-07-26 04:57:45 UTC
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.
Comment 8 helplibreoffice 2014-07-26 05:23:18 UTC
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.
Comment 9 raal 2014-09-12 18:13:47 UTC
(1) that the Page Break value needs to be saved across sessions -> it is bug 81773
Comment 10 Robinson Tryon (qubit) 2014-12-15 00:13:58 UTC
(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