CloserValueInfInColumn Method

Important note
Applies to a design table sheet. Scans the values of a column and returns the smallest 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.CloserValueInfInColumn(columnIndex: Integer, value: Real): Real

The CloserValueInfInColumn function has two arguments:

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

Example

Message("Closest inf value is # ", Relations\DesignTable1\sheet_name.CloserValueInfInColumn(2,41mm))

Sample

KwrProgramDT.CATPart

 

Back Up Next