SetWSSelection

[Sam Jones]

What is the format for specifying the selection of a worksheet cell when there are no subrows in the worksheet, and even if there was, what would the format be for selecting a cell that is not part of a subrow? 

 

PROCEDURE   SetWSSelection

( worksheet:HANDLE;

  currentCellRow:INTEGER;

  currentCellColumn:INTEGER;

  topRangeRow:INTEGER;

  leftRangeColumn:INTEGER;

  topRangeSubrow:INTEGER;

  bottomRangeRow:INTEGER;

  rightRangeColumn:INTEGER;

  bottomRangeSubrow:INTEGER

) ;

 

I have tried not including any subrow specification, putting "0"s in the subrow specification, and putting the cell row, col values in the subrow specification.  None of that works.

[michaelk]

As far as I can tell the topRangeSubrow and bottomRangeSubrow always return 0 no matter what when using GetWSSelection.

 

I'm able to select cells using 0 in those values.  If there are subrows it always selects the header row.

 

currentCellRow and currentCellColumn should be in the range of the topRangeRow,leftRangeRow,rightRangeRow,botttomRangeRow

 

I've found that it may let you set (1,1,10,3,0,14,7,0) but you might be force quitting Vectorworks soon after.

 

The only way I can see that a user could select a range of rows with a mouse would force currentCellRow,currentCellColumn to be equal to either topRangeRow,leftRangeRow or rightRangeRow,botttomRangeRow.  

[Sam Jones]

@michaelk

 

I just want a command to select one worksheet cell, e.g. C12

[michaelk]

SetWSSelection(WSHand,12,3,12,3,0,12,3,0);