Description:
A table sequence constant displayed in JSON style.
Syntax:
[{Fi:…,…},…]
Note:
A JSON style table sequence constant expression is used in a constant cell or in a parameter.
Parameters:
Fi |
Name of a column in the table sequence |
Return value:
A table sequence
Example:
Cellset parameter:
:
|
A |
|
1 |
=arg1 |
Result: |
2 |
[{name:Jone,score:435},{name:Mary,score:677}] |
Result: |
Description:
Generate a new sequence by arranging distinct members (or single values) in two sequences.
Syntax:
A%B
Note:
The operator enables a new sequence by arranging distinct members (or single values) in sequenceA and sequence B. Won’t repeate distinct operation over same members.
Parameters:
A |
An integer sequence |
B |
A sequence or a single value; treated as sequence [B] when it is a value |
Return value:
A sequence
Example:
|
A |
|
1 |
=[1,2,3,4]%[2,3] |
[1,4] |
2 |
=[1,2,3,3]%[1,3] |
[2,3]; won’t repeat distinct operation over same members |
3 |
=[1,2,3]%3 |
[1,2] |
4 |
=[1,2,3,3,4]%[1,1,3] |
[2,3,4,1] |
Related functions: