To set up formatting of the selected area type, use the following groups of parameters on the parameters panel:
Formatting. It is used to set up formatting of sidehead, heading, corner, data, dimensions, dimension levels, and table dimension elements.
Format Cells. It is used to set up cell formatting.
Element Format. It is used to set up style elements format: entire table, first stripe of rows, second stripe of rows, first stripe of columns, second stripe of columns, column headers, last stripe of rows, row headers, last stripe of columns, and table corner.
Open the Formatting group of parameters
To open the Formatting group of parameters on the parameters panel:
On the parameters panel:
Select a table cell or a cell range.
Click the Parameters button on the toolbar. The parameters panel opens.
Select the required area type in the drop-down menu of the parameters panel title.
Go to the Formatting group of parameters.
On the working area:
Select a table cell or a cell range in the working area or select the required area type on the parameters panel.
Select the Formatting context menu item or select the required area type in the drop-down list of the Formatting command.
NOTE. When selecting the Formatting item for the Cells area type, the Format Cells group of parameters opens.
Open the Format Cells group of parameters
To open the Format Cells group of parameters on the parameters panel:
On the parameters panel:
Select a cell or a cell range.
Click the Parameters button on the toolbar.
Select the Cells area type in the drop-down menu of the parameters panel title.
On the working area:
Select a cell or a cell range outside the table.
Select the Formatting context menu item.
Open the Element Format group of parameters
To open the Element Format group of parameters on the parameters panel:
Select a table cell or a cell range.
Click the Parameters toolbar button. The parameters panel opens.
Select the Cells area type in the drop-down menu of the parameters panel title.
Go to the Table Style group of parameters.
Select the Edit context menu item for the changed style in sheet styles.
In the Create Table Style group of parameters select the configured element and click the Edit button.
Formatting parameters depend on the selected area type:
Sidehead/Heading. Available settings: font, fill and special border.
Corner. Available settings: cell contents, font, fill, and special border.
Data. Available settings: font, fill, special border, other.
Cells. The panel contains tabs:
Settings. Cell formatting settings: font, fill, special border, special format.
Advanced. Alignment settings, hyperlink settings, and other link settings: alignment, hyperlink, other.
Dimension/Level/Element. The panel contains tabs:
Title. Header settings: font, fill, special border.
Data. Data settings: special format, fill, special border, other.
Style Element. Available settings: font, fill, special border, special format, other. After the required settings are determined, click the Apply button.
Set the parameters:
To set up font, select:
Font. Select one of the fonts in the drop-down list. If required, one can load custom fonts.
Size. Set the required font size. The size is set in points, and it can be selected in the drop-down list or entered manually. Range of available values: [1; 72].
Color. Select font color in the drop-down palette. To show the palette, click the Palette button.
Font Style. Select font style:
Bold. One can also use CTRL+B to set this option.
Italic. One can also use CTRL+I to set this option.
Underline. One can also use CTRL+U to set this option.
NOTE. As a rule, the CTRL+U hotkey combination is reserved in the browser for opening source code of the current page. To use this hotkey combination for underlining text, redefine its purpose in browser settings.
Strikethrough. One can also use ALT+SHIFT+5 to set this option.
When the button is pressed, the corresponding font style is used. Several styles can be created at the same time.
Cell text alignment. Select text alignment relative to a cell in the drop-down menu of the Left button:
Left. It is used by default. One can also use CTRL+SHIFT+L to set this option.
Center. One can also use CTRL+SHIFT+E to set this option.
Right. One can also use CTRL+SHIFT+R to set this option.
NOTE. As a rule, the CTRL+SHIFT+R hotkey combination is reserved in the browser for refreshing the current page. To use this hotkey combination for aligning text to the right, redefine its purpose in browser settings.
By Width.
Only one option can be selected.
Select fill type:
Solid Fill. To set up solid fill, set the following parameters in the Fill group:
Fill Color. The parameter determines a fill color. Select a color in the drop-down palette or set it in the RGB or HEX format.
Hatching Type. If required, add hatching. The parameter is set to No Hatching by default. The drop-down list contains all available hatching types.
Hatching Color. The parameter is displayed after a hatching type is selected. Select a color in the drop-down palette or set it in the RGB or HEX format.
Image. To set up a fill with an image, use the Image parameter. The radio button is deselected by default, a cell fill is set up in a standard way. To use an image as a cell fill, select the radio button. To add an image to the cell, click the Select File button.
The image selection dialog box opens. Working with the dialog box depends on the browser in use. After an image is selected, the file name is displayed in the corresponding box, the report sheet cell is filled with the use of the image.
To remove the image, click the Remove button next to the texture name.
To replace the image, click the Select File button.
After the image is selected, the following elements are displayed:
Download. Click the Download button to export the image used as a fill.
Stretch Image. The checkbox is deselected by default, the cell image corresponds to its original size. Select the checkbox to fit the image to the cell.
To reset the specified fill settings, click the Delete button next to the Fill tab name.
To set up a border, select:
Border type. Click corresponding buttons of border types to be displayed:
. All.
. Internal.
. Horizontal.
. Vertical.
. External.
. Left.
. Top.
. Right.
. Bottom.
. No border.
Line Type. Select a line type in the Line drop-down list.
Color. Select border color in the drop-down palette. To show the palette, click the Palette button.
To delete border settings, click the Delete button.
It is available for the Corner area type.
By default, table area corner does not display header. To display header, select the following in the drop-down menu of the Name box:
Do not Show Name. Nothing is displayed.
Name from Heading/Sidehead. When this option is selected, an additional box appears, in which select header type:
Dimension. Dimension name is displayed.
Attribute. Dimension attribute name is displayed.
Dimension.Attribute. Attribute and dimension names are displayed.
Custom Name. Name edited by the user is displayed. When a custom name is enabled for at least one corner row or column, all corner cells become editable. It is set up for each corner column and row. When toggling to the attribute/dimension name display option for header type, the custom name is reset.
To change data format settings, in the drop-down list select one of the supported data formats. Depending on the selected format, different settings are available:
General. Equal to canceling formatting. If the General format is selected, the following settings are available:
Decimal Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Number. Default format. If the Number format is selected, the following settings are available:
Decimal Places. Select the number of displayed decimal places.
Negative Numbers. Select format of displaying negative numbers.
Thousands Separator. Set the checkbox to apply the thousands separator option. The checkbox is deselected by default.
Decimal Separator. Select the separator type in the drop-down list.
Thousands Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Percentage. If the Percentage format is selected, the following settings are available:
Decimal Places. Select the number of displayed decimal places.
Decimal Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
If percentage format is used, number values are multiplied by 100 and the "%" character is added. Values entered into a cell are processed in different ways depending on the way the "%" character is used. For example, when 40% is entered, the cell displays 40%, but the cell value is 0.4. When 40 is entered, the cell displays 4000%, but the cell value is 40.
Currency. If the Currency format is selected, the following settings are available:
Decimal Places. Sets the number of displayed decimal places.
Symbol. Sets currency symbol.
Negative Numbers. Select format of displaying negative numbers.
Decimal Separator. Select the separator type in the drop-down list.
Thousands Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Date. If the Date format is selected, the following settings are available:
Type. Select date display format in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Time. If the Time format is selected, the following settings are available:
Type. Select time display format in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Exponential. This format is used to show a number in exponential format. If the Exponential format is selected, the following settings are available:
Decimal Places. Select the number of displayed decimal places.
Decimal Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Text. Equal to canceling formatting. Text format is set by default for the cells that contain non-numeric values. Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Additional. If the Additional format is selected, the following settings are available:
Type. To automatically convert value, select the preset option:
Zip code.
Telephone number.
Table number.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
Custom. It contains code views of all available data formats. If the Custom format is selected, the following settings are available:
Type. To automatically convert value, select the preset option:
Currency. Select currency display format in the drop-down list.
Date and Time. Select time display format in the drop-down list.
Numbers. Select number display format in the drop-down list.
Other. Select other display format in the drop-down list.
Decimal Separator. Select the separator type in the drop-down list.
Thousands Separator. Select the separator type in the drop-down list.
Advanced settings are available for cells, data, dimensions, dimension levels, table dimension elements:
Set Up Cell Editor. By default, display parameter is selected in accordance with the selected parameter type. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited directly in the edit box or on the Set Up Display panel. To open the panel, click the Set Up button.
Show Editor Only on Activated Cell. Deselect the Show Editor Only on Activated Cell checkbox to show always the active cell editor. If the checkbox is selected, the editor is displayed only on activated cell.
To fill in empty or zero cells, enter text, number, or characters in corresponding boxes.
The values, with which empty cells are filled, including numeric ones, will not be saved in the data source.
To delete filling of empty or zero cells, click the Delete button.
Advanced settings are available for the Cells area type:
To manage cell edit locking, hide cell contents or deny selection, set the options:
Locked. When the checkbox is selected, cell contents will be locked for editing.
Hide Formulas. When the checkbox is selected, cell contents with formulas will be hidden and cannot be edited. Data obtained as a result of formula calculation should be displayed in the cell.
Deny Selection. When the checkbox is selected, the cell becomes unselectable on opening the form in the view mode. The context menu for this cell will not be called. While trying to select cell denied for selection, the focus remains on the previously selected cell till the next cell available for selection is selected. One can move by available cells in the table using the keyboard. When the cell range where there are unselectable cells is selected, all unselectable cells remain unselected.
Tooltip Text. Enter tooltip text for a locked cell.
To determine whether cell contents should be printed, select or deselect the Print Cell checkbox. When the Print Cell checkbox is deselected, the cell contents is not printed. Text, hyperlinks, and background color or pattern are not exported. This checkbox is selected for all cells by default.
To determine a method for inside cell alignment, use the Alignment group of settings. Cell value can be aligned horizontally and vertically with selected rotation angle and paddings from the cell borders. Wrap method can also be selected for string values.
Set the options of value position within a cell:
Alignment. Set value alignment method:
Horizontal. Available options:
By Value. Alignment depends on the cell(s) contents. If a cell contains only numbers (including thousands separators, decimal separators, and the percent sign), it is right-aligned; otherwise, it is left-aligned. Default value.
Left. Aligns data to the left border of the cell.
Center. The value is aligned at the same distance from the left and right cell border taking into account defined paddings.
Right. Aligns data to the right border of the cell.
By Width. The value is aligned to fit the cell width.
Vertical. Available options:
Top. The value is top-aligned.
Center. The value is aligned at the same distance from the top and bottom border taking into account defined paddings.
Bottom. The value is bottom-aligned. Default value.
Paddings. Set paddings between an element and cell borders: in each box set padding size for the corresponding cell border.
Text Rotation. Set text tilt angle in a cell.
Wrap Text. Set text wrapping in cells:
Do not Hyphenate. The text is not wrapped. The entire text is displayed as a single line.
By Words. Cell text is wrapped. The width of a cell determines where line breaks occur.
Text and image placed to a cell can act as a hyperlink. On clicking the cell contents the specified action is executed.
NOTE. A hyperlink is set for the whole cell, that is, it is impossible to separately set up hyperlinks for image and part of text.
To set up a hyperlink, set the parameters:
Treat as Hyperlink. Select the checkbox to convert cell text to a hyperlink. The checkbox is deselected by default, and cell text is not a hyperlink.
NOTE. By default, all hyperlinks are blue and underlined.
Alternate Text. Select the checkbox and enter an alternate text for a hyperlink in the corresponding box. In this case cell text is overlapped with this text. If a hyperlink with the alternate text is set for the cell with an image, the text is located over the image. The checkbox is deselected by default, and hyperlink text matches the cell text.
NOTE. Setting an alternate text for a hyperlink is available only when the Treat as Hyperlink checkbox is selected.
Image. Select the checkbox to add an image to a cell and hyperlink settings. The checkbox is selected and a hyperlink is set up for a cell text.
To add an image, click the Select File button. The image selection dialog box opens. After the image is selected, name of the selected file is displayed in the corresponding box, the selected image is displayed in the data entry form sheet cell.
To remove the image, click the Remove button next to the image name.
To change the image, click the Select File button.
Desired Action. In the drop-down list select the action to be executed on hyperlink click.
NOTE. Setting an action for a hyperlink is available only when the Treat as Hyperlink checkbox is selected.
The following options are available in in the drop-down list of the Desired Action parameter:
Undefined. Triggering a hyperlink does not result in any action.
Open Link. When this option is selected, a box is displayed for entering a hyperlink that will open a separate HTML page in the browser.
Open Report Sheet. When this option is selected, a drop-down list opens. In the drop-down list select a sheet to go to on hyperlink click.
Show Cell Range. When this option is selected, a box for entering a range opens. Enter manually a cell range to be selected on hyperlink click or select it in the working area. The following options of entering or selecting a cell range are available:
One cell. Enter a cell address or select it in the working area. For example: A2.
Cell range. First, enter address of the upper left cell, where the range starts, next, after a colon, specify address of the bottom right cell where the range ends, or select the range in the working area. For example: A2:B5.
One row. Enter a row number via a colon or click it in the working area. For example: 5:5.
Several rows. First, enter the first row number via a colon, then enter the second row number or select the rows in the working area. For example: 1:5.
One column. Enter the column name via a colon or click the column in the working area. For example: E:E.
Several columns. First, enter the first column name via a colon, them the second column name or select the columns in the working area. For example: A:E.
Combined area. Enter cell range addresses and single cell addresses via a semicolon, which this area consists of, or select different cell ranges and single cells in the working area with the held down CTRL key. For example: I8:J13;L13:N17;Q12.
Entire table. Enter the TABLE value or click the table corner.
To show a cell range on a different sheet, add a sheet name in the format: <sheet name>! before the above mentioned cell range enter options. For example: Sheet3!A2:C322, Sheet2!A:E.
Show Object in Screen Center. When this item is selected, the drop-down lists are displayed to select form sheet and object on the form sheet.
In the first drop-down list select the form sheet with the required object.
In the second drop-down list select the object on the selected form sheet. Clicking the hyperlink moves to this object. Objects are charts, maps, pictures, and so on.
NOTE. The drop-down list for object selection becomes active only after the form sheet is selected.
Open Repository Object. When this option is selected, a drop-down list opens. In the drop-down list select a repository object, which opens on hyperlink click.
NOTE. To open an object from a different repository, use the Open Link option.
Run Procedure/Function. When this action is selected, two additional boxes are displayed:
Unit. Select the development environment unit connected to the form.
Procedure/Function. Specify name of the procedure or function that must be run on hyperlink click.
JS-Function. Specify name of the JS-function that must be started in the web application on hyperlink click. This may be a system and a custom JS-function. Function name:
javascript:<Function name (custom parameters, callback, args)>
Parameters:
Custom parameters. Required custom parameters.
Callback. Mandatory parameter. Callback function.
Args. Function arguments.
Using angle brackets when specifying function name with parameters is mandatory.
The example of function name:
javascript:<AfterOperTest(callback)>
The function should have the required signature:
function <Function name>(custom parameters, callback, args)
{
…callback();
}
The following parameters can be obtained as arguments:
Report. Parameter for managing a report.
DataEntryForm. Parameter for managing a data entry form.
DataArea. Parameter for managing a table area.
Function example:
function addAttachments(callback, args)
{
var rep = args.Report;
var da = args.DataArea
var grid = da.getGridView();
var tabSheet = grid.getTabSheet();
var tableSource = grid.getTableSource();
var onMeasuresLoaded = (function(){
var tabSheetRange = tabSheet.getSelection().getRange();
attachFile(da, tabSheetRange);
tableSource.MeasuresLoaded.remove(onMeasuresLoaded, this, );
});
tableSource.MeasuresLoaded.addOne(onMeasuresLoaded, this, args);
callback();
}
function attachFile(da, tabSheetRange) {
var rep = da.getSource();
var grid = da.getGridView();
var tabSheet = grid.getTabSheet();
if (tabSheetRange && tabSheetRange.isValid()) {
var cells = tabSheetRange.getCells();
if (cells.length == 1) {
var cell = cells[0];
var coord = cell.getCoord();
var range = { top: coord.rowIndex, left: coord.colIndex, width: 1, height: 1 };
var views = rep.getGridViews(range);
var gridKey = views.length ? views[0].key : undefined;
var attachDlg = da.getGridView().showAttachmentDialog(gridKey, coord.rowIndex, coord.colIndex);
}
}
}}
NOTE. It is allowed to specify only procedure or function name or JS-function name.
The connected unit enables the user to:
Process entered data on the go.
Show confirmation dialog box for executed operation.
Execute additional actions before and/or after occurring of any event.
Show information messages that contain particular information (such as identifier of the changed control), and so on.
Depending on where procedure or function implementation is located, the method to specify path to it differs. A procedure or function is implemented in:
Repository unit/form: <procedure/function name>.
One of repository build objects: <procedure/function name>.
NOTE. Procedure/function signature can contain parameters.
To reset the specified hyperlink settings, click the Delete button next to the Hyperlink tab name.
See also:
Setting Up Data Entry Form Formatting and Display Type