XFRX version 9.6

The generated file can now be automatically zipped. We have added new parameters to Setparams method:

Example:

With these SetParams parameters, XFRX first creates "invoices.pdf", then creates "archive.zip" (if it doesn't exist) and adds "invoices.pdf" into the archive. Then "invoices.pdf" will be deleted:

lnRetVal = loSession.SetParams("invoices.pdf",,.T.,,,,"PDF","archive.zip", .t., .t.)

You can prevent individual report bands from printing by calling skipBands() methods of the XFRXSession object. A parameter of this method is a string containing a comma delimited list of bands that will be skipped. The bands are represented by codes as stated in the following table:

Example:
loSession.skipBands("H,GH1,GF3,S")

The format definition of numeric cells in Excel is different from the format syntax used in Foxpro. XFRX is now able to convert the simple format definitions and allows for user-defined implicit and/or explicit Excel-type format definitions.
In Visual Foxpro, the numeric field is converted to its text representation based on an explicit format definition (format field in the report expression definition) or field's decimal places and SET DECIMAL setting.
When a numeric field is transformed to an Excel cell, the following algorithm is used:

1. If there is an explicit XLS format defined, use it.
   To define an explicit XLS format for a numeric field, add:

   #UR XLSF= (expression)

   to the field's comment.

   Example:
   #UR XLSF="General"

   The "General" formatting - no special formatting, the number of decimal places is determined by the field's value

   #UR XLSF="Standard"
   

   The "Standard" formatting - two decimal places, thousand and decimal separators will be used according to the Excel defaults

   #UR XLSF="#0.00"
   

   Two decimal places, no leading zeros

   #UR XLSF="#0.00;[red]#0.00"
   

   Two decimal places, display negative numbers in red
2. If the field contains a format definition, try to look up the format in a conversion table. A conversion table can be populated programatically when XFRX is executed so that the formats that are often used and cannot by converted automatically by XFRX would not require an explicit definition in each field in the report.
   To add an entry to the conversion table, use addXLSFormatConversion method of XFRXSession class.

   Example:
   loSession.addXLSFormatConversion("@L 999999.99","000000.00")

3. If the field contains a format definition and it is not listed in the conversion table, try to convert it. XFRX is able to convert simple format definitions containing the following characters: '9', '#', ',', '.' and ' '. For example, 999,999.99 is converted to ###,###.00.
4. If the format cannot be converted, use the implicit XLS numeric format, if available.
   To define the implicit XLS numeric format, call setDefaultXLSFormat method of the XFRXSession object with the implicit format as a parameter.

   Example:
   loSession.setDefaultXLSFormat("General")

5. If the implicit XLS numeric format is not defined, XFRX creates a format definition to display the same number of decimals as in VFP report output.

If you want to specify that a certain numeric field should be converted as a text cell in the excel sheet, define "TEXT" as its explicit XLS numeric format:

#UR XLSF='TEXT'

For a live example of formatting the Excel cells, please have a look at the "XLS formatted numeric cells sample" report in the demo application.