FlexCel Studio for VCL/LCL
ContentsIndex
PreviousUpNext
UFlxMessages.pas

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!