Combine Function
The CXL.Combine() function is used to allow cells to contain values for CXL parameters and combine them into one value for a CXL paramenter. The Options parameter is a good example which can have many values, and thus by using the CXL.Combine() function militiple options can be set up in cells and combined into one parameter value, as used in many of the wizard created sheets.
Wizard: "Stock, Customer or Vendor Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.
Example
| Combine values for parameters: | =CXL.Combine( D3, D4 ) more Combine Examples |
|
Returns "COMP_A, COMP_B" from cell ref D3 and D4 Takes an array of referances. Thus we can put values in cells, and combine them to make a list of values for CXL function parameters. Blank values are ignores |
|
| to become: | =CXL.CodesSpill( CXL.Combine( D3, D4 ), "GLCodesByHead" ) |
Wizard: "Get GL Values Example Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.
Parameters:
| Parameter | Description |
|---|---|
| CompCode |
Single Company code Short code assigned by Consolidated XL, or by you to identify your company |
| CellValues |
One or more cell values to combined to make a list Blank values ignored |