officefileapi-devexpress-dot-spreadsheet-dot-cellvalue-0dc20bdb.md
Returns the CellValue object specifying the #REF! error value of a cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public static CellValue ErrorReference
Public Shared ErrorReference As CellValue
| Type | Description |
|---|---|
| CellValue |
A cell error value.
|
The following code snippets (auto-collected from DevExpress Examples) contain references to the ErrorReference field.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
how-to-use-excel-add-ins-in-winforms-spreadsheet/CS/SpreadsheetAddIn/Form1.cs#L74
result.Add(-2146826252, DevExpress.Spreadsheet.CellValue.ErrorNumber);
result.Add(-2146826265, DevExpress.Spreadsheet.CellValue.ErrorReference);
result.Add(-2146826273, DevExpress.Spreadsheet.CellValue.ErrorInvalidValueInFunction);
winforms-spreadsheetcontrol-api-part1/CS/SpreadsheetControl/SpreadsheetActions/CellActions.cs#L121
worksheet.Cells["B3"].Value = "Have a nice day!";
worksheet.Cells["B4"].Value = CellValue.ErrorReference;
worksheet.Cells["B5"].Value = true;
worksheet.Cells["B3"].Value = "Have a nice day!";
worksheet.Cells["B4"].Value = CellValue.ErrorReference;
worksheet.Cells["B5"].Value = true;
spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/CellActions.cs#L44
worksheet.Cells["B3"].Value = "Have a nice day!";
worksheet.Cells["B4"].Value = CellValue.ErrorReference;
worksheet.Cells["B5"].Value = true;
how-to-use-excel-add-ins-in-winforms-spreadsheet/VB/SpreadsheetAddIn/Form1.vb#L71
result.Add(-2146826252, DevExpress.Spreadsheet.CellValue.ErrorNumber)
result.Add(-2146826265, DevExpress.Spreadsheet.CellValue.ErrorReference)
result.Add(-2146826273, DevExpress.Spreadsheet.CellValue.ErrorInvalidValueInFunction)
winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/CellActions.vb#L115
worksheet.Cells("B3").Value = "Have a nice day!"
worksheet.Cells("B4").Value = CellValue.ErrorReference
worksheet.Cells("B5").Value = True
worksheet.Cells("B3").Value = "Have a nice day!"
worksheet.Cells("B4").Value = CellValue.ErrorReference
worksheet.Cells("B5").Value = True
spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/CellActions.vb#L46
worksheet.Cells("B3").Value = "Have a nice day!"
worksheet.Cells("B4").Value = CellValue.ErrorReference
worksheet.Cells("B5").Value = True
See Also