setting namedcell does not work correctly

[GliderGeek]

sample code:

cwd = os.getcwd()
spreadsheet_path = os.path.join(cwd, 'template.xlsx')
graph = ExcelCompiler(spreadsheet_path).gen_graph()
graph.set_value('input1', 3)  # cell A1
result = graph.evaluate('Blad1!B1')  # =A1+5
# result=5 instead of 8

template.xlsx

[vallettea]

I think this is because you generated teh graph while A1 is empty and thus the graph has only one node. Try to assign a value in your worksheet before generating the graph.

[GliderGeek]

i don't think that is the case, because it does work when normal coordinates are used. it would also be a lot nicer when the original graph can be re-used. i think that i have found the problem in the code, will publish it here later

[Brad-eki]

I have been using named cells and they appear to be working properly.

has this been fixed?