Named ranges bug

Issue #120 resolved
Former user created an issue

1) Debug print statement seems to be left in

2) Bug in parsing named ranges:

VLOOKUP(Country!$E$3, Table_Currencies[#All], 2, 9) True
Traceback (most recent call last):
  File "/.../openpyxl-1.5.8-py2.6.egg/openpyxl/reader/", line 138, in _load_workbook
    wb._named_ranges = read_named_ranges(, wb)
  File "/.../openpyxl-1.5.8-py2.6.egg/openpyxl/reader/", line 122, in read_named_ranges
    destinations = split_named_range(name_node.text)
  File "/.../openpyxl-1.5.8-py2.6.egg/openpyxl/", line 75, in split_named_range
    raise NamedRangeException('Invalid named range string: "%s"' % range_string)
openpyxl.shared.exc.NamedRangeException: Invalid named range string: " Table_Currencies[#All]"

Comments (2)

  1. Log in to comment