Method Details

• getRange

  IRange getRange()

  Gets the IRange object that represents the auto merge range.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   IRange mergeRange = mergeInfo.getRange();
   

  Returns:

  The IRange object that represents the auto merge range.

• setRange

  void setRange(IRange range)

  Sets the IRange object that represents the auto merge range.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   mergeInfo.setRange(worksheet.getRange("B1:B4"));
   IRange mergeRange = mergeInfo.getRange();
   

  Parameters:

  range - The IRange object that represents the range to auto merge.

• getDirection

  AutoMergeDirection getDirection()

  Gets the auto merge direction.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   AutoMergeDirection direction = mergeInfo.getDirection();
   

  Returns:

  The auto merge direction.

• setDirection

  void setDirection(AutoMergeDirection direction)

  Sets the auto merge direction.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   mergeInfo.setDirection(AutoMergeDirection.Row);
   AutoMergeDirection direction = mergeInfo.getDirection();
   

  Parameters:

  direction - The auto merge direction.

• getMode

  AutoMergeMode getMode()

  Gets the auto merge mode.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column, AutoMergeMode.Free);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   AutoMergeMode mode = mergeInfo.getMode();
   

  Returns:

  The auto merge mode.

• setMode

  void setMode(AutoMergeMode mode)

  Sets the auto merge mode.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   mergeInfo.setMode(AutoMergeMode.Free);
   AutoMergeMode mode = mergeInfo.getMode();
   

  Parameters:

  mode - The auto merge mode.

• getSelectionMode

  AutoMergeSelectionMode getSelectionMode()

  Gets the auto merge selection mode.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column, AutoMergeMode.Free, AutoMergeSelectionMode.Merged);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   AutoMergeSelectionMode selectionMode = mergeInfo.getSelectionMode();
   

  Returns:

  The auto merge selection mode.

• setSelectionMode

  void setSelectionMode(AutoMergeSelectionMode selectionMode)

  Sets the auto merge selection mode.

  
   worksheet.autoMerge(worksheet.getRange("A1:A4"), AutoMergeDirection.Column);
   IAutoMergeRangeInfo mergeInfo = worksheet.getAutoMergeRangesInfo().get(0);
   mergeInfo.setSelectionMode(AutoMergeSelectionMode.Merged);
   AutoMergeSelectionMode selectionMode = mergeInfo.getSelectionMode();
   

  Parameters:

  selectionMode - The auto merge selection mode.