| TArrowLen |
The length of an arrow head.
|
| TArrowStyle |
Style of an arrow.
|
| TArrowWidth |
Preset width for an arrow.
|
| TAutofitMerged |
Specifies how a merged cell will be autofitted. For example, if you have a merged cell from row 1 to 4, You might want to increase the size of the first row, the second, the last, or every row a little.
|
| TAutomaticColor |
A list of special colors that depend on the user settings in windows.
|
| TAxisLabelPosition |
Position of the labels on the axis.
|
| TAxisType |
Type of axis.
|
| TBackgroundMode |
How to draw backgrounds of text.
|
| TBlipCompression |
This type specifies the amount of compression that has been used for a particular picture.
|
| TBlipTransformType |
The type of transform applied to an image.
|
| TBubbleSizeType |
What the bubble size means.
|
| TBuiltInStyle |
Enumerator with all built-in styles in Excel.
|
| TCategoryAxisOptions |
Options for a Category Axis.
|
| TCellIndentationRendering |
Defines how FlexCel renders cell indentation when exporting to pdf or printing.
|
| TCellType |
This enumeration holds all the possible datatypes inside a cell.
|
| TCellValueType |
This enumeration holds all the possible datatypes inside a cell.
|
| TCfvoType |
Type of a Value-Object for a conditional format.
|
| TChartAxisPos |
Axis postion.
|
| TChartErrorBarBarType |
Specifies the possible ways to draw an error bar.
|
| TChartErrorBarDirection |
Direction of an Error bar in a chart.
|
| TChartErrorBarErrorType |
Error amount type for the error bar.
|
| TChartLabelPositionMode |
How coordinates are stored for a label when it is manually positioned.
|
| TChartLayoutMode |
Specifies how the coordinates of a chart rectangle apply.
|
| TChartLayoutTarget |
Defines if the coordinates of the enclosing rectangle include the axis marks and labels.
|
| TChartLegendPlacement |
Position of the legend inside the chart.
|
| TChartLineStyle |
Line styles for a chart object.
|
| TChartLineWeight |
Different widths for chart lines. Since Excel 2007 this isn't used anymore, as you can use arbitrary line widths.
|
| TChartMarkerType |
Kind of marker.
|
| TChartRadarStyle |
Style for the radar chart.
|
| TChartTrendlineType |
Defines the type of trendline.
|
| TChartType |
Chart style.
|
| TCheckboxState |
Possible values of a checkbox in a sheet.
|
| TClippingStyle |
Can be used to clip into a region instead of drawing on it.
|
| TCollapseChildrenMode |
Determines how the children of the node of an outline will be when the node is collapsed or expanded.
|
| TColorTransformType |
List of transformations that can be done to a color.
|
| TColorType |
Defines which one of the values stored in a TExcelColor structure is the one that must be used.
|
| TColumnImportType |
Handles how to convert a column from text when importing a text file.
|
| TCompoundLineType |
Type of line.
|
| TCompressionLevel |
This specifies how much the xlsx or pdf files must be compressed. The bigger compression ratio, the slower it will be to generate the files.
|
| TCondFmtError |
Errors that might happen in a conditional format.
|
| TCondFmtIconSet |
Different icon sets used in conditional formatting.
|
| TConditionalFormatKind |
Defines which kind of conditional formatting the rule contains.
|
| TConditionType |
A list of conditional operators that you can apply in a Conditional format.
|
| TContentTransferEncoding |
Defines how a part of a MIME message will be coded.
|
| TDataBarAxisPosition |
Axis position for the databar.
|
| TDataBarDirection |
The direction of the databar.
|
| TDataBindingLoadMode |
Specifies the loading mode of an XML Map databinding.
|
| TDataConnectionCredentialMethod |
Credentials method used for server access.
|
| TDataConnectionFieldType |
These are the possible data types to use when importing text into the SpreadsheetML document. Strings are converted to these data types in the worksheet.
|
| TDataConnectionFileType |
The file type being used for text import.
|
| TDataConnectionHtmlFormat |
How to handle formatting from the HTML source.
|
| TDataConnectionParameterType |
Specifies how a parameter is refreshed.
|
| TDataConnectionQualifier |
Qualifier to use to denote string data types in when text is imported from an external file.
|
| TDataConnectionReconnectionMethod |
How to reconnect when a connection fails.
|
| TDataConnectionType |
Represents a connection type. This enumeration lists the documented values, but there could be other values peresent in the file.
|
| TDataLabelPosition |
Defines where a label is displayed on a chart.
|
| TDataValidationConditionType |
Defines the condition used in the data validation box.
|
| TDataValidationDataType |
Possible types of data validation.
|
| TDataValidationIcon |
Icon to be displayed in the error box of a data validation action. Note that this not only affects the icon used, but the possible values.
An information icon will allow you to enter an invalid value in a cell, a stop icon will not.
|
| TDataValidationImeMode |
The IME (input method editor) mode enforced by a data validation.
|
| TDateUnits |
Date units for a date axis.
|
| TDocumentCustomPropertyType |
Defines which kind of property is a custom property.
|
| TDrawingAlignment |
Specifies the alignment types for text in a drawing.
|
| TDrawingColorType |
Defines the kind of colors that might be stored inside a color definition in a drawing or a theme.
|
| TDrawingFontAlign |
Different types of font alignment.
|
| TDrawingFontCharSet |
Character set for a font as defined in the DrawingML standard.
|
| TDrawingPattern |
Different types of patterns for filling an Excel 2007 object. This is different from the patterns to fill a cell.
|
| TDrawingRectAlign |
How to position two rectangles relative to each other.
|
| TDrawingTextCapitalization |
how text is capitalized when rendered.
|
| TDrawingTextStrike |
How the text is stroke out.
|
| TDrawingUnderlineStyle |
Possible underline types in a drawing.
|
| TDrawingValueType |
Data that can be stored inside a TDrawingValue |
| TEncryptionAlgorithm |
Encryption algorithms supported in xlsx encrypted files.
|
| TEncryptionType |
How the file is encrypted. This applies only to xls files. Xlsx files are encrypted using the Agile xlsx encryption.
|
| TEnterStyle |
Defines how characters will be converted when encoding a string as Html.
|
| TEscherConnectorType |
The type of connector.
|
| TExcelFileErrorActions |
Enumerates what to do on different FlexCel error situations.
|
| TExcelFileFormat |
Different Excel versions create different empty xls/xlsx files. For example an empty xls file created by Excel 2003 will have "Arial" as its default font, and one created by Excel 2007 will have "Calibri". By default, when you call TExcelFile.NewFile FlexCel will create a file that is similar to what Excel 2003 would create. This is fine, but if you want to start for example from an empty Excel 2007 file, you can do so by calling NewFile() with this enumeration.
|
| TExcelVersion |
Defines which Excel version FlexCel is targeting. Note that while on v2007 you still can make xls 97 spreadsheets.
|
| TExcludedRecords |
A list of records that might not be saved into a file when using TExcelFile.SaveForHashing(TStream) |
| TFileFormats |
Supported file formats to read and write files.
|
| TFillStyleType |
Stores the different kind of fill styles for an autoshape or drawing.
|
| TFillType |
Type of fill for an autoshape. (In xls files) |
| TFlexCelClipboardFormat |
The file fomats that FlexCel can natively put in the clipboard.
|
| TFlexCelError |
An enumeration of all possible FlexCel non fatal errors that can be logged.
|
| TFlexCelImageHorizAlign |
Sets how an image is aligned inside a box.
|
| TFlexCelImageVertAlign |
How an image is aligned inside a box.
|
| TFlipMode |
How an image will be flipped when filling a pattern.
|
| TFlxAnchorType |
How an image behaves when inserting/copying rows/columns |
| TFlxBorderStyle |
Cell border style.
|
| TFlxDiagonalBorder |
Diagonal border style.
|
| TFlxErr |
Error Codes used in Exceptions.
|
| TFlxFontStyles |
Font style. You can "or" on "and" it to get the actual styles.
For example, to set style to bold+italic, you should use TFlxFontStyles.Bold | TFlxFontStyles.Italic.
to check if style includes italic, use ((Style & TFlxFontStyles.Italic)!=0) |
| TFlxFormulaErrorValue |
Error codes for cells on excel |
| TFlxInsertMode |
Inserting mode. Important: This enumeration is also used when deleting ranges. When deleting, Down means Up and Right means Left.
|
| TFlxMessage |
Some custom strings.
|
| TFlxParam |
Parameter names that can go into an "invalid params" error message.
|
| TFlxPatternStyle |
Pattern style.
|
| TFlxReadingOrder |
Reading order for a cell.
|
| TFlxUnderline |
Underline type.
|
| TFmReturnType |
Formula return types... A value, an array or a reference.
|
| TFontCharSet |
Character set for a font as defined in the DrawingML standard.
|
| TFontScheme |
Specifies the scheme to which a font belongs in the theme. This attribute is only valid in Excel 2007 or newer.
|
| TFormattingType |
The elements here are different types of fill/effects/etc that can be applied to an object.
Currently Excel only defines 3 types, but more can be added in future specifications.
Newer types can be accessed by casting an int to TFormattingType. (for example "(TFormattingType)5" would refer to a now non existing formatting type) |
| TFormulaToken |
Known token on a formula. They are not supposed to be localized, but they can be by editing formulamsg.resx |
| TFormulaValueType |
This enumeration contains the possible values a formula might contain.
|
| TFullRecalcOnLoadMode |
Defines how FlexCel will save the files so they will be recalculated or not when you open them in Excel.
|
| TFunctionGroup |
Specifies the function group index if the defined name refers to a function. The function group defines the general category for the function. This attribute is used when there is an add-in or other code project associated with the file.
|
| TGradientType |
The type of gradient stored inside a IExcelGradient object.
|
| THeaderAndFooterKind |
Different kinds of headers and footers depending on which pages they apply.
|
| THeaderAndFooterPos |
Different sections on a header or footer.
|
| THFlxAlignment |
Horizontal Alignment on a cell.
|
| THideObjects |
Defines how objects are shown on the file.
|
| THidePrintObjects |
Enumeration defining which objects should not be printed or exported to PDF. You can 'or' more than one option together.
For example, to not print images and not comments, you should specify: THidePrintObjects.Images | THidePrintOption.Comments |
| THtmlFileFormat |
How the html page will be saved.
|
| THtmlStyle |
Defines the way html is generated.
|
| THtmlVersion |
Defines the HTML version that will be used when exporting.
|
| THyperLinkType |
Possible types of cell hyperlinks.
|
| TIgnoredErrors |
Specifies what kind of errors Excel will ignore for ranges of cells. "Errors" in a spreadsheet are the green triangles that appear in the top left corner of the cell, like "Number stored as text".
|
| TImageColorDepth |
Number of colors for the exported images.
|
| TImageExportType |
Defines how you want to export the sheet.
|
| TImageNaming |
Defines how images will be automatically named by FlexCel, when you do not supply a better name.
|
| TInternalNameRange |
List of internal range names.
On Excel, internal range names like "Print_Area" are stored as a 1 character string.
This is the list of the names and their value.
You can convert an InternalNameRange into a string by casting it to a char, or by calling TXlsNamedRange.GetInternalName
|
| TJpegOrientation |
Specifies the rotation of a JPEG image.
|
| TLabelDataValue |
Defines what information a DataLabel should show.
|
| TLineCap |
How the line ends.
|
| TLineDashing |
Line style (dashes, solid, etc).
|
| TLineJoin |
How a line joins with the next |
| TLinkOption |
Specifies to which object the label is linked to.
|
| TListBoxSelectionType |
Types of selection allowed in a listbox.
|
| TMultipartType |
Different ways to define a multipart archive.
|
| TObjectType |
A type of object. Do not confuse this with a type of shape ( TShapeType ) This does not describe the shape form (like if it is a rectangle or a circle) but the shape kind (for example if it is a comment, an image or an autoshape) |
| TOperator |
Operators that can be found inside a formula |
| TOverlayBlendMode |
Overlay blend modes.
|
| TPanePosition |
Position on a pane when window is split |
| TPaperSize |
Pre-defined Page sizes. For Printer specific page-sizes, see TPrinterDriverSettings Note that a printer specific page size might have a value that is not on this enumeration.
|
| TPathShadeType |
Enumerates the different gradient modes for a Path gradient.
|
| TPenAlignment |
Specifies the alignment to be used for the underline stroke.
|
| TPitchFamily |
Pitch family for a font.
|
| TPlotEmptyCells |
Defines how empty cells will be plotted in the chart.
|
| TPresetColor |
Preset colors.
|
| TPresetShadowEffectType |
Types of preset shadow.
|
| TPrimaryThemeColor |
Specifies one of the 12 theme colors. Does not include semantic colors, which are in TThemeColor |
| TPrintComments |
Determines how the comments will be displayed when printing.
|
| TPrintErrors |
Determines how to print the errors when printing or exporting a sheet.
|
| TPrintOptions |
How the sheet should be printed. You can mix value together by and'ing and or'ing the flags.
See the example to see how to set or clear one specific value of the enumeration.
|
| TPropertyId |
Standard properties of an ole file. There are two different sets of properties, the standard ones (properties that exist for any file) and the extended ones (properties that exist for Ms Office documents) |
| TProtectionType |
Indicates how a sheet will be protected.
|
| TQEncodeMetaInfo |
Defines how a string returned by Q-Encode will be handled.
|
| TRangeCopyMode |
What we do with the cells when we call InsertAndCopyRange.
|
| TRangeOp |
Operation between ranges.
|
| TRecalcMode |
Sets how the excel file will be recalculated. Normally FlexCel calculates a file only before saving and when you explicitly call TExcelFile.Recalc(Boolean). With this enum you can change that behavior.
|
| TRecalcVersion |
Identifies how FlexCel will identify itself in the generated file, in order to recalculate.
|
| TReferenceStyle |
Use this enumerator in the property TExcelFile.FormulaReferenceStyle to specify the reference mode that FlexCel will use when you enter formulas as text or when it returns the formula text.
|
| TShapeOption |
Many different configuration options for a shape.
|
| TShapeOptionType |
Returns the type of option type.
|
| TShapePresetGuideType |
Internal use.
|
| TShapeType |
Enumeration with the different shapes.
|
| TSheetCalcMode |
How the file will be calculated by Excel. This enum doesn't affect FlexCel recalculation.
|
| TSheetOptions |
General options for a sheet. In Excel, this settings are located in Tools->Options->View in the "Window options" box.
Most of this options can be set with dedicated methods in TExcelFile, but this type allows to set them all at once, or copy them from other file. This options apply only to the active sheet. For options that apply to all the sheets see TSheetWindowOptions |
| TSheetType |
Sheet types |
| TSheetViewType |
The page mode of a sheet. You select this in Excel by changing the icons at the bottom right, or from the ribbon, in the "View" tab.
|
| TSheetWindowOptions |
General options for how sheets display. In Excel, this settings are located in Tools->Options->View in the "Window options" box.
This options apply only to all the sheets. For options that apply only to the active sheet see TSheetOptions |
| TSortFormulaMode |
Defines how FlexCel will sort a range of cells, when you call XlsFile.Sort. You will normally want to specify "MoveFormulas", but for huge amounts of data where you know formulas won't matter, you might choose the "ExcelLike" mode. Note that Excel itself doesn't adapt correctly the formulas when sorting, and it works like the ExcelLike mode.
|
| TSortOrder |
The sort order for a sort operation.
|
| TStackedMode |
Way the series stack one to the other. This does not apply to all chart types.
|
| TStructRefSection |
This enum contains the possible values that can go into a structured reference.
You can combine multiple values, but not all combinations make sense. For example #Data + #Headers it fine, but #All + #Headers is just #All.
|
| TStyleCategory |
Category to which a cell style belongs. This is only valid for Excel 2007 or newer.
|
| TSVGExportType |
Customized what data will be included in an svg file.
|
| TSystemColor |
System colors.
|
| TTableStyleType |
Defines the part of the table for which a tablestyle applies.
|
| TTextHorzOverflow |
How the text in a shape will overflow horizontally once there is no more room for it.
|
| TTextRotation |
Text direction for objects like comments, that allow rotation, but only in 90 degrees.
|
| TTextVertOverflow |
How the text in a shape will overflow vertically once there is no more room for it.
Note that from the Excel UI, you can only set both Vert overflow and Horizontal overflow at the same time.
|
| TThemeColor |
Specifies one of the 12 theme colors, or one of the 4 semantic colors. In cells, Excel doesn't use semantic colors, but in drawings they can be used, even if the Excel UI only allows one type of color.
|
| TTickType |
Ticks for an axis.
|
| TTimePeriod |
A time period for conditional format.
|
| TTokenType |
Enumerates the different kind of tokens you can find in a formula |
| TTokenWhitespaceCharacter |
Character used in the whitespace.
|
| TTokenWhitespacePosition |
Specifies where the whitespace is added in relation to the next token.
|
| TTotalsRowFunction |
Type of function used to summarize a table column.
|
| TUIDashStyle |
Platform independent line style.
|
| TUIFontStyle |
The different styles a font can have.
|
| TUIHatchStyle |
Specifies the different patterns available.
|
| TUIInterpolationMode |
How the image will be scaled. See System.Drawing.Drawing2D.InterpolationMode for reference.
|
| TUISmoothingMode |
Smoothing mode. See System.Drawing.Drawing2D.SmoothingMode.
|
| TUIStrikeout |
Defines if the text is stroke out. Currently there is only an style of strike out, which is a single strikeout.
|
| TUIUnderline |
Type of underline in the text.
|
| TUnsupportedFormulaErrorType |
Types of error that might happen while recalculating.
|
| TUserDefinedFunctionLocation |
Defines where the custom function is located, if inside a macro in the same file, or inside a macro in an external file.
|
| TUserDefinedFunctionScope |
Defines how custom functions are added to the recalculation engine.
If a function is defined in both Global and Local scope, Local scope will be used.
|
| TValueAxisOptions |
Options for a Value Axis.
|
| TVFlxAlignment |
Vertical Alignment on a cell.
|
| TXlsBiffVersion |
The specific Excel version that FlexCel will emulate when reading and saving files.
|
| TXlsImgType |
Possible image types on an excel sheet.
|
| TXlsSheetVisible |
Sheet visibility.
|