split_named_range not able to split correctly an expression
Created originally on Bitbucket by Gabriel Reis
split_named_range function crashed when trying to parse the following expression:
OFFSET(MODEL!$A$1,'Stock Graphs'!$D$3-1,'Stock Graphs'!$C$25+5,'Stock Graphs'!$D$6,1)/1.65
Exception message:
NamedRangeException('Invalid named range string: "1)/1.65"',)
Pdb details:
(Pdb) for range_string in SPLIT_NAMED_RANGE_RE.split(node_text)[1::2]: print range_string
OFFSET(MODEL!$A$1
'Stock Graphs'!$D$3-1
'Stock Graphs'!$C$25+5
'Stock Graphs'!$D$6
1)/1.65
(Pdb) node_text
"OFFSET(MODEL!$A1,'Stock Graphs'!
D3-1,'Stock Graphs'!
C25+5,'Stock Graphs'!
D$6,1)/1.65"
(Pdb)
Attachments: openpyxl_split_name_range_error