Jump to content

Jonathan Anderson

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Jonathan Anderson

  1. I have not been able to populate cells of my spreadsheet with working formulas. See my post at this link for details.
  2. It may not be immediately obvious that the string input argument for "ConvertFormula" in the "Application" property node refers to the lower right corner where the 2D input array should go in "RxCy" format where x is the absolute row index and y is the absolute column index (number not letter). Do not confuse the letters "R" and "C" with column letters because the "R" represents the word "row" and the "C" represents the word "column". Likewise the string input argument for "Range" in the "Worksheet" property node refers to the upper left corner where the 2D input array should go in "Ax" format where A is the absolute column letter and x is the absolute row index. See 2 examples shown in the attached image.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.