ErrorMessage
Class
This is a class for detailed error messages across HyperFormula.
Properties
Section titled “Properties”ArrayDimensions
Section titled “ArrayDimensions”Static
▪ ArrayDimensions: string = “Array dimensions are not compatible.”
Defined in hyperformula/src/error-message.ts:18
ArraySourceRemoved
Section titled “ArraySourceRemoved”Static
▪ ArraySourceRemoved: string = “Source cell of the array result was overwritten or removed.”
Defined in hyperformula/src/error-message.ts:22
BadCriterion
Section titled “BadCriterion”Static
▪ BadCriterion: string = “Incorrect criterion.”
Defined in hyperformula/src/error-message.ts:26
BadMode
Section titled “BadMode”Static
▪ BadMode: string = “Mode not recognized.”
Defined in hyperformula/src/error-message.ts:35
BadRef
Section titled “BadRef”Static
▪ BadRef: string = “Address is not correct.”
Defined in hyperformula/src/error-message.ts:52
BitshiftLong
Section titled “BitshiftLong”Static
▪ BitshiftLong: string = “Result of bitshift is too long.”
Defined in hyperformula/src/error-message.ts:77
CellRangeExpected
Section titled “CellRangeExpected”Static
▪ CellRangeExpected: string = “Cell range expected.”
Defined in hyperformula/src/error-message.ts:28
CellRefExpected
Section titled “CellRefExpected”Static
▪ CellRefExpected: string = “Cell reference expected.”
Defined in hyperformula/src/error-message.ts:50
CharacterCodeBounds
Section titled “CharacterCodeBounds”Static
▪ CharacterCodeBounds: string = “Character code out of bounds.”
Defined in hyperformula/src/error-message.ts:89
CircularReference
Section titled “CircularReference”Static
▪ CircularReference: string = “Cell is part of a circular reference.”
Defined in hyperformula/src/error-message.ts:41
ComplexNumberExpected
Section titled “ComplexNumberExpected”Static
▪ ComplexNumberExpected: string = “Complex number expected.”
Defined in hyperformula/src/error-message.ts:96
DateBounds
Section titled “DateBounds”Static
▪ DateBounds: string = “Date outside of bounds.”
Defined in hyperformula/src/error-message.ts:36
DistinctSigns
Section titled “DistinctSigns”Static
▪ DistinctSigns: string = “Distinct signs.”
Defined in hyperformula/src/error-message.ts:14
DivisionByZero
Section titled “DivisionByZero”Static
▪ DivisionByZero: string = “Division by zero.”
Defined in hyperformula/src/error-message.ts:91
EmptyArg
Section titled “EmptyArg”Static
▪ EmptyArg: string = “Empty function argument.”
Defined in hyperformula/src/error-message.ts:16
EmptyArray
Section titled “EmptyArray”Static
▪ EmptyArray: string = “Empty array not allowed.”
Defined in hyperformula/src/error-message.ts:17
EmptyRange
Section titled “EmptyRange”Static
▪ EmptyRange: string = “Empty range not allowed.”
Defined in hyperformula/src/error-message.ts:51
EmptyString
Section titled “EmptyString”Static
▪ EmptyString: string = “Empty-string argument not allowed.”
Defined in hyperformula/src/error-message.ts:78
EndStartPeriod
Section titled “EndStartPeriod”Static
▪ EndStartPeriod: string = “End period needs to be at least start period.”
Defined in hyperformula/src/error-message.ts:49
EqualLength
Section titled “EqualLength”Static
▪ EqualLength: string = “Ranges need to be of equal length.”
Defined in hyperformula/src/error-message.ts:44
EqualXValues
Section titled “EqualXValues”Static
▪ EqualXValues: string = “All x values are equal.”
Defined in hyperformula/src/error-message.ts:66
ErrorLiteral
Section titled “ErrorLiteral”Static
▪ ErrorLiteral: string = “Error value was entered directly into the formula.”
Defined in hyperformula/src/error-message.ts:72
Formula
Section titled “Formula”Static
▪ Formula: string = “Expected formula.”
Defined in hyperformula/src/error-message.ts:69
IncorrectDateTime
Section titled “IncorrectDateTime”Static
▪ IncorrectDateTime: string = “String does not represent correct DateTime.”
Defined in hyperformula/src/error-message.ts:88
IndexBounds
Section titled “IndexBounds”Static
▪ IndexBounds: string = “Index out of bounds.”
Defined in hyperformula/src/error-message.ts:67
IndexLarge
Section titled “IndexLarge”Static
▪ IndexLarge: string = “Index too large.”
Defined in hyperformula/src/error-message.ts:68
IntegerExpected
Section titled “IntegerExpected”Static
▪ IntegerExpected: string = “Value needs to be an integer.”
Defined in hyperformula/src/error-message.ts:34
InvalidDate
Section titled “InvalidDate”Static
▪ InvalidDate: string = “Invalid date.”
Defined in hyperformula/src/error-message.ts:76
InvalidRoman
Section titled “InvalidRoman”Static
▪ InvalidRoman: string = “Invalid roman numeral.”
Defined in hyperformula/src/error-message.ts:94
LengthBounds
Section titled “LengthBounds”Static
▪ LengthBounds: string = “Length out of bounds.”
Defined in hyperformula/src/error-message.ts:79
LessThanOne
Section titled “LessThanOne”Static
▪ LessThanOne: string = “Argument cannot be less than 1.”
Defined in hyperformula/src/error-message.ts:92
LinestNoInterceptError
Section titled “LinestNoInterceptError”Static
▪ LinestNoInterceptError: string = “The intercept is fixed at 0, so it has no standard error.”
Defined in hyperformula/src/error-message.ts:12
LinestNoStatistic
Section titled “LinestNoStatistic”Static
▪ LinestNoStatistic: string = “This position of the LINEST statistics has no value.”
Defined in hyperformula/src/error-message.ts:13
LinestStaticSize
Section titled “LinestStaticSize”Static
▪ LinestStaticSize: string = “LINEST requires input dimensions that determine a fixed result size.”
Defined in hyperformula/src/error-message.ts:10
LinestStaticStats
Section titled “LinestStaticStats”Static
▪ LinestStaticStats: string = “LINEST requires a constant stats argument to determine its result size.”
Defined in hyperformula/src/error-message.ts:11
MaturityLong
Section titled “MaturityLong”Static
▪ MaturityLong: string = “Maturity date cannot be more than one year after the settlement date.”
Defined in hyperformula/src/error-message.ts:87
NaFunction
Section titled “NaFunction”Static
▪ NaFunction: string = “The NA function always evaluates to the #N/A error.”
Defined in hyperformula/src/error-message.ts:55
Static
▪ NaN: string = “NaN or infinite value encountered.”
Defined in hyperformula/src/error-message.ts:43
Negative
Section titled “Negative”Static
▪ Negative: string = “Value cannot be negative.”
Defined in hyperformula/src/error-message.ts:45
NegativeCount
Section titled “NegativeCount”Static
▪ NegativeCount: string = “Count cannot be negative.”
Defined in hyperformula/src/error-message.ts:70
NegativeLength
Section titled “NegativeLength”Static
▪ NegativeLength: string = “Length cannot be negative.”
Defined in hyperformula/src/error-message.ts:59
NegativeTime
Section titled “NegativeTime”Static
▪ NegativeTime: string = “Time cannot be negative.”
Defined in hyperformula/src/error-message.ts:80
NoBroadcastValue
Section titled “NoBroadcastValue”Static
▪ NoBroadcastValue: string = “Operand ranges cannot be broadcast to a common size, so this position has no value.”
Defined in hyperformula/src/error-message.ts:19
NoConditionMet
Section titled “NoConditionMet”Static
▪ NoConditionMet: string = “None of the conditions were met.”
Defined in hyperformula/src/error-message.ts:82
NoConvergence
Section titled “NoConvergence”Static
▪ NoConvergence: string = “Calculation did not converge.”
Defined in hyperformula/src/error-message.ts:83
NoDefault
Section titled “NoDefault”Static
▪ NoDefault: string = “No default option.”
Defined in hyperformula/src/error-message.ts:81
NoSpaceForArrayResult
Section titled “NoSpaceForArrayResult”Static
▪ NoSpaceForArrayResult: string = “No space for array result.”
Defined in hyperformula/src/error-message.ts:21
NonZero
Section titled “NonZero”Static
▪ NonZero: string = “Argument cannot be 0.”
Defined in hyperformula/src/error-message.ts:90
NonZeroPeriods
Section titled “NonZeroPeriods”Static
▪ NonZeroPeriods: string = “Number of periods cannot be 0 when the rate is -1.”
Defined in hyperformula/src/error-message.ts:75
NotBinary
Section titled “NotBinary”Static
▪ NotBinary: string = “String does not represent a binary number.”
Defined in hyperformula/src/error-message.ts:46
NotHex
Section titled “NotHex”Static
▪ NotHex: string = “String does not represent a hexadecimal number.”
Defined in hyperformula/src/error-message.ts:48
NotOctal
Section titled “NotOctal”Static
▪ NotOctal: string = “String does not represent an octal number.”
Defined in hyperformula/src/error-message.ts:47
NumberCoercion
Section titled “NumberCoercion”Static
▪ NumberCoercion: string = “Value cannot be coerced to number.”
Defined in hyperformula/src/error-message.ts:32
NumberExpected
Section titled “NumberExpected”Static
▪ NumberExpected: string = “Number argument expected.”
Defined in hyperformula/src/error-message.ts:33
NumberRange
Section titled “NumberRange”Static
▪ NumberRange: string = “Number-only range expected.”
Defined in hyperformula/src/error-message.ts:53
OneValue
Section titled “OneValue”Static
▪ OneValue: string = “Needs at least one value.”
Defined in hyperformula/src/error-message.ts:61
OutOfSheet
Section titled “OutOfSheet”Static
▪ OutOfSheet: string = “Resulting reference is out of the sheet.”
Defined in hyperformula/src/error-message.ts:37
OutsideArrayResult
Section titled “OutsideArrayResult”Static
▪ OutsideArrayResult: string = “Position is outside the array result of this formula.”
Defined in hyperformula/src/error-message.ts:23
ParseError
Section titled “ParseError”Static
▪ ParseError: string = “Parsing error.”
Defined in hyperformula/src/error-message.ts:71
PatternNotFound
Section titled “PatternNotFound”Static
▪ PatternNotFound: string = “Pattern not found.”
Defined in hyperformula/src/error-message.ts:60
PeriodLong
Section titled “PeriodLong”Static
▪ PeriodLong: string = “Period number cannot exceed life length.”
Defined in hyperformula/src/error-message.ts:74
PoolDimensions
Section titled “PoolDimensions”Static
▪ PoolDimensions: string = “Range dimensions are not compatible with the window size and the stride.”
Defined in hyperformula/src/error-message.ts:20
PositiveAndNegative
Section titled “PositiveAndNegative”Static
▪ PositiveAndNegative: string = “Needs at least one positive and one negative value.”
Defined in hyperformula/src/error-message.ts:65
RangeManySheets
Section titled “RangeManySheets”Static
▪ RangeManySheets: string = “Range spans more than one sheet.”
Defined in hyperformula/src/error-message.ts:27
RateGuess
Section titled “RateGuess”Static
▪ RateGuess: string = “The iterative rate search needs an initial guess greater than -1.”
Defined in hyperformula/src/error-message.ts:84
ReferenceExceedsSheetSize
Section titled “ReferenceExceedsSheetSize”Static
▪ ReferenceExceedsSheetSize: string = “Reference exceeds the maximum row or column size of the sheet.”
Defined in hyperformula/src/error-message.ts:40
ReferenceRemoved
Section titled “ReferenceRemoved”Static
▪ ReferenceRemoved: string = “Reference points to a row or column that was removed.”
Defined in hyperformula/src/error-message.ts:39
ResultTooLong
Section titled “ResultTooLong”Static
▪ ResultTooLong: string = “Result exceeds the maximum allowed length.”
Defined in hyperformula/src/error-message.ts:99
ScalarExpected
Section titled “ScalarExpected”Static
▪ ScalarExpected: string = “Cell range not allowed.”
Defined in hyperformula/src/error-message.ts:31
SearchRangeDimension
Section titled “SearchRangeDimension”Static
▪ SearchRangeDimension: string = “Search range needs to be a single row or a single column, not a two-dimensional range.”
Defined in hyperformula/src/error-message.ts:30
Selector
Section titled “Selector”Static
▪ Selector: string = “Selector cannot exceed the number of arguments.”
Defined in hyperformula/src/error-message.ts:85
SheetRef
Section titled “SheetRef”Static
▪ SheetRef: string = “Sheet does not exist.”
Defined in hyperformula/src/error-message.ts:73
ShouldBeIorJ
Section titled “ShouldBeIorJ”Static
▪ ShouldBeIorJ: string = “Should be ‘i’ or ‘j’.”
Defined in hyperformula/src/error-message.ts:97
SizeMismatch
Section titled “SizeMismatch”Static
▪ SizeMismatch: string = “Array dimensions mismatched.”
Defined in hyperformula/src/error-message.ts:98
StartEndDate
Section titled “StartEndDate”Static
▪ StartEndDate: string = “Start date needs to be earlier than end date.”
Defined in hyperformula/src/error-message.ts:86
ThreeValues
Section titled “ThreeValues”Static
▪ ThreeValues: string = “Range needs to contain at least three elements.”
Defined in hyperformula/src/error-message.ts:63
TwoCashFlows
Section titled “TwoCashFlows”Static
▪ TwoCashFlows: string = “A schedule of cash flows needs at least two entries to define a rate of return.”
Defined in hyperformula/src/error-message.ts:64
TwoValues
Section titled “TwoValues”Static
▪ TwoValues: string = “Range needs to contain at least two elements.”
Defined in hyperformula/src/error-message.ts:62
UnresolvedReference
Section titled “UnresolvedReference”Static
▪ UnresolvedReference: string = “Reference in the formula could not be resolved.”
Defined in hyperformula/src/error-message.ts:38
ValueBaseLarge
Section titled “ValueBaseLarge”Static
▪ ValueBaseLarge: string = “Value in base too large.”
Defined in hyperformula/src/error-message.ts:56
ValueBaseLong
Section titled “ValueBaseLong”Static
▪ ValueBaseLong: string = “Value in base too long.”
Defined in hyperformula/src/error-message.ts:58
ValueBaseSmall
Section titled “ValueBaseSmall”Static
▪ ValueBaseSmall: string = “Value in base too small.”
Defined in hyperformula/src/error-message.ts:57
ValueLarge
Section titled “ValueLarge”Static
▪ ValueLarge: string = “Value too large.”
Defined in hyperformula/src/error-message.ts:25
ValueNotFound
Section titled “ValueNotFound”Static
▪ ValueNotFound: string = “Value not found.”
Defined in hyperformula/src/error-message.ts:54
ValueSmall
Section titled “ValueSmall”Static
▪ ValueSmall: string = “Value too small.”
Defined in hyperformula/src/error-message.ts:24
WeekendString
Section titled “WeekendString”Static
▪ WeekendString: string = “Incorrect weekend bitmask string.”
Defined in hyperformula/src/error-message.ts:93
WrongArgNumber
Section titled “WrongArgNumber”Static
▪ WrongArgNumber: string = “Wrong number of arguments.”
Defined in hyperformula/src/error-message.ts:15
WrongDimension
Section titled “WrongDimension”Static
▪ WrongDimension: string = “Wrong range dimension.”
Defined in hyperformula/src/error-message.ts:29
WrongOrder
Section titled “WrongOrder”Static
▪ WrongOrder: string = “Wrong order of values.”
Defined in hyperformula/src/error-message.ts:95
WrongType
Section titled “WrongType”Static
▪ WrongType: string = “Wrong type of argument.”
Defined in hyperformula/src/error-message.ts:42
Methods
Section titled “Methods”FunctionName
Section titled “FunctionName”Static
▸ FunctionName(arg: string): string
Defined in hyperformula/src/error-message.ts:100
Parameters:
| Name | Type |
|---|---|
arg |
string |
Returns: string
LicenseCapability
Section titled “LicenseCapability”Static
▸ LicenseCapability(functionName: string): string
Defined in hyperformula/src/error-message.ts:103
Parameters:
| Name | Type |
|---|---|
functionName |
string |
Returns: string
LicenseKey
Section titled “LicenseKey”Static
▸ LicenseKey(arg: string): string
Defined in hyperformula/src/error-message.ts:102
Parameters:
| Name | Type |
|---|---|
arg |
string |
Returns: string
NamedExpressionName
Section titled “NamedExpressionName”Static
▸ NamedExpressionName(arg: string): string
Defined in hyperformula/src/error-message.ts:101
Parameters:
| Name | Type |
|---|---|
arg |
string |
Returns: string