title: R1C1-formulas in Gembox.Spreadsheet
body: <p>I am testing GemBox.Spreadsheet (47.0.1031) and found a note that R1C1-formulas are <a href="https://support.gemboxsoftware.com/community/view/add-support-for-r1c1-formula-reference" rel="nofollow noreferrer">available in the latest versions</a>.</p>
  <p>But, how does it work? My tests have failed so far:</p>
  <pre><code>SpreadsheetInfo.SetLicense(&quot;FREE-LIMITED-KEY&quot;);
  var f = new ExcelFile();
  var ws = f.Worksheets.Add(&quot;Sheet1&quot;);
  f.CalculationOptions.PrioritizeR1C1ReferencingNotation = true;
  
  for(int i = 0; i&lt;50; i++)
  {
      ws.Cells[i, 0].Value = i + 1;
      ws.Cells[i, 1].Formula = &quot;=RC[-1] * 17&quot;;
  }
  f.Save(..path..);
  </code></pre>
  <p>not even <code>=R1C1</code> works, and <code>=RC1</code> is read as an absolute reference (column RC row 1), despite my attempt with the <code>PrioritizeR1C1ReferencingNotation</code> setting.</p>
  <p>Excel shows a warning about corrupted content in /xl/worksheets/sheet1.xml-Part when opening the file and removes the formula.</p>