def test_set_rdsheet_1(self,h):
r = TestReader(
('Sheet1',[['S1R0C0']]),
('Sheet2',[[(XL_CELL_ERROR,0)]]),
)
book = tuple(r.get_workbooks())[0][0]
# fire methods on filter
f = ErrorFilter()
f.next = c = Mock()
f.start()
f.workbook(book,'new.xls')
f.sheet(book.sheet_by_index(0),'new')
f.cell(0,0,0,0)
f.set_rdsheet(book.sheet_by_index(1))
f.cell(0,0,1,0)
f.finish()
compare(c.method_calls,[])
h.check(
('xlutils.filter','ERROR',"Cell A1 of sheet 'Sheet2' contains a bad value: error (#NULL!)"),
('xlutils.filter','ERROR','No output as errors have occurred.'),
)
