SpreadsheetFormatCell

[community_help]

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6747.html

[BrianO]

1) alignment="auto" and width="auto" also work. Are others missing?

2) I would add a note that dataformat #,##0 and probably others listed under the dataformat section fail because they need to be escaped (e.g., dataformat = "##,##0")

3) The syntax of {alignment="right", dataformat = "##,##0"} also works when passing multiple parameters for the format. For example:

SpreadsheetFormatCellRange(objSS, {alignment="right", dataformat = "##,##0"}, 3, 3, lnRowLen, lnColLen)

[5TagWalt]

I've tried using textwrap = true, to no avail.

The precise line I'm attempting is the following:

SpreadsheetFormatCell(SpreadsheetObj, {textwrap=true}, 40, 1);

My expected outcome is to see the text I'm putting in the cell wrap.

Is this not what I should expect?