Link Search Menu Expand Document

IRange Interface

Range interface

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

The IRange type exposes the following members.

Properties
NameDescription
Public propertyAlignmentHorizontal
Sets the horizontal text alignment style of the row.
Public propertyAlignmentVertical
Sets the vertical text alignment style of the row.
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 propertyDiagonalBorderColor
Gets or sets the color of the diagonal border.
Public propertyDiagonalBorderStyle
Gets or sets the diagonal border style.
Public propertyFillPattern
Sets the fill pattern of the row.
Public propertyFillPatternBackColor
Sets the background color for a fill pattern of the row.
Public propertyFillPatternForeColor
Sets the foreground color for a fill pattern of the row.
Public propertyFont
Sets the font.
Public propertyFontColor
Sets the color of the font.
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 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 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 row.
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 whether a text is wrapped.
Top
Methods
NameDescription
Public methodCalculate
Calculates the formulas in the Range.
Public methodCopyInto(String)
Makes copy and paste of the current range into position referenced by A1-style cell name
Public methodCopyInto(Int32, Int32)
Makes a copy and paste of the current range into the position referenced by (row, col) cell
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout