FlexGrid Merge Columns: Row/Column selection inconsistant?!?! 
Author Message
 FlexGrid Merge Columns: Row/Column selection inconsistant?!?!

My love/hate relationship with the MS Flex Grid continues!  I have a
FlexGrid in a VB6 form.  Column 2 of the grid's columns is set to be a merge
column.  The remaining 3 columns are NOT merge columns.

When the user selects a cell, I've set things up so that the entire FlexGrid
row appears selected.  I'm hoping someone will tell me I'm wrong, but
selecting an entire row SEEMS to be a problem on Merge Columns.  The problem
appears to be this:  Let's say there happens to be only two records
currently displayed in the FlexGrid.  Presently (because of the particular
contents of the two records), Column 2 of the FlexGrid (which is a
MergeColumn) spans across BOTH rows of the grid (because it's the same value
in both of the grid's records).

Now, if the user happens to select the FIRST record, the COMPLETE entire row
appears selected, *including Column 2 (the MergeColumn).  BUT, if the user
selects the SECOND record, Column 2 will NOT appear selected.  In fact only
the columns before and after column 2 in the second record will appear
selected!

Feel free to tell me I must be doing something wrong.  Short of that, a
workaround (if one exists) would be appreciated.  Thanks in advance.



Wed, 12 Dec 2001 03:00:00 GMT  
 FlexGrid Merge Columns: Row/Column selection inconsistant?!?!
In looking in the help, the MergeCells property seems to be what you are
after.  It seems (a quote) ------

When MergeCells is set to a value other than 0 (Never), selection
highlighting is automatically turned off. This is done to speed up
repainting, and because selection of ranges containing merged cells may lead
to unexpected results.

------
So the selection set is distorted with the mergecells/rows/cols properties.

Hope this helps

Nick August


Quote:
> My love/hate relationship with the MS Flex Grid continues!  I have a
> FlexGrid in a VB6 form.  Column 2 of the grid's columns is set to be a
merge
> column.  The remaining 3 columns are NOT merge columns.

> When the user selects a cell, I've set things up so that the entire
FlexGrid
> row appears selected.  I'm hoping someone will tell me I'm wrong, but
> selecting an entire row SEEMS to be a problem on Merge Columns.  The
problem
> appears to be this:  Let's say there happens to be only two records
> currently displayed in the FlexGrid.  Presently (because of the particular
> contents of the two records), Column 2 of the FlexGrid (which is a
> MergeColumn) spans across BOTH rows of the grid (because it's the same
value
> in both of the grid's records).

> Now, if the user happens to select the FIRST record, the COMPLETE entire
row
> appears selected, *including Column 2 (the MergeColumn).  BUT, if the user
> selects the SECOND record, Column 2 will NOT appear selected.  In fact
only
> the columns before and after column 2 in the second record will appear
> selected!

> Feel free to tell me I must be doing something wrong.  Short of that, a
> workaround (if one exists) would be appreciated.  Thanks in advance.



Thu, 13 Dec 2001 03:00:00 GMT  
 FlexGrid Merge Columns: Row/Column selection inconsistant?!?!
Thank you for tracking that down Nick.  It's a drag, but at least I know
now!  Thanks again.


Quote:
> In looking in the help, the MergeCells property seems to be what you are
> after.  It seems (a quote) ------

> When MergeCells is set to a value other than 0 (Never), selection
> highlighting is automatically turned off. This is done to speed up
> repainting, and because selection of ranges containing merged cells may
lead
> to unexpected results.

> ------
> So the selection set is distorted with the mergecells/rows/cols
properties.

> Hope this helps

> Nick August



> > My love/hate relationship with the MS Flex Grid continues!  I have a
> > FlexGrid in a VB6 form.  Column 2 of the grid's columns is set to be a
> merge
> > column.  The remaining 3 columns are NOT merge columns.

> > When the user selects a cell, I've set things up so that the entire
> FlexGrid
> > row appears selected.  I'm hoping someone will tell me I'm wrong, but
> > selecting an entire row SEEMS to be a problem on Merge Columns.  The
> problem
> > appears to be this:  Let's say there happens to be only two records
> > currently displayed in the FlexGrid.  Presently (because of the
particular
> > contents of the two records), Column 2 of the FlexGrid (which is a
> > MergeColumn) spans across BOTH rows of the grid (because it's the same
> value
> > in both of the grid's records).

> > Now, if the user happens to select the FIRST record, the COMPLETE entire
> row
> > appears selected, *including Column 2 (the MergeColumn).  BUT, if the
user
> > selects the SECOND record, Column 2 will NOT appear selected.  In fact
> only
> > the columns before and after column 2 in the second record will appear
> > selected!

> > Feel free to tell me I must be doing something wrong.  Short of that, a
> > workaround (if one exists) would be appreciated.  Thanks in advance.



Thu, 13 Dec 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. recalc flexgrid row height for wrap on resizing columns

2. Flexgrid - how to size columns/rows to text

3. Merging MsFlexgrid Rows/Columns Problem

4. MSFlexGrid, merging 2 columns in the 1st row

5. MSFlexGrid Row/Column Selection

6. Full row selection in MSHflexgrid does not select first column

7. Stumped with msflexgrid column zero row selection.

8. Error creating rows with columns having different column width

9. FlexGrid / FlexGrid pro traversing columns question

10. How to sort a column in flexgrid when user click a column heading on the fixed row?

11. Sort flexgrid with selection by row?

12. User row selection in MS-FlexGrid

 

 
Powered by phpBB® Forum Software