12421242

Grid with flag "theme=dark"

DefinitionDescriptionValuesExamples
height=;Sets the height of the grid (in "pixel" or as a percentage of the display).px or as % of the displayheight=100%;
height=200;
padding=;Sets the padding for the grid.pxpadding=8;
gridcollapsegroups=;Shows groups collapsed (if true) or expanded (if false) per defaulttrue/false
default: false
gridcollapsegroups=false;
headeravailable=;Sets the first row of the table as column header.true/false
default: true
headeravailable=true;
showcolumnheader=;Sets column headers active/inactive.true/false
default: true
showcolumnheader=true;
listcolumns=::,::;Defines the visible columns of the list.
Column indices are relative to the position of your list, so if your list starts in column C, index 1 represents column C.
index: Column list index

width: Width in px

type: text, image, number, date, time, phone, web, email, distance, address
default: text
listcolumns=1:150:text,4:80:image;
detailcolumns=::<readwrite/readonly>:,:...;Defines the visible columns of the detail dialog.
Column indices are relative to the position of your list, so if your list starts in column C, index 1 represents column C.
index: Column list index

type: text, image, number, date, time, phone, web, email, map, address
default: text

readwrite/readonly: defines if the value in this column can be edited

defaultvaluecell: there's an additional 4th parameter for detailcolumns called "defaultvaluecell". If this parameter is set, the value of the default value cell (Config!B2) is used to prefill the editor of that particular column before the list edit dialog is shown. Multiple columns can have this parameter. Please note that currently the full address (including sheetname) should be used.
detailcolumns=1:text:,2:text:,4:text:readonly:Config!B2
drilldowncolumns=,;Defines columns for the list analysis and filter function.Column list indexdrilldowncolumns=1,2;
sumcolumns=,;
searchcolumns=,;Defines columns for the search function. If no indices are defined all columns of type text are used.Column list indexsearchcolumns=1,4;
showsearchpanel=;Sets the search bar active/inactive.true/false
default: true
showsearchpanel=true;
locationcolumns=,;Defines the columns with latitude and longitude values for the map.Column list index containing the longitude value. Column list index containing the latitude value.locationcolumns=9,10;
gridtheme=;Sets the color theme of the list.dark/light
default: light
gridtheme=light;
groupcolumn=;Groups your rows after a specific column.Column list index.groupcolumn=2;
maxemptyrows=;Defines the number of blank rows after which the display of the list data should be terminated on the client.

Blank rows in the list are ignored, but if there are more blank rows in the list area than defined in maxemptyrows, the list ends.
maxemptyrows=3;
allowemptyvalues=;Defines if users are able to select an empty value in the toggle editor (drop-down list).

In your Excel, the "Ignore blank" check box needs to be checked when setting the definition allowemptyvalues=true;
true/false
default: allowemptyvalues=true;
allowemptyvalues=true;
horizontalscrolling=;Defines whether horizontal scrolling is activated by default in a list, so that the user does not have to activate it first via the functions menu.true/false
default: horizontalscrolling=false;
horizontalscrolling=false;
gridlines=;Defines the separator lines in the list column view.both, horizontal, vertical, none
default:
horizontal
gridlines=horizontal;
frozenrowscount=;Defines the number of rows on the top that are frozen and do not scroll.frozenrowscount=2;
frozencolumnscount=;Defines the number of columns on the left that are frozen and do not scroll.frozencolumnscount=1;
startwithdashboard=;Defines whether the list analysis is the first view of the list.

The list analysis diagrams can be used to filter the list. After you set the desired filter with a click you will be directed to the filtered list column view.
true/false
default: startwithdashboard=true;
startwithdashboard=true;
showlistwhenfiltering=;After you set the desired filter with a click on a chart you will be directed to the filtered list view by default (showlistwhenfiltering=true;). With this flag you can deactivate direct forwarding (showlistwhenfiltering=false;), so that several filters can be set in the list analysis view. After each click, the charts and sums recalculate so that you can evaluate your data in the list analysis, or set multiple filters before switching to the list column view.true/false
default: showlistwhenfiltering=true;
showlistwhenfiltering=true;
dashboardtheme=;Sets the color theme of the list analysis.

Does not affect list analysis in context/function menu. Applies only when startwithdashboard=true; is set.
dark/light
default: dark
dashboardtheme=dark;
dashboardcounttiles=;Defines whether the count tiles are displayed in the list analysis.true/false
default: dashboardcounttiles=true;
dashboardcounttiles=true;
dashboardsumtiles=;Defines whether the sum tiles are displayed in the list analysis.true/false
default: dashboardsumtiles=true;
dashboardsumtiles=true;
dashboardcountcharts=;Defines whether the count charts are displayed in the list analysis.true/false
default: dashboardcountcharts=true;
dashboardcountcharts=true;
dashboardsumcharts=;Defines whether the sum charts are displayed in the list analysis.true/false
default: dashboardsumcharts=true;
dashboardsumcharts=true;
allowlinebreak=;Defines whether line breaks are to be made or not.true/false
default:
allowlinebreak=false;
allowlinebreak=false;
usecellbackgroundcolors=;Defines whether the background color of the cells should be same as in the Excel. This way you can work with conditional background colors to see where, for example, a limit has been exceeded .true/false
default:
usecellbackgroundcolors=false;
usecellbackgroundcolors=true;