View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bart[_6_] Bart[_6_] is offline
external usenet poster
 
Posts: 37
Default Bug applying Borders to Range

Who can explain me the following problem with applying borders to
cells?
The Border property window for cells looks incomplete to me or at
least is very inconvenient.
Borders 'belong' to cells. You can experiment with this by moving
cells around bordering cells with Borders.

The best way to show this problem is by example:
Cell A1 has a Bottom Border. The range A2:A3 is selected.
Now, the Border Property window is showing a Top Border for this
range. I think that's incorrect. It should be, I think, at least a
GRAY Top Border, meaning that there is a Border, but not 'belonging'
to the selected range.
It even becomes more bizarre when at this point a Bottom Border, for
example, is added. By applying this, the Bottom Border of A1 becomes
also a 'belonging' of cell A2 as a Top Border.

I'm using Excel 2003 SP2. Has this Border property window been
replaced in the 2007 version?

Regards and good luck,

Bart