Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class
Properties Methods


In This Topic
    CellRange Class Members
    In This Topic

    The following tables list the members exposed by CellRange.

    Public Properties
     NameDescription
    Public PropertyCountOverridden. Gets the number of Cells within the CellRange.  
    Public PropertyDataValidationGets or sets the CellRange's DataValidation.  
    Public PropertyElementsGets the items in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyEndingElementGets or sets the last item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyStartingElementGets or sets the first item in the range. (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    Public Methods
     NameDescription
    Public MethodAddConditionalFormattingAdds ConditionalFormatting to the CellRange.  
    Public MethodClearOverridden. Clears specific elements in the CellRange.  
    Public MethodClearConditionalFormattingsRemoves all ConditionalFormattings from the CellRange.  
    Public MethodCopyAndPasteToOverloaded. Copies a CellRange & pastes it to another location.  
    Public MethodCutAndPasteToOverloaded. Cuts a CellRange & pastes it to another location.   
    Public MethodEquals  
    Public MethodGetConditionalFormattingsGets the CellRange's ConditionalFormattings.  
    Public MethodGetHashCode  
    Public MethodGetValidationResultsGets a list of Cells that have failed the DataValidation process.  
    Public MethodGetWorksheetReturns the Worksheet associated with the CellRange.  
    Public MethodMergeCellsAdds the CellRange in the MergedCellCollection.  
    Public MethodRemoveConditionalFormatting  
    Public MethodReplaceContentOverridden. Searches into the content of the CellRange and replaces all occurences of a specific value with a new value.  
    Public MethodReplaceContents<TSearch,TNew>Overridden. Searches into the content of the CellRange and replaces all instances of the SearchValues with their corresponding NewValues.  
    Public MethodToStringReturns the addresses of the StartingElement and EndingElement in the following format: ( "SE : EE " ).  
    Public MethodUnmergeCellsRemoves all the element in the CellRange from the MergedCellCollection.  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodGetElementsOverridden.   
    Protected Internal MethodGetNewStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodGetWorksheetElementOverridden.   
    Protected Internal MethodIsBoundElement (Inherited from Xceed.Workbooks.NET.StyledRange<Cell>)
    Protected Internal MethodIsElementInRangeOverridden.   
    Protected Internal MethodIsEndingBoundElementOverridden.   
    Protected Internal MethodIsStartingBoundElementOverridden.   
    Protected MethodOnPropertyChanged  
    Protected Internal MethodReadStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodReset (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodSetElementsOverridden.   
    Protected Internal MethodUpdateChildrenStylePropertyOverridden.   
    Protected Internal MethodUpdateStyleBorders (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodWriteStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Top
    See Also

    Reference

    CellRange Class
    Xceed.Workbooks.NET Namespace

    Send Feedback