OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

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
vb.net
vb.net
Public Sub SetAddInFormula(ByVal formula As String)
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.

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 Block
vb.net
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)")
Scrollbar