Apache OpenOffice (AOO) Bugzilla – Issue 46332
Border not shown - invisible
Last modified: 2013-08-07 15:12:27 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
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.
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
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...
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
Created attachment 24635 [details] Spacing solution (not my prefered)
Created attachment 24636 [details] Overdrawing solution (I prefer this one)
ok, so this is not a defect but an enhancement. I re-assign it to requirements.
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
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