Link Search Menu Expand Document

Range Class

Range class
Inheritance Hierarchy
SystemObject
Bytescout.SpreadsheetRange

Namespace:Bytescout.Spreadsheet
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.5.1.2018-master
Syntax
public class Range : IRange

The Range type exposes the following members.

Properties
NameDescription
Public propertyAlignmentHorizontal
Sets a horizontal text alignment style of the cell.
Public propertyAlignmentVertical
Sets the vertical text alignment style of the cell.
Public propertyAreas
Gets an Areas collection that represents all the ranges in a multiple-area selection.
Public propertyBottomBorderColor
Sets the color of the bottom border.
Public propertyBottomBorderStyle
Sets the bottom border style.
Public propertyBottomRowIndex
Index of the bottom row of the range.
Public propertyCellFormat
Sets the cell format.
Public propertyColumn
Gets the zero based column number of the first column in the first area (Areas[0]) of the Range .
Public propertyColumns
Gets a Range object that represents the columns in the specified range.
Public propertyCode exampleCount
Gets the number of cells in the Range.
Public propertyDiagonalBorderColor
Sets the color of the diagonal border.
Public propertyDiagonalBorderStyle
Sets the diagonal border style.
Public propertyFillPattern
Sets the fill pattern.
Public propertyFillPatternBackColor
Sets the background color for a fill pattern.
Public propertyFillPatternForeColor
Sets the foreground color for a fill pattern.
Public propertyFont
Sets the font of the cell.
Public propertyFontColor
Sets the color of the font.
Public propertyFontColorIndex
Sets the index of the font color.
Public propertyFontEscapement
Sets the font escapement.
Public propertyFontUnderline
Sets the font underline style.
Public propertyFormula
Sets the formula for the range.
Public propertyHiddenFormula
Gets or sets a value indicating whether formula is hidden.
Public propertyIndent
Gets or sets the Indent value for the cell.
Public propertyInnerBorderColor
Sets the color of the inner border.
Public propertyInnerBorderStyle
Sets the inner border style.
Public propertyIsDiagonalDownLine
Sets a value indicating whether this instance is diagonal down line.
Public propertyIsDiagonalUpLine
Sets a value indicating whether this instance is diagonal up line.
Public propertyIsNotEmptyCells
Gets a bool value indicating that the range contains only empty cells or not
Public propertyLeftBorderColor
Sets the color of the left border.
Public propertyLeftBorderStyle
Sets the left border style.
Public propertyLeftColumnIndex
Index of the left column of the range.
Public propertyLocked
Sets a value indicating whether this IRange is locked.
Public propertyNumberFormatString
Sets the number format string.
Public propertyOuterBorderColor
Sets the color of the outer border.
Public propertyOuterBorderStyle
Sets the outer border style.
Public propertyRightBorderColor
Sets the color of the right border.
Public propertyRightBorderStyle
Sets the right border style.
Public propertyRightColumnIndex
Index of the right column of the range.
Public propertyRotation
Sets the text rotation angle for the cell.
Public propertyRow
Gets the zero based row number of the first row in the first area (Areas[0]) of the Range .
Public propertyRows
Gets a Range object that represents the rows in the specified range.
Public propertyShrinkToFit
Gets or sets a value indicating shrink content to fit into cell.
Public propertyTextDirection
Gets or sets the reading order.
Public propertyTopBorderColor
Sets the color of the top border.
Public propertyTopBorderStyle
Sets the top border style.
Public propertyTopRowIndex
Index of the top row of the range.
Public propertyValue
Sets the value of range.
Public propertyValueAsHTML
Sets the formatted text (Rich-Text) in HTML coded format
Public propertyValueDataTypeByNumberFormatString
Sets the type (ValueDataTypeByNumberFormatString) of the number format.
Public propertyWrap
Sets a value indicating a text is wrapped.
Top
Methods
NameDescription
Public methodAddress
Returns the range reference.
Public methodAddress(Boolean, Boolean, Boolean)
Returns the range reference.
Public methodCalculate
Calculates the formulas in the Range.
Public methodCopyInto(String)
Makes a copy and paste of this range into a new range specified by top left cell (referenced by A1-style name, for example: A1, F3 or C4)
Public methodCopyInto(Int32, Int32)
Makes a copy and paste of this range into a new range specified by top left cell (row, col indexes)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodMerge
Merges cells in the range.
Public methodSort(String, SortOrder, Boolean, SortOrientation, SortDataOption)
Sorts a range.
Public methodSort(String, SortOrder, String, SortOrder, String, SortOrder, Boolean, SortOrientation, SortDataOption, SortDataOption, SortDataOption)
Sorts a range.
Public methodSpecialCells
Returns a CellList object that represents all the cells that match the specified type and value.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUnMerge
Unmerges cells in the range.
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout