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
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for