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.
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.
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));
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)