title: How to set R1C1 style formula using Apache Poi
body: <p>I'm getting datas through JSON and generating Excel using Apache POI, When I use normal Formula "SUM(Q5:R5)" it works fine, but when I tried to use r1c1 reference formula SUM(RC[-2]:RC[-1]), it throws exception. I have referred Apache POI doc, and found Indirect method, but am not sure how to apply on my case. Can anyone help me in this issue.</p>
  
  <p>Error Code: Caused by: org.apache.poi.ss.formula.FormulaParseException: Specified named range 'RC' does not exist in the current workbook.</p>
  
  <pre><code>if(value[CELL_TYPE].equals("CELL_TYPE_FORMULA")) {
      String data = value[CELL_DATA];
      c.setCellFormula(data);
      c.setCellType(getCellType(value[CELL_TYPE]));
  }
  </code></pre>
  
  <p>Am getting error while setting the cellFormula.</p>
  
  <p>And this is the JSON Array data which am trying to set for the cell:
  ["SUM(RC[-2]:RC[-1])", "CELL_TYPE_FORMULA"]</p>