1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
module Spreadsheet
module Excel
##
# This class encapsulates Excel Error-Codes
class Error
attr_reader :code
ERROR_VALUES = {
0x00 => "#NULL!", # Intersection of two cell ranges is empty
0x07 => "#DIV/0!", # Division by zero
0x0F => "#VALUE!", # Wrong type of operand
0x17 => "#REF!", # Illegal or deleted cell reference
0x1D => "#NAME?", # Wrong function or range name
0x24 => "#NUM!", # Value range overflow
0x2A => "#N/A!" # Argument or function not available
}
def initialize code
@code = code
end
##
# The String value Excel associates with an Error code
def value
ERROR_VALUES.fetch @code, "#UNKNOWN"
end
end
end
end
|
