I am trying to use SetFontFormatting on a MergedCellsRegion and it does not work. I can use this just fine on an individual Cell as well as use SetFormatting without a problem. Should this work?
Yes, this should work. Can you post a small sample of the code so I can see the formatting you are setting and where the formatting object is coming from?
I was able to get this working with the following code.
oCellFont = oWorkbook:CreateNewWorkbookFont().
oCellFont:Name = "Arial".
oCellFont:Bold = Infragistics.Excel.ExcelDefaultableBoolean:
False.
oCellFont:
Height = 160 .
oMergedCellFormat = oWorkbook:CreateNewWorksheetCellFormat().
oMergedCellFormat:Alignment = Infragistics.Excel.HorizontalCellAlignment:LEFT.
oMergedCellFormat:ShrinkToFit = Infragistics.Excel.ExcelDefaultableBoolean:
TRUE.
oMergedCellFormat:FillPatternForegroundColor = System.Drawing.Color:LightGray.
oMergedCellFormat:FillPattern = Infragistics.Excel.FillPatternStyle:Solid.
oMergedCellFormat:FormatString =
"@".
oMergedCellFormat:
FONT:SetFontFormatting(oCellFont).
oIncrementRegion:CellFormat:SetFormatting(oMergedCellFormat).