2 Replies Latest reply: May 4, 2012 12:55 PM by 5TagWalt RSS

    SpreadsheetFormatCell

    community help Community Member
        • 1. Re:  SpreadsheetFormatCell
          BrianO Community Member

          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)

          • 2. Re:  SpreadsheetFormatCell
            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?