diff options
Diffstat (limited to 'ext/win32ole/tests/testOLEEVENT.rb')
-rw-r--r-- | ext/win32ole/tests/testOLEEVENT.rb | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/ext/win32ole/tests/testOLEEVENT.rb b/ext/win32ole/tests/testOLEEVENT.rb index 15b7ca8413..368794b150 100644 --- a/ext/win32ole/tests/testOLEEVENT.rb +++ b/ext/win32ole/tests/testOLEEVENT.rb @@ -5,6 +5,7 @@ class TestWIN32OLE_EVENT < RUNIT::TestCase def setup @excel = WIN32OLE.new("Excel.Application") @excel.visible = true + @event = "" end def test_on_event book = @excel.workbooks.Add @@ -24,6 +25,45 @@ class TestWIN32OLE_EVENT < RUNIT::TestCase end assert_equal("OK", value) end + + def handler1 + @event += "handler1" + end + def handler2 + @event += "handler2" + end + + def test_on_event2 + book = @excel.workbooks.Add + begin + ev = WIN32OLE_EVENT.new(book, 'WorkbookEvents') + ev.on_event('SheetChange'){|arg1, arg2| + handler1 + } + ev.on_event('SheetChange'){|arg1, arg2| + handler2 + } + book.Worksheets(1).Range("A1").value = "OK" + ensure + book.saved = true + end + assert_equal("handler2", @event) + end + + def test_on_event3 + book = @excel.workbooks.Add + begin + ev = WIN32OLE_EVENT.new(book, 'WorkbookEvents') + ev.on_event{ handler1 } + ev.on_event{ handler2 } + book.Worksheets(1).Range("A1").value = "OK" + ensure + book.saved = true + end + assert_equal("handler2", @event) + end + + def teardown @excel.quit @excel = nil |