Difference between revisions of "Grid Appearance"

From Lianjapedia
Jump to: navigation, search
Line 4: Line 4:
  
 
=Grid Section=
 
=Grid Section=
 +
==Alternating row colors==
 +
Display alternating row colors (True | False)
 +
* See [[Colors]].
  
−
==Row dynamic background==
+
==Automatic pagination==
−
The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'red','')
+
Grid is rendered using pagination if the number of records exceeds below amount (True | False)
  
−
==Row dynamic foreground==
+
==Automatic pagination size==
−
The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'white','')
+
Grid is rendered using pagination if Automatic pagination is true and the number of records exceeds this amount
  
−
==Show actionbar==
+
==Autoresize columns==
−
Show the actionbar (True | False)
+
Autoresize grid columns to fit data (True | False)
  
−
==Show grid lines==
+
==Background color==
−
Show grid lines (True | False)
+
Section background color.
 +
* See [[Colors]].
  
−
==Alternating row colors==
+
==CSS style==
−
Display alternating row colors (True | False)
+
CSS style (separate attributes with ; or use app:/filename.css).
 +
* See [[CSS]].
 +
 
 +
==Foreground color==
 +
Section background color.
 +
* See [[Colors]].
 +
 
 +
==Gradient colors==
 +
Render the background color as a gradient (True | False).
 +
* See [[Gradients]].
 +
 
 +
==Gradient end color==
 +
Gradient end color.
 +
* See [[Gradients]].
 +
 
 +
==Gradient start color==
 +
Gradient start color.
 +
* See [[Gradients]].
 +
 
 +
==Gradient type==
 +
Specify the gradient type.
 +
* See [[Gradients]].
 +
 
 +
==Grid background color==
 +
Grid background color.
 +
* See [[Colors]].
 +
 
 +
==Grid foreground color==
 +
Grid foreground color.
 
* See [[Colors]].
 
* See [[Colors]].
  
Line 24: Line 56:
 
Height of the grid rows
 
Height of the grid rows
  
−
==Autoresize columns==
+
==Infinitely scrollable==
−
Autoresize grid columns to fit data (True | False)
+
Grid is always rendered using infinite scroll for large data sets (mousewheel on desktop/web, flick up and down on mobile) (True | False). From v4.1.
  
−
==Stretch last column==
+
==Inline effect==
−
Stretch last grid column (True | False)
+
The display effect for inline images and memos (None | Dropshadow | Raisedshadow). From v4.1.
  
−
==Split grid==
+
==Inline height==
−
Split the grid into a grid and a form (True | False)
+
The display size height for inline images and memos. From v4.1.
  
−
==Show split edit==
+
==Inline width==
−
Display grid in split/form edit mode when displayed (True | False)
+
The display size width for inline images and memos. From v4.1.
  
−
==Show memo/object panel==
+
==MultiSelect rows==
−
Show memo/object panel in splitbar mode (True | False)
+
Enable multi selection of grid rows. The SelectionChanged delegate is called as rows are selected or deselected (True | False)
 +
 
 +
==MultiSelect rows expression==
 +
The expression to evaluate when a multi select row operation is performed. These are passed as a comma separated list to the SelectionChanged delegate.
 +
 
 +
==Pagination==
 +
Grid is always rendered using pagination (for large data sets) (True | False)
 +
 
 +
==Row dynamic background==
 +
The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'red','')
 +
 
 +
==Row dynamic foreground==
 +
The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'white','')
  
 
==Scrollbar==
 
==Scrollbar==
 
Section displays the grid vertical scrollbar (True | False)
 
Section displays the grid vertical scrollbar (True | False)
 +
 +
==Show actionbar==
 +
Show the actionbar (True | False)
 +
 +
==Show grid lines==
 +
Show grid lines (True | False)
 +
 +
==Show images inline==
 +
Show image columns as inline images (True | False). From v4.1.
  
 
==Show logicals as CheckBoxes==
 
==Show logicals as CheckBoxes==
 
Display logical/Boolean values as CheckBoxes (True | False)
 
Display logical/Boolean values as CheckBoxes (True | False)
  
−
==MultiSelect rows==
+
==Show memo/object panel==
−
Enable multi selection of grid rows. The SelectionChanged delegate is called as rows are selected or deselected (True | False)
+
Show memo/object panel in splitbar mode (True | False)
  
−
==MultiSelect rows expression==
+
==Show memo/varchar inline==
−
The expression to evaluate when a multi select row operation is performed. These are passed as a comma separated list to the SelectionChanged delegate.
+
Show memo/varchar columns as inline text (True | False). From v4.1.
  
−
==Pagination==
+
==Show split edit==
−
Grid is always rendered using pagination (for large data sets)(True | False)
+
Display grid in split/form edit mode when displayed (True | False)
  
−
==Automatic pagination==
+
==Split grid==
−
Grid is rendered using pagination if the number of records exceeds below amount (True | False)
+
Split the grid into a grid and a form (True | False)
  
−
==Automatic pagination size==
+
==Stretch last column==
−
Grid is rendered using pagination if Automatic pagination is true and the number of records exceeds this amount
+
Stretch last grid column (True | False)
 +
 
 +
==Transparency==
 +
Specify a transparency percentage from 0 to 100.
 +
* See [[Shading and Transparency]].
  
 
=Grid Column=
 
=Grid Column=
  
 
==Alternating row colors==
 
==Alternating row colors==
 +
Should this column have alternating row colors if the grid does (True | False).
  
−
==Fixed column width==
+
==Background color==
 +
The background color of the column
 +
* See [[Colors]]
  
−
==Column width==
+
==Button==
 +
Display as a button (True | False).
 +
 
 +
==Button caption==
 +
The (optional) button caption.
  
 
==Cell dynamic background==
 
==Cell dynamic background==
 +
The expression or function that provides dynamic cell color formatting, e.g. iif({}<0,"red",""). Note the use of {}, substituted with the current cell value.
  
 
==Cell dynamic foreground==
 
==Cell dynamic foreground==
 +
The expression or function that provides dynamic cell color formatting, e.g. iif({}<0,"red",""). Note the use of {}, substituted with the current cell value.
  
−
==Button==
+
==Column width==
−
 
+
Specify the fixed width in pixels of this column (0 is autosized).
−
==Button caption==
+
  
 
==Custom control==
 
==Custom control==
 +
The name of a procedure/function that will create a custom container/control to be rendered in the cell. Desktop only.
  
−
==Total this column==
+
==Fixed column width==
 +
Should this column be a fixed width (True | False).
 +
 
 +
==Text Alignment==
 +
Text alignment (Auto | Left | Center | Right).
  
 
==Total expression==
 
==Total expression==
 +
Specify an expression to calculate the column total, e.g. calc_column("{}"). Note that {} will be substituted with the data controlsource.
  
 
==Total format==
 
==Total format==
 +
Specify an expression to format the column total, e.g. currency({}).
 +
 +
==Total this column==
 +
Include this column in the summary totals (True | False).

Revision as of 11:10, 4 December 2017

Under Construction

See Also

Attachments Section Attributes, Colors, CSS, Data Attributes, Gradients, Grid Column Attributes, Grid Section Attributes, Section Appearance, Shading and Transparency

Grid Section

Alternating row colors

Display alternating row colors (True | False)

Automatic pagination

Grid is rendered using pagination if the number of records exceeds below amount (True | False)

Automatic pagination size

Grid is rendered using pagination if Automatic pagination is true and the number of records exceeds this amount

Autoresize columns

Autoresize grid columns to fit data (True | False)

Background color

Section background color.

CSS style

CSS style (separate attributes with ; or use app:/filename.css).

Foreground color

Section background color.

Gradient colors

Render the background color as a gradient (True | False).

Gradient end color

Gradient end color.

Gradient start color

Gradient start color.

Gradient type

Specify the gradient type.

Grid background color

Grid background color.

Grid foreground color

Grid foreground color.

Grid row height

Height of the grid rows

Infinitely scrollable

Grid is always rendered using infinite scroll for large data sets (mousewheel on desktop/web, flick up and down on mobile) (True | False). From v4.1.

Inline effect

The display effect for inline images and memos (None | Dropshadow | Raisedshadow). From v4.1.

Inline height

The display size height for inline images and memos. From v4.1.

Inline width

The display size width for inline images and memos. From v4.1.

MultiSelect rows

Enable multi selection of grid rows. The SelectionChanged delegate is called as rows are selected or deselected (True | False)

MultiSelect rows expression

The expression to evaluate when a multi select row operation is performed. These are passed as a comma separated list to the SelectionChanged delegate.

Pagination

Grid is always rendered using pagination (for large data sets) (True | False)

Row dynamic background

The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'red',)

Row dynamic foreground

The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'white',)

Scrollbar

Section displays the grid vertical scrollbar (True | False)

Show actionbar

Show the actionbar (True | False)

Show grid lines

Show grid lines (True | False)

Show images inline

Show image columns as inline images (True | False). From v4.1.

Show logicals as CheckBoxes

Display logical/Boolean values as CheckBoxes (True | False)

Show memo/object panel

Show memo/object panel in splitbar mode (True | False)

Show memo/varchar inline

Show memo/varchar columns as inline text (True | False). From v4.1.

Show split edit

Display grid in split/form edit mode when displayed (True | False)

Split grid

Split the grid into a grid and a form (True | False)

Stretch last column

Stretch last grid column (True | False)

Transparency

Specify a transparency percentage from 0 to 100.

Grid Column

Alternating row colors

Should this column have alternating row colors if the grid does (True | False).

Background color

The background color of the column

Button

Display as a button (True | False).

Button caption

The (optional) button caption.

Cell dynamic background

The expression or function that provides dynamic cell color formatting, e.g. iif({}<0,"red",""). Note the use of {}, substituted with the current cell value.

Cell dynamic foreground

The expression or function that provides dynamic cell color formatting, e.g. iif({}<0,"red",""). Note the use of {}, substituted with the current cell value.

Column width

Specify the fixed width in pixels of this column (0 is autosized).

Custom control

The name of a procedure/function that will create a custom container/control to be rendered in the cell. Desktop only.

Fixed column width

Should this column be a fixed width (True | False).

Text Alignment

Text alignment (Auto | Left | Center | Right).

Total expression

Specify an expression to calculate the column total, e.g. calc_column("{}"). Note that {} will be substituted with the data controlsource.

Total format

Specify an expression to format the column total, e.g. currency({}).

Total this column

Include this column in the summary totals (True | False).

Retrieved from "https://www.lianja.com/doc/index.php?title=Grid_Appearance&oldid=18681"