Just to verify cfSearching's experimental code: it works fine for me on CF 9.0.1. -- Adam Interesting. I tried the old syntax under 9,0,0,251028 and it does not work for me. Let me try updating to 9.0.1 and see if I get the same results. @Jush - Since your results are different than Adam's are you sure you tested my code with 9.0.1? Update: I did some additional experimenting with 9.0.0 and I am pretty sure the feature is broken in that version. Based on the behvavior, I think they mistakenly used POI's horizontal alignment function for both properties. Notice if you use "vertical_bottom" or "vertical_justify" CF actually changes the horizontal alignment, not vertical. <cfscript> sheet = SpreadsheetNew(); spreadsheetSetCellValue(sheet, "Foo", 1, 1); spreadsheetSetCellValue(sheet, "Bar", 2, 1); // this produces horizontal CENTER alignment spreadsheetFormatCell(sheet, {alignment="vertical_bottom"}, 1, 1); // produces horizontal RIGHT alignment spreadsheetFormatCell(sheet, {alignment="vertical_justify"}, 2, 1); // must set these properties last otherwise they do not stick! ... spreadsheetSetColumnWidth(sheet, 1, 40); spreadsheetSetRowHeight(sheet, 1, 60); spreadsheetSetRowHeight(sheet, 2, 60); spreadSheetWrite(sheet, "c:/path/to/test.xls", true); </cfscript> Message was edited by: -==cfSearching==-
... View more