What's new in EMS Advanced Export Component Suite 4.16.0.2

Sep 28, 2020
  • Property Captions was pablished for the TQExport4SQL component. Using this one you can change the column's names in SQL script.
  • Fixed adding a column to the export list in QExport4Dialog.

New in EMS Advanced Export Component Suite 4.15.0.1 (Apr 3, 2019)

  • Possibility of making a result file name validation is added.
  • This validation checks an existing of not valid symbols in the file name.

New in EMS Advanced Export Component Suite 4.10.2 (Dec 10, 2014)

  • Support of RAD Studio XE7 is added.

New in EMS Advanced Export Component Suite 4.10.1 (Dec 10, 2014)

  • Support of RAD Studio XE6 is added.

New in EMS Advanced Export Component Suite 4.10 (Dec 10, 2014)

  • Support of RAD Studio XE5 is added.
  • QExport4XML. Added export to MS Access XML format files.
  • QExportDocx. Added BLOB fields export.
  • Other improvements and bug fixes.

New in EMS Advanced Export Component Suite 4.9 (Dec 10, 2014)

  • Added the possibility to append date/time to the exported file name. The AppendDateTimeToFileName and AppendDateTimeToDatabaseName (TADO_QExport4Access) properties. Use the ExportedFileName and ExportedDatabaseName (TADO_QExport4Access) properties to get the name of the file to which the export is performed.
  • QExport4SQL. Added the possibility to generate a single INSERT statement. The MultipleInsert property.
  • TQExport4XML. Now the BLOB filed data is uploaded using base64 encoding. (For Delphi 2005/CBuilder 2006 versions and older).
  • QExport4XLS. Now the exported data can be splitted into Excel worksheets by the specified number of rows. The SplitByRows property.
  • When changing delimiters in the Formats property, the delimiters in the corresponding format masks are changed automatically.
  • QExport4XLS. Now when trying to export more than 255 columns, an error
  • message occurs.
  • QExport4XLS. Fixed the errors of the format mask usage.
  • If format masks correspond to system masks, they were not saved in the dfm file. Fixed now.
  • When removing a delimiter in the Formats property, it was replaced by #0 in the corresponding format masks. Fixed now.
  • QExport4DBF. While exporting the TWideMemoField fields were recorded in the dbt file in Unicode. Fixed now.
  • QExport4SQL. When unloading currency data types, a currency symbol was added to the values. Fixed now.
  • Other improvements and bug fixes.

New in EMS Advanced Export Component Suite 4.8 (Dec 10, 2014)

  • QExport4Xlsx. Added the RightToLeftExcelMode property. If RightToLeftExcelMode = True, opening the exported file makes Excel switch to the 'Right to Left' display mode.
  • QExport4Xlsx. Now string data with non-printable characters (characters with codes up to # 31) are exported correctly.
  • QExport4Xlsx. The values of Date/Time fields were exported as numbers. Fixed now.
  • Now all fields, including Blob fields, are exported by default.
  • QExport4Dialog. Now it is impossible to export, if none of the fields are selected.
  • QExport4ASCII. The Null character was added to the end of each row. Fixed now.
  • QExport4ASCII. Export to CSV. The format mask was not applied to real numeric values. Fixed now.
  • QExport4ASCII. Export to CSV. The column width is now calculated only for the fields, where the field width is not specified.
  • QExport4ASCII. Export to CSV. The export of multibyte characters caused the error. Fixed now.
  • QExport4ASCII. Now column width parameters are read from a configuration file correctly.
  • QExport4XLS. Values were formatted incorrectly. Fixed now.
  • QExport4XLS. The format masks for standard styles were modified while being exported. Fixed now.
  • Other improvements and bug fixes.

New in EMS Advanced Export Component Suite 4.7 (Dec 10, 2014)

  • QExport4XLS. Added the Aggregates property. This collection allows to define aggregate functions for the range of cells.
  • QExport4XLS. The row height settings were not applied. Fixed now.
  • QExport4XLS. The images stretched along the width of data output. Fixed now.
  • TQExport4ASCII. Added the TrimCaptionsToDataLength property. When TrimCaptionsToDataLength=True, the caption width will be aligned along the data columns width.
  • TQExport4ASCII. When DataSet=nil and AutoCalcColWidth=True, the data export caused the error. Fixed now.
  • TQExport4Xlsx. In the designer the editor of the StripStylesLis properties could not be called. Fixed now.
  • TQExport4Xlsx. The font settings were not applied. Fixed now.
  • TQExport4Xlsx. When processing OnGetDataParams, the resulting file was created incorrectly. Fixed now.
  • QExport4XLS. TQExport4Xlsx. A number of properties were not saved in the configuration file. Fixed now.
  • TQExport4DBF. When using a Chinese locale, the file was created incorrectly. Fixed now.
  • XML-Based. The data export caused the error. Fixed now.
  • In OnGetExportText the values for null-fields could not be overridden. Fixed now.
  • Other improvements and bug fixes.

New in EMS Advanced Export Component Suite 4.6 (Dec 10, 2014)

  • Support of RAD Studio XE2 is added.
  • Some other improvements and bugfixes.

New in EMS Advanced Export Component Suite 4.5 (Dec 10, 2014)

  • Added the support of MS Access 2007. When the FileVersion property of the TADO_QExport4Access component is equal to afvAccess2007, the export is performed to the MS Access 2007 format.
  • TQExport4Xlsx. Now it is possible to set a view of each cell individually using the new OnGetDataParams event.
  • TQExport4Xlsx. Added the possibility to determine and set the columns width automatically. The new AutoCalcColWidth property is responsible for this.
  • TQExport4Xlsx. The data formatting could not be applied. Fixed now.
  • TQExport4Xlsx. Values of the Formats and UserFormats properties were not saved in the configuration file. Fixed now.
  • TQExport4Xls. When opening a file with multiple sheets, generated by the component, the cells actions (sorting, filtering, etc.) became inaccessible in Excel. Fixed now.
  • TQExport4Xls. In some cases the data export caused the program hang-up. Fixed now.
  • TQExport4Dialog. When exporting to MS Access, the "Print file after export" and "Open file after export" options did not work (it was not possible to open and print the file). Fixed now.
  • ADO_QExport4Access. When PrintFile=True and ShowFile=True, the ACCESS process remained in the process list after the export is finished. Fixed now.
  • Some other improvements and bug fixes.

New in EMS Advanced Export Component Suite 3.40 (May 23, 2009)

  • Fixed the problem with extra delimiter symbols at the end of the header lines when exporting to CSV format.
  • Fixed the problem with extra delimiter symbols at the end of the record lines when exporting to Clipboard.
  • Fixed the bug that didn't allow setting the sheet height, scope and width when exporting to PDF format.
  • Fixed the bug that didn't allow saving the Width and Align property values to the template file when exporting to PDF format.
  • Fixed the bug that caused the following: when exporting memo type fields
  • to MS Access, the data length after export always equaled the field length by adding subsequent spaces, even though the actual data length was shorter.
  • Due to this the data from such fields could not be edited.
  • Added the support of fields of BCD type.
  • Added the opportunity to randomly rotate the cell text when exporting to XLS format.
  • Fixed the bug that caused the EOleSysError which often emerged during export to MS Access when creating a new database file (.mdb).
  • Delphi 2006 support.
  • EMS Quick Export Component Suite renamed to EMS Advanced Export Component Suite!

New in EMS Advanced Export Component Suite 3.4 (Jun 20, 2006)

  • Ability to connect through SSH and HTTP tunnels, other improvements and bugfixes.