cId

=cId(string cortexAlias)
Parameters
  • cortexAlias: (Optional) An alias for this Cubicle. Default is used on omission.

Summary
Returns the internal string ID of the remote Cubicle.

cLocalLog

=cLocalLog(bool withHeadings = false, int i = 100)
Parameters
  • withHeadings: (Optional) Set to true to return column names. Default is false.
  • i: (Optional) The number of log items to return. Default = 100.

Summary
Returns the internal log of the Add-In.

cLog

=cLog(int i = 100, string cortexAlias = null)
Parameters
  • i: (Optional) The number of log items to return. Default = 100.
  • cortexAlias: (Optional) An alias for this Cubicle. Default is used on omission.

Summary
Returns the log of the specified Cubicle.

cLoadFromFile

=cLoadFromFile(string path, bool autoReg, bool explicitExports, string cortexAlias = null)
Parameters
  • path: The path to the assembly
  • autoReg: (Optional) set to true to automatically scan the assembly for function bindings
  • explicitExports: (Optional) set to true to only bind functions marked with ExcelDNA attributes
  • cortexAlias: (Optional) An alias for this Cubicle. Default is used on omission.

Summary
Loads an assembly from a file.

cRegisterFunctions

=cRegisterFunctions(string fullName, bool explicitExports)
Parameters
  • fullName: The fullName of the assembly to bind
  • explicitExports: (Optional) set to true to only bind functions marked with ExcelDNA attributes.

Summary
Binds the methods of a loaded assembly.

cArray

=cArray(object a1, …, object a60)
Summary
The cArray worksheet function allows the user to construct an object array out of a non-consecutive range of Excel cell references. This function is used when calling a worksheet function that requires an parameter array when the actual cells are scattered across various rows and columns. The function returns an object array a1, a2, a3, …, a60.

cSync

=cSync(object a1, …, object a60)
Summary
This worksheet function is used to syncronize multiple branches of the Excel dependency tree. The function simple returns the first parameter but will be recalculated when any of the cells references by the parameters change.

Last edited May 8, 2013 at 8:39 AM by Tjaart, version 2

Comments

No comments yet.