User Interface Preferences

The User Interface section of the Set Preferences dialog contains settings related to the user interface, such as how column headings are displayed and the manner in which certain dialogs are configured.

Return focus to browser window
When selected, the browser window regains focus after a query completes. If the browser window was behind other windows or was minimized, it becomes the active window.

By default, in certain operating systems (e.g., pre-Windows XP), whenever you get a response from the system, the browser window grabs the focus. You can disable this behavior by clearing this check box.

Enable keyboard shortcuts
When selected, keyboard shortcuts for switching tabs, editing actions, showing column information, and searching for items are enabled.
Show "Run Macro" in the "File" menu
In earlier versions of 1010data, queries could be saved as macros and run in this way. This option is provided for legacy reasons.
Display progress bar
When selected, a dialog containing a progress bar will appear while a query is processing. The progress bar shows the percentage of total operations completed within the current query.
Show advanced query error information
When selected, more detailed information related to query errors is presented.
Show columns headings as
The column heading, name, or a combination of both can be displayed at the top of each column in a table.
the label
The column heading will be displayed at the top of each column (e.g., Unemployment Rate).

the name
The column name will be displayed at the top of each column (e.g., unemp_rate).

both the name and label
Both the column heading and the column name will be displayed at the top of each column.

When viewing a table multiple rows at a time, if a cell has the same value as the one above it, show
This determines how repeated values will be displayed within a particular column in a table.
the value
If a particular cell has the same value as the cell in the row above it, the same value will be displayed in that cell. This is the default setting.

a ditto mark (all columns)
If a particular cell has the same value as the cell in the row above it, a ditto mark (") will be displayed in that cell.

a ditto mark (fixed columns only)
Within a fixed column, if a particular cell has the same value as the cell in the row above it, a ditto mark (") will be displayed in that cell. Otherwise, if it is not a fixed column, the same value will be displayed.
Note: In this example the State column is fixed, but Unemployment Rate is not.
a blank (all columns)
If a particular cell has the same value as the cell in the row above it, the cell will appear blank.

a blank (fixed columns only)
Within a fixed column, if a particular cell has the same value as the cell in the row above it, the cell will appear blank. Otherwise, if it is not a fixed column, the same value will be displayed.
Note: In this example the State column is fixed, but Unemployment Rate is not.
In selection boxes, show columns in
This determines how column headings will appear within the drop-down lists in row selection dialogs (e.g., Select Rows, Find Row).
the order that they appear in the table
Column headings will appear within the drop-down lists in the same order that they appear in the table.
alphabetical order
Column headings will appear in the drop-down lists in alphabetical order and will include column names for any linked tables.
alphabetical order but with columns from linked tables last
Column headings will appear in the drop-down lists in alphabetical order; however, column headings for any linked tables will appear separately (in alphabetical order) at the bottom of the list.
Use combo boxes instead of select boxes
When selected, combo boxes will be used instead of select boxes for the drop-down lists in all dialogs.
Number of decimal places
Specifies the number of decimal places to display for numbers in the 1010data grid.
Number of Summarizations for Quick Summary
The number of summarizations available in the Quick Summary dialog. The default is 10.
Number of Grouping Columns for Tabulation
The number of grouping columns available in the Tabulation dialog. The default is 3.
Number of Summarizations for Tabulation
The number of summarizations available in the Tabulation dialog. The default is 10.
Number of Row Dimensions for Cross Tabulation
The number of rows of results available in the Cross Tabulation dialog. The default is 3.
Number of Column Dimensions for Cross Tabulation
The number of columns of results available in the Cross Tabulation dialog. The default is 3.
Number of Columns for Links
The number of available columns to match when linking tables or worksheets using the link dialogs (e.g., Link in Another Table, Link in Another Worksheet, Link and Select Rows). The default is 3.
Default folder path to save a quick query or new table
The path to the folder where quick queries and new tables are saved by default. If no path is specified, the user's My Data folder is the default location.