Merge(StyleInfo,Boolean) Method

Merges the style settings with the current object with the option to overwrite settings in the current object.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Sub Merge( _
   ByVal source As StyleInfo, _
   ByVal force As Boolean _
)

'Usage
 
Dim instance As StyleInfo
Dim source As StyleInfo
Dim force As Boolean
 
instance.Merge(source, force)

public virtual void Merge( 
   StyleInfo source,
   bool force
)

Parameters

source: Object whose style settings are merged with the current object
force: Whether to overwrite the current settings with the settings from the merge object

Remarks

This method gives you the option to overwrite existing settings in the current object. If you set the force parameter to true, settings from the merge object overwrite settings in the current object. Set the force parameter to false if you do not want to overwrite settings in the current object. Set to true to overwrite the current settings.

If you do not need to overwrite the existing settings in the current object, you might want to use the Merge(StyleInfo) method.

Example

This example merges two style objects.

FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo(); 
si.VisualStyles = true; 
FarPoint.Win.Spread.StyleInfo merge = new FarPoint.Win.Spread.StyleInfo(); 
merge.BackColor = Color.Red; 
fpSpread1.ActiveSheet.DefaultStyle = si; 
si.Merge(merge, true);

Visual Basic

Dim si As New FarPoint.Win.Spread.StyleInfo
si.VisualStyles = True
Dim merge As New FarPoint.Win.Spread.StyleInfo
merge.BackColor = Color.Red
FpSpread1.ActiveSheet.DefaultStyle = si
si.Merge(merge, True)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

StyleInfo Class
StyleInfo Members
Overload List
Merge(StyleInfo)

User-Task Documentation

Allowing Cells to Merge Automatically