Table

Example

The following example of a script creates rows. The "appendLines" attribute will be used for adding rows to a table (you can also use it as follows: objectName.appendLines();). A new table does not contain any cells and these must be created explicitly by adding rows in the following way:

main()
{
setValue("","appendLines", 6 );
}

Example

In the following example, the graphics attributes appendLine, updateLine, appendLines, updateLines, cellValue can also set any_type variables per cell. The variables can contain the following three elements (elements 2 and 3 are optional. A variable must not contain more than three elements):

1. Value of a cell
2. Background color of a cell
3. Foreground color of a cell

Thus, value, foreground and background color of a table (column1 = first column, column2 = second column) can be set simultaneously.

main()
{
  dyn_anytype x,y;
  x[1]="abcd";
  x[2]="[100,0,0]";
  x[3]="_3DFace";
  y[1]="test";
  y[2]="[0,100,0]";
  y[3]="_3DText";
  setValue("TABLE2","updateLine",1,"Column1",x,"Column2",y);
}

The following script deletes a selected row. The specific attributes are "currentCell" and "deleteLineN". The first attribute contains two parameters of type int. The first parameter is used to query or set the number of the row and the second to query the number of the column. The attribute "deleteLineN" contains a parameter of type int. This parameter specifies the number of the row that should be deleted.

main()
{
  int row, column;
  getValue("", "currentCell", row, column);
  setValue("", "deleteLineN", row);
}

Example

The following script processes the user input in the work function. The parameters contain the row number as an integer, the column name as well as the keyboard entry of the user as string variables. If the content of the cell should not be a string, it can be changed using sscanf(). In this example, an integer value should be entered. This means a value without decimals. If the content could not be changed, an "Error" will be shown. The user input will be saved in the column with "cellValueRC". This attribute contains a parameter of type int that contains the row number as well as a parameter of type string that contains the column header of the cell. The content of the cell will be passed using the third parameter. In the work function, the value that has been entered by the user, will be added together with the value 3 and will be written to the table.

main(int rowN, string columnN, string input)
{
   int ok, val;
   ok = sscanf(input, "%d", val);
   if(ok == 1)
   {
     int h = work(val);
     setValue("TABLE2", "cellValueRC", rowN, columnN,h);
   }
else
   setValue("TABLE2","cellValueRC",rowN,columnN,"Error!");
}
int work(int val)
{
  val = val + 3;
  return val;
}

Example

In the following example rows are assigned to four valves. The script shows the valve flow rate in a column. The function dpConnect() calls the function showRate() whenever one of the data point variables "VD01.flowrate" to "VD04.flowrate" change. The showRate() function sets the values of the column "Flow rate" to the online values.

main()
{
dpConnect("showRate","VD01.flowrate:_online.._value",

       "VD02.flowrate:_online.._value",
       "VD03.flowrate:_online.._value",
       "VD04.flowrate:_online.._value");
/* note that the dpConnect function has to be written on one line */
}
showRate(string dp1, int fl1, string dp2, int fl2,string dp3, int fl3, string dp4, int fl4)
{
   setValue("", "updateLine", 1, "Valve", "VD01","flow rate", fl1);
   setValue("", "updateLine", 1, "Valve", "VD02","flow rate", fl2);
   setValue("", "updateLine", 1, "Valve", "VD03","flow rate", fl3);
   setValue("", "updateLine", 1, "Valve", "VD04","flow rate", fl4);
   setValue("", "updateLine", 1, "Valve", "total","flow rate", fl1+fl2+fl3+fl4);
  /* note that the showRate function has to be written on one line */
}

Example

You can find out what row and column of a table has been clicked as follows:

main(int row, string column, string value)
{
  DebugN("Row",row,"Column",column);
}

Example

Following example adds HTML elements (text + picture) to a table cell.

string picPath = "arc.png";
this.appendLine("#1", "<b><i>My Icon:</i></b> <img src='pictures:"+picPath+"'></img>");
this.cellFormatRC(0, "#1", "[h,,,ALIGNMENT_CENTER]");

It is to considered that alignment settings for HTML content must also be made within the HTML tags (=> align attribute, see example below) as settings made via Control/GEDI are not applied for the HTML content.

Example

<div>My content</div>
<table border=1 align="center">
<tbody>
<tr><td>My centered table content</td></tr>
</tbody>
</table>