SpreadsheetFormatRow() and SpreadsheetFormatCell() could not align text vertical to top
<cfscript>
theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "courses.xls";
theSheet = SpreadsheetNew("CourseData");
SpreadsheetAddRows(theSheet,courses);
format1=StructNew()
format1.alignment="vertical_top";
SpreadsheetFormatRow(theSheet,format1,"5");
//SpreadsheetFormatCell(theSheet,format1,5,1)
</cfscript>
I copied the example from the function example, but it does not work on my CF9.0 Server. Neither format row or format cell works.
Does anyone have any idea why it is not working and how could I make the text in the cell align to top?
Thanks.
