Grid - Pre Sale Questions
Selection Rectangle with Merged Cells in Upper Left
Thread Starter: ricrat51 Started: 7/23/2008 6:31 PM UTC
Replies: 2
Selection Rectangle with Merged Cells in Upper Left

Assuming that this occurs in all directions.
Please refer to the following pictures
Cells 3,4 4,6 3,7 4,7 merged using MergeRect
UL->Upper Left;     LR->Lower Right

Shot1.gif shows this.

Shot2
  Shows the result of clicking on the cell in location 3,6 (UL)
  Shows row and col is 3 and 6
  Shows rectangle UL and LR are 3,6 and 4,7
  All is as expected.

Shot3
  Shows the result of clicking on the cell in location 4,7 (LR)
  Shows row and col is 4 and 7  ?????  Can alway chec
  Shows rectangle UL and LR are 3,6 and 4,7
  Can always determine if cell is part of a merged cell.  Not a big deal.

Shot4
  Shows the result of selecting a rectangle starting at 4,7 (LR)
  The row and col are 4 and 7 as expected
  The rectangle is 3,6 UL and 9,12 LR as desired.
  The shading omits cells 3,8 thru 3,12 and 5,6 thru 9,12

Is this a bug?
Do I need to shade the selection rectangle myself when using merged cells as corners?
Please advise

This message includes the following attachments:

Re: Selection Rectangle with Merged Cells in Upper Left
Hello ricrat51,

Not a bug as this is the designed behavior.

The bounding rectangle of the selected region is not necessarily equal to the selected region.


-Nicholas
Re: Selection Rectangle with Merged Cells in Upper Left

Is there a simple method for making them the same?
Something preferably with minimal coding
Thanks