CloserValueSupInColumn Method

Important note
Applies to a design table sheet. Scans the values of a column and returns the greatest cell value which is the nearest to a specified one. Returns 0 if no value is found or if the method arguments are not properly specified.

Syntax

sheet.CloserValueSupInColumn(columnIndex: Integer, Value: Real)

The CloserValueSupInColumn method takes two arguments:

Arguments	Description
columnIndex	Required. Index of the table column. Integer from 1 to n.
Value	Required. Value searched for. Should be a real.

Example

ValueSup=Relations\DesignTable1\sheet_name.CloserValueSupInColumn(1, 80mm)
Message("Closest sup value is # (0.08 is expected)", ValueSup)

Sample

KwrProgramDT.CATPart