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.
• 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 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.

x

The following issue applies to compound layout reports using document composer syntax:

• Prior to WebFOCUS Server Release 7.7 Version 05 gen 115, text markup strings containing the special page variables <ibi-page-number> and <ibi-total-pages> in compound documents displayed embedded spaces between the words and page number values. For example:

  MARKUP=ON, TEXT='Page <ibi-page-number/> of <ibi-total-pages/>',$

  would display

  Page 1      of 100 

  In WebFOCUS Server Release 7.7 Version 05 gen 115, the space can be removed from the text object with WRAP=OFF and no embedded styling between the page number variables. For example, the following code produces a page number string without the extra spaces:

  MARKUP=ON, WRAP=OFF, TEXT='<font face="ARIAL" size=10><i>Page <ibi-page-number/> of <ibi-total-pages/> of Sales Report </i>', $

  would display

  Page
  1 of 100

  The extra space will continue to be presented within text objects where WRAP=ON or styling is embedded in the text string. For example:

  WRAP=ON,MARKUP=ON, TEXT='<i>Page</i> <ibi-page-number/> of <ibi-total-pages/>', $

  would display

   Page 1      of
  100