def test_trim_cells(excel):
excel_compiler = ExcelCompiler(excel=excel)
input_addrs = ['trim-range!D5']
output_addrs = ['trim-range!B2']
old_value = excel_compiler.evaluate(output_addrs[0])
excel_compiler.trim_graph(input_addrs, output_addrs)
excel_compiler._to_text(is_json=True)
new_value = ExcelCompiler._from_text(
excel_compiler.filename, is_json=True).evaluate(output_addrs[0])
assert old_value == new_value
def test_trim_cells_range(excel):
excel_compiler = ExcelCompiler(excel=excel)
input_addrs = [AddressRange('trim-range!D4:E4')]
output_addrs = ['trim-range!B2']
old_value = excel_compiler.evaluate(output_addrs[0])
excel_compiler.trim_graph(input_addrs, output_addrs)
excel_compiler._to_text()
excel_compiler = ExcelCompiler._from_text(excel_compiler.filename)
assert old_value == excel_compiler.evaluate(output_addrs[0])
excel_compiler.set_value(input_addrs[0], [5, 6])
assert old_value - 1 == excel_compiler.evaluate(output_addrs[0])
excel_compiler.set_value(input_addrs[0], [4, 6])
assert old_value - 2 == excel_compiler.evaluate(output_addrs[0])
excel_compiler.set_value(tuple(next(input_addrs[0].rows)), [5, 6])
assert old_value - 1 == excel_compiler.evaluate(output_addrs[0])
def test_evaluate_empty(excel):
excel_compiler = ExcelCompiler(excel=excel)
assert 0 == excel_compiler.evaluate('Empty!B1')
excel_compiler.recalculate()
assert 0 == excel_compiler.evaluate('Empty!B1')
input_addrs = ['Empty!C1', 'Empty!B2']
output_addrs = ['Empty!B1', 'Empty!B2']
excel_compiler.trim_graph(input_addrs, output_addrs)
excel_compiler._to_text(is_json=True)
text_excel_compiler = ExcelCompiler._from_text(
excel_compiler.filename, is_json=True)
assert [0, None] == text_excel_compiler.evaluate(output_addrs)
text_excel_compiler.set_value(input_addrs[0], 10)
assert [10, None] == text_excel_compiler.evaluate(output_addrs)
text_excel_compiler.set_value(input_addrs[1], 20)
assert [10, 20] == text_excel_compiler.evaluate(output_addrs)
