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
|
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
|
