Skip navigation
This question was posted in response to the following article:
Currently Being Moderated

SpreadsheetFormatCell

May 4, 2012 10:38 AM

328 Views   2 Replies   Latest reply: 5TagWalt, May 4, 2012 12:55 PM
 
Replies
  • BrianO
    Currently Being Moderated
    1. BrianO,
    May 4, 2012 10:38 AM   in reply to Community Help
    Report

    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)

     
    |
    Mark as:
  • 5TagWalt
    Currently Being Moderated
    2. 5TagWalt,
    May 4, 2012 12:55 PM   in reply to Community Help
    Report

    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?

     

     

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points