Is there an easier way to determine the .Row and .Col cell references of
all the members of a merged group within a Flexgrid or Hierarchical
Flexgrid?
Currently I'm 'walking' the grid and performing comparisons of Text
values, TextArray values or the physical coordinates of a cell.
Problems seem to arise with the coordinates comparison when the group of
merged cells is not entirely visible within the flexgrid. When the whole
merged cell group is visible, selecting any cell within the group
gives .CellTop as the _relative_ coordinate of the top of the merged group
within the flexgrid and .CellHeight gives the height of the merged group.
If the complete merged block is visible I can walk the grid and find which
cells lie within these coordinate limits. However, because the coordinated
are _relative_, this method falls down when only part of the merged block
is visible.
Any suggestions as to a simpler (and more efficient/quicker?) method would
be much appreciated.
Stuart