Dataframe and Data Node Options
The following table lists the customization options available for dataframes and data nodes:
| Parameter Keys | Value Type | Example | Description |
|---|---|---|---|
| "Format","Color" | int - hex color | ["Format","Color",0x000000] | Background color of the pane |
| "Format","CrossLinking" | bool | ["Format","CrossLinking",False] | False = Disable Cross filtering for this Pane |
| "Format","Pad" | float | ["Format","Pad",.15] | Percentage of Total Height/Width Padding on Pane |
| "Layout","Zoom" | float | ["Layout","Zoom",1.78] | Zoom Level Of Dataframe |
| "Layout","ShowTitle" | boolean | ["Layout","ShowTitle",False] | Show or Hide Title Bar |
| "Layout","ShowRowLabel" | boolean | ["Layout","ShowRowLabel",False] | Show or Hide Dataframe Row Label (on left side) |
| "Layout","AllowCSVDownload" | boolean | ["Layout","AllowCSVDownload",False] | Allow CSV Download of Data, must also be turned on in config |
| "Layout","Title" | string | ["Layout","Title","Title Text"] | Title Bar Text (if blank, then defaults to sheet name) |
| "Layout","TitleFont","Size" | float | ["Layout","TitleFont","Size",40] | Font Size of Title Bar Text |
| "Layout","TitleFont","Color" | int - hex color | ["Layout","TitleFont","Color",0xff003e] | Font Color of Title Bar Text |
| "Layout","TitleFont","Bold" | boolean | ["Layout","TitleFont","Bold",True] | Bold Title Bar Text |
| "Layout","TitleFont","Italic" | boolean | ["Layout","TitleFont","Italic",True] | Italic Title Bar Text |
| "Layout","TitleFont","Underline" | boolean | ["Layout","TitleFont","Underline",True] | Underline Title Bar Text |
| "Layout","TitleFont","Alpha" | float | ["Layout","TitleFont","Alpha",.5] | Transparency of Title Bar Text, between 0 - 1 |
| "Layout","TitleAlignX" | float | ["Layout","TitleAlignX",1] | Horizontal Alignment of Title Bar Text, between 0 - 1 |
| "Format","Header", "Color" | int - hex color | ["Format","Header", "Color", 0x5F5F5F] | Background color of Column Header |
| "Format","Header", "TxtColor" | int - hex color | ["Format","Header", "TxtColor", 0xFFFFFF] | Text color of Column Header |
| "Format","Header", "Height" | float | ["Format","Header", "Height", 35] | Height of Column Header |
| "Format","Header", "Bold" | boolean | ["Format","Header", "Bold", True] | Bold Text on Column Header |
| "Format","Header", "Italic" | boolean | ["Format","Header", "Italic", True] | Italic Text on Column Header |
| "Format","Header", "Underline" | boolean | ["Format","Header", "Underline", True] | Underline Text on Column Header |
| "Format","Header", "LMRAlign" | int | ["Format","Header", "LMRAlign", 0] | Text alignment in Column Header: 0 Left, 1 Middle, 2 Right aligned |
| "Format","Header", "ShowHeadBorder" | boolean | ["Format","Header", "ShowHeadBorder", False] | Border around Column Header |
| "Format","Header", "ShowDataframeBorder" | boolean | ["Format","Header", "ShowDataframeBorder", False] | Border around Entire Dataframe |
| "Format","Header", "BorderColor" | int - hex color | ["Format","Header", "BorderColor", 0x000000] | Border Color around Column Header |
| "Format","Header", "BorderThickness" | float | ["Format","Header", "BorderThickness", 1.5] | Border Thickness around Column Header |
| "Row","Height" | float | ["Row","Height", 40] | Row Height for All Rows |
| "Column", Column Index (int), "Width" | float | ["Column", 1, "Width", 200] | Sets The Width of A Given Column |
| "Column", Column Index (int), "DisplayName" | string | ["Column", 1, "DisplayName", "Column Name"] | Column Name of A Given Column (will replace the name in the raw data) |
| "Column", Column Index (int), "Code" | string | ["Column", 1, "Code", "#,###.00"] | Sets The Number Format (decimal, comma, etc) of A Given Column |
| "Column", Column Index (int), "Formula" | string | ["Column", 1, "Formula", "=A1/100"] | Formula to Define the Heat Map Range of A Given Column |