ajBigStrSet function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Creates a big string and returns the big string ID.
Syntax
ajBigStrSet(text, [run_condition], [run_by_function_point_only])
Argument Name | Description | Description |
---|---|---|
text (required) | Range / Array | The text or text cell reference to be saved. |
run_condition (optional) | Boolean | The function will run when the value is TRUE. Otherwise will not run. The default value is TRUE. |
run_by_function_point_only (optional) | Boolean | If it equals FALSE, the function can be executed through ‘Excel Calculation’ (can be either Automatic or Manual, Calculate Now or Calculate Sheet) or Preview Function Point. If it equals TRUE, the function can be executed with Preview Function Point (AlchemyJ ribbon \ Preview Function Point) only. The default value is TRUE. |
The function will return:
1) Return Value: Big String
2) Return Type: Single Value
Example
In this example, we will demonstrate how to save plain text to memory and returns the big string ID. In this example, we would be using 'abc'.
The Big String value we have used here is 'abc'. To convert 'abc' into a big string ID, we can use the formula as shown in B5 and it will return a Big String value as shown in B6.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type.