x

The following are known issues with EXL2K FORMULA:

• The INT function is only supported if the result is returned to a field defined with an Integer data type.
• The phrase ON byfield RECOMPUTE does not recalculate the formula at the sort break, but rather, repeats the formula from the previous row.
• Prefix operators used to manipulate the display values can be used with Excel FORMULA output, but are placed in the worksheet as values rather than formulas. When display prefix operators are used within a request, both the initial value and the prefixed value are placed into the internal matrix in the order in which they are defined and are available to the procedure. Excel FORMULA will use the last reference of a field in a request used in a formula from the internal matrix, unlike all other formats.

  In the following example, the field UNITS will be represented twice in the internal matrix: for UNITS and PCT.UNITS. When the COMPUTE that follows references the UNITS field, it is passed the last instance of UNITS, which in this case, is PCT.UNITS, rather than the first instance, which would be UNITS.

  TABLE FILE GGSALES
  SUM UNITS
       BUDUNITS
       PCT.UNITS
       COMPUTE PERC_BUD/D12.6 = UNITS/BUDUNITS; AS 'Percent of Budget'
  BY REGION 
  BY ST 
  ON TABLE PCHOLD FORMAT EXL2K FORMULA
  END

  

• SET SUBTOTALS = ABOVE may produce incorrect formulas when used with EXL2K FORMULA.

x

The following issues apply to FORMAT EXL07:

• FORMAT EXL07 and FORMAT XLSX are synonyms and can be used interchangeably. The the FILE SAVED message will always display XLSX FILE SAVED regardless of the format specified to identify that the actual file format generated is the XLSX file structure supported by Excel 2007, Excel 2010, and Excel 2013.
• Dynamic field-based reformatting created as DEFINE or COMPUTE fields can be used in EXL2K generated workbooks, but are not currently supported for XLSX/EXL07 workbooks.

x

The following browser specific issue occurs when using the HTML HFREEZE reporting feature:

• When using a non-Internet Explorer browser, the top and bottom border styling of the column title is missing 1 pixel between the field column titles.