XFRX readme

XFRX version 18.1.0, Release notes

Release date: 27nbsp;July 2018

Links

Important installation note for the latest version

VFP 9.0: UtilityReportListener class in XFRX
Since version 12.4 the XFRXListener class (which is used when running reports in VFP 9.0 in the object assisted (report listener) mode) is derived from the UtilityReportListener class, which is not included inside XFRX.PRG (XFRX.FXP) and needs to be provided for XFRX to run correctly. UtilityReportListener is a FFC class, which takes care, via its predecessor FXListener, of the new dynamic reporting features introduced in VFP 9.0 SP2. It is implemented in ReportListener.vcx class library, which is by default stored in the FFC subdirectory of the VFP home directory. In the development environment you make it available by executing the following command:
```
SET CLASSLIB TO (HOME()+"ffc\_reportlistener")
```
To distribute UtilityReportListener with your application you need to include the following FFC files (all available in the FFC directory):
- _reportlistener.vcx
- reportlisteners.h
- reportlisteners_locs.h
- foxpro_reporting.h
- _frxcursor.vcx
- _frxcursor.h
- _gdiplus.vcx
- gdiplus.h
A drawback of including the FFC classes to your project is that they add almost 1MB to the final exe size so alternatively, if you don't use the dynamic features in SP2 and you would like to reduce the final exe size, you can use a UtilityReportListener implementation that comes in with the XFRX package in UtilityReportListener.zip. This implementation corresponds to the pre-SP2 FFC class and is only about 30KB. To use the alternative implementation add the following files to your project (all available in the UtilityReportListener.zip archive):
- reportlisteners.h
- reportlisteners_locs.h
- foxpro_reporting.h
- utilityReportListener.prg
and make the implementation visible by executing the following command before running XFRX:
```
SET PROCEDURE TO utilityReportListener.prg ADDITIVE
```

Important installation notes for 12.x versions and newer

VFP 6.0: The XFRX previewer component requires FOXTOOLS.FLL library if used in VFP 5.0, VFP 6.0, VFP 7.0.
XFRXLIB.FLL now also requires MSVCP71.DLL library to be installed (the previous version required GDIPLUS.DLL and MSVCR71.DLL libraries), all three libraries are required now

Enhancements and fixes

XFRX#LISTENER

FIX: The output file doesn't contain images. In the log file there is a message "Error 2028.00 _xfsaveimage 0.00 API call caused an exception".

XFRX#PREVIEW

FIX: XFRX Preview can wrap a long line into two lines.
FIX: XFRX Preview generates dangling reference.
ENH: Better localization to German language (Thank you very much to k-advice software GmbH).

XFRX#INIT

XFRX#CORE

ENH: Native support for PNG (with alpha chanel).
ENH: Better colors conversion for BMP with compression BI_BITFIELDS from N bpc to 8 bpc.
ENH: Support for alpha chanel in BMP RGBA16 and RGBA32.
ENH: Support for transparent pixels in BMP RLE4 and RLE8.
ENH: Native support for JPEG-CMYK. (faster processing, but bigger pdf file).
DEL: Droped '#UR COLOR "CMYK"' directive.
ENH: New parameter CMYK2RGB.
ENH: New parameter TRANSPARENTOFF.
FIX: Bug in TIFF bigendian processing.
FIX: Slower processing of JPEG images.
FIX: The output PDF file with PDF/A-1a or PDF/A-1b is not compliant.
ENH: Added support in append mode for cross-reference stream in the original file.
ENH: Added support for only digital signing for existing file.
FIX: The text in the output file has weird background color if the output file has PDF/A compliance.
FIX: PDF shows only the first BMP file if the size of each file is greater than 16 MiB.

PDFL

XFRX#TEXTFORMAT

NATIVE_FXLSX, NATIVE_PFXLSX

FIX: Some cell(s) has not background color.

XFRX#DIAGNOSIS

FIX: If VFP can't load XFRXLIB.FLL then diagnostic mode don't analyze xfrxlib.fll.

XFRX version 18.0.0, Release notes

Release date: 18 March 2018

Enhancements and fixes

XFRX#CORE

FIX: XFRX cuts the text field content if the trim mode is not "Default trimming" and DPI scale is greather than 100%.

XFRX#INIT

FIX: If a "float" position type text field is stretched it is not moved to the next band

CopyToXLSX

FIX: XFRX_CopyToXLSX files saved with "Martina" as the creator
ENH: Header without auto filter are now supported
ENH: Static formating - speed improvements
ENH: Dynamic formating - speed improvements
ENH: Dynamic formating - record count limit removed

NATIVE_FXLSX, NATIVE_PFXLSX

ENH: significant speed improvements

XFRX version 17.3.1, Release notes

Release date: 31 December 2017

Enhancements and fixes

XFRX#INIT

XFRX#LISTENER

XLS, FODS, NATIVE_FXLSX

FIX: Texts lost event if text has short length for outputs.

FDOC, FODT, FRTF, NATIVE_FDOCX

FIX: Texts converts to textboxes event if text has short length.

ODT, FODT, ODS, FODS, PFODS

FIX: Error message "Function argument value, type, or count is invalid." in log file during export report to Libre Office.

FIX: Text lost aligment for FRTF output.

XFRX#DRAW

XFRX#TEXTFORMAT

ENH: Add support for <strong /> and <em /> for html.
FIX: Lost justify with XFRX#LISTENER.
FIX: Lost justify for short text between images/rectangles.

XFRX#PREVIEW

FIX: A white band overlaps the embeded toolbar.

XFRX version 17.3.0, Release notes

Release date: 20 November 2017

Enhancements and fixes

GENERAL

ENH: Support rotation settings for rectangle..
ENH: Automatic convert textbox/label to image (#UR TEXTTOIMAGE=<expression>)
FIX: If report has set "Left margin" great then zero, then all texts and objects shifted to left by value of "Left margin".
FIX: XFRX don't move objects to down in page footer band if XFRX remove objects which set "Print when expression" to .F. and "Remove line if blank" is checked too.
FIX: Outputs ignore trim mode 3 and 4.
FIX: Output contains double empty lines between paragraphs in long text for outputs - DOC, NATIVE_DOCX, ODT, ODS, XLS, XLSPLAIN, FODS, PFODS, NATIVE_FXLSX, NATIVE_PFXLSX.

ENH: Add support for attachments in PDF output.
ENH: Better support for indexed bitmaps for PDF output.
FIX: Long text has wrong line height, if textbox's height is greather then tesxt's height.
FIX: PDF output ignore all trim modes.

XFRX#INIT

FIX: XFRX don't ignore reports's record for DOS platform.
FIX: XFRX don't move objects under stretched object if overlapped by 1px.
FIX: If report contain rectangle from across a few report bands, then some rectangle not show (if band with bottom rectangle cause new page).
FIX: Sheet contains repeated group header (with using parameter SHEET_PER_NP_GROUP) for outputs XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX, FODS, PFODS.
FIX: Output file is not read able. (with using parameter SHEET_PER_NP_GROUP) for outputs NATIVE_FXLSX, NATIVE_PFXLSX, FODS, PFODS.
FIX: XFRX#INIT doesn't support private dataenvironment with VFP 5.
FIX: XFRX don't work correctly if report contains dataenvironment.

XFRX#LISTENER

FIX: If report contain rectangle from across a few report bands, then output are mismatch.
FIX: Shape has bad left position if set dynamic property for Width and set runtime extension's script for RENDER method.

XFRX#LISTENER + TF

FIX: If textbox has back opaque and check "Use default background color", then formated text not is in output.

PDF, XPS

FIX: Textbox with opaque background has height's colors higher by 2px.

FIX: Strikeout and uderline has black color always.

RTF, FRTF

FIX: Not possibly delete last character in textbox.
FIX: Rectangle which has border's default color has border's white color in output file.
FIX: RTF output ignore all trim modes.

FODS, PFODS

FIX: Unreadable output file if some number formated such as "scientific" and LibreOffice's version is 5.4.x.

FDOC, NATIVE_FDOCX, FODT

FIX: Randomly swapped text.

XFRX#DRAW

FIX: Method SavePicture() ignore parameter tnBpp.

XFRX#XML

ENH: XFRX#XML has same API such as XFRX#DRAW for custom drawing.

FDOC, FRTF, FODT, NATIVE_FDOCX

FIX: Output file contains only first column if report has check "Column order" to "Left to Right"

XLS, XLSPLAIN

FIX: A parameter LEAVE_FULL_FIELD_CONTENT don't works.

XFRX version 17.2.0, Release notes

Release date: 17 August 2017

Enhancements and fixes

GENERAL

ENH: RTF is now supported in Textformat . For more information please see the Textformat - RTF wiki page.
ENH: New output type CPLAIN.

Print, Preview, Images

ENH: <FJ> (full justify) is now supported.

ODT,FODT,ODS,FODS,PFODS, NATIVE_DOCX,NATIVE_FDOCX,NATIVE_FXLSX,NATIVE_PFXLSX

FIX: XFRX temporary folder is not deleted and contains a ghost folder. An error message "The directory is not empty." is logged in the XFRX log file.

XFRX#INIT

ENH: Page and column expression.
FIX: Horizontal line has wrong top position in all output formats if the top position is near the Summary band header in the report designer.
FIX: Long text in Page Header band can cause the "Too many variables" error.
FIX: (XLSPLAIN, PFODS, NATIVE_PFXLSX) If the output file has two pages, page footer is displayed twice.
FIX: (XLS, XLSPLAIN, FODS, PFODS, NATIVE_FXLSX, NATIVE_PFXLSX) Non-functional parameter SHEET_PER_NP_GROUP.

FIX: <FJ> doesn't work correctly if the text contains a space before the end of the line.
FIX: Empty string causes an infinity loop if a textbox has two or more lines and "Stretch with overflow" is unchecked.
FIX: The background color box for a label is narrower than the label text.

ENH: Add support for <FJ>.
FIX: Transparent WMF/EMF image shows as a black rectangle.
FIX: The background color box for a label is narrower than the label text.

XFRX#LISTENER

FIX: A long text in the summary band doesn't wrap to a new page.
FIX: XFRX ignores the PictureDPI property if set before the SetParams() method call.
FIX: All output formats ignore the set Print area "Whole page" option.

XFRX#TEXTFORMAT

FIX: If a paragraph contains a wrapped image then the alignment is wrong for right, center and block alignment options.

RTF, FRTF

FIX: Better RTF output when using the TE Edit Text control, Libre Office, etc.

XFRX version 17.1.0, Release notes

Release date: 22 May 2017

Enhancements and fixes

GENERAL

ENH: Rich text / textformat support. There are two formats currently supported: pseudo HTML and BB codes. For more information please see the textformat wiki page. You can also download examples from the textformat to screen package.
ENH: UTF-8 support. See the Experimental features - UTF-8 data wiki page for more details. This feature may not work properly in PDF and XPS.
FIX: XFRX does not work correctly if UNIQUE is set ON.

ENH: Empty signature field - #UR EMPTYSIGNATURE=expr. This allows for placing an empty signature field into the document. The expression evaluates to a unique name given to signature.
ENH: Reports can now be appended to password protected PDF files.

FIX: Hairline borders are invisible.

FIX: XFRX supports only hairline and solid border styles.
FIX: Hyperlinks ignore format settings (font, name, etc.)

FODS, PFODS

FIX: A border is rendered for all rectangles regardless the border definition.

FIX: Printer "EPSON TM-T70II Receipt" crops the paper after printing long receipts.

RTF, FRTF

FIX: Images can cause unreadable output files.

FDOC, FRTF, FODT, ODS, NATIVE_FDOCX

FIX: A cursor is left open in the current datasession.

ODT,FODT,ODS,FODS,PFODS

FIX: The output file is unreadable if the report contains a text with raster font and the font embedding is set on.

XLSPLAIN, PFODS, NATIVE_FXLSX + XFRX#INIT with transformation from XFF/XFRX#LISTENER

FIX: The output file doesn't contain group footer objects from the second page onwards.

XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX

FIX: Character "/" in #UR XLSF gets converted to a DATE MARK.

XFRX#LISTENER

FIX: The "Whole page" printer setting is ignored

XFRX version 17.0.0, Release notes

Release date: 21 February 2017

Enhancements and fixes

ENH: Added support for topdown bitmap, bitmap 2bpp, 4bpp RLE, 8bpp RLE, 16bpp, BMP OS/2, etc.
FIX: Wrong shape curvature calculations for curvature values between 1 and 98.
FIX: PDF output ignores "Clip contents" for bigger images.
FIX: PDF output doesn't support 16 bpp bmp file. The workarround is to use a third parameter (1 or 2) of QRBarcodeImage() method for foxbarcodeqr.
FIX: Right-aligned texts/labels have wrong left position.
FIX: Garbage text in the second line for texboxes with height greather than one line if the text has only one line.
FIX: An ellipsis is always appended to fields that have trim mode set to "Trim to nearest character, append ellipsis".

HTML

ENH: Output compatible with Gmail for HTML attachment - see to parameter GMAILCompatibility.
FIX: Wrong shape curvature calculations for curvature values between 10 and 45.

XFRX#INIT

ENH: Watermark trick support.
ENH: Support for multidetail bands/new detail band properties.
ENH: Support for Column print order - Left to right.
FIX: If a column overflows to a new column and the group has "Reprint group header on each page" ON, then xfrx does not render the group header.
FIX: The summary band top position is calculated incorrectly if the report has more than 1 column and the bottom position of the last column is less then the bottom position of the first column.
FIX: WITH-RETURN-ENDWITH bug, can cause cx00000005.

XFRX#PREVIEW

ENH: Added support for custom background color of searched text. See to property FindColor of Default settings.
ENH: Added support for calling the print option without calling "Printer options" dialog. See to Default settings and Printer default options.
ENH: Added "Current page" to printer options dialog.

XFRX#DIAGNOSIS

ENH: Add file name for dll/fll imported.
ENH: Add printer info.

XFRX_CopyToXLSX

FIX: OO/LO Calc can't open the output file, but MS Excel can.

NATIVE_FXLSX, NATIVE_PFXLSX, FODS, PFODS

FIX: Pagebreaks don't work if the page ends on an empty line.

XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX, ODS, FODS, PFODS

FIX: Pagebreaks don't work if the report contains a vertical line or a rectangle spanning from the page header to the page footer.

XFRX#LISTENER/XFRX#INIT with XFF/XML transform + XLSPLAIN, NATIVE_PFXLSX, PFODS

FIX: The output file has only the first page.

NATIVE_FDOCX

FIX: The page header is bigger than how it is defined in the report.

XFRX#INIT+FDOC,FRTF,FODT,NATIVE_FDOCX

FIX: If the report has more than one columns and the column print order is "Top to Bottom", than the output file contains only one column.

NATIVE_PFXLSX

FIX: Image higher than how it's defined in the report - on first page.
If the report contains external hyperlinks and no images, then the output file is unreadable.

NATIVE_FXLSX

FIX: Image smaller than how it's defined in the report if the report has more than one page.
If the report contains external hyperlinks and no images, then the output file is unreadable.

XFRX_COPYTOODS

FIX: Messagebox with "ZAP %file%" message when SET SAFATEY ON.

FODS,PFODS + VFP 5,6

FIX: Error message "Property is not found."

XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX, FODS, PFODS + VFP 5,6

FIX: Error message "Function argument value, type, or count is invalid."

ODS,FODS, PFODS + VFP 5,6,7,8

FIX: Format expression ignores spaces.

XFRX#LISTENER

FIX: Error message "Operator/operand type mismatch." when calling SetParams() method without parameters.
FIX: Vertical lines that start and finish in the same group are rendered separately for each band.

GDI+ Wordwrap

FIX: Potential Cx00000005 bug.
FIX: Random missing words at the end of right aligned fields.

GDI Wordwrap

FIX: Random missing words at the end of right aligned fields.

NATIVE_FXLSX, NATIVE_PFXLSX

FIX: Cells can intermittently have wrong background color.

FIX: Wrong shape curvature calculations for curvature values between 1 and 98.
FIX: Memory leak.
FIX: Unreadable file if source contains Chinese/Arabic/etc. characters.

PRINT,XFRX PREVIEW,Images

FIX: Wrong shape curvature calculations for curvature values between 1 and 98.

FRTF

FIX: Shape has bad curves for curvature values between 51 and 98 ( <=xfrx 16.0.x) or for values between 1 and 98 (<=xfrx 16.1.x).

FIX: Wrong shape curvature calculations for curvature values between 51 and 98.

FIX: If a textbox has a black foreground color, then the text can be white in the output file.
FIX: The output document contains the "?" character for Chinese code page.

XFRX#INIT+XLS/XLSPLAIN/FODS/PFODS/NATIVE_FXLSX/NATIVE_PFXLSX

FIX: If report has more the one column, than the output file contains only one column.

XFRX version 16.1.4, Release notes

Release date: 21 November 2016

Enhancements and fixes

XFRX#INIT

FIX: If the textbox source contains a semicolon syntax (such as field1;field2) and field1 is empty, then the output contains an empty first row.
FIX: XFRX doesn't restore the current work area?after processing reports?with data environment.
FIX: XFRX#INIT doesn't support DIB and BITMAP in OLE presentation record in general field.

FIX: Output?file is unreadable?if SetPassword() is called under VFP 5/6/7.
FIX: Text?not split to multiple lines for textboxes with height greater than one line and "Stretch with overflow" unchecked.
FIX: Error message "###ERROR: 9 in makestring2 16441,000000 Data type mismatch" if label or textbox has set "Repeat Value" set to "No".
FIX: TABs position calculation problems. The default TAB size in VFP is?four?spaces.
FIX: Incorrect top left position calculation for horizontal lines.

ODT,NATIVE_DOCX + DEMO

FIX: Error message 'Missing expression'.

FIX: label text too wide

XFRX_CopyToXLSX

FIX: Some characters (ASCII <=31)?cause the XLSX file generated with XFRX_CopyToXLSX to be unreadable.

DEMO forms

FIX: SET PATH TO problems in the Load() method.
FIX: Bugs?in PDF Library example.
FIX: Bugs?in Drill Down report example.

XFRX#LISTENER and?NATIVE_FXLSX,NATIVE_PFXLSX,FODS,PFODS

FIX: The preview looks good but all fields get exported as false.

XFRX Core + XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX

FIX: Currency code position calculation problem for numbers with currency.

?(XFRX#INIT + transform from XFF/XML or XFRX#LISTENER) + XLS/XLSPLAIN,FODS,PFODS,NATIVE_FXLSX, NATIVE_FXLSX, NATIVE_FDOCX

FIX: Layout issues when a report contains a textbox, a label or a vertical line in the page header/report title with bottom position outside the band height

XFRX version 16.1.2 & 16.1.3, Release notes

Release date: 3 September 2016

Enhancements and fixes

XFRX#INIT

FIX: Documents puts in Win8.x into general field has worse preview's image in output file.
FIX: Missing method getDocName().
Many errors in log file at reusing XFRX#INIT object.

XFRX#CORE

FIX: Only XFRX preview shows images. A error log contain message "12,00 in xfrx_getwmfsize @ 3957,00 Variable 'LCFILE' is not found".

ODT,NATIVE_DOCX + DEMO

FIX: Error message 'Missing expression'.

FIX: Text of label has greather witdh, in output file, than in report.

XFRX#LISTENER

FIX: xfrxlistener::Render() ignore return value from DODEFAULT().
FIX: If report master record don't contains keyword PAPERSIZE, then XFRX cause error "9 ? Data type mismatch.".
FIX: Error message "Alias 'THISS' is not found." in log file..
FIX: _reportlistener.vcx from SP 1, If xfrx is Successor or successor property sets on XFRX object than REPORT command failed.

DOCX,DOC2PDF

FIX: Output file contains fused first and second page, other pages are moved forward.

XFF#WRITER

FIX: Error 2032,00 fillbuffer 28944,00 Ambiguous date/datetime constant. Use the format: {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]}.
FIX: Calls method drawPicture() cause error message 'Variable "lcFile" is not found.'

XLS, XLSPLAIN

FIX: If I can change its data, but when I use the closer button, Excel does not ask if it should save the changes. Excel just closes the file and all changes are lost.

FDOC

FIX: XFRX change value of property ConfirmConversions, but don't set original value.

FIX: XFRX change value of property ConfirmConversions, but don't set original value.
FIX: + MS Word 2003; Images, restangles and lines can has bad left position.
FIX: Text of label has greather witdh, in output file, than in report.

NATIVE_DOCX

FIX: Text of label has greather witdh, in output file, than in report.

FIX: XFRX displays a dialog box before overwriting an existing file SET("SAFETY")="ON".
FIX: Text of label has greather witdh, in output file, than in report.

FIX: Print do not respect paper orientation for custom paper size.

XFRX#PREVIEW

FIX: Export dialog - It's no possibly select output type in czech or slovak localization.
FIX: Export dialog - XFRX preview change current area.
FIX: Find dialog - XFRX preview change current area.

XFRX_CopyToODS

FIX: Return value is -201 data source conatins number. "Debug output" contains message: #OOWRITER: Error 1734.000000 addtextincell 38313.000000 Property CNUMBERCLASS is not found.

XFRX version 16.1.1, Release notes

Release date: 11 August 2016

Enhancements and fixes

XLS,XLSPLAIN,FODS,PFODS, NATIVE_FXLSX, NATIVE_PFXLSX

FIX: Bad pagebreak if object was through more lines.

FIX: If textboxt has not check "Stretch overflow" and text is very long then text in PDF not is cutted.

XFRX#INIT

FIX: If some object has "Print repeat values" set to "Yes" and "Remove line if blank" is checked, then output contains chaos or much empty lines..

XFRX#LISTENER

FIX: Some characters from symbol font (CyberMetricsGDT) shows as square in all outputs.

FDOC,FRTF,FODT,NATIVE_FDOCX + XFRX#INIT with (XFF,XML) transformation/XFRX#LISTENER

FIX: A graphical objecst can has bad zOrder .

NATIVE_FDOCX

ENH: Supports more than 16 base colors for text back color.

OO Calc/Writer

FIX: Output file is unreadable if report contains some image with name which contains CHAR(150).

FODS, PFODS

FIX: Percent value is show bad for MS Excel percent format cell.

XFRX Preview

FIX: The implementation of 16.1 is going well except for a compile error on _STRTOFILE: Visual Class Library c:\vfp\projects\xfrxlib\xfrxlib.vcx has the following errors: Unknown _STRTOFILE - Undefined.
ENH: Add Append mode on export dialog in XFRX Preview.
ENH: Add output to ZIP archive on export dialog in XFRX Preview.

XFRX version 16.1, Release notes

Release date: 26 July 2016

Enhancements and fixes

ENH: Support for 128 bit RC4 was added.
ENH: Added option to define PDF version of the output file.
FIX: Images?with transparent background (WMF/EMF/PNG/TIFF) are now supported.
FIX: Text fields (label) are intermittently wrapped to two lines.?
FIX: Error message "Operator/operand type mismatch" if orginal PDF file has no trailer record.
FIX: Creation date is unreadable?if the file is encrypted.?
FIX: Error message in log file??"File 'mainhwnd.prg' does not exist." in method createid.
FIX: Error message in log file??"Operator/operand type mismatch." in?procedure _xf_screenhwnd.
FIX: The output file can?t be printed in duplex mode.?
FIX: If the document?property contain "?" character and the output file is encrypted, then the PDF viewer shows Chinese characters in the document properties dialog window.

XFRX#INIT

ENH: Added support for dynamic?styles from VFP 9.0.
ENH: Support for?images such as jpeg, gif, tiff, png ,emf, etc in general field ?- OLE host's "Package".

XFRX#LISTENER

ENH: Added Support for Microsoft.VFP.Reporting.Builder.AdvancedProperty???(HTML.Link, HTML.Anchor, HTML.Alt-Title)

Excel

ENH: #UR XLSF for date values is now supported
ENH: Add?support for native date/datetime

OO Calc

ENH: #UR XLSF?is now supported
ENH: Added?support of native date/datetime

FDOC

FIX: Intermittent wrong text styling.?

FIX: If method SplitDocument() is called and the tcArchive is filled via SetParams()method, then the output archive is always empty. When merging more reports the?split document feature is not functional.

XFRX#INIT?+ VFP 9.0 / XPS

FIX: XFRX?ignores "Trim mode for characters expression" for textboxes.??

ODT,FODT, ODS,FODS,PFODS

FIX: Doesn't support bold and italic for asian fonts.
FIX: Doesn't support asian fonts with localized?name.
FIX: When creating file for OO Writer or OO?Calc, the collate?gets changed to "MACHINE"

XFRX Previewer

FIX: Error message "Error in line 3402 of xfcont.isoverhyperlink (record 332): Command contains unrecognized phrase/keyword." when compiling xfrxlib.vcx under VFP 5/6/7.

Diagnosis

FIX: Error message 'Invalid path or filename'? if file utilityReportListener.prg? doesn't exists and SET("PROCEDURE") is not empty.

XFRX#LISTENER

FIX: XFRX#LISTENER doesn't support ListenerRef.NoRenderWhen.
FIX: Very slow processing for some output formats
FIX: All outputs are slightly moved to the right.?

XFRX_CopyToXLSX

FIX: If SET("MARK") is a string of zero length, then MS Excel does not show date/datetime values correctly.?

Print,Export to images?

FIX: Some text missing?for codepages 932, 936, 949, 950.

XFRX#LISTENER+ FDOC, FRTF, FODT, NATIVE_FDOCX, FODS

FIX: Text with dynamic style in report definition has bad style - by the first text ??in the output file.

FDOC,FRTF,FODT,NATIVE_FDOCX

FIX: Bad?zOrder of all graphical objects.?

NATIVE_FXLSX,NATIVE_PFXLSX

FIX: Strings are not shared (the strings are now stored more effectively resulting in smaller file size)

FODT,ODT

FIX: The output file doesn't contain objects from "Page header"/"Title" band if the report?contain "Page header"/"Title" band with zero height.

NATIVE_DOCX, NATIVE_FDOCX

FIX: The output files use the "Gulim" font for all asian languages.?

NATIVE_DOCX,NATIVE_FDOCX,NATIVE_FXLSX,NATIVE_PFXLSX

FIX: When creating file for OO Writer or OO?Calc, the collate?gets changed to "MACHINE"

NATIVE_FDOCX

FIX: Unreadable output file if the report contains a "Title" band with zero height.

XFRX#DRAW

FIX: Error message "Data type mismatch" in XFFWriter::CalculateSectionTopPosition() when converting XFF to the output taget.

XLS/XLSPLAIN

FIX: Bad formula in #UR XLSF?causes application freeze.

XFRX Core

FIX: Error when compiling xfrx.prg?with codepages 932, 936, 949, 950.?

RTF / FRTF

ENH: Appending generated output to existing RTF document.
FIX: Image has wrong wrapping style.?
FIX: WMF pictures are not correctly displayed from OpenOffice/LibreOffice.
FIX: Slow processing if report contains many pictures
FIX: Output file show mismatch characters?if report contains font with more font charset.
FIX: If a textbox/label overlaps an?image then the background colow of the textbox/label is set to black.
FIX: Tabs less than 0.13cm are allowed.
FIX: If the "Print area" is set to "Whole page" in Page setup then texts and objects?may not be visible.

XFRX version 16.0, Release notes

Release date: 23 February 2016

Enhancements and fixes

XFRX Core

Lost first string in the output file. The log file says: ###ERROR: 1229,00 in xfrx_x_trim_gdiplus Too few arguments.
_xfConvertImage() evaluates wrong transparent color for GIF images.
Layout fix - right-aligned labels are shifted to right.
XFRX ignores long #UR directive in the Comment field.
SetOtherParams() method ignores parameter PRINT_BOOKMARKS.
All output types: transparent rectangles fill patern not supported
XFRXWriter: Parameter tnAdjType is ignored.
Lost decimal values of report and page margins for SET POINT TO ",".
Layout differences between direct output and transformation via XFF/XML file.
Layout differences between XFRX#Init and XFRX#Listener output generation types
"MT Extra" font support
Detail section height calculation fixes
Error message "Unknown member OREPORT." in method addRectangle().
Enhanced diagnosis module
EMF: Error message "API call caused an exception" if picture parameter "BPP" =1 or tnBpp =1 in SavePicture() method.
VFP 5.0 + VFP 6.0: Error message "Function argument value, type, or count is invalid." in method convertxlsformatstring()
Only 0 and 1 MODE values are supported
Document properties generation for all output types
XFRX Listener mode: Error message Operator/operand type mismatch. in method XFRXListener::getpagewidth()

PDF/A levels 1a, 1b, 2a, 2b, 2u, 3a, 3b, 3u are now supported, signed PDF documents are supported for PDF/A level 1a and 1b
Fixed issues with current area selection
The underline/striked line is longer than the text for label.
All texts are converted to images if the user account is 'Standard user' (not admin).
All texts are converted to images under Citrix.
PDF/A issues with special characters
If both normal and bold style is used for the same font, the bold style is displayed as normal
#UR INCLUDEFONT may be intermittently dropped
GIF (87a) support
ID attribute in the trailer section is not a valid MD5 hash.
It is not possible to find or copy text if font is "Dausch" or other symbol font.

Excel and ODS

SHEETPAGEBREAK is ignored for SET("DECI") < 3
When merging multiple reports, the second and next reports don't generate headers/footers
If screen DPI is set to 125% and higher, then column width and height are smaller then objects in the report.
Large report generation speedup.
VFP 5.0-7.0: Error message "LOOBJX is not an object." in method RenderPage
Enhanced codepage/fonts support
external hyperlink support
Unreadable output file if document title contain "&".
If the source of s textbox is empty then the output file contains an empty line.

HTML/MHT

Opera, FireFox and Safari shows characters instead of symbols for symbol font.
Missing closing "a" elements on every page.
Doesn't supports curved rectangles.
Missing closing "div" element on the last page.
FireFox shows texts with "Arial Black" or "Arial Narrow" fonts as blank.
"fj" (full justify flag) works in IE but not in Opera, Firefox or Chrome.
The HTML viewer does not show images if the file name contains the "#" character.

DOC, DOCX, Native Word

Lost multispaces in text with right or center alignment.
Shifted text if first TAB is on zero position.
Layout issues if screen DPI is set to 125% or higher
When merging multiple reports, if the first report has page header/footer and the second report doesn't, then the headers from the 1st report are also displayed for the 2nd report.
VFP 5.0+6.0: not enough memory issues
external hyperlink support
Unreadable output file if document title contain "&".

Lost right and center label alignment.
Rotated text with transparent background has white background.
Layout issues when the text contains TABs.
Each single row text has CR

OpenOffice

Label size is short then text size.
Full justify flag is ignored in new OpenOffice versions
if LEAVE_FULL_FIELD_CONTENT is on, the cells show longer text than size of cell.
Error message "Code page number is invalid." in method addtextincell.
Enhanced Courier font support
output generation speedup
Error message "invalid range" after click to textbox with hyperlink to another sheet.

XFRX Previewer

The mouse pointer for hyperlink is highlighted on bad position if text rotated.
Fixed layout issues with when the screen DPI is set to 150% and higher

XFRX version 15.7.5, Release notes

Release date: 12 November 2015

Enhancements and fixes

FIX: underline/strike line too long
FIX: text converts to images for non-admin users and on citrix servers
FIX: if both normal and bold font styles are used for the same font, the bold style is converted to normal

Excel and ODS

FIX: empty text fields intermittently generate blank lines in the output sheet

XFRX Core

FIX: RTL (right-to-left) flag was ignored

XFRX version 15.7, Release notes

Release date: 6 October 2015

Enhancements and fixes

FIX: #UR COLOR and #UR MASK are ignored when using XFRX#LISTENER or transform report from XFF.
FIX: If a text field has a transparent background and the text is converted to an image, the background is white in the PDF output
FIX: Mouse pointer for hyperlink is highlight in a wrong place for rotated text fields.
FIX: Acrobat Reader shows no text or wouldn't print if certain characters are used
FIX: Text based on the "Courier New" font, or another monospaced font, does not contains spaces between words or the spaces have wrong width.
FIX: Text displayed with symbol fonts may not visible in pdf/xps
FIX: When using XFRX#LISTENER or XFRX#INIT the output file is always in UNICODE. The pdf file is bigger then output file from XFRX 15.5, because all fonts are included. It's equal to: loSession.SetOtherParams("UNICODE",.T.)

XFF, XML

FIX: XFRX loses information about #UR INCLUDEFONT or #UR INCLUDEFONT SUBSET during the XFF/XML transformation

PDFL

FIX: createDocument() method calls cause "Function argument value, type, or count is invalid." error

Word

FIX: Reversed red and green colors in text-to-image conversion
FIX: NATIVE_FDOC: Lines, shapes and images are positioned in front of the text.

Excel and ODS

FIX: Mismatch rows in output file for report with groups
FIX: Output sheets do not contain pagebreaks. (To enable set parameter SHEETPAGEBREAK to .T. )
FIX: NATIVE_FXLSX: The output file is always set to papersizeindex=9.
FIX: The output file does not contain the page setup definition for print area and fit to width options.

HTML

FIX: IE shows character "?" instead " " for the FoxPrint font.
FIX: Lost font information when StrikeThru style is applied

XFRX Core

ENH: hyperlink for images. #UR A NAME, #UR A HREF directives in images definitions are now supported in the following output types: PDF, HTML/MHT, DOC, FDOC, RTF, FRTF, XLS/XLSPLAIN, XPS
ENH: pagebreaks support in FDOS/PFODS, XLS/XLSPLAIN and NATIVE_FXLSX/NATIVE_PFXLSX. See more at https://eqeuscom.atlassian.net/wiki/display/DOC/Excel+specific+features#Excelspecificfeatures-Addpagebreakinsheet
ENH: automatic print area preset for FDOS/PFODS, XLS/XLSPLAIN and NATIVE_FXLSX/NATIVE_PFXLSX output types
FIX: #UR A HREF doesn't support external hyperlinks in RTF,FRTF,XPS,XLS,XLSPLAIN

XFRX version 15.6, Release notes

Release date: 19 Aug 2015

Enhancements and fixes

ENH: Enhanced unicode support. Search, print and copy is now supported in unicode PDF documents.
ENH: Enhanced barcode font support
ENH: Automatic symbol font detection
ENH: Automatic truetype/postscript/opentype font detection
FIX: Corrupted PDF if SET NULL is ON
FIX: Lost italic for some fonts under XP/WV/W7/W8
FIX: PDF/A compatibility FIX

XFRX Core

FIX: convertXLSFormatString() method doesn't correctly handle number formats when exporting to Excel.

XFRX previewer

FIX: "Go to page" dialog shows decimal value in the spinner

Native Word export

FIX: Unreadable output file in MS Word 2003/2007.
FIX: Page footer too high in the flow layout output

Excel, XLSPlain, NATIVE_FXLSX, NATIVE_PFXLSX

FIX: currency type values produce empty cells
FIX: lost 1st row on each page if page header and title have zero height
FIX: NEXT_SHEET_NAME_EXPR parameter ignored
FIX: intermittent detail vs. header mismatch
FIX: intermittent wrong vertical alignment

XFRX version 15.5, Release notes

Release date: 22 Jun 2015

Enhancements and fixes

XFRX Core

User scripts: new keywords - TRANSPARENT (transparent flag), BPP (bit per pixel) and JPEGQ (jpeg quality)
Export to pictures: new parameter - TRANSPARENT
Enhanced layout control for #UR POSITIONABSOLUTE fields
New property lHidePictureOutsideBand to included pictures outside bands. (By default, pictures outside bands are excluded)
Enhanced VFP5 support
FIX: Errors when compiling XFRX in VFP 6.0
FIX: Alias 'XD0G6XO8' is not found in the Finalize() method.
FIX: m-dot error fix in the native docx/xlsx exports
FIX: the PARAMETERS keyword is ignored if the custom script is not converted to image.
FIX: XFRX does not declare API functions with unique aliases.
FIX: "Function argument value, type, or count is invalid." error in _XF_HANDLEMESSAGE()
FIX: Image processing - "scale content" flag is ignored.

HTML

new parameter CONVERTEMF_TIFFTOPNG to EMF/TIFF to PNG

XFRX previewer

Slovak localization
FIX: error when sizing the previewer too small
FIX: cannot prevent focus to previewer form if the form is disabled
FIX: MouseWheel event outside the previewer window still scroll the content
FIX: Preview or export to picture shows text with background only with postscript font.
FIX: intermittent error "Function argument value, type or count is invalid"

XPS, RTF, FRTF, XLS, XLSPlain

Added hyperlink support (#UR A HREF and #UR A NAME.)

NATIVE_FXLSX, NATIVE_PFXLSX

FIX: #UR POSITIONABSOLUTE is now supported
FIX: intermittent error when opening the generated file in Excel
FIX: LEAVE_FULL_FIELD_CONTENT parameter is ignored.
FIX: no output when SET NULL is OFF

FODS, PFODS

FIX: LEAVE_FULL_FIELD_CONTENT parameter is ignored.

FIX: GIF image with white transparent color has black background in PDF output.
FIX: temporary files intermittently not deleted after export

Native printing

XFFWriter::printDocument() - you can now define the file name for virtual printers

XFRX version 15.4, Release notes

Release date: 15 Apr 2015

Enhancements and fixes

XFRX Core

Enhanced report listener chaining
Enhanced support for GIFs with transparent colors
Proper code page handling when large text objects wrap to a new page
Proper line height calculation in flow layout output types
Automatic file name extensions added in lowercase
Enhanced codepage detection for resoid in (0,1,2) in VFP 9.0
nProgressType support added
Font initialization optimized
"Clip content" support added
SET SAFETY ON fix
Enhanced output layout calculation

XFRX_CopyToXLSX

Named areas generation fixed

XFRX previewer

Cleaner rendering
Cross-object links
VFP 5.0 compatibility fixes
Zoom by holding Ctrl and scrolling
Multi-tab previewer - last tab activation fix
TopLevel forms support

Enhanced support for images with DPI greater than 255

NATIVE_DOCX, NATIVE_FDOCX

Excel output type

Export numeric values as numbers
Corrupted output with empty date/datetime values fixed
Image rotation
Text rotation
Rectangle background recognition fix
Proper display of objects with top=0

Enhanced support for 32-bit images
FoxPrint.ttf font support fixed
Signed PDF intermittent problems fixed
Postscript font support
BC3of9 barcode font support
Symbol font support

Native printing

Respect user defined page size

XFRX version 15.3, Release notes

Release date: 21 Jan 2015

Enhancements and fixes

XFRX Core

Intermittent image rendering problems
Better environment cleanup
Onscreen command results
BIGREPORT parameter (see https://eqeuscom.atlassian.net/wiki/display/DOC/Output+Types)
EMF output type
Better band height calculation

XFRX_COPYTOODS enhancements

25% faster
smaller output size
fewer cell styles

XFRX_CopyToXLSX

Faster
New parameter lcSheetExpressionGroup for automatic sheet split by expression

XFRX previewer

Hyperlink highlighting didn't work for textboxes with background color or non-default zoom
Blank hyperlink problems
Enhanced zooming

Postscript-only font support

NATIVE_DOCX, NATIVE_FDOCX

removing \0 from text fields
TransformReport does not support headers/footers
Intermittent <TJ> directive problems

NATIVE_FXLSX, NATIVE_PFXLSX, FDOC, FRTF, FDOS, NATIVE_FDOCX

removing \0 from text fields
-1 error code handling
TransformReport does not support headers/footers
Reactangle with BackColor and FillStyle=None show background color (which is wrong)

Text justify rendering problems
Enhanced unicode support
Better codepage handling
Memory leak in font handling
Problems with multiple hyperlinks linking to a single location
Enhanced VFP 5.0 compatibility
Non-transparent text field rotation fix
Preliminary UTF-8 support

RTF, FRTF

added support for other picture format such as PNG, GIF, TIFF
Transparent text placed over a shape has white background.
Faster image handling
Fixes in the cleanup procedure

XFRX versions 15.2, Release notes

New features

New output type: Data export to XLSX and ODS
This new feature allows for exporting table/cursor data into Excel or OpenOffice spreadsheets, similarly to the COPY TO ? TYPE XL5 command, with the following enhancements:
- The number of records is not limited to 65K. The current Excel limit is 1,048,576 rows per sheet. If the number of exported rows is larger, the output goes into multiple sheets.
- The generated file can be up to 2GB in size
- Formatting options, including dynamic (conditional) formatting, column width, header names and styles and text trimming
Please see details and code samples in our documentation wiki at https://eqeuscom.atlassian.net/wiki/display/DOC/Data+export+to+XLSX+and+ODS

FIXs fixed

XFRX Core

Incorrect codepage converted from blank resoid.
All outputs (except DOC, HTML, PDF) ignore #UR ROTATE for images
BIG report (cca 4000) pages - output do not contains images or other objects. Log file contain error message: 1190 - File "name" is too large. To workaround this, you have the following options:
- Reduce image size
- Run "SET BLOCKSIZE TO 0" before instantiating the XFRX object
- Use other params "BIGREPORT" (call loXFRX.SetOtherParams("BIGREPORT",.T.) )
ProcessReport method to always use SET EXACT OFF.
Images display as "scale contents, fill frame" instead "scale contents, retain shape" for source type "Image file name".

XFRX previewer

Error messages "Unknown _XFVFPVERSION - Undefined", "Unknown _XFPRINTERPROPERTIES - Undefined" when compiling project that include xfrxlib.vcx
Print dialog freezing on 64-bit OS

XPS documents do not show symbols.
XPS incorrect rendering of images with DPI <> 96.

NATIVE_DOCX, NATIVE_FDOCX

Wrong textbox frame width for multiline report label.
Missing or redundant page header/footer

NATIVE_FXLSX, NATIVE_PFXLSX

Centered alignment rendered as a right one.
Wrong rectangle colors.
NEXT_SHEET_NAME/NEXT_SHEET_NAME_EXPR parameters not respected

Unreadable PDF from XFRX under VFP 5.0-7.0
italics style lost for some fonts under XP/WV/W7/W8
PDFs with chinese/japanese texts (uses UNICODE) are not searchable.

FDOC, FRTF, FDOS, NATIVE_FDOCX

Wrong multiline text generation.

XLS, XLSPLAIN

Intermittent missing images.

Open office

Text in cells and textboxs doesn't show StrikeThru.

XFRX versions 15.1, Release notes

Release date: 5 Sep 2014

New features

New output type: Native Excel (xlsx) output

The Excel application is not required and does not need to be installed to generate the documents. There are currently two output options: NATIVE_FXLSX and NATIVE_PFXLSX (plain layout). NATIVE_PFXLSX, the plain layout, usually provides the best layout results, minimizing the number of rows and columns in the output document, but the layout may not be up to the pixel exactly the same as the source report. NATIVE_FXLSX generates more accurate layout but the resulting number of columns and rows may be higher.
New output types: DOC2PDF and FDOC2PDF - saves the output to DOC and then exports to PDF via Word. Word 2007 or newer is required
Experimental support of multi detail bands in VFP 8.0. Can be switched on with loSession.lMultiDetailBehavior=.T.
Enhanced support for Asian languages throughout the system
Font embedding support for all Word output types
FROM, TO, BPP, JPEGQUALITY, THUMBNAILWIDTH, THUMBNAILHEIGHT, PAGESPERSHEET, ALLEVENODD parameters are now accessible via SetOtherParams()

FIXs fixed

PDF output type

Enhanced font support on Windows 7/8 - platform specific encoding
Crashing on fonts with missing locations table
Better support for font embedding, especially symbol/barcode fonts
Enhanced support of fonts with no unicode encoding
Lines rendering precision enhanced
PDF file trailer inconsistency fixed
Enhanced support for Japanese characters
Better support of RESOID/FontCharset/Codepage

Pictures/OLE bound now fully supported (Clip Contents, Scale- retain, Scale-fill)
Correct size evaluation for png/gif/tiff/emf image formats
Freezing in 64-bit OS's fixed
WITH RETURN ENDWITH FIX fixed
m dot FIXs fixed
Fatal error when sending an empty or non-existent printer name
Printer properties freezing problem fixed
Temporary images were incorrectly saved in the current folder
Rectangle backcolor fix for open office and native word output
Fixes to support SET EXACT ON setting
Fixed problems with overlapping multiline textboxes generation
Excel output: SHEET_PER_PAGE flag was not working in VFP 9.0
Native Word output: added setAuthor(), setTitle(), setSubject(), setKeywords(), setComments(), setCategory(), setManager(), setCompany() and Custom Properties
Native Word output: images in headers/footers support
Office 2007: enhanced Arabic and Hebrew font support
DOC and FDOC output types - layout enhancements, Word 2007 compatibility, metadata generation
Enhanced internal diagnositics

XFRX versions 15.0, Release notes

Release date: 18 Mar 2014

New features

New output type: Plain HTML output

This output type works in a similar fashion to the plain excel output type: The objects on the page are aligned into a grid, each object going into a separate cell, and then the output is layed out as a table. Lines and rectangles are displayed as table cell borders. Fonts, colors and sizes are defined via CSS.

This solution produces a clean, fast rendering, cross-browser compatible HTML output, suitable for web pages or emails. (Click here for a sample document: Sample1)

The output is invoked by "HTMLPLAIN" output type parameter:
```
loSession = xfrx("XFRX#INIT")
lnRetVal = loSession.SetParams("output.html",,,,,,"HTMLPLAIN")
If lnRetVal = 0
    loSession.ProcessReport("report1")
    loSession.finalize()
Endif 
```
By default, the output is a complete self-contained HTML file. You can also use the HTML_NOSTYLES option to process just the inner HTML, without CSS styles, head or body tags:
```
loSession = xfrx("XFRX#INIT")
lnRetVal = loSession.SetParams("output.html",,,,,,"HTMLPLAIN")
If lnRetVal = 0
    loSession.SetOtherParams("HTML_NOSTYLES", .T.)
    loSession.ProcessReport("report1")
    loSession.finalize()
Endif 
```
Notes:
- This feature requires .NET framework 3.5. The HTML is produced by a .NET console application which reads XML files generated by XFRX and coverts them. This console application (xfrxt.exe) needs to be distributed along with the application.
- This output type currenty does not support images

FIXs fixed

Better (more precise) output for multiline labels/textboxes
Output directory write permission check
DOCX - codepage problems, backcolor problems
DOCX - text rotation
DOCX - speed enhancement
DOCX, OpenOffice - intermittent page number fix
DOC - crossover tags
Enhanced codepage conversion
Enhanced support if asian codepages in OpenOffice and DOCX
PDF - fixed problems with displaying Arial Narrow and Arial Black fonts
Listener mode - db area number preservation fix
XFRX Previewer - "mdot" FIX fixed
HTML output - font family name FIX
OpenOffice - image rotation
OpenOffice - hyperlink FIX

XFRX versions 14.7, Release notes

Release date: 30 Nov 2013

New features

New output type: Native Word (docx) output - the Word application is not required and does not need to be installed to generate the documents

The new output type can generate Word documents in docx (OpenXML) format both in the standard and flow layout. The generated documents are equivalent to the standard word documents generated by XFRX and can be opened in Word versions 2003 (with a plugin), 2007 and newer. The output type codes are "NATIVE_DOCX" (standard) and "NATIVE_FDOCX" (flow layout).

Overview:

Output type code	Standard layout	Flow layout	Output format	Word version needed to generate	Word version needed to view
DOC	yes	no	DOC	2000+	2000+
FDOC	no	yes	DOC	2000+	2000+
NATIVE_DOCX	yes	no	DOCX	none	2003+
NATIVE_FDOCX	no	yes	DOCX	none	2003+

Usage:

All you need to do is to specify NATIVE_DOCX or NATIVE_FDOCX. This is a pure VFP implementation so no other setup is needed, except MD5.FLL library MD5.FLL, which is a free library implementing the MD5 algorithm. MD5.FLL was written by Duke Lotherington, Visual Records Consulting, 3944 Murphy Canyon Rd, San Diego CA 92123, duke@visualrecords.com (http://www.leafe.com/dls/vfp)

Pre VFP-9 mode:


loSession= xfrx("XFRX#INIT")
lnRetVal = loSession.SetParams("output.docx",,,,,,"NATIVE_FDOCX")
If lnRetVal = 0
    loSession.ProcessReport("report1")
    loSession.finalize()
Endif

VFP-9 mode:


loxfrx = XFRX("XFRX#LISTENER")
lnRetval = loxfrx.SetParams("output.docx",,,,,,"NATIVE_FDOCX")
IF lnRetval = 0
    REPORT FORM report1 OBJECT loxfrx
endif

FIXs fixed

XFRX diagnosis module does not require FOXTOOLS.FLL in compile time any more
XML output type now includes the code page defined in SetParams
Pictures rotation is now supported DOCX output. We will be adding this to other output types (where doable)
FIXED: Open office output type does not include the correct code page in listener mode
FIXED: Report previewer: unpaired Lockscreen = .T. / .F.

XFRX versions 14.6, Release notes

Release date: 4 Nov 2013

New features

XFRX Diagnosis

Running XFRX with the following parameters:
```
DO xfrx WITH "XFRX#DIAGNOSIS", "DIAGNOSIS.TXT"
```
Will create a new file specified by the 2nd parameter (DIAGNOSIS.TXT), which is useful when dealing with setup problems. It lists the version number, registration string, vcx, dll and fll file version and locations and other information. Please review this file when dealing with setup problems and also please send it to us attached to support questions.
New output types - "DOCX" and "FDOCX"

The new output types run the standard (DOCX) or flow layout (FDOCX) conversion and generate word documents with the DOCX extension (the OpenXML format). This output type requires Word 2007 or newer to be installed on the computer. (until the next XFRX release ... at least ;)

FIXs fixed

Word standard and flow layout output
- Intermittent freezing of Word 2007 when previewing a document generated by XFRX
- Textbox height calculation fix - this was a Word 2010-only specific fix
- Exporting to DOC format using Word 2010 or 2013 will save the document as a DOCX document. Unfortunately this was the only way to solve the intermittent Word 2010 freezing, caused by changes in the HTML output support in these versions.
PDF output
- Additional enhancements to 32bit images rendering
- Enhanced support for Bold, Italic and Bold/Italic font styles when used with non-Latin1 character sets
HTML output
- Output to HTML in VFP 9.0 going via XFF file or XFRX previewer displayed the page footer over the bottom of the detail output. This problem has been fixed.
XFRX Print and Previewer Modules
- Fixing duplicate constant compile error
- Fixed intermittent freezing of the printer properties dialog box
Open office output
- proper attributes encoding and code page setting
- better environment cleanup method
- layout enhancements - textbox background and transparency settings, rotation

XFRX versions 14.5, Release notes

Release date: 12 May 2013

New features

Better barcode support: new PDF output directive - #UR SYMBOLFONT

Put "#UR SYMBOLFONT" into the comment of the report field that contains the barcode. This will instruct the engine not to do any codepage conversions and flag the font as a symbol font in the PDF document.

FIXs fixed

PDF output
- 32bit images are now rendering properly
- document properties longer than 255 characters are now supported
- Fixed errors in digitally signed documents on certain computers
XFRX Draw engine
- Creating new XFF document is not complaining about exclusive access any more
XFRX Previewer
- Intermittent error on mouse-wheel click is fixed
Reporting engine - affects all output types
- FIXs fixed in 'Stretch relative to tallest object in group'
- Memory leak in hndlib.dll fixed (Many thanks to Borislav Borissov and Martina Jindrova for tracking this down). This error was causing various intermittent layout or structure errors in the generated documents, especially in long documents or when a large amount of documents were created at a time

XFRX versions 14.4, Release notes

Release date: 11 September 2012

New features

New output type: Excel plain format (XLSPLAIN)

The Excel plain output format is an alternative output to Excel that aims to provide cleaner as well as smaller Excel documents. The following are the key differences from the standard Excel output:
- Each report is generated as a single sheet with a single page header at the top of the document and a single page footer at the very bottom. The header/footer sections are not inserted inside the report where the pages would normally break.
- The process eliminates empty columns and rows whenever possible.
- The report layout is automatically adjusted to eliminate narrow rows and columns.
- HORIZONTAL_ADJUSTMENT and VERTICAL_ADJUSTMENT are no longer needed. The system analyzes the report layout on the fly and identifies the places where objects can be aligned without affecting the final output.
To invoke the Excel plain format, send "XLSPLAIN" string as the output type parameter. Example (VFP 9.0):
```
 LOCAL loObj
 loObj = EVALUATE([XFRX("XFRX#LISTENER")])
 lnRetVal = loObj.SetParams("test.xls",,,,,,"XLSPLAIN")
 IF lnRetVal = 0
  REPORT FORM demoreps\invoices object loObj  
 ENDIF
     
```

New previewer extension handler: BeforeExport

A new extension handler trigger was added: BeforeExport. The method is executed right before the report is exported to the output format and can be used to parametrize the xfrx session object before exporting. Please see more about extension handlers in chapter Registering an extension handler inside the Common methods and properties chapter at http://www.eqeus.com/files/XFRXDevGuide.htm#_Toc326496250.

Example:

use demoreps\invoices order customer
local loSession, lnRetval, loXFF, loPreview, loScripts
loSession=EVALUATE([xfrx("XFRX#LISTENER")])
lnRetVal = loSession.SetParams(,,,,,,"XFF") && no name = just in memory
If lnRetVal = 0
 REPORT FORM demoreps\invoices object loSession  
 *
 * the XFRX#DRAW object reference is stored in oxfDocument property
 *
 loXFF = loSession.oxfDocument
 *
 * initialize the previewer 
 *
 SET PATH TO xfrxlib
 SET CLASSLIB TO xfrxlib ADDITIVE 
 loPreview = CREATEOBJECT("frmMPPreviewer")
 *
 * setup the extension handler
 *
 loPreview.oExtensionHandler = CREATEOBJECT("SampleExtensionHandler")
 loPreview.windowtype = 1 
 loPreview.iTool = 2 && embedded toolbar
 loPreview.PreviewXFF(loXFF)
 loPreview.show(1)
ENDIF

DEFINE CLASS SampleExtensionHandler as Custom

 PROCEDURE BeforeExport
 LPARAMETERS toSession, toExportParameters

 toSession.setAuthor("Martin") && set the document author property
 IF toExportParameters.cTarget = "XLS" && (XLS or XLSPLAIN)
  toSession.SetOtherParams("DISPLAY_GRID_LINES",.F.) && do not display gridlines in excel
 ENDIF 

ENDDEFINE

FIXs fixed

Excel output type (XLS)
- Enhanced footer rendering. The system now eliminates vertical gaps between bottom of the page and the page footer
- 'pos' already exists warning message removed

XFRX versions 14.3, Release notes

Release date: 3 June 2012

New features and FIX fixes

PDF output
- Font glyphs extraction algorithm has been improved, the size of PDF files with embedded font subset is now significantly smaller
- Date/time metadata now includes the current time zone
- Word-wrapping algorithm issue fixed in VFP 5
- PDF/A is now supported
  PDF/A is an ISO standard for the digital preservation of electronic documents. PDF/A document is a PDF document with specific restrictions that ensure that the document will always display and print exactly the same way, no matter which platform or document viewer is used:
  - Platform independent
  - No hidden or transparent content
  - All information needed to display the document is embedded (including fonts)
  - Document metadata stored as XML
  - No encryption, no password protection
  - No JavaScript or other executable parts
  - No LZW compression
  - Displayed and printed content must match (all annotations must be printed)
  There are currently two PDF/A specifications:
  - PDF/A-1 from 2005
  - PDF/A-2 from 2011
  XFRX currently supports specification PDF/A-1 Level ?B? (PDF/A-1b).
  
  Note: Please note the PDF/A-enabled document files can be significantly larger than regular PDF documents because the used fonts must always be included.
  
  To generate a PDF/A document, call SetPDFA(.T.) method on the session object before processing. This method is available in VFP8 and VFP9 session objects, as well as the XFRX#DRAW object.
  
  Example (VFP 9.0):
```
LOCAL loObj
loObj = EVALUATE([XFRX("XFRX#LISTENER")])
lnRetVal = loObj.SetParams("pdfa9.pdf",,,,,,"PDF")
IF lnRetVal = 0
 loObj.setpdfa(.T.)
 REPORT FORM demoreps\invoices object loObj  
ENDIF
    
```

XFRX versions 14.2, Release notes

Release date: 26 September 2011

New features and FIX fixes

PDF output
- Bookmarks and document properties are now encoded in unicode, allowing non-Latin 1 characters to be correctly displayed. The text is converted using the default code page or the code page specified in the 4th parameter of the SetParams method (tcCodePage)
- PDF file size issue fixed - images in the PDF file were saved in BMP format in some scenarios, which was increasing the file size significantly
- Improved compatibility in appending to existing PDF files
- Vertical lines rendering problem fixed - in some scenarios vertical lines showed slanted in the PDF output.
- Occasional layout issues fixed - word-wrapping algorithm improved
Excel output - the compatibility check window is now always suppressed
OpenOffice output types - significant layout improvements in all output types
- Multiline export layout fix
- Transparent background is now correctly rendered
- field content overflowing boundary box problem fixed
- Flowmode now respects text horizontal shift within one line
XFRX previewer - intermittent crashing on mouse middle-click fixed
XFRX previewer - local variable declaration fixes
XFRX previewer - current area reset fix

XFRX versions 14.1, Release notes

Release date: 6 December 2010

Office 2010 compatibility notes fixes

Word 2010 - fixed the problem with missing pictures
Intermittent Excel 2010 freezing fixed
Issues with picture frames in flow layout word output fixed
"Cannot load Word or Excel application" error message - please be aware XFRX does not support Office 2010 running in "Click to run" setup mode.
More info at: http://xfrx.blogspot.com/2010/12/office-2010-and-click-to-run.html

XFRX versions 14.0, Release notes

Release date: 19 July 2010

New features

Digital signatures in PDF

The digital signature can be used to validate the document content and the identity of the signer. (You can find more at http://en.wikipedia.org/wiki/Digital_signature). XFRX implements the "MDP (modification detection and prevention) signature" based on the PDF specification version 1.7, published in November 2006.

The signing algorithm in XFRX computes the encrypted document digest and places it, together with the user certificate, into the PDF document. When the PDF document is opened, the Adobe Acrobat (Reader) validates the digest to make sure the document has not been changed since it was signed. It also checks to see if the certificate is a trusted one and complains if it is not. The signature dictionary inside PDF can also contain additional information and user rights - see below.

At this moment XFRX supports invisible signatures only (Acrobat will show the signature information, but there is no visual element on the document itself linking to the digital signature). We will support visible signatures in future versions.

In the current version, XFRX is using the CMS/PKCS #7 detached messages signature algorithm in the .net framework to calculate the digest - which means the .NET framework 2.0 or newer is required. The actual process is run via an external exe - "xfrx.sign.net.exe", that is executed during the report conversion process. In future, we can alternatively use the OpenSSL library instead.

How to invoke the digital signing

(Note: the syntax is the same for VFP 9.0 and pre-VFP 9.0 calling methods)

To generate a signed PDF document, call the DigitalSignature method before calling SetParams. The DigitalSignature method has 7 parameter:

cSignatureFile

The .pfx file. pfx, the "Personal Information Exchange File". This file contains the public certificate and (password protected) private key. You get this file from a certificate authority or you can generate your own for testing, which for example, OpenSSL (http://www.slproweb.com/products/Win32OpenSSL.html). XFRX comes with a sample pfx that you can use for testing.

cPassword

The password protecting the private key stored in the .pfx file

nAccessPermissions

per PDF specification:
1 - No changes to the document are permitted; any change to the document invalidates the signature.
2 - Permitted changes are filling in forms, instantiating page templates, and signing; other changes invalidate the signature. (this is the default value)
3 - Permitted changes are the same as for 2, as well as annotation creation, deletion and modification; other changes invalidate the signature.

cSignatureName

per PDF specification: The name of the person or authority signing the document. This value should be used only when it is not possible to extract the name from the signature; for example, from the certificate of the signer.

cSignatureContactInfo

per PDF specification: Information provided by the signer to enable a recipient to contact the signer to verify the signature; for example, a phone number.

cSignatureLocation

per PDF specification: The CPU host name or physical location of the signing.

cSignatureReason

per PDF specification: The reason for the signing, such as ( I agree ... ).

Demo

The demo application that is bundled with the package (demo.scx/demo9.scx) contains a testing self-signed certificate file (TestEqeus.pfx) and a sample that creates a signed PDF using the pfx. Please note Acrobat will confirm the file has not changed since it was signed, but it will complaing the certificate is not trusted - you would either need to add the certificate as a trusted one or you would need to use a real certificate from a certification authority (such as VeriSign).

Feedback

Your feedback is very important for us. Please let us if you find this feature useful and what features you're missing.

XFRX versions 12.9, Release notes

Release date: 15 June 2010

FIXs fixed

PDF output - multiline text rendering - center and right-aligned text is now rendered properly
PDF output - specific BMP picture subformats (32 bpp and others) were rendering as a black box. This problem has been fixed.
VFP 9 listener mode - Render method now properly calls the chained report listeners' methods
The proper field codepage is now stored in the XFRX intermediate file
High resolution pictures now render and print properly
"@L" picture format is now working correctly in all VFP versions
Warning about "page" index overwrite is removed
Warning about "pos" index overwrite is removed
The correct background color wasn't displaying for fields marked as opaque using a dynamic condition
"#UR OUTLINE" and "#UR TOOLTIP" now support numeric values
XFRX previewer - an error was showing when no data were loaded
XFRX previewer - email icon tooltip fixed
XFRX previewer - intermittent crashing was fixed [negative window handlers]
XFF Printing - enhanced custom paper-size handling
XFF Printing - paper orientation problems fixed

XFRX versions 12.8, Release notes

Release date: 22 November 2009

New features / Updates

XFRX previewer - file selection button ([...]) has been added to the export options form
XFRX previewer - new properties for default values for zoom, pages-per-sheet, default output name and a starting page:
A new object-type property has been added to the XFCont, cntXFRXMultipage and frmMPPreviewer classes: oDisplayDefaults. It has the following properties:
- StartingPage (integer) - the 1st page to show in the previewer. Default value is 1.
- DefaultOutputFileName (string) - the default output file name when exporting from the previewer
- PagesPerSheet (string) - encoded pages per sheet layout value. Default value: 1x1. Allowed values: 1x1, 2x1, 2x2, 3x1, 3x2, 4x2.
- ZoomFactor (integer) - the zoom factor. default value = 100. -1 = fit to width, -2 = fit page. The zoom factor will be used only of PagesPerSheet is 1x1, otherwise it defaults to -2.
Example:
```
loPreview = CREATEOBJECT("frmMPPreviewer")
loPreview.oDisplayDefaults.StartingPage = 2
loPreview.oDisplayDefaults.DefaultOutputFileName = "invoice15_09"
loPreview.oDisplayDefaults.ZoomFactor = -1
loPreview.oDisplayDefaults.PagesPerSheet = "1x1"
loPreview.PreviewXFF(loXFF)
loPreview.show(1)
    
```

FIXs fixed

Dynamic properties in VFP 9.0 - dynamic textbox background is now displayed correctly
Rectangle-bound scripts in VFP 9.0 are now correctly evaluated
Word output - the page margins are updated so that wide reports fit into the paper size
PDF output - word wrapping algorithm didn't intermittently work properly with dashes and some other characters that allow for wrapping to a new line
PDF output - fonts with no code page are now properly handled if a code page is specified
PDF output - left and center alignment calculation shift in GDI+ mode has been fixed
Word output - the temporary XML copy of the word document could have been left undeleted with certain Word versions
Previewer - XFRX previewer now works properly in top-level forms
"@Z$" format string is now handled properly
Printing - the printer paper size is now automatically pre-selected with the report paper size
'X_TRIM missing' error is fixed
Excel output in VFP 9.0/SP2 now properly exports numeric values and numeric formats - if you need the numeric values, set the CallEvaluateContents property of the xfrxlistener to 2.
More details: the actual FIX was caused by the new Listener properties introduced in SP2: CallAdjustObjectSize, CallEvaluateContents. When the default parent report listener is used (fxlistener at FFC), it checks for the report dynamics and if there are not any, it sets these two properties to 1 and thus disables the EvaluateContents calls. However, when EvaluateContents is not called, XFRX won't know about the actual numeric value and the output will be exported as a text.

XFRX versions 12.7, Release notes

Release date: 23 December 2008

New features / Updates

Trim mode is now supported in all VFP versions
In VFP 9.0 the trim mode is controlled by the "Trim mode for character expressions" setting on the "Format" tab in the "Field Properties" form.
In pre-VFP 9.0 version the trimming is controlled by a special string in fields comment: #UR TRIM=, followed by the trim mode code:

Code	Description
0	Default trimming in pre-VFP 9.0 versions - trim to nearest word
1	Trim to nearest character
2	Trim to nearest word
3	Trim to nearest character, append ellipsis
4	Trim to nearest word, append ellipsis
5	Show inner path as ellipsis

Example: #UR TRIM=3 wraps to the nearest character and appends ellipsis

Shape fill pattern is now correctly rendered in picture and print output
XFRX Previewer - middle click now closes the active tab

FIXs fixed

Intermittent crashing on Windows Vista with specific printers has been fixed
The printed output was occasionally shifted for specific printers
Open office output layout issues have been fixed
Page-range filtering didn't work for merged reports
XFRX previewer issues
- Double-click on a custom hyperlink executed the linked event twice
- Bookmark panel size wasn't setup correctly during drilldown
- The previewer form didn't work correctly inside top-level forms
- Occasional screen flickering during drilldown
- Print options do not show if no printers are installed

Known issue: The full justify feature (<FJ>) does not work in the previewer. We are working on fixing this as soon as possible.

XFRX versions 12.6, Release notes

Release date: 01 August 2008

New features / Updates

Full justification is now supported in PDF, Word output, picture export and the XFRX previewer
Add <FJ> into the comments of the fields you want to full justify.
Absolute layout boxes in Word output are now automatically expandable
Picture rotation is now supported in VFP 9.0, using the new SP2 designer user interface

XFRX Previewer

Hyperlink decoration can now be suppressed on the printer output
A new property has been added to the XFCont, cntXFRXMultipage and frmMPPreviewer classes: UnderlineHyperlinksOnPrint. You can use the following values:
0 - no decoration for hyperlinks
1 - display "normal" hyperlinks in blue, but do not decorate custom event hyperlinks (green)
2 - (default value) decorate both blue and green hyperlinks

To support this, the PrintDocument method of the XFRX#DRAW class has a new parameter, tnUnderlineHyperlinksOnPrint, with the same values and logic.

Custom buttons can now be added to the XFRX previewer toolbar at runtime
This feature is implemented using the extension handler mechanism: A new method is now supported - ToolbarOnInit, which is invoked at the time the toolbar is initialized. In this method the extension handler can add new buttons to the previewer and their click events can be bound with other methods in the extension handler. A new property is now supported, too - oPreviewContainer. If it is available, the previewer will automatically fill it with the XFCont object reference for easier access to the previewer properties in the custom buttons click event methods.

Example:

use demoreps\sales
local loSession, lnRetval, loXFF, loPreview, loScripts
loSession=EVALUATE([xfrx("XFRX#LISTENER")])
lnRetVal = loSession.SetParams(,,,,,,"XFF") && no name = just in memory
If lnRetVal = 0
 REPORT FORM demoreps\sales object loSession
 *
 * the XFRX#DRAW object reference is stored in oxfDocument property
 *
 loXFF = loSession.oxfDocument
 *
 * initialize the previewer 
 *
 SET PATH TO xfrxlib
 SET CLASSLIB TO xfrxlib ADDITIVE 
 loPreview = CREATEOBJECT("frmMPPreviewer")
 *
 * setup the extension handler
 *
 loPreview.oExtensionHandler = CREATEOBJECT("SampleExtensionHandler")
 loPreview.windowtype = 1 
 loPreview.iTool = 2 && embedded toolbar
* loPreview.iTool = 1 && standard toolbar
 loPreview.PreviewXFF(loXFF)
 loPreview.show(1)
ENDIF

DEFINE CLASS SampleExtensionHandler as Custom

 oPreviewContainer = null

 PROCEDURE ToolbarOnInit
 LPARAMETERS toToolbar
 LOCAL button
 IF toToolbar.AddObject("mybutton", "commandbutton")
  BINDEVENT(toToolbar.mybutton, "click" , this, "ButtonClicked")  
  toToolbar.mybutton.tabindex = 1
  toToolbar.mybutton.Visible = .t.
  IF UPPER(totoolbar.BaseClass)!="TOOLBAR"
   toToolbar.mybutton.left = toToolbar.cmdQuit.left
   toToolbar.cmdQuit.left = toToolbar.mybutton.left + toToolbar.mybutton.width
  ENDIF  
 endif

 PROCEDURE ButtonClicked
 LOCAL lcString
 lcString = "this.oPreviewContainer.Name: "+this.oPreviewContainer.Name+CHR(13)
 lcString = lcString + "current page: "+TRANSFORM(this.oPreviewContainer.nPageNo)+CHR(13)
 lcString = lcString + "XFRX#DRAW Object: "+this.oPreviewContainer.oXFRXWriter.Name+CHR(13)
 lcString = lcString + "Page count: "+TRANSFORM(this.oPreviewContainer.oXFRXWriter.PageCount)+CHR(13)
 WAIT WINDOW lcString
* 
* this.oPreviewContainer.oXFRXWriter.PrintDocument(...)
* this.oPreviewContainer.oXFRXWriter.SavePicture(...)
ENDDEFINE

FIXs fixed

"SET NULL ON" problem has been fixed
A problem with previewer crashing on Windows Vista has been fixed
Dynamic background is now supported in VFP 9

XFRX versions 12.5 + 12.4, Release notes

Version 12.5 released on: 31 January 2008
Version 12.4 released on: 14 November 2007

New features / Updates

VFP 9.0 SP2 features are now supported
This version supports both VFP 9.0 SP2 and VFP 9.0 pre-SP2 environments. In SP2 it supports the new dynamics and rotation features.

GDI+ compatible word wrapping algorithm

The new version comes with an alternate GDI+ wordwrapping algorithm. Since the introduction of VFP 9.0 we are experiencing layout compatibility issues between the old reporting engine (pre-VFP 9.0) and the new reporting engine (VFP 9.0). [Please see Guide to Reporting Improvements VFP 9.0 help topic for more information.]

With XFRX we are experiencing a similar problem - while the pre-VFP 9.0 report engine inside XFRX is using GDI for wordwrapping and layout calculation, the VFP 9.0 report that is used in XFRX for VFP 9.0 is using GDI+. Moreover, XFRX is using GDI+ for printing, output to pictures and previewing. The main difference between using GDI and GDI+ is text width. Each text element is slightly wider with GDI+, which can result in element content being cut, earlier wrapping longer stretched fields. Here is a summary:

XFRX ver. 12.3 and earlier

VFP 9.0 VFP 8.0 and earlier

Output to PDF and other output formats GDI GDI

Report engine GDI+ GDI

Report previewer GDI+ GDI+

Printing out of XFRX GDI+ GDI+

Although converting everything to GDI+ would ease the complexity, it would bring another problem - "old" reports might need to be modified. So, instead, the latest XFRX version now contains both GDI and GDI+ wordwrapping algorithms and you can choose which one is going to be used. By default GDI+ is used in VFP 9.0 in the listener mode and GDI is used in VFP 8.0 earlier. There is probably no reason to switch to GDI in VFP 9.0 but it might sometimes be useful to switch to GDI+ as printing and previewing is still in GDI+:

XFRX ver. 12.4 with wordwrapping set to GDI+

VFP 9.0 VFP 8.0 and earlier

Output to PDF and other output formats GDI+ GDI+

Report engine GDI+ GDI+

Report previewer GDI+ GDI+

Printing out of XFRX GDI+ GDI+

XFRX ver. 12.4 with wordwrapping set to GDI

VFP 9.0 VFP 8.0 and earlier

Output to PDF and other output formats GDI GDI

Report engine GDI+ GDI

Report previewer GDI+ GDI+

Printing out of XFRX GDI+ GDI+

To set the wordwrapping algorithm manually then, before running your reports, create a public or private variable _xfrx_WordWrapAlgorithm and set it to 1 for GDI mode and 2 for GDI+ mode.

E-mail support in the XFRX previewer
An email icon has been added to the XFRX previewer toolbar. It is disabled by default for backward compatibility and can be enabled by setting the iEmail property of the previewer class [xfCont, cntXFRXMultiPage or frmMPPreviewer] to 1. If you click the email icon, it runs the Email method of the xfCont class. By default it displays a simple dialog box asking for email address, subject, body, etc. and uses VFPWinsock library to send the email.
Note: VFPWinsock is a free SMTP sendmail library written by a VFP MVP Francis Faure. It is not distributed together with XFRX and it can be downloaded from http://www.xfrx.net/vfpWinsock/index_e.asp. It is a nice little package written in VFP distributed as a single .prg.
The default behavior can be intercepted or overridden by an extension handler [Please find more information about extension handlers in the Developer's Guide here:] - and, as the default dialog does not ask for all information VFPWinsock needs (eg. it does not ask for SMTP host) you actually need to create an extension handler to make it work in your environment. There are two events that extension handler can implement:
- Email - the event is fired when the icon is clicked, before the dialog is displayed. XFF file reference is sent as the 1st parameter. Returning .F. will suppress the default behavior.
- EmailOptions - this event is fired after the dialog is displayed and user clicked "Send". XFF file reference and options object is sent as a parameter. Returning .F. will suppress the email to be sent
  The parameter object has the following properties:
  - cTo
  - cCC
  - cBCC
  - cSubject
  - cAttachmentName
  - cBody
Following are sample of the two most common scenarios:
- Suppress the default behavior and handle the email event on your own
```
loPreview = CREATEOBJECT("frmMPPreviewer")
loPreview.iEmail = 1 && show the email icon
loPreview.oExtensionHandler = CREATEOBJECT("SampleExtensionHandler")
loPreview.PreviewXFF(loXFF) && preview the document 
loPreview.show(1)

DEFINE CLASS SampleExtensionHandler as Custom

PROCEDURE Email
LPARAMETERS  loXFF
LOCAL loSession, lcFileName
loSession=EVALUATE([xfrx("XFRX#INIT")])
lcFileName = Addbs(Sys(2023))+"test.pdf" && temporary file name
If loSession.SetParams(lcFileName,,.T.,,,,"PDF") = 0 && the 3rd parameter says we do not want to preview the PDF
 loSession.TransformReport(loXFF)
 
 LOCAL sm
 Set Procedure To vfpwinsock ADDITIVE 
 sm = Createobject("vfp_winsock_send_mail")
 sm.smtp_host = "your.smtp.server.here" &&&<<<<<<<<<<<<<<<<<<<< put your smtp server here
 sm.From = "eqeus@eqeus.com" 
 sm.To = "eqeus@eqeus.com"
 sm.subject = "Email test"
 sm.silence = .T.
 sm.attaCHMENT = lcFileName
 if !sm.Send()
  MESSAGEBOX(sm.erreur,16,"xfrx test")
 ELSE
  MESSAGEBOX("Message was sent",0,"xfrx test")
  ERASE (lcFileName)
 endif

Endif

RETURN .F.
ENDPROC

ENDDEFINE
```
- Use the default dialog box, use an extension handler to supply mail server parameters and let XFRX send the email
```
DEFINE CLASS SampleExtensionHandler as Custom

PROCEDURE EmailOptions
LPARAMETERS  loXFF, loOptions
loOptions.cSMTP_HOST = "mail.your_domain.com"
loOptions.cFrom = "eqeus@eqeus.com"
ENDPROC

ENDDEFINE
```

FIXs fixed

Landscape printing has been improved, both clockwise and anti-clickwise rotation is now supported
Landscape reports printing as portrait in Word has been fixed
The 10000 lines limit in XLS output has been removed
Picture shift problem in XLS has been fixed

XFRX version 12.3, Release notes

Release date: 27 August 2007

Important installation notes for 12.x versions

The XFRX previewer component requires FOXTOOLS.FLL library if used in VFP 6.0.
XFRXLIB.FLL now also requires MSVCP71.DLL library to be installed (the previous version required GDIPLUS.DLL and MSVCR71.DLL libraries), all three libraries are required now

New features / Updates

New output type - XPS

The XPS [XML Paper Specification] is a new document specification developed by Microsoft. You can find more information about XPS at:
- http://www.microsoft.com/whdc/xps/default.mspx
- http://en.wikipedia.org/wiki/XML_Paper_Specification
There are no special requirements regarding the platform setup ? especially .NET framework is not required. XFRX generates the document on its own from scratch so all you need is VFP and XFRX.
To be able to preview the XPS document, you need an XPS document viewer. If you are running Windows Vista you already have one as it is included with .NET Framework 3.0. For Windows XP and Windows Server 2003 you can download the viewer from http://www.microsoft.com/whdc/xps/viewxps.mspx.

FIXs fixed

Speedup - the XFF file processing and PDF generation should be around 10-20% faster
"Money" type was not properly handled in some scenarios
Printing multiple pages per sheet was not working correctly for the "letter" size papers
Horizontal and vertical lines were not properly rendered in page footer for flow layout output types (FDOC, FRTF)
A FIX causing slowdown when exporting to PDF was fixed
PAGETOTAL variable was not correctly evaluated when merging multiple reports
A combination of a specific font, "stretch" flag and a textbox height could cause an occasional blank line inclusion
Appending to PDF - PDF files with a specific format were not correctly supported
Printing - layout problems with landscape reports have been fixed
VFP 8 engine - objects on bands wrapped to a new page occasionally got a wrong z-index
VFP 9 engine
- Cancelling a report was producing an empty document. No whatever was processed till the user cancelled the report is generated in the document.
- Exporting landscape reports to Word produced a document that appeared as portrait when printed
- AdjustObjectSize event is now properly propagated to listener's successors
XFRX previewer
- Navigation using searched keywords was not working correctly when SET EXACT was set to ON
- Various tweaks were done to improve the user interface

XFRX version 12.2, Release notes

Release date: 5 December 2006

Important installation notes for 12.x versions

The XFRX previewer component requires FOXTOOLS.FLL library if used in VFP 6.0.
XFRXLIB.FLL now also requires MSVCP71.DLL library to be installed (the previous version required GDIPLUS.DLL and MSVCR71.DLL libraries), all three libraries are required now

New features / Updates

XFRX Advanced Previewer

Printer selection dialog enhanced
The dialog contains new controls allowing for the following options:
- The number of copies to print
- Include odd / even or all pages
- Zoom - printing multiple pages per sheet
Export dialog enhanced
The dialog allows for the following new features:
- Specify the export output targets that would be available for selection
- When exporting to "Image" output formats, the following new options are available:
  - The number of copies to print
  - Include odd / even or all pages
  - Zoom - printing multiple pages per sheet
  - The DPI of the image created

Previewer extension handler
The extension handler now supports two new events (PrintOptions and ExportOptions) - print and export events after the options dialog is selected and the user clicks [Ok]. The events receive two parameters - the XFF object reference and an object containing the parameters user selected.

Example: Defining the export output options list, intercepting the XLS export

USE invoices ORDER customer
LOCAL loSession, lnRetval, loXFF, loPreview, loScripts
loSession=EVALUATE([xfrx("XFRX#LISTENER")])
lnRetVal = loSession.SetParams("",,,,,,"XFF") && no name = just in memory
If lnRetVal = 0
 REPORT FORM invoices OBJECT loSession  
 loXFF = loSession.oxfDocument
 *
 * initialize the previewer 
 *
 SET CLASSLIB TO xfrxlib ADDITIVE 
 loPreview = CREATEOBJECT("frmMPPreviewer")
 loPreview.setExtensionHandler(CREATEOBJECT("MyExtensionHandler"))
 loPreview.windowType = 0
 loPreview.iBook = 0
 loPreview.PreviewXFF(loXFF)
 loPreview.show(1)
ENDIF


DEFINE CLASS MyExtensionHandler AS Custom

  PROCEDURE Export
    LPARAMETERS toXFF
 IF USED("_xfExportTypes")
  USE IN _xfExportTypes
 ENDIF
 *
 * define my export options list
 *
 CREATE CURSOR _xfExportTypes (name C(50), extension C(4), targetCode C(10))
 INSERT INTO _xfExportTypes VALUES ("HTML", "html", "HTML")
 INSERT INTO _xfExportTypes VALUES ("PDF", "pdf", "PDF")
 INSERT INTO _xfExportTypes VALUES ("Excel", "xls", "XLS")
  ENDPROC
 
  PROCEDURE ExportOptions
    LPARAMETERS toXFF, toOptions
 IF toOptions.cTarget = "XLS"
  *
  * my own code to handle output to Excel
  *
  =MESSAGEBOX("exporting to "+toOptions.cOutputFile)
  RETURN .F.   && suppress the default behavior
 eLSE
  RETURN .T.   && continue with the default behavior
 ENDIF

  ENDPROC
ENDDEFINE

Printing and exporting to pictures
The SavePicture and PrintDocument methods now have new parameters for controlling whether to include all pages, odd or even only, the number of copies and the number of pages per sheet.

FIXs fixed

frmMPPreviewer class was missing the iBook property
Private data session reports were causing crashes in previewer (VFP 9)
Opaque colored backgrounds were not printing properly
The report previewer wasn't sending the XFF file reference parameter to the extension hander events
Displaying multiple pages at once in the previewer was not working correctly (old pages being left on the screen) if there were not enough pages remaining in the document
XFRX was producing corrupted PDFs when fonts were included in the document (error 135)
Appending to PDF was improved (more PDF document "subformats" are now supported)
Wrapped lines were dropped in the previewer (in some scenarios)
OpenOffice - the absolute layout output was not working correctly (blank textboxes) with the latest OpenOffice version
The word wrapping algorithm was not respecting the current code page - Cyrillic texts having lines too wide
VFP 8 engine - vertical lines are now properly wrapped to a new page when stretched bands wrap
If the page range is not specified for SavePicture and PrintDocument method, the whole document is exported/printed

XFRX version 12.1, Release notes

Release date: 5 September 2006

Important installation notes

The XFRX previewer component requires FOXTOOLS.FLL library if used in VFP 6.0.
XFRXLIB.FLL now also requires MSVCP71.DLL library to be installed (the previous version required GDIPLUS.DLL and MSVCR71.DLL libraries), all three libraries are required now

New features / Updates

XFRX Advanced Previewer
- The previewer is now able to preview multiple pages at once
  A new selection control on the toolbar can now switch the previewer to display up to 8 pages at the same time
- Displaying progress bar
  A progress bar object reference can be sent to the previewer to show progress when exporting to PDF and other output formats
  
  Example:
  
  loXFF = XFRX("XFRX#DRAW")
  loXFF.openDocument("output.xff")
  loProgress = createobject("progress") && this is a progress object that will be passed to the previewer
  loPreview = CREATEOBJECT("frmMPPreviewer")
  loPreview.oProgress = loProgress && set the reference
  loPreview.previewXFF(loXFF, "XFRX sample",1,"XFRX Sample Job name") && you can now also specify the printer job name
  loPreview.show(1)
  
  define class progress as custom
  procedure updateProgress
  lpara tnReport,tnPage,tnPercentage
  wait window nowait "Exporting page: "+allt(str(tnPage))+" (Press Ctrl+Q to Cancel)"
  endproc
  enddef
- Exporting from the previewer can be cancelled by user action
  The TransformReport method now reacts to the gnStopXFRX public variable change so that the export in progress can be cancelled
  
  Example:
  
  PUBLIC gnStopXFRX
  ON KEY LABEL CTRL+Q gnStopXFRX = 1 && the subsequent report exporting can be cancelled by
  && pressing CTRL+Q
- Print job name can be specified for each previewing document
  A new (4th, optional) parameter of the PreviewXFF method specifies the printer job name. If the 4th parameter is empty, the 2nd parameter (report caption) is used as the printer job name. If both 2nd and 4th parameters are empty, the default printer job name "XFRX" is used.

FIXs fixed

Bookmarks were not exporting to PDF
OpenOffice output didn't work correctly with SET EXACT flag set to ON
Memory leak problem in XFRXLIB.FLL was fixed
RightClick and MouseWheel events are now properly handled in the XFRX previewer
Flow layout options - bands wrapping on a new page were incorrectly rendered as page headers

XFRX version 12.0, Release notes

Release date: 17 August 2006

Installation notes:

The XFRX previewer component requires FOXTOOLS.FLL library if used in VFP 6.0.
XFRXLIB.FLL now also requires MSVCP71.DLL library to be installed (the previous version required GDIPLUS.DLL and MSVCR71.DLL libraries)

New features / Updates

New output types

Flow layout Open Office Writer document (FODT)
Absolute layout Open Office Calc Spreadsheet (ODS)
Flow layout Open Office Calc Spreadsheet (FODS)

Since 12.0, the Writer and Calc outputs are supported, both of which can be generated either using the absolute or flow layout format (please see chapter "Flow layout document option" in the Developer's guide for more information about the flow layout options).

To generate the OpenOffice document, use the following codes as the 7^th parameter (targetType) of the SetParams method:

Document type

targetType

OpenOffice Writer document with absolute layout

ODT

OpenOffice Writer document with flow layout

FODT

OpenOffice Calc spreadsheet with absolute layout

ODS

OpenOffice Calc spreadsheet with flow layout

FODS

XFRX Advanced Previewer

The displaying component was completely reworked, result of which is:
- Significant speed increase
  The previewer is now about 50 times faster in displaying the page content and moving from one page to another
- Unicode support
  The previewer now supports Chinese and Japanese code pages, correctly displays Hebrew and Arabic and supports multiple code pages within single report (new feature in VFP 9)
- Better rendering
  As the XFRX previewer in previous version was using GDI, text with small font sizes was displayed slightly wider, which was causing various layout discrepancies. These problems are now gone as the new previewer is using GDI+.
- Rotated text
  Rotated labels and fields are now supported in the previewer
- Searching
  Searching in the previewer is now significantly faster. The whole document is searched, all found occurences are listed in a side panel (as hyperlinks/bookmarks).
PDF Output

Unicode is now supported in the PDF output type. This allows for converting of multi-byte code pages (Chinese, Japanese) as well as supporting multiple code pages withing one report / document.
The unicode samples can be downloaded from: http://www.eqeus.com/files/xfrx12_demos.zip
Printing and export to pictures
- These output types now also support unicode and multiple character sets.
- When exporting to pictures, the 7th and 8th parameters can specify a DPI or a zoom factor of the picture
  Example:
```
loXFF.SavePicture("output.bmp","BMP",1,1,24,,"DPI",300) && saves the picture as 300 DPI
loXFF.SavePicture("output.bmp","BMP",1,1,24,,"ZOOM",150) && zoom to 150%
      
```

FIXs fixed

Occasionally, pictures stored in relative paths to the FRX file locations were not correctly displayed.
Font subset embedding didn't work correctly with true type fonts with short "loca" table adressing.
Occasional crashing when converting reports to pictures.
If the datasession Init method returned .F., the report was not properly cancelled.
Pictures with zero height or width were causing a corrupted PDF
When PictureDPI property was set, "stretch picture, retain shape" wasn't working correctly in PDF
The layout of printing / previewing / generating pictures was improved - "cleaner" lines, proper handling of transparent / invisible rectangles

XFRX version 11.3, Release notes

Release date: 14 March 2006

New features / Updates

XFRX Advanced Previewer
- Tabbed interface
  The advanced previewer can now preview multiple documents using the popular tabbed interface approach.
- Custom event hyperlinks (drill-down)
  
  XFRX now recognizes two types of hyperlinks:
  - ?normal? hyperlinks (printed in blue ), which navigate to other places in the report or to an external web address and
  - ?custom event? hyperlinks (printed in green ), where XFRX allows for assigning a custom VFP code that will be called when users click the hyperlink.
  This ?custom event? hyperlink feature can be used to invoke application specific actions (information forms, custom processes, etc.) or for implementing drill-down functionality ? invoking detailed report where the field user clicked on is taken as a parameter for the report (for example, clicking a customer name in the report listing all customers can run a report with detail information about this specific customer). The new report can be directed to a new page of a multipage previewer, which could provide a comfortable environment for ?drilling down? specific information ? with the ability to go back to the original report without closing the current one, side by side report comparison, exporting / printing selected reports, etc.
  
  Please find more information about this feature as well as a step-by-step example in the Developer's guide, "Implementing custom event hyperlinks (drilldown) in XFRX previewer" chapter.
- Fake toolbar option
  The previewer can now optionally replace the default toolbar with a toolbar-like control placed above the previewer control. This option can be very useful if the previewer form is not inside the main VFP screen.
- New toolbar icon - "Export"
  If the user clicks at the new Export icon, a dialog with the output type and the file name selection is displayed and the output document is generated based on options selected.
- Previewer extension handler
  The extension handler allows for extending the functionality of the basic classes without need of creating subclasses. All you need is to create a custom class, which implements certain methods. The custom class is registered with the XFRX previewer class (using SetExtensionHandler method) and the previewer calls the extension methods on appropriate events.
- The previewer instantiation is now significantly simplified
  A complete standalone-window previewer is now shipped with XFRX - all you need to do to make it work is to instantiate a class and call one of its methods with an XFF file to preview as a parameter. Alternatively, you can use the prepared single document or multiple documents (tabbed interface) controls to your forms.
  
  Please find more information about the advanced previewer in the Developer's guide, "XFRX previewer" chapter.
- German localization is now available
PDF output format
- Hebrew code page (cp 1254) is now supported
- Pictures are binary comparised to reduce the size of PDF documents with repeated pictures
- VFP 9: DynamicLineHeight property is used to control if the text field background color should fill the whole textbox (VFP 9 default behavior) or only the actual text printed (VFP 8 backward compatibility behavior)
General
- Target image DPI can be specified (large pictures can be downsampled to reduce the result document size) [see PictureDPI property for XFRXListener and XFRXSession classes at Developer's guide, "Properties and methods common in XFRXListener and XFRXSession classes" chapter].
- Image quality can be specified for ActiveX objects [see DefaultPictureFormat property for XFRXListener and XFRXSession classes at Developer's guide, "Properties and methods common in XFRXListener and XFRXSession classes" chapter].

FIXs fixed

Strikethrough font attribute is now correctly recognized
Exporting to image formats was crashing in VFP7.
XFRX Previewer
- SetLanguage method was modifying the actual SELECT area

Evaluation package note: The Prevdemo directory with the XFRX previewer implementation sample has been removed as the same functionality is now supported by the "native" class frmMPPreviewer of XFRXLib.vcx.

XFRX version 11.2, Release notes

Release date: 6 December 2005

New features

OpenOffice Writer document format is now supported.
OpenOffice is using the OASIS Open Document Format for Office Applications, which is also supported by a variety of other office applications including StarOffice, KOffice, and IBM Workplace. XFRX generates the file format natively, so OpenOffice doesn?t have to be installed on the computer where the document is generated.
You can find more information about the OASIS Open Document Format at http://www.oasis-open.org/committees/tc_home.php?wg_abbrev=office.
More information about OpenOffice can be found at http://www.openoffice.org.
TIFF, GIF, PNG, BMP and JPEG picture format is now supported in PDF and RTF output types. (BMB and JPEG formats are supported natively, for other picture formats the GDI+ version of XFRXLIB.FLL is required)

XFRX version 11.1, Release notes

Release date: 7 September 2005

New features

Turkish (1254) and Greek (1253) code pages are now supported in the PDF output
A printer properties dialog for a given printer can now be invoked from XFRX, returning the printer properties structure as a string. This string can be saved as a user preference and sent to XFRX when printing. This functionality is similar to SYS(1037) introduced in VFP 9.0, with two differences/improvements:
- The page setup and printer selection dialogs are skipped, which saves two clicks for the users and preempts confusions in case the printer has already been selected. (Very often, there is a printer selection box in the "main" form and a button to invoke printer properties).
- This implementation works in earlier versions of Visual FoxPro, too (from VFP 5.0)
A custom printer properties structure can be used when XFRX transforms the output to a printer
HNDLIB.DLL and XFRXLIB.FLL versions check. When the required library version is not available, the warning message displays:
- The version of currently used library file
- the required version
- the location of currently used library file

FIX fixes

General issues
- XFRX now supports using THISFORM in before/after band expressions
VFP 9.0 related issues
- RANGE clause is now supported
RTF issues
- The problem with long text being wrapped too early has been fixed
DOC issues
- A FIX in rectangle transparency/back color calculation has been fixed
XFRX previewer
- Right aligned labels position shift has been fixed
Print engine
- A FIX in rectangle transparency/back color calculation has been fixed
- TABs are now supported in the printed output
- Problems with early wrapping and stretched text being too high have been fixed.

XFRX version 11.0, Release notes

Release date: 2 June 2005

New features

This version introduces custom scripts. Custom scripts are methods or code snippets written in Visual FoxPro, which can be linked to objects on the report or triggered during the processing of the report, and can be used to "draw" to the report being processed: to generate pictures, add any custom graphics (graphs, watermarks, etc.), text objects, hyperlinks, bookmarks and many more.
The new version also allows to bypass the reporting engine altogether and create any of the output formats supported by XFRX from scratch ? directly from your Visual FoxPro code.
Please see the Developer's guide at http://www.eqeus.com/xfrxmanual.php for more information.
Text message of the error codes returned by SetParam method can now be retrieved with ErrorMessage method.

FIX fixes

General issues
- Striked font style is now supported in all output formats (except plain text :) )
- If a report didn't exist, the warning message was not suppressed in the silent mode
- SavePicture method was crashing when the page range was specified with string value (e.g. "4-5")
VFP 9.0 related issues
- The problems with XFRXListener initializations when the support libraries were not in the default directory have been fixed
FRTF issues
- The document was displayed in CP 1251 (in cyrilic) when opened in Open Office.
- Page size calculation problem (long pages were wrapping to a new page) has been fixed
XLS issues
- Transparent textboxes are now correctly converted as trasparent
XFRX previewer
- Problems with line colors have been fixed
- The printer selection dialog box is now localizable

XFRX version 10.2, Release notes

Release date: 20 April 2005

New features

XFRX is now able to print the generated reports. You can print the stored XFF files as well as print directly from the advanced previewer.The advanced previewer implements a simple printer selection dialog, with an option to select page ranges to print, which can be easily overwritten by a custom form. Please see the Developer's guide at http://www.eqeus.com/xfrxmanual.php for more information.

FIX fixes

VFP 9 related issues
- SetOtherParams method is now correctly implemented
PDF issues
- 8-bit grayscale JPEG pictures are now supported in PDF
- XFRX now saves repeated pictures more effectively (reduces the size of the final document)
- If the PDF file could not be created, wrong return code was returned (-1 instead of -3). This problem has been fixed.
XLS issues
- rectangle background color is now supported
- XFRX is now able to generate multiple sheets for a single report run, in two modes: sheet-per-page or sheet-per-group
- The sheet names can now be defined as an expression evaluated for each sheet
- The grid can now be hidden in the generated XLS documents
- By default, the content of non-stretchable fields is cut according to the size of the field. XFRX can now optionally leave the full content of the field in the Excel cell.
XFRX Previewer
- The problem with searching with "Use Wildcards" and "Search Backward" flags has been fixed
- "Search Next" was not working correctly if searching conditions where modified
- The found expression was not correctly highlighted if "Use Wildcards" flag was on
Reporting engine
- Pictures stretching across multiple bands should print once per page
- XFRXLIB.FLL version checking has been added
- Various layout problems in FDOC and FRTF output targets have been fixed

XFRX ver. 12.3 and earlier
	VFP 9.0	VFP 8.0 and earlier
Output to PDF and other output formats	GDI	GDI
Report engine	GDI+	GDI
Report previewer	GDI+	GDI+
Printing out of XFRX	GDI+	GDI+

Document type	targetType
OpenOffice Writer document with absolute layout	ODT
OpenOffice Writer document with flow layout	FODT
OpenOffice Calc spreadsheet with absolute layout	ODS
OpenOffice Calc spreadsheet with flow layout	FODS