• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVIDEA function
  • CVINFO function
  • CVMENUST function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

CUSTPROPR Function

The CUSTPROPR function returns a custom property from a given range of custom properties. Custom properties returned using the CUSTPROPR() function are based on a fixed identifier with an appended variable postfix. The range specifies the number (and values) of available variable postfixes for the properties while the offset selects which variable postfix is to be used.

Syntax

CUSTPROPR("Fixed Identifier","Scope","Range","Offset")

Where

Fixed Identifier is the custom property label to which the automatically generated variable postfix will be added.

Scope can be any of the following values:

• C - Cell

• P - Paragraph

• T - Table

• TR - Row

• TC - Column

• D - Document Settings

• SSK - This is the smallest section with a Knowledge Library Link that encompasses the object containing the calculation (easiest to think of a paragraph).

• SSL - This is the smallest section with a Label that encompasses the object containing the calculation.

Range is a formatted range declaration. The variable postfix will be selected from the available values specified by this range and conformed to the given offset. Range values are entered as two numbers or strings ordered smallest to largest, and separated by a double-dot. For example, "1..5", "C..H", and "Z..AD" are all valid range entries. CaseView increments through the available range of values in the same way table labels or cell numbers increment. That is, A-Z followed by AA, AB, AC, etc.

Offset specifies the variable postfix from the available range which should be appended to the fixed identifier.

Example

Assume that cell C3 has a value of 2 and the paragraph has a custom property DEF2 whose value is 15.

CUSTPROPR("DEF","p","1..5",C3) would return the value 15.

The function searches for a paragraph property based on the scope. It appends the applicable variable postfixes to the fixed identifier DEF and returns a range of possible custom properties: DEF1, DEF2, DEF3, DEF4, and DEF5. The offset in this case is a calculated value (a cell number) and the function follows that reference to determine the offset is 2.

DEF2 is returned as the appropriate paragraph custom property, which has a value of 15.

Note: A blank string is returned if the function cannot find a match.

Related Topics

• Miscellaneous Functions