history.txt

Advanced.Export.Component.v4.01.rar,delphi 第三方控件

Version 2.00

  General changes and innovations:

  1. A possibility of restricting the number of exported records is added.
     Use the SkipRecCount property to define the number of skipped records and
     the ExportRecCount property  to define the number of exported ones.

  2. Now it is possible to export data to any stream instead of disk file.
     Check out the ExportToStream method in all components of the suite except
     the TQExportXLS component.

  3. A possibility of exporting from different sources is added.
     Now QuickExport supports TDataSet, TDBGrid, TListView and TStringGrid or
     any of their descendants.

  4. The appearance of the export dialog is improved.
     We hope you'll like its new design.

  5. A possibility of changing the order of the exported columns is added.

  6. We have added a lot of new features to the Excel export component.
     Now you can define font, color, borders, fill, etc. for each column,
     row or even cell of the spreadsheet. You can also define an aggregate
     function for each column.

  7. A possibility of defining the number of the start column in export
     to XLS file is added.

  8. A possibility of restricting the number of header/footer rows in export to XLS file is added.

  9. Now it's possible to define page orientation in export to RTF file.

 10. Now it's possible to set the column alignments in export to TXT or RTF file.

 11. Now only QExportConsts.pas is used for localization
     (you shouldn't translate dfm files for this purpose).

 12. New demo applications are added. Native C++ Builder demos are also
     included in the installation packages now.

  We are going to add new features to the component set. Our nearest plans are:
  - add export to pdf format;
  - add Kylix support.

  Please find below a technical description of all new properties and events.

1. A possibility of export from different sources is added.
   Now you can export your data from TDataSet, TDBGrid,
   TListView and TStringGrid.

   All components of the suite have the following published properties:
     DataSet: TDataSet;
     DBGrid: TDBGrid;
     ListView: TListView;
     StringGrid: TStringGrid;

     Of course, you should specify at least one of these properties.

     ExportSource: TExportSource;
     TExportSource = (esDataSet, esDBGrid, esListView, esStrigGrid);
     - defines the current export source. Default value is esDataSet.


2. TQExportASCII component

   A possibility of defining the column alignment is added.

   property ColumnsAlign: TStrings;
   This property must contain a list of strings, such as

   <COLUMN_NAME>=L[eft]|C[enter]|R[ight]

3. TQExportRTF component

   3.1 Now it's possible to select page orienration.

   property Options.PageOrientation: TQExportPageOrientation;
   type TQExportPageOrientation = (poPortrait, poLandscape);

   3.2 A possibility of defining the column alignments is added.

   property ColumnsAlign: TStrings;
   This property must contain a list of strings, such as

   <COLUMN_NAME>=L[eft]|C[enter]|R[ight]

4. TQExportXLS component

   4.1 New properties are added:

     FieldFormats: TxlsFieldFormats;
     - defines the style of the data columns.
     The TxlsFieldFormats type is described below.

     HeaderRows: integer;
     - defines the number of rows in the Header property to
       include in the result file.
       If the HeaderRows value is 0 (default) then all the rows from the Header
       property will be included in the result file.

     FooterRows: integer;
     - defines the number of rows in the Footer property to
       include in the result file.
       If the FooterRows value is 0 (default) then all the rows from the Footer
       property will be included in the result file.

     StartDataCol: integer;
     - defines the number of the start data column (0 -- Excel column A,
     1 -- column B, etc). Default value is 0.

   4.2 property Options: TXLSOptions.

     New properties are added:

     SheetTitle: string;
     - defines the sheet title.

     HeaderFormat: TxlsFormat;
     - defines the style of the Header.
       You can also write code in the OnGetHeaderParams event handler to
       tune the Header in runtime.
       The TxlsFormat type is described below.

       OnGetHeaderParam: TGetHeaderFooterParamsEvent;
       TGetHeaderFooterParamsEvent = procedure(Sender: TObject;
         Col, Row: integer; Format: TxlsFormat; var S: string) of object;

     CaptionFormat: TxlsFormat;
     - defines the style of the Captions.
       You can also write code in the OnGetCaptionParams event handler to
       tune the Captions in runtime.

       OnGetCaptionParams: TGetCaptionParamsEvent;
       TGetCaptionParamsEvent = procedure(Sender: TObject; Col: integer;
         Format: TxlsFormat; var Caption: string) of object;

     DataFormat: TxlsFormat;
     - defines the style of the data columns. This stile will be used in all
       data columns as default. If you want to change these settings then
       you can define property FieldFormats or write code in the
       OnGetDataParams event handler to tune the data cells in runtime.

       OnGeDataParams: TGetDataParamsEvent;
       TGetDataParamsEvent = procedure(Sender: TObject; Col, Row: integer;
         Format: TxlsFormat; var FormatText: string) of object;

     AggregateFormat: TxlsFormat;
     - defines the style of the aggregate values.
       You can also write code in the OnGetAggregateParams event handler to
       tune the Aggregate in runtime.

       OnGetAggregateParams: TGetAggregateParamsEvent;
       TGetAggregateParamsEvent = procedure(Sender: TObject; Col: integer;
         Format: TxlsFormat; var FormatText, Value: string) of object;

     FooterFormat: TxlsFormat;
     - defines the style of the Footer.
       You can also write code in the OnGetFooterParams event handler to
       tune the Footer in runtime.

       OnGetFooterParam: TGetHeaderFooterParamsEvent;
       TGetHeaderFooterParamsEvent = procedure(Sender: TObject;
         Col, Row: integer; Format: TxlsFormat; var S: string) of object;


   Description of TxlsFormat and TxlsFieldFormat.
   ----------------------------------------------

   TxlsFormat describes the style characteristics used when displaying text in
   cells. TxlsFormat defines font (name, style, size etc.), borders (left,
   right, top, bottom etc), fill and alignment (horizontal and vertical).

   published properties

     * Font: TxlsFont;

       + Size: integer;
         - Font size in points.
           Default value is 10.

       + Style: TxlsFontStyles;
         TxlsFontStyle = (xfsBold, xfsItalic, xfsStrikeOut);
         TxlsFontStyles = set of TxlsFontStyle;
         - Font style.
           Default value is empty set.
           In CaptionsFormat default value of this property is [xfsBold].

       + Color: TxlsColor;
         TxlsColor = (clrBlack, clrBrown, clrOliveGreen, clrDarkGreen,
                      clrDarkTeal, clrDarkBlue, clrIndigo, clrGray80Percent,
                      clrDarkRed, clrOrange, clrDarkYellow, clrGreen, clrTeal,
                      clrBlue, clrBlueGray, clrGray50Percent,
                      clrRed, clrLightOrange, clrLime, clrSeaGreen, clrAqua,
                      clrLightBlue, clrViolet, clrGray40Percent,
                      clrPink, clrGold, clrYellow, clrBrightGreen,
                      clrTurquoise, clrSkyBlue, clrPlum, clrGray25Percent,
                      clrRose, clrTan, clrLightYellow, clrLihtGreen,
                      clrLightTurquoise, clrPaleBlue, clrLavender, clrWhite);
         - Font color.
           Default color is clrBlack.

       + Script: TxlsFontScript;
         TxlsFontScript = (fscNone, fscSuperscript, fscSubscript);
         - defines the font script.
           Default value is fscNone.

       + Underline: TxlsFontUnderline;
         TxlsFontUnderline = (fulNone, fulSingle, fulDouble,
           fulSingleAccounting, fulDoubleAccounting);
         - Font underlining.
           Default value is fulNone.

       + Charset: TFontCharset;
         - Font charset (see Delphi help).
           Default value is 1 (DEFAULT_CHARSET).

       + Name: TFontName;
         - Font name;
           Default value is 'Arial'.


     * Borders: TxlsBorders;
       - Cell borders.

       + Left: TxlsBorder;

         + Style: TxlsBorderStyle;
           TxlsBorderStyle = (bstNone, bstThin, bstMedium, bstDashed,
             bstDotted, bstThick, bstDouble, bstHair, bstMediumDashed,
             bstDashDot, bstMediumDashDot, bstDashDotDot,
             bstMediumDashDotDot, bstSlantedDashDot);
           - defines the border style.
             Default value is bstNone.

         + Color: TxlsColor;
           - defines the border color.
             Default value is clrBlack.

       + Right: TxlsBorder;
       + Top: TxlsBorder;
       + Bottom: TxlsBorder;
       + DiagDown: TxlsBorder;
       + DiagUp: TxlsBorder;

     * Fill: TxlsFill;
       - Cell filling.

       + Background: TxlsColor;
         - defines the background color.
           Default value is clrWhite.

       + Foreground: TxlsColor;
         - defines the color of the pattern.
           Default value is clrBlack.

       + Pattern: TxlsPattern;
         TxlsPattern = (ptNone, ptSolid, ptChess, ptWhiteSpots, ptBlackSpots,
           ptBoldHorizontal, ptBoldVertical, ptBoldDiagRight,
           ptBoldDiagLeft, ptBoldChess, ptRingMail, ptThinGorizontal,
           ptThinVertical, ptThinDiagLeft, ptThinDiagRight, ptCells,
           ptCrissCross, ptThinSpots, ptThinThinSpots);
         - defines the filling pattern;
           Default value is ptNone.

     * Alignment: TxlsAlignment;
       - Text alignment.

       + Horizontal: TxlsHorizontalAlignment;
         TxlsHorizontalAlignment = (halGeneral, halLeft, halCenter,
           halRight, halFill);
         - Horizontal alignment in the cell.
           Default value is halGeneral.

       + Vertical: TxlsVerticalAlignment;
         TxlsVerticalAlignment = (valTop, valCenter, valBottom, valJustify);
         - Vertical alinment in the cell.
           Default value is valBottom.

     * Wrap: boolean;


   TxlsFieldFormat inherites from TxlsFormat.

   TxlsFieldFormat = class(TxlsFormat);

   published properties:

     * FieldName: string;
     - defines the column name.

     * Width: integer;
     - defines the column width.

     * Aggregate: TxlsAggregate;
       TxlsAggregate = (aggNone, aggSum, aggAvg, aggMin, aggMax);
     - defines the aggregate function for this column.
       Default value is aggNone.


1.xy version history
=====================

05-17-2002
Version 1.99

1. Now QuickExport suite is fully documented. We've added
missing documentation for TVExportDialog component and also
for all properties, methods and events of other components
which were undocumented.

2. We've created a special 'end-user' help file so you
can include it into the installation package of your application.
You can also write your own help file (for example, in your
native language) and replace our VExportDlg.hlp file with yours.

3. TVExportDialog component: a possibility of print file
after export is added (the PrintFile property). You can enable
or disable this feature using the AllowPrintFile property.

4. TVClipboardExport component: new properties
QuoteStrings: Integer and QuoteChar: Char are added.
You can use these properties if you wish to quote output
strings by QuoteChar symbol.

5. TVSQLExport component: fixed bug with exporting strings
containing the apostrophe symbol. The problem with exporting