EMS Advanced Data Export VCL 4.14.1.5 Full Source

{******************************************************************************} {* *} {* EMS Advanced Data Export Component Suite *} {* *} {* Copyright (C) 1999 - 2017 EMS Database Management Solutions, Ltd. *} {* *} {******************************************************************************} 21-06-2017 Version 4.14.1.5 1. Access violation occured while exporting data through the QExport4Xlsx component when the custom export source selected and the property AutoCalcColWidth is set to True. Fixed now. 2. XLS-file is being crashed after export if the property AutoCalcColWidth is set to True. Fixed now. 3. The TQExport4XLS component caused a closing of the dataset when the property Sheets contained only one element. Fixed now. 4. TQExport4XLS. Temporary files were created in the application folder, which resulted in access errors in some cases. Fixed now. 18-04-2017 Version 4.14.1 1. Support of RAD Studio 10.2 Tokyo added. 2. The possibility to set topics of the help file in the TQExport4Dialog.HelpContext or TQExport4Dialog.HelpTopic properties added. 3. The TXlsFieldFormat.Width property did not work. Fixed now. 10-03-2017 Version 4.14.0 1. Support for 64-bit Windows target platform has been added. 2. Support for Unicode configuration files added. 3. Now it is possible to export data into XLSX files, containing Unicode symbols in names. 4. ODS and ODT files with Unicode symbols, generated by the component, were opened with MS Excel and MS Word with errors. Fixed now. 5. Now all components except for TADO_QExport4Access and TQExport4DBF export BLOB and binary data as Base64 and HEX strings. 6. Now you can set column width in ColumnWidths property of the TQExport4XLS component with TqeCustomSource4 as source and no fields defined. 7. AutoCalcColWidth property is now applied correctly to XLS files. 8. XLSX files were opened with errors if data cell styles were changed inside of the OnGetDataParams event handler. Fixed now. 9. The Access violation error occurred on getting size and precision for TFmtBCDField field types. Fixed now. 10. Now the formatting strings for TXlsxCellStyle.NumericFormat property in TQExport4Xlsx component create new styles in the document correctly. 11. The errors occurred in TQExport4ODS and TQExport4ODT components on exporting data without adding any style settings. Fixed now. 11-05-2016 Version 4.13.2 1. Support of RAD Studio 10.1 Berlin is added. 20-04-2016 Version 4.13.1 1. Possibility of exporting the string's data as hyperlinks has been added. 2. Possibility of formatting TBCDField field values as the currency field types. 3. All 64-bit integer values with length more than 18 digits were being converted into a float type with exponential notation. Fixed now. 4. Errors due to 64-bit run-time package QExport4RT_C23.cbproj compilation. Fixed now. 5. A height of the strings was not being adjusted depending on the font's and data's size of the cell. Fixed now. 6. Export to TXT, CSV, DIF, SYLK. The problem is an illegal addition byte (value 00) after every line break. Fixed now. 7. Fix of integer overflow. 8. Fix of images exporting to XLS. 9. The error "Cannot load package 'QEXport4RT_C11'. It contains unit 'Gifconsts', which is also contained in package 'vcl100'" was fixed. 10. The error "Cannot load package 'QEXport4RT_C12'. It contains unit 'Pnglang', which is also contained in package 'vclimg120'" was fixed. 11. The "Not enough timers available" error message was being throwed because of using the components inside of IntraWeb application. Fixed now. 01-10-2015 Version 4.12.1 1. Support of RAD Studio 10 Seattle is added. 28-05-2015 Version 4.11.1 1. Support of RAD Studio XE8 is added. 2. Export to XLS. Ability to set page properties for the printed page has been implemented. 3. Export to PDF. The AutoBreakString property is renamed to BreakString. The way it works has been changed. 4. The LoadPropertiesFromStream and SavePropertiesToStream methods have been added. 5. Export to Access. Microsoft.ACE.OLEDB.15.0 support is added. 6. Multiple bugs related to decimal separator setting have been fixed. 7. Export to PDF. The line breaks in MEMO-fields were deleted. Fixed now. 05-09-2014 Version 4.10.2 1. Support of RAD Studio XE7 is added. 13-05-2014 Version 4.10.1 1. Support of RAD Studio XE6 is added. 23-10-2013 Version 4.10 1. Support of RAD Studio XE5 is added. 2. QExport4XML. Added export to MS Access XML format files. 3. QExportDocx. Added BLOB fields export. 4. Other improvements and bug fixes. 08-04-2013 Version 4.9 1. 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. 2. QExport4SQL. Added the possibility to generate a single INSERT statement. The MultipleInsert property. 3. TQExport4XML. Now the BLOB filed data is uploaded using base64 encoding. (For Delphi 2005/CBuilder 2006 versions and older). 4. QExport4XLS. Now the exported data can be splitted into Excel worksheets by the specified number of rows. The SplitByRows property. 5. When changing delimiters in the Formats property, the delimiters in the corresponding format masks are changed automatically. 6. QExport4XLS. Now when trying to export more than 255 columns, an error message occurs. 7. QExport4XLS. Fixed the errors of the format mask usage. 8. If format masks correspond to system masks, they were not saved in the dfm file. Fixed now. 9. When removing a delimiter in the Formats property, it was replaced by #0 in the corresponding format masks. Fixed now. 10. QExport4DBF. While exporting the TWideMemoField fields were recorded in the dbt file in Unicode. Fixed now. 11. QExport4SQL. When unloading currency data types, a currency symbol was added to the values. Fixed now. 12. Other improvements and bug fixes. 20-08-2012 Version 4.8 1. QExport4Xlsx. Added the RightToLeftExcelMode property. If RightToLeftExcelMode = True, opening the exported file makes Excel switch to the 'Right to Left' display mode. 2. QExport4Xlsx. Now string data with non-printable characters (characters with codes up to # 31) are exported correctly. 3. QExport4Xlsx. The values of Date/Time fields were exported as numbers. Fixed now. 4. Now all fields, including Blob fields, are exported by default. 5. QExport4Dialog. Now it is impossible to export, if none of the fields are selected. 6. QExport4ASCII. The Null character was added to the end of each row. Fixed now. 7. QExport4ASCII. Export to CSV. The format mask was not applied to real numeric values. Fixed now. 8. QExport4ASCII. Export to CSV. The column width is now calculated only for the fields, where the field width is not specified. 9. QExport4ASCII. Export to CSV. The export of multibyte characters caused the error. Fixed now. 10. QExport4ASCII. Now column width parameters are read from a configuration file correctly. 11. QExport4XLS. Values were formatted incorrectly. Fixed now. 12. QExport4XLS. The format masks for standard styles were modified while being exported. Fixed now. 13. Other improvements and bug