XFRX version 15.2

 Release date: 26 Nov 2014 

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

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