Skip to main content
Jush1
Known Participant
June 28, 2012
Question

SpreadsheetFormatRow() and SpreadsheetFormatCell() could not align text vertical to top

  • June 28, 2012
  • 1 reply
  • 4973 views

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

    This topic has been closed for replies.

    1 reply

    Inspiring
    June 28, 2012

    I could be wrong, but I do not think that feature worked in CF9.   Did you check the bug database?

    Jush1
    Jush1Author
    Known Participant
    June 28, 2012

    it is not in the bug specifically as the two function mentioned here. The documentation indicates it should be working with CF9.

    Thanks for your reply!

    Inspiring
    June 28, 2012

    Yep, I know the documentation says it should work. But I just seem to recall something about that particular setting not working. Again, I am not 100% certain. But seeing as how you are having problems too it  does lend some credence to the theory. Let me look around and see if I can find anything to substantiate or disprove it.