- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
SCAN
This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.
Syntax
SCAN([initial_value], array, lambda(accumulator, value))
Argument
This function has the following arguments:
Argument | Description |
|---|---|
[initial_value] | (Optional) Sets the starting value for the accumulator. |
array | An array to be scanned. |
lambda | A LAMBDA that is called to scan the array. The LAMBDA takes two parameters:
|
Remarks
Use the initial_value argument to set the starting value for the accumulator parameter. If you are working with text, set the initial value to "".
If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters".
Data Types
Returns an array.
Examples
SCAN(1, A1:C2, LAMBDA(a,b,a*b))
SCAN("",A1:C2,LAMBDA(a,b,a&b)