- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
- FarPoint.Win.Spread Assembly
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
-
GrapeCity.Spreadsheet
- Classes
-
Structs
- ActionResult<T>
- Alignment
- AutoFilterColumn
- Border
- BorderLine
- Break
- CellProtection
- CellReference
- CfExecutedResult
- CfIcon
- CfValue
- Color
- CustomFilterCriteria
- DataValidationExecutedResult
- DataValidationSuggestionItem
- DateGroupItem
- Fill
- FormatResult
- GradientFillEffect
- GradientStop
- NumberFormat
- Reference
- StyleFormat
- TableStyleElement
- WorksheetReference
- Enums
- Interfaces
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.IO.Pdf
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.Slicers
- GrapeCity.Spreadsheet.UI
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
GrapeCity.Spreadsheet.WorksheetReference
WorksheetReference Struct
Represents a reference to a range of cells in the specified worksheet.
Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public struct WorksheetReference : IComparable<WorksheetReference>, IEquatable<WorksheetReference>Public Structure WorksheetReference
Implements IComparable(Of WorksheetReference), IEquatable(Of WorksheetReference)Constructors
| Name | Description |
|---|---|
| WorksheetReference(IWorksheet, Reference) | |
| WorksheetReference(IWorksheet, int, int) | Initializes a new instance of the WorksheetReference class. |
| WorksheetReference(IWorksheet, int, int, int, int) | Initializes a new instance of the WorksheetReference class. |
Fields
| Name | Description |
|---|---|
| Empty | Represents a WorksheetReference structure with its properties left uninitialized. |
Properties
| Name | Description |
|---|---|
| IsEmpty | Gets a value indicating whether this value is empty. |
| Range | Gets the range of cells. |
| Worksheet | Gets the worksheet. |
Methods
| Name | Description |
|---|---|
| CompareLocation(WorksheetReference, WorksheetReference) | Compares the location of 2 worksheet references. |
| Equals(WorksheetReference) | Indicates whether the current WorksheetReference value is equal to another WorksheetReference value. |
| IsValid(bool) | Gets a boolean value indicating whether this WorksheetReference value is valid. |
| ToString() | Converts to string. |