OOo Basic で OOo Calc のセルに値を入力
- A1をクリックして選択し,1 を入力
- A2をクリックして選択し,2 を入力
- A3をクリックして選択し,3 を入力
- A4をクリックして選択し,4 を入力
- A5をクリックして選択し,5 を入力
上記の手順の OOo Basic マクロを見てみる.
REM ***** BASIC ***** sub Main rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = "ToPoint" args1(0).Value = "$A$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1()) rem ---------------------------------------------------------------------- dim args2(0) as new com.sun.star.beans.PropertyValue args2(0).Name = "StringName" args2(0).Value = "1" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args2()) rem ---------------------------------------------------------------------- dim args3(0) as new com.sun.star.beans.PropertyValue args3(0).Name = "ToPoint" args3(0).Value = "$B$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args3()) rem ---------------------------------------------------------------------- dim args4(0) as new com.sun.star.beans.PropertyValue args4(0).Name = "StringName" args4(0).Value = "2" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args4()) rem ---------------------------------------------------------------------- dim args5(0) as new com.sun.star.beans.PropertyValue args5(0).Name = "ToPoint" args5(0).Value = "$C$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args5()) rem ---------------------------------------------------------------------- dim args6(0) as new com.sun.star.beans.PropertyValue args6(0).Name = "StringName" args6(0).Value = "3" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args6()) rem ---------------------------------------------------------------------- dim args7(0) as new com.sun.star.beans.PropertyValue args7(0).Name = "ToPoint" args7(0).Value = "$D$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args7()) rem ---------------------------------------------------------------------- dim args8(0) as new com.sun.star.beans.PropertyValue args8(0).Name = "StringName" args8(0).Value = "4" dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args8()) rem ---------------------------------------------------------------------- dim args9(0) as new com.sun.star.beans.PropertyValue args9(0).Name = "ToPoint" args9(0).Value = "$E$1" dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args9()) end sub