I have created an own Table with coloumns like "waiting, working, blocked" (flush-left) and added it to my HTML-report.
1. But row index is still placed in the middle (centre). Flush-right is also working but it is more structure with a flush-left.
2. Is it possible somehow to display my numbers in per cent?
3. How can i add a diagramm (waiting, working etc.) for each row in a seperate coloumn for the HTML-Report?
Solved! Go to Solution.
1: This is a bug which we will fix. The HTML row index doesn't use the justification setting defined for the row index column in the table file.
2: This is currently not possible.
3: You can insert HTML code into a table cell. The code has to be surrounded by << and >>. So the following string can be used to create a stacked bar with 3 segments:
<< <span style="width: 10px; height: 9px; font-size: 10px; float: left; background-color: rgb(60, 148, 0);"></span><span style="width: 86px; height: 9px; font-size: 10px; float: left; background-color: rgb(250, 188, 0);"></span><span style="width: 4px; height: 9px; font-size: 10px; float: left; background-color: rgb(208, 34, 0);"></span>>>
I just checked the current implementation, which is unchanged since 13.0.
With Plant Simulation 13.0 the follwoing format attributes of each cell gets applied to tables in the HTML report:
So, after upgrading/updating to 13.0 you should see the tables in your HTML report with the same visual format attributes you set in the source object.
Digital Factory Divison
A way to get the numbers to display as a % is to change the column type to a string and then you can format your data as you see fit. Sorting the data then into accending or decending values will not work the same, so to get around this you can include an extra column that contains the raw data and then use this to sort, depending on what your doing you can then either delete the column after sorting (if regenerating the table each time) or can exclude it from the report (see below code, wrote from memory).
[TableFile, 1, 2, 3, 4, 5] - Will show columns 1 through to 5, but could exclude columns 6 and 7 for example.
thank you all for your support. all your proposals are working fine.
An additional question,
how can i create a connection between my coloumn values and the diagramm code?
To get the HTML span tags into the table, you would need a method using the table contents from the numerical columns, calculating the needed width for each horizontal 100%-bar.
I hope this helps a bit further!
Digital Factory Divison