Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{description}
{excerpt}Indicates or sets the type of references used in this workbook.  
{excerpt}
{signature:C#}
 public boolean UseRCFormulaNotation{ get; set; }
{signature}{signature:vb.net}
Public Property UseRCFormulaNotation() As Boolean
{signature}
{remarks}
When false, the default, all references will be in "Normal" style, and should be expressed as A1, $A$1, etc.  If set to true, references will be in RC style, and should be expressed as R1C1, R\[1\]C\[1\], etc.  All methods and properties that take formulas as input or output will pay attention to this value.  Setting this value will also affect the style of references that Excel displays on opening the file.  This option is analagous to the Tools\->Options\->General\->R1C1 Reference Style in Excel.
{remarks}
{example}{code:csharp|title=C#}

          wb.UseRCFormulaNotation = true;
          myCell.Formula = "=R3C2";
        {code}
{code:vb.net|title=vb.net}

          wb.UseRCFormulaNotation = True
          myCell.Formula = "=R3C2"
        {code}

{example}