I am creating a spreadsheet, and the first row is a merged cell with the title. I'd like an underline on this merged cell. However, only the first cell of the original unmerged first row is underlined.
I worked around this by using topborder on row 2...but it seems like I should be able to underline a merged cell. Can anyone point out if I have something wrong? Thanks! <cfset header1format = structnew()> <cfset header1format.bottombordercolor="black"> <cfset header1format.bottom border="thin"> <!---creates header row of 6 merged cells---> <cfset SpreadsheetAddRow(sheet1, "Blah blah title")> <cfset SpreadsheetMergeCells(sheet1, 1,1,1,6)> <cfset SpreadsheetFormatRow(sheet1, header1format, 1)> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
