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

...

Description

Excerpt

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

Signature
C#
C#
 public boolean UseRCFormulaNotation{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property UseRCFormulaNotation() As Boolean
{signature}
{remarks}
When 
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#}

Example
Code Block
csharp
csharp
titleC#


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


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