Message-ID: <1232304877.10153.1711714730972.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10152_137940570.1711714730972" ------=_Part_10152_137940570.1711714730972 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Workbook.UseRCFormulaNotation

Workbook.UseRCFormulaNotation

Description=20

Indicates or sets the type of references used in this workbook.

=20
C#
=20
 public boolean UseRCFormulaNotation{ get; set; }
=20
=20
vb.net
=20
Public Property UseRCFormulaNotation() As Boolean
=20
=20

Remarks

When false, t= he 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 sty= le, and should be expressed as R1C1, R[1]C[1], etc. All methods and propert= ies 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 dis= plays on opening the file. This option is analagous to the Tools->Option= s->General->R1C1 Reference Style in Excel.=20

Examples

=20
C#
=20

          wb.UseRCFormulaNotation =3D true;
          myCell.Formula =3D "=3DR3C2";
        
=20
=20
vb.net
=20

          wb.UseRCFormulaNotation =3D True
          myCell.Formula =3D "=3DR3C2"
        
=20
------=_Part_10152_137940570.1711714730972--