Excel.ValueErrorCellValueSubType enum
Represents types of #VALUE! errors.
Remarks
Fields
| coerceStringToBoolInvalid = "CoerceStringToBoolInvalid" | An error caused by encountering a string where a boolean was expected, and that string not being coercible to a boolean. Displays as error type #VALUE! in Excel. |
| coerceStringToInvalidType = "CoerceStringToInvalidType" | An error caused by conversion of a string to a type other than a boolean or number. Displays as error type #VALUE! in Excel. |
| coerceStringToNumberInvalid = "CoerceStringToNumberInvalid" | An error caused by encountering a string where a number was expected, and that string not being coercible to a number. Displays as error type #VALUE! in Excel. |
| hlookupResultNotFound = "HlookupResultNotFound" | An error caused by HLOOKUP not finding its lookup_value parameter. Displays as error type #VALUE! in Excel. |
| hlookupRowIndexLessThanOne = "HlookupRowIndexLessThanOne" | An error caused by a row_index_num parameter of HLOOKUP of less than 1. Displays as error type #VALUE! in Excel. |
| invalidImageUrl = "InvalidImageUrl" | An error caused by a |
| lambdaWrongParamCount = "LambdaWrongParamCount" | An error caused by passing the incorrect number of parameters to a lambda value. Displays as error type #VALUE! in Excel. |
| stockHistoryEndBeforeStart = "StockHistoryEndBeforeStart" | An error caused by passing an end_date parameter that precedes the start_date parameter to STOCKHISTORY. Displays as error type #VALUE! in Excel. |
| stockHistoryInvalidDate = "StockHistoryInvalidDate" | An error caused by passing an invalid date to STOCKHISTORY. Displays as error type #VALUE! in Excel. |
| stockHistoryInvalidEnum = "StockHistoryInvalidEnum" | An error caused by invalid interval or header parameters for STOCKHISTORY. Displays as error type #VALUE! in Excel. |
| stockHistoryNonTradingDays = "StockHistoryNonTradingDays" | An error caused by STOCKHISTORY having a date range which only contains days that don't have stock trading. Displays as error type #VALUE! in Excel. |
| stockHistoryNotAStock = "StockHistoryNotAStock" | An error caused by passing a stock parameter which is not a stock to STOCKHISTORY. Displays as error type #VALUE! in Excel. |
| stockHistoryNotFound = "StockHistoryNotFound" | An error caused by STOCKHISTORY not finding the history of the specified stock. Displays as error type #VALUE! in Excel. |
| stockHistoryOnlyDateRequested = "StockHistoryOnlyDateRequested" | An error caused by STOCKHISTORY parameters that request only the date and no other fields. Displays as error type #VALUE! in Excel. |
| stockHistoryStartInFuture = "StockHistoryStartInFuture" | An error caused by passing a future start_date parameter to STOCKHISTORY. Displays as error type #VALUE! in Excel. |
| subArrayStartColumnMissingEndColumnNot = "SubArrayStartColumnMissingEndColumnNot" | An error caused by SUBARRAY missing a start column. Displays as error type #VALUE! in Excel. |
| subArrayStartRowMissingEndRowNot = "SubArrayStartRowMissingEndRowNot" | An error caused by SUBARRAY missing a start row. Displays as error type #VALUE! in Excel. |
| unknown = "Unknown" | An unknown type of error. Displays as error type #VALUE! in Excel. |
| vlookupColumnIndexLessThanOne = "VlookupColumnIndexLessThanOne" | An error caused by a column_index_num parameter of VLOOKUP of less than 1. Displays as error type #VALUE! in Excel. |
| vlookupResultNotFound = "VlookupResultNotFound" | An error caused by VLOOKUP not finding its lookup_value parameter. Displays as error type #VALUE! in Excel. |
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for