in
reporter toolbox or select the 'Form | Cell |
Cell Text', you can see the dialogue box such as <Figure 1>.
This function is used to edit a command, command parameter
If you click the icon
in
reporter toolbox or select the 'Form | Cell |
Cell Text', you can see the dialogue box such as <Figure 1>.
You can edit a cell command etc at <Figure 1>, as follows the rules.
1) Start character is always '=', except for text.
2) Division of each sentence uses the comma(,).
3) Input the format as '@Function(contents)', except for basic data object function. ex) =@ave(A0:A3).
4) String variable starts as '$'.
5) It is possible to use an operator such as +(addition), -(subtraction), *(multiplication), /(division), %(remainder).
6) It is possible to make a counting formula by using the multiple function or operator.
7) First, calculate the sentence in ().
8) It can use the single cell substitute sentence. ex) =12, =3.14, =C1, =2F4, =G6.
9) Use the table, cell width/height specific number as function parameter ex) 1A0, 1A3, 1B3, 2C5.
10) If table number is omitted at cell specific number, it means the current table. ex) E3, G5, A2, F0.
Reference) Calculation Format
Input the basic data object as follows the example
Basic data object : = Data commnad, command parameter 1, command parameter 2, ...
AI current value data object ex) =AiCurr, count,
AI average value data object ex) =AiAve,color,Hour,0,1,0,0,0,
AI multiple average value data object ex) =AiMultiAve,speed,Hour,0,23,0,0,
Function data object : =@Function name(parameter ...)
A0 ~ A3 average value function ex) =@ave(A0:A3)
Text object : Korean, English, Number are written at dialogue box such as <Figure 1>.
Insert text ex) Operation daily report
Cell command such as above, refer to part of Basic Data , Function in Insert menu.
<Figure 1> Cell Text Edit dialogue box
Relate items)