|
FlexCel Studio for VCL/LCL
|
Contains a list of types, constants, variables and generic utility methods used in the whole suite.
You will normally need to use this file when using FlexCel.
|
Name |
Description |
|
Internal use. Specifies the characters that a name has to have to be a data range in TFlexCelReport. | |
|
Difference in days between the 1900 and 1904 date systems supported by Excel. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Convert the DEFAULT column width to pixels. This is different from ColMult, that goes in a column by column basis. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies the separator character for tags in TFlexCelReport. | |
|
Internal use. Specifies the default locale. | |
|
1= Draft quality | |
|
Print over, then down | |
|
1= Black and white | |
|
1=orientation not set | |
|
if 1, then PaperSize, Scale, Res, VRes, Copies, and Landscape data have not been obtained from the printer, so they are not valid. MAKE SURE YOU MAKE THIS BIT = 0 *BEFORE* CHANGING ANY OTHER OPTION. THEY WILL NOT CHANGE IF THIS IS NOT SET. | |
|
1= Print Notes | |
|
0= landscape, 1=portrait | |
|
1=use custom starting page number. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal range name. On Excel, internal range names like "Print_Range" are stored as a 1 character string. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
A2 - 420mm x 594mm | |
|
A3 - 297mm x 420mm | |
|
A3 Extra - 322mm x 445mm | |
|
A3 Extra Transverse - 322mm x 445mm | |
|
A3 Rotated - 420mm x 297mm | |
|
A3 Transverse - 297mm x 420mm | |
|
A4 - 210mm x 297mm | |
|
A4 Extra - 235mm x 322mm | |
|
A4 Plus - 210mm x 330mm | |
|
A4 Rotated - 297mm x 210mm | |
|
A4 small - 210mm x 297mm | |
|
A4 Transverse - 210mm x 297mm | |
|
A5 - 148mm x 210mm | |
|
A5 Extra - 174mm x 235mm | |
|
A5 Rotated - 210mm x 148mm | |
|
A5 Transverse - 148mm x 210mm | |
|
A6 - 105mm x 148mm | |
|
A6 Rotated - 148mm x 105mm | |
|
B4 (ISO) - 250mm x 353mm | |
|
B4 (ISO) - 250mm x 353mm | |
|
B4 (JIS) - 257mm x 364mm | |
|
B4 (JIS) Rotated - 364mm x 257mm | |
|
B5 (ISO) - 176mm x 250mm | |
|
B5 (ISO) Extra - 201mm x 276mm | |
|
B5 (JIS) - 182mm x 257mm | |
|
B5 (JIS) Rotated - 257mm x 182mm | |
|
B5 (JIS) Transverse - 182mm x 257mm | |
|
B6 (ISO) - 125mm x 176mm | |
|
B6 (JIS) - 128mm x 182mm | |
|
B6 (JIS) Rotated - 182mm x 128mm | |
|
C - 17"" x 22"" | |
|
D - 22"" x 34"" | |
|
Dbl. Japanese Postcard - 200mm x 148mm | |
|
Dbl. Jap. Postcard Rot. - 148mm x 200mm | |
|
E - 34"" x 44"" | |
|
Envelope #10 - 41/8"" x 91/2"" | |
|
Envelope #11 - 41/2"" x 103/8"" | |
|
Envelope #12 - 43/4"" x 11"" | |
|
Envelope #14 - 5"" x 111/2"" | |
|
Envelope #9 - 37/8"" x 87/8"" | |
|
Envelope C3 - 324mm x 458mm | |
|
Envelope C4 - 229mm x 324mm | |
|
Envelope C5 - 162mm x 229mm | |
|
Envelope C6 - 114mm x 162mm | |
|
Envelope C6/C5 - 114mm x 229mm | |
|
Envelope DL - 110mm x 220mm | |
|
Envelope Invite - 220mm x 220mm | |
|
Envelope Italy - 110mm x 230mm | |
|
Envelope Monarch - 37/8"" x 71/2"" | |
|
Executive - 71/4"" x 101/2"" | |
|
Folio - 81/2"" x 13"" | |
|
German Legal Fanfold - 81/2"" x 13"" | |
|
German Std. Fanfold - 81/2"" x 12"" | |
|
Japanese Postcard - 100mm x 148mm | |
|
Japanese Postcard Rot. - 148mm x 100mm | |
|
Ledger - 17"" x 11"" | |
|
Legal - 81/2"" x 14"" | |
|
Legal Extra - 91/2"" x 15"" | |
|
Letter - 81/2"" x 11"" | |
|
Undefined - Letter Extra - 91/2"" x 12"" | |
|
Letter Extra Transv. - 91/2"" x 12"" | |
|
Letter Plus - 812"" x 1211/16"" | |
|
Letter Rotated - 11"" x 81/2"" | |
|
Letter small - 81/2"" x 11"" | |
|
Letter Transverse - 81/2"" x 11"" | |
|
Note - 81/2"" x 11"" | |
|
Quarto - 215mm x 275mm | |
|
10x11 - 10"" x 11"" | |
|
10x14 - 10"" x 14"" | |
|
11x17 - 11"" x 17"" | |
|
12x11 - 12"" x 11"" | |
|
15x11 - 15"" x 11"" | |
|
63/4 Envelope - 35/8"" x 61/2"" | |
|
9x11 - 9"" x 11"" | |
|
Statement - 51/2"" x 81/2"" | |
|
Super A/A4 - 227mm x 356mm | |
|
Super B/A3 - 305mm x 487mm | |
|
Tabloid - 11"" x 17"" | |
|
Tabloid Extra - 1111/16"" x 18"" | |
|
Not defined. | |
|
US Standard Fanfold - 147/8"" x 11"" | |
|
Internal use. Specifies the separator character for report variables in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. | |
|
Internal use. Specifies an special character in TFlexCelReport. |
|
|
Name |
Description |
|
Defines how an image is anchored to the sheet. | |
|
Possible types of cell hyperlinks. | |
|
Possible image types on an excel sheet. | |
|
Sheet visibility. |
|
|
Name |
Description |
|
Returns a column identifier for a column index. | |
|
Tries to convert a string to a TDateTime. | |
|
Internal use. Returns a TFormatSettings object with the default settings. | |
|
Initializes a TXlsNamedRange record with the default values. | |
|
Increments a Cell range by an offset. | |
|
This method will search for a file in the disk. | |
|
This method has been deprecated. Use TryFormatDateTime1904 instead. | |
|
Converts a datetime value to a formatted string, using Excel format strings. | |
|
Converts a datetime value to a formatted string, using Excel format strings. | |
|
Tries to convert a string to a float in an invariant culture. This means "." is always decimal separator. |
|
|
Name |
Description |
|
Image Anchor information. | |
|
This record is a placeholder for older Delphi versions that don't have FormatSettings defined for handling different locales. | |
|
An encapsulation of an Excel hyperlink. | |
|
Image information for a normal image. | |
|
Printer specific settings. It is a byte array with a Win32 DEVMODE structure. | |
|
A string cell value with its rich text information. | |
|
One RTF run for the text in a cell. FirstChar is the first (base 0) character to apply the format, and FontIndex is the font index for the text | |
|
An Excel Cell range, 1-based. | |
|
Encapsulates the value in a cell. | |
|
Sheet margin for printing, in inches. | |
|
An Excel named range. |
|
Name |
Description |
|
Used for pointer arithmetic. Point to PAnsiChar if Delphi is less than 2009, or to PByte otherwise. | |
|
The range of color indexes allowed by Excel 2003 or older. | |
|
An integer expressing an Excel standard paper size. Use TExcelPaperSize_XXX constants for the allowed values. | |
|
Event associated with TCustomFlexCelReport.OnGetFilename. | |
|
Event associated with TCustomFlexCelReport.OnGetOutStream. | |
|
An array of TRTFRun structures, where each struct identifies a font style for a portion of text. For example, if you have: Value="Hello" RTFRuns={FirstChar:1 FontIndex=1, FirstChar=3, FontIndex=2} "H" (char 0) will be formatted with the specific cell format. "el" (chars 1 and 2) will have font number 1 "lo" (chars 3 and 4) will have font number 2 | |
|
An UTF16 wide char. This type maps to WideChar in Delphi less than 2009 or to Char otherwise. | |
|
An UTF16 wide string. This type maps to WideString in Delphi less than 2009 or to UnicodeString otherwise. |
|
Name |
Description |
|
Factor to convert from Excel Internal Units to pixels or viceversa. Look at Excel Internal Units for more information. | |
|
Factor to convert from Excel Internal Units to pixels or viceversa. Look at Excel Internal Units for more information. |
|
Copyright (c) 2002-2008 TMS Software. All rights reserved.
|
|
What do you think about this topic? Send feedback!
|