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

Sets the formula of the worksheet to the given Add-In Formula.

Signature
C#
C#
public void SetAddInFormula(string formula)
{signature}
{signature:
}
Signature
vb.net
vb.net
Public Sub SetAddInFormula(ByVal formula As String)
{signature}

{parameters}
{param:formula}
Parameters
Param
formula
formula

Add-In

Formula

you

wish

to

add,

as

a

String.

Include

the

equals

sign

as

well

as

a

reference

to

the

Excel

Add-In

file

you

wish

to

reference,

if

the

file

is

not

included

in

the

local

macros

directory.

{param} {remarks} {remarks} {example} {code:csharp|title=C#}

Remarks

Example
Code Block
csharp
csharp
titleC#

//--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
//--- from the file TestAddInFormula2Helper.xpl.xla
WB[0]["D3"].SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)");
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

'--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple
'--- from the file TestAddInFormula2Helper.xpl.xla
WB(0)("D3").SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)")
{code} {example} {scrollbar}
Scrollbar