User Tools

Site Tools


Guide Section: An EASAP GUI

CASE VIEWER is a GUI object with visual and functional similarities to DATA TABLE but specialized for the search, selection, retrieval of a case, and subsequent launch of an Excel Client.

CASE VIEWER may have Child FILTER objects that create SQL queries to allow a User to search for and then select a case.

With CASE VIEWER and a Child FILTER an Author may present the following steps to a User :

  1. Query a database for cases that meet User-specified criteria
  2. Let a User select a single case
  3. Deliver a database-linked Excel spreadsheet
    • → Initialized with that case's data
  4. Let a User modify the case within Excel
  5. Let a User save that case back to the MySQL instance from within Excel

Once a case is selected, the CASE VIEWER reference will contain the value of that case id for use in a DATABASE TO EXCEL DESKTOP→​Case Id:

Essential Parameters:
Columns:Select Excel named ranges or MySQL metadata to populate CASE VIEWER table
Column Titles:Comma separated strings to describe each column in a header
Optional Parameters:
Title:Title text
Width:Width in pixels
Height:Height in pixels
Header Height:Header height in pixels
Title Style:HTML STYLE for Title:
Show if:Logical expression, if TRUE then box shown, if FALSE then box NOT shown
Column Sizes:Comma-separated literal pixel widths or object references
Lock Column Width:Allows dynamic modification of column width, default→FALSE
Delimiter:Character to delimit object references in Column Titles: or Show if: (default→%)
Excel File Whitelist:Whitelist of spreadsheets to allow within CASE VIEWER
Pattern:Display dates in this format (default→dd-MM-yy see Date Formats in an EASAP)
Count:Enter the name of a new SCALAR which will contain the number of results returned in the result set restricted by FILTER conditions.
Refresh on Save:Update this CASE VIEWER data following an EASA Ribbon→Save from within an Excel Client (default→FALSE).
Displayed Cases:Enter the name of a new explicit LIST which will contain case ids for the current state of the CASE VIEWER.
Formats: printf()-style Separator for Formats: separated formatting strings for each of the Columns: of data, although dates or times are not supported.
Separator for Formats: Separate the strings specified in Formats: with this character. Comma is not recommended as it is interpreted as a 'thousands separator', % (percent) is reserved as a prefix for a format specifier as well, / or <FORWARD SLASH> is the default.

A CASE VIEWER may have either of two Child objects:

Object Name Description
FILTERDynamically modifies which case records are visible according to the value of a logical comparison.
EXTERNAL FILTERDynamically modifies the case records visible according to the case id's returned from the SQL in its External SQL: parameter.

Formats: and Separator for Formats:

A lengthy javadoc reference for Java formatting may be found at:

Here we introduce a format specifier and give some examples.

Formats: contains a list of format specifiers separated by the character set in Separator for Formats:

The length of this list must be the same as the length of the list in Columns:

Below are some common format specifiers for strings and floating point data:

  • %s→string
  • %S→uppercase string
  • %f→ floating point number
    • %f10.4→ floating point number with a minimum number of characters to be writing of 10 and precision of 4
      • eg. 000654.1234 for 654.12345
  • %g → scientific notation
    • eg. 6e+12
  • $ %s → constant string + string
    • eg. $ 16.49
  • %,f.2 → add locale-specific thousands separator to a floating point number
    • eg. 4,321.98 for 4321.98
  • %d → format result as an integer
    • %(d → enclose negative integer in parenthesis
      • eg. (1000) for -1000
  • %+d always include a sign
    • eg. +45 for 45

Mortgage Calculator EASAP with a CASE VIEWER

The Mortgage Calculator (Excel Desktop Client) EASAP uses a CASE VIEWER to search for and select a mortgage record to modify in a mortgage calculator spreadsheet.

Page Tools