{"appearance":{"background":"white","padding":14,"font":{"family":"Courier New","size":10.0,"bold":false,"italic":false,"underline":false,"strikeout":false,"color":"rgb(0,72,168)"},"border":{"on":true,"size":0.0,"style":"solid","color":"#666"},"text":{"wrap":false,"hAlign":"left","vAlign":"top"}},"outputType":"WIDGET","widgetState":null,"outputs":{"console":"<pre class='debug-source'>&gt;library(flipData)\n</pre>\n<pre class='debug-source'>&gt;library(flipFormat)\n</pre>\n<pre class='debug-source'>&gt;library(flipTables)\n</pre>\n<pre class='debug-source'>&gt;library(rhtmlHeatmap)\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;mat &lt;- GetTidyTwoDimensionalArray(formTable, formIgnoreRows, formIgnoreColumns)\n</pre>\n<pre class='debug-source'>&gt;if (!is.numeric(mat[1, 1]))\n stop(&quot;The input table must contain only numeric values.&quot;)\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;mat &lt;- if (formSortRows == &quot;Ascending averages&quot;) {\n Reorder(mat, rows = &quot;Ascending&quot;, columns = &quot;None&quot;)\n} else if (formSortRows == &quot;Descending averages&quot;) {\n Reorder(mat, rows = &quot;Descending&quot;, columns = &quot;None&quot;)\n} else\n mat\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;mat &lt;- if (formSortColumns == &quot;Ascending averages&quot;) {\n Reorder(mat, rows = &quot;None&quot;, columns = &quot;Ascending&quot;)\n} else if (formSortColumns == &quot;Descending averages&quot;) {\n Reorder(mat, rows = &quot;None&quot;, columns = &quot;Descending&quot;)\n} else\n mat\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;color &lt;- if (formColor == &quot;Blues and reds&quot;) {\n &quot;RdBu&quot;\n} else if (formColor == &quot;Greys and reds&quot;) {\n &quot;RdGy&quot;\n} else\n formColor\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;color.range &lt;- if (formColor %in% c(&quot;Blues and reds&quot;, &quot;Greys and reds&quot;)) {\n mx &lt;- max(abs(mat))\n c(-mx, mx)\n} else\n NULL\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;n.row &lt;- nrow(mat)\n</pre>\n<pre class='debug-source'>&gt;n.col &lt;- ncol(mat)\n</pre>\n<pre class='debug-source'>&gt;cellnote &lt;- matrix(&quot;&quot;, n.row, n.col)\n</pre>\n<pre class='debug-source'>&gt;for (i in 1:n.row)\n for (j in 1:n.col)\n cellnote[i, j] &lt;- FormatWithDecimals(mat[i, j], 2)\n</pre>\n<pre class='debug-source'>&gt;show.cellnote.in.cell &lt;- (n.row &lt;= 20 &amp;&amp; n.col &lt;= 15 &amp;&amp; formCell != &quot;No&quot;) || formCell == &quot;Yes&quot;\n</pre>\n<pre class='debug-source'>&gt;show.x.axis.labels &lt;- (n.col &lt;= 20 &amp;&amp; formColumnLabels != &quot;No&quot;) || formColumnLabels == &quot;Yes&quot;\n</pre>\n<pre class='debug-source'>&gt;show.y.axis.labels &lt;- (n.row &lt;= 20 &amp;&amp; formRowLabels != &quot;No&quot;) || formRowLabels == &quot;Yes&quot;\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;r.output.1 &lt;- Heatmap(mat, Rowv = NULL, Colv = NULL,\n xaxis_location = &quot;top&quot;, yaxis_location = &quot;left&quot;,\n colors = color, color_range = color.range, cexRow = 0.79,\n cellnote = cellnote, show_cellnote_in_cell = show.cellnote.in.cell,\n xaxis_hidden = !show.x.axis.labels,\n yaxis_hidden = !show.y.axis.labels)\n</pre>\r\n<div class=\"debug-summarystatistics\">\r\n<table>\r\n<tr><th>Total time:</th><td>2.07s</td></tr>\r\n<tr><th>Time on R server:</th><td title=\"rApacheServe 1.77s (pre 0.00s, post 0.00s) httpget_code() setup for eval 0.00s session$eval 1.75s (pre 0.00s, post 0.07s) unexplained 0.01s apparmor forking (pre 0.03s, post 0.00s)\">1.77s</td></tr>\r\n<tr><th>Time evaluating code:</th><td>1.65s</td></tr>\r\n<tr><th>Bytes sent:</th><td>3,600</td></tr>\r\n<tr><th>Bytes received:</th><td>9,964</td></tr>\r\n</table>\r\n</div>","htmlwidgets":"<div id=\"htmlwidget_container\">\n <div id=\"htmlwidget-490d50098a96c1871d55\" style=\"width:960px;height:500px;\" class=\"rhtmlHeatmap html-widget\"></div>\n</div>\n<script type=\"application/json\" data-for=\"htmlwidget-490d50098a96c1871d55\">{\"x\":{\"rows\":null,\"cols\":null,\"matrix\":{\"data\":[\"0.00\",\"19.88\",\"18.65\",\"0.00\",\"13.76\",\"3.06\",\"0.00\",\"14.07\",\"2.75\",\"8.56\",\"17.43\",\"2.14\",\"10.09\",\"9.48\",\"4.59\",\"16.82\",\"11.62\",\"3.98\",\"22.63\",\"6.12\",\"6.73\",\"12.23\",\"3.36\",\"5.81\",\"29.66\",\"4.28\",\"52.29\"],\"dim\":[9,3],\"rows\":[\"Never\",\"Once or twice a year\",\"Once every 3 months\",\"Once a month\",\"Once every 2 weeks\",\"Once a week\",\"2 to 3 days a week\",\"4 to 5 days a week\",\"Every or nearly every day\"],\"cols\":[\"Colas (e.g., Coca Cola, Pepsi Max)?\",\"Sparkling mineral water\",\"Coffee\"],\"cells_to_hide\":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],\"cellnote_in_cell\":[\"0.00\",\"19.88\",\"18.65\",\"0.00\",\"13.76\",\"3.06\",\"0.00\",\"14.07\",\"2.75\",\"8.56\",\"17.43\",\"2.14\",\"10.09\",\"9.48\",\"4.59\",\"16.82\",\"11.62\",\"3.98\",\"22.63\",\"6.12\",\"6.73\",\"12.23\",\"3.36\",\"5.81\",\"29.66\",\"4.28\",\"52.29\"]},\"image\":\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAkAAAADCAYAAABBCiV2AAAAeklEQVQImQFvAJD/APf7//+cyeH/pMzj//f7///C2e7/6/P7//f7///A2O3/7PT8/wLg6/YAEAcFAEsqGQDa5/QAEQsFAPr9/gC41ugACwcEAPz9/gACsdfnADQcEgDu9fsA+Pv9ABcPCAD8/f8Ap87mABwRCQAgP3EAWBE/CmSlDcUAAAAASUVORK5CYII=\",\"theme\":null,\"options\":{\"xaxis_height\":80,\"yaxis_width\":120,\"xaxis_font_size\":11.06,\"yaxis_font_size\":11,\"xaxis_location\":\"top\",\"yaxis_location\":\"left\",\"xaxis_title\":null,\"yaxis_title\":null,\"xaxis_title_font_size\":14,\"yaxis_title_font_size\":14,\"xaxis_hidden\":false,\"yaxis_hidden\":false,\"xaxis_font_family\":\"sans-serif\",\"yaxis_font_family\":\"sans-serif\",\"title\":null,\"title_font_size\":24,\"title_font_family\":\"sans-serif\",\"title_font_color\":\"#000000\",\"subtitle\":null,\"subtitle_font_size\":18,\"subtitle_font_family\":\"sans-serif\",\"subtitle_font_color\":\"#000000\",\"footer\":null,\"footer_font_size\":11,\"footer_font_family\":\"sans-serif\",\"footer_font_color\":\"#000000\",\"tip_font_size\":11,\"tip_font_family\":\"sans-serif\",\"brush_color\":\"#0000FF\",\"show_grid\":true,\"legend_font_size\":11,\"x_is_factor\":false,\"legend_colors\":[\"#08306B\",\"#083573\",\"#093A7B\",\"#094083\",\"#09458B\",\"#084B93\",\"#08509B\",\"#0D55A0\",\"#125BA4\",\"#1660A8\",\"#1A65AC\",\"#1D6AB0\",\"#2070B4\",\"#2675B7\",\"#2C7ABA\",\"#3280BD\",\"#3785BF\",\"#3C8AC2\",\"#4090C5\",\"#4795C8\",\"#4E99CA\",\"#559ECD\",\"#5BA2CF\",\"#62A7D2\",\"#68ACD5\",\"#70B0D7\",\"#78B5D9\",\"#81B9DB\",\"#89BEDC\",\"#91C2DE\",\"#99C7E0\",\"#A1CBE2\",\"#A7CEE4\",\"#AED1E6\",\"#B4D3E9\",\"#BBD6EB\",\"#C1D9ED\",\"#C7DCEF\",\"#CBDEF1\",\"#CFE1F2\",\"#D3E3F3\",\"#D7E6F5\",\"#DBE9F6\",\"#DFEBF7\",\"#E3EEF8\",\"#E7F1FA\",\"#EBF3FB\",\"#EFF6FC\",\"#F3F8FE\",\"#F7FBFF\"],\"legend_range\":[0,52.2935779816514],\"legend_width\":60,\"legend_digits\":1,\"shownote_in_cell\":true,\"cell_font_size\":11,\"left_columns\":null,\"left_columns_font_size\":11,\"right_columns\":null,\"right_columns_font_size\":11,\"extra_tooltip_info\":null,\"anim_duration\":500,\"yclust_width\":0,\"xclust_height\":0}},\"evals\":[],\"jsHooks\":[]}</script>\n<script type=\"application/htmlwidget-sizing\" data-for=\"htmlwidget-490d50098a96c1871d55\">{\"viewer\":{\"width\":450,\"height\":350,\"padding\":5,\"fill\":true},\"browser\":{\"width\":960,\"height\":500,\"padding\":5,\"fill\":true}}</script>","htmlwidget-head":"{\"stylesheets\":[\"https://rserverhtmlwidgetasset.azureedge.net/heatmapcore-0b0c3c977a3de18d1ff639e311c1249c.css\"],\"javascript\":[\"https://rserverhtmlwidgetasset.azureedge.net/htmlwidgets-d2ab507a7e7d3e3d7c2178bda9d4c762.js\",\"https://rserverhtmlwidgetasset.azureedge.net/d3.min-fe2151217025e25f119e69ca126390f4.js\",\"https://rserverhtmlwidgetasset.azureedge.net/heatmapcore-e2f210a7754f3fcbeddce04d2f73b348.js\",\"https://rserverhtmlwidgetasset.azureedge.net/index-1868b419773570135e12157d84680fcc.js\",\"https://rserverhtmlwidgetasset.azureedge.net/rhtmlHeatmap-fce4de827a4fdb1bd7d1317d03394668.js\"],\"attachments\":[]}","message":"","warning":"","visible":"yes"},"secondsTaken":2.0745878,"updated":"2017-05-18T05:10:53.3290013Z","lastUpdatedMessage":null,"executedCode":"library(flipData)\nlibrary(flipFormat)\nlibrary(flipTables)\nlibrary(rhtmlHeatmap)\n\nmat <- GetTidyTwoDimensionalArray(formTable, formIgnoreRows, formIgnoreColumns)\nif (!is.numeric(mat[1, 1]))\n stop(\"The input table must contain only numeric values.\")\n\nmat <- if (formSortRows == \"Ascending averages\") {\n Reorder(mat, rows = \"Ascending\", columns = \"None\")\n} else if (formSortRows == \"Descending averages\") {\n Reorder(mat, rows = \"Descending\", columns = \"None\")\n} else\n mat\n\nmat <- if (formSortColumns == \"Ascending averages\") {\n Reorder(mat, rows = \"None\", columns = \"Ascending\")\n} else if (formSortColumns == \"Descending averages\") {\n Reorder(mat, rows = \"None\", columns = \"Descending\")\n} else\n mat\n\ncolor <- if (formColor == \"Blues and reds\") {\n \"RdBu\"\n} else if (formColor == \"Greys and reds\") {\n \"RdGy\"\n} else\n formColor\n\ncolor.range <- if (formColor %in% c(\"Blues and reds\", \"Greys and reds\")) {\n mx <- max(abs(mat))\n c(-mx, mx)\n} else\n NULL\n\nn.row <- nrow(mat)\nn.col <- ncol(mat)\ncellnote <- matrix(\"\", n.row, n.col)\nfor (i in 1:n.row)\n for (j in 1:n.col)\n cellnote[i, j] <- FormatWithDecimals(mat[i, j], 2)\nshow.cellnote.in.cell <- (n.row <= 20 && n.col <= 15 && formCell != \"No\") || formCell == \"Yes\"\nshow.x.axis.labels <- (n.col <= 20 && formColumnLabels != \"No\") || formColumnLabels == \"Yes\"\nshow.y.axis.labels <- (n.row <= 20 && formRowLabels != \"No\") || formRowLabels == \"Yes\"\n\nr.output.1 <- Heatmap(mat, Rowv = NULL, Colv = NULL,\n xaxis_location = \"top\", yaxis_location = \"left\",\n colors = color, color_range = color.range, cexRow = 0.79,\n cellnote = cellnote, show_cellnote_in_cell = show.cellnote.in.cell,\n xaxis_hidden = !show.x.axis.labels,\n yaxis_hidden = !show.y.axis.labels)","lastSavedCode":"library(flipData)\nlibrary(flipFormat)\nlibrary(flipTables)\nlibrary(rhtmlHeatmap)\n\nmat <- GetTidyTwoDimensionalArray(formTable, formIgnoreRows, formIgnoreColumns)\nif (!is.numeric(mat[1, 1]))\n stop(\"The input table must contain only numeric values.\")\n\nmat <- if (formSortRows == \"Ascending averages\") {\n Reorder(mat, rows = \"Ascending\", columns = \"None\")\n} else if (formSortRows == \"Descending averages\") {\n Reorder(mat, rows = \"Descending\", columns = \"None\")\n} else\n mat\n\nmat <- if (formSortColumns == \"Ascending averages\") {\n Reorder(mat, rows = \"None\", columns = \"Ascending\")\n} else if (formSortColumns == \"Descending averages\") {\n Reorder(mat, rows = \"None\", columns = \"Descending\")\n} else\n mat\n\ncolor <- if (formColor == \"Blues and reds\") {\n \"RdBu\"\n} else if (formColor == \"Greys and reds\") {\n \"RdGy\"\n} else\n formColor\n\ncolor.range <- if (formColor %in% c(\"Blues and reds\", \"Greys and reds\")) {\n mx <- max(abs(mat))\n c(-mx, mx)\n} else\n NULL\n\nn.row <- nrow(mat)\nn.col <- ncol(mat)\ncellnote <- matrix(\"\", n.row, n.col)\nfor (i in 1:n.row)\n for (j in 1:n.col)\n cellnote[i, j] <- FormatWithDecimals(mat[i, j], 2)\nshow.cellnote.in.cell <- (n.row <= 20 && n.col <= 15 && formCell != \"No\") || formCell == \"Yes\"\nshow.x.axis.labels <- (n.col <= 20 && formColumnLabels != \"No\") || formColumnLabels == \"Yes\"\nshow.y.axis.labels <- (n.row <= 20 && formRowLabels != \"No\") || formRowLabels == \"Yes\"\n\nr.output.1 <- Heatmap(mat, Rowv = NULL, Colv = NULL,\n xaxis_location = \"top\", yaxis_location = \"left\",\n colors = color, color_range = color.range, cexRow = 0.79,\n cellnote = cellnote, show_cellnote_in_cell = show.cellnote.in.cell,\n xaxis_hidden = !show.x.axis.labels,\n yaxis_hidden = !show.y.axis.labels)","highlightedCodeSpans":[{"start":115,"length":9,"index":4},{"start":126,"length":14,"index":4},{"start":142,"length":17,"index":4},{"start":263,"length":12,"index":4},{"start":369,"length":12,"index":4},{"start":493,"length":15,"index":4},{"start":602,"length":15,"index":4},{"start":731,"length":9,"index":4},{"start":786,"length":9,"index":4},{"start":841,"length":9,"index":4},{"start":871,"length":9,"index":4},{"start":1215,"length":8,"index":4},{"start":1236,"length":8,"index":4},{"start":1292,"length":16,"index":4},{"start":1321,"length":16,"index":4},{"start":1385,"length":13,"index":4},{"start":1411,"length":13,"index":4}],"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"guiControls":{"Code":"form.setHeading(\"Heatmap\");\nform.dropBox({label: \"Table\", name: \"formTable\", types:[\"RItem\", \"Table\"]});\nform.comboBox({label: \"Color palette\", name: \"formColor\", default_value: \"Blues\",\n alternatives: [\"Blues\", \"Reds\", \"Greens\", \"Greys\", \"Purples\",\n \"Oranges\", \"Blues and reds\", \"Greys and reds\"]})\nform.comboBox({label: \"Sort rows\", alternatives: [\"None\",\n \"Ascending averages\",\n \"Descending averages\"],\n name: \"formSortRows\", default_value: \"None\"});\nform.comboBox({label: \"Sort columns\", alternatives: [\"None\",\n \"Ascending averages\",\n \"Descending averages\"],\n name: \"formSortColumns\", default_value: \"None\"});\nform.textBox({label: \"Rows to ignore\", type: \"text\", default_value: \"NET, Total, SUM\",\n name: \"formIgnoreRows\", required: false});\nform.textBox({label: \"Columns to ignore\", type: \"text\", default_value: \"NET, Total, SUM\",\n name: \"formIgnoreColumns\", required: false});\nform.comboBox({label: \"Show cell values\", name: \"formCell\", default_value: \"Automatic\",\n alternatives: [\"Automatic\", \"Yes\", \"No\"]});\nform.comboBox({label: \"Show row labels\", name: \"formRowLabels\", default_value: \"Automatic\",\n alternatives: [\"Automatic\", \"Yes\", \"No\"]});\nform.comboBox({label: \"Show column labels\", name: \"formColumnLabels\", default_value: \"Automatic\",\n alternatives: [\"Automatic\", \"Yes\", \"No\"]});","JSError":null,"JSErrorDetails":null,"ControlDefinitionErrors":null,"InputValidationErrors":null,"Controls":[{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Type":"Heading","Label":null,"Value":null,"Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":"Heatmap","Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formTable","Type":"DropBox","Label":"Table","Value":"5d0be4d3-3e32-4eb7-bf82-ea012e630110","Allowed":["5d0be4d3-3e32-4eb7-bf82-ea012e630110"],"EmptyListMessage":null,"Multi":false,"Prompt":"Select an input which is of type Ritem or Table.","ErrorMessage":"Table: Table accepts only one input which is of type Ritem or Table.","Invalid":null,"Required":true,"AllowedTypes":["RItem","Table"],"MinInputs":1,"MaxInputs":1,"Height":1,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formColor","Type":"ComboBox","Label":"Color palette","Value":"Blues","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Blues","Reds","Greens","Greys","Purples","Oranges","Blues and reds","Greys and reds"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formSortRows","Type":"ComboBox","Label":"Sort rows","Value":"None","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["None","Ascending averages","Descending averages"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formSortColumns","Type":"ComboBox","Label":"Sort columns","Value":"None","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["None","Ascending averages","Descending averages"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formIgnoreRows","Type":"TextBox","Label":"Rows to ignore","Value":"NET, Total, SUM","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formIgnoreColumns","Type":"TextBox","Label":"Columns to ignore","Value":"NET, Total, SUM","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formCell","Type":"ComboBox","Label":"Show cell values","Value":"Automatic","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Automatic","Yes","No"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formRowLabels","Type":"ComboBox","Label":"Show row labels","Value":"Automatic","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Automatic","Yes","No"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formColumnLabels","Type":"ComboBox","Label":"Show column labels","Value":"Automatic","Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Automatic","Yes","No"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Type":null,"Label":null,"Value":null,"Allowed":null,"EmptyListMessage":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":true}]},"calculating":"Idle","showDebug":false,"layout":"OutputOnly","size":{"Width":576,"Height":512},"vSplit":0.25,"hSplit":0.45,"updateWarnings":true,"updateMode":"Manual","warnSlow":false,"outputSize":{"Width":576,"Height":511},"Options":{"debugconsole":false,"codeposition":"OutputOnly","size":{"width":576,"height":512},"splitH":0.45,"splitV":0.25,"update warnings":true,"updating":"Manual","warn slow":false}}