Skip to main content
This topic has been closed for replies.

2 replies

5TagWalt
Participating Frequently
May 4, 2012

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?

Inspiring
May 4, 2012

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)