XFRX version 16.1, Release notes

Release date: 26 July 2016

Enhancements and fixes

• PDF
• 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. 
• DOC
• 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
• 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 "&".
• RTF
• 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

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

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

• PDF
• 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.
• PDF
• 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
• XPS
• 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
• PDF
• 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
• XPS
• 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)
• PDF
• 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
• 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
• PDF
• 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:

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

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

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

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