Returns an SHA-1 hash of the values in the given range.
This function can be used to compute changes within a range, which can be specified as a defined name or an address.
This function can work with discontiguous ranges.
@Checksum(<Range>)
| Argument Name | Description |
|---|---|
| Range | The range name or address. |
function example
| A | |
|---|---|
| 1 | |
| 2 | 5.0 |
| 3 | 4.0 |
| 4 | 3.0 |
| 5 | 2.0 |
| 6 | 1.0 |
| Procedure | ||||||
|---|---|---|---|---|---|---|
| Method | Overload | ErrorHandlingMode | ||||
| Argument | Value | Comment | ||||
| OnAfterBuild | ||||||
| SetEntry | Text | |||||
| Address | Data.Range | |||||
| CellByCell | True | |||||
| CellCondition | ||||||
| Entry | @Checksum(Data.Range) | |||||
| A | |
|---|---|
| 1 | |
| 2 | 0aeee979a64de2bcdf8c02fc02e65c67b4625e73 |
| 3 | e2b32402f693732bc7aab7c1166007ed637ea7f4 |
| 4 | ebeb8094d727364ef0e9b73f508c165e6681503e |
| 5 | 2521d22729ff8ca61035ecef6eb9a75cf4f0125d |
| 6 | d6edacf684ba28977ccfcff88e053ffcb2175d67 |