Skip to main content

User Defined Functions

Multiple user defined functions are available in Spreadsheet Server for retrieving various data. Below is a list of the non-formula (GXL, GXD, etc.) user defined functions supported by Spreadsheet Server.

User Defined Function Description

SS_GetComment()

Retrieves the comment entered in Excel for the specified cell reference (for example, SS_GetComment(A10)).

SS_Layout()

Retrieves a custom layout definition as a parameter. This function accepts one parameter (for example, SS_Layout(<xml>), where <xml> represents the entire XML string of the layout definition.

SS_ProfileSetting()

Retrieves a property from a Designer GL profile. This function accepts two parameters (for example, SS_ProfileSetting(SettingName as String,Optional ProfileName as String)). Available setting names are:

  • ProfileName
  • Key1Name
  • Key2Name
  • SegmentNamenn (where nn is the segment number)

SS_Setting()

Retrieves a property from the SSSettings file. This function accepts one parameter (for example, SS_Setting(SettingName)).

SS_ValueListFromRange()

Creates a value list of cells that may be referenced in other formulas. This function accepts an array of values, or actual ranges (for example, A10:A15), up to 35 parameters.

UpdateDesignerGLAccountString()

Updates an account string without a delimiter based on the default Designer GL definition. This function may only be called as a macro. The user must highlight the range of data to be updated, then execute the macro.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk