Merges style settings with the current object and has the option to force style settings from the merge object to overwrite settings in the current object.

Syntax

Visual Basic (Declaration)
Public Overloads Overridable Function Merge( _ ByVal obj As Object, _ ByVal force As Boolean _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As StyleInfo Dim obj As Object Dim force As Boolean Dim value As Boolean value = instance.Merge(obj, force)

C#
public virtual bool Merge( object obj, bool force )

Parameters

obj: Object whose style settings are merged with the current object
force: Whether to overwrite the current settings with the settings from the merge object
Set to True to overwrite the current settings.

Return Value

Boolean: true if merge is successful; false otherwise

Remarks

The Merge(Object, Boolean) method gives you the option to overwrite existing settings in the current object. If you set the fForce parameter to True, settings from the merge object overwrite settings in the current object. Set the fForce parameter to False if you do not want to overwrite settings in the current object.

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

Example

This example creates three objects, two StyleInfo objects and a SheetStyleProperty object. The ForeColor and Font properties of the first StyleInfo object are set, and the BackColor of the second. The second object is then merged with the first. Then a Boolean value returns whether the BackColor property has , in fact, been set after the merge.

C#	Copy Code
FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo(); FarPoint.Web.Spread.StyleInfo minfo = new FarPoint.Web.Spread.StyleInfo(); minfo.BackColor = Color.Yellow; info.ForeColor = Color.Red; info.Font.Bold = true; info.Merge(minfo, true); FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info); bool bol; bol = info.IsPropertySet(FarPoint.Web.Spread.SheetStyleProperty.BackColor); ListBox1.Items.Add(Convert.ToString(bol));

Copy Code

FarPoint.Web.Spread.StyleInfo info = new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.StyleInfo minfo = new FarPoint.Web.Spread.StyleInfo();
minfo.BackColor = Color.Yellow;
info.ForeColor = Color.Red;
info.Font.Bold = true;
info.Merge(minfo, true);
FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info);
bool bol;
bol = info.IsPropertySet(FarPoint.Web.Spread.SheetStyleProperty.BackColor);
ListBox1.Items.Add(Convert.ToString(bol));

Visual Basic	Copy Code
Dim info As New FarPoint.Web.Spread.StyleInfo() Dim minfo As New FarPoint.Web.Spread.StyleInfo() Dim prop As FarPoint.Web.Spread.SheetStyleProperty minfo.BackColor = Color.Yellow info.ForeColor = Color.Red info.Font.Bold = True info.Merge(minfo, True) FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info) Dim bol As Boolean bol = info.IsPropertySet(prop.BackColor) ListBox1.Items.Add(bol)

Visual Basic

Copy Code

Dim info As New FarPoint.Web.Spread.StyleInfo()
Dim minfo As New FarPoint.Web.Spread.StyleInfo()
Dim prop As FarPoint.Web.Spread.SheetStyleProperty
minfo.BackColor = Color.Yellow
info.ForeColor = Color.Red
info.Font.Bold = True
info.Merge(minfo, True)
FpSpread1.ActiveSheetView.SetStyleInfo(0, 0, info)
Dim bol As Boolean
bol = info.IsPropertySet(prop.BackColor)
ListBox1.Items.Add(bol)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6