icon of Reporter ToolBox.
It is a function to get the number of vertical cells which is the maximum value of the horizontal addresses.
This function usually get the number of total increased lines, when GetLineCount function is run.
If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.
After inserting the ¡®@GetLineCount(B1:B1)¡¯ at Insert Function dialogue box,
you can modify this function by using the Cell
Text Edit dialogue box. This dialogue box comes up by selecting the 'Form |
Cell | Cell Text' or
icon of Reporter ToolBox.
Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.
Function for the number of lines uses following format.
-Function definition : int GetLineCount(cell 1 : cell 2)
-Function parameter : Specific number of cell. (start / end location)
-Result : The number of lines between start and end.
Example of written function) =@GetLineCount(B2:B2)
Function description : It displays the number of vertical lines which is located between B2 ~ B2.
If B2 cell is multiple lines, it displays the number more than 1. (or always 1 )
Relate items)
Data Object for Multiple Lines