Issue 46332

Summary: Border not shown - invisible
Product: Calc Reporter: david
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Spacing solution (not my prefered)
none
Overdrawing solution (I prefer this one) none

Description david 2005-03-30 22:40:48 UTC
Borders around cells in column A are invisible at the left sides of the cells. 
It seems that the user interface designer thought that since these cells lies 
next the row number list (1,2,3,4...) the user wouldn't need to see the borders 
- this is of course very wrong. Important spreadsheet layout details such as 
borders should of course NEVER be invisible for any cells no matter where the 
cells are positioned.
This goes for the upper borders on cells in row 1 too.

Cheers
-- David
Comment 1 daniel.rentz 2005-04-04 17:28:17 UTC
Only the right part of the border is shown in column A (i.e. of a thick or
double border line). You can see the full border in the print preview. And you
are right: because it is not possible to scroll before column A or above row 1,
the row/column headers overwrite the other part of the borders.
Comment 2 david 2005-04-04 17:35:31 UTC
You should add 1-2 pixels of empty space left of column A (or which ever column 
is next to the row list), and 1-2 pixels of empty space above row 1 (or which 
ever column is next to the row list).

Yes, I know the user can work around it (page preview or let column A be empty 
and non-printed), but why not fix the problem and smooth the work flow - and 
beat Excel in this case.

-- David
Comment 3 daniel.rentz 2005-04-04 17:45:44 UTC
I think this would look ugly in the common case that no cell has any borders.
But another idea is to let the borders overdraw the row/column headers...
Comment 4 david 2005-04-04 18:20:22 UTC
That's a good idea but you'll have to change the row/colum list border colours 
then from black to grey:

http://davelab.com/calc_border_overdraw.gif

That's a fine solution. Here's the alternate idea with spacing:

http://davelab.com/calc_border_space.gif
Comment 5 david 2005-04-04 18:26:05 UTC
Created attachment 24635 [details]
Spacing solution (not my prefered)
Comment 6 david 2005-04-04 18:26:55 UTC
Created attachment 24636 [details]
Overdrawing solution (I prefer this one)
Comment 7 frank 2005-04-07 11:42:36 UTC
ok,

so this is not a defect but an enhancement. I re-assign it to requirements.
Comment 8 david 2005-04-07 12:01:20 UTC
On second thought I prefer a combination of the two screenshots:

http://www.openoffice.org/nonav/issues/showattachment.cgi/24635/
calc_border_space.gif

http://www.openoffice.org/nonav/issues/showattachment.cgi/24636/
calc_border_overdraw.gif

One in which the spacing is used when the border of the spreadsheet touches the 
row or column lists so show here ends the spreadsheet. But when the user has 
scrolled away from the leftmost and/or topmost part of the spreadsheet there 
should be no spacing (to show the spread sheet continues) and borders should 
overdraw the row/colum lists (remember the row/column lists own border have to 
be grey and not black to make cell borders distinguishable from the permanent 
column/row list border).

-- David
Comment 9 ace_dent 2008-05-16 00:51:58 UTC
OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html