Skip to content

createGLNSequence

Implementations

Microsoft Excel: AIDCT.GS1.createGLNSequence(prefixDefinition, startValue, count, sparse)

Google Sheets: Google Sheets: aidctGS1CreateGLNSequence(prefixDefinition, startValue, count, sparse)

Create a sequence of GLNs.

This function returns an array of values.

Parameters

NameTypeDescription
prefixDefinition*AnyPrefix definition, either a simple GS1 Company Prefix (as a string) or the result of a call to definePrefix. Only prefix types 0 (GS1 Company Prefix) and 1 (U.P.C. Company Prefix) are supported.
startValueNumberStart value of a domain of values to transform.
countNumberCount of values to transform. If positive, values transformed are startValue to startValue+count-1. If negative, values transformed are startValue down to startValue+count+1.
sparseBooleanIf true, value is mapped to a sparse sequence resistant to discovery.

Parameters in italics are optional.

* This parameter accepts a single value or an array of values.