title: First Formula Copied to All Cells in Column
body: <p>We are using a multidimensional array to set the formulas and values for a column range of the same dimension. The problem we are seeing is that no matter what values are in the array, the column is copying the first formula in every cell in the column.
  ex:</p>
  
  <pre><code>var values = new object[3,1];
  values[0,0] = "=$A$2";
  values[1,0] = 3;
  values[2,0] = 4;
  
  range.Formula = values;
  </code></pre>
  
  <p>When we look in the spreadsheet we see the formula "=$A$2" in each cell in the column. If we set the first value in the multidimensional array to not be a formula everything works fine. Am I missing something?</p>
  
  <p><strong>Edit</strong>
  This happens with Excel 2010.</p>