Per Button daten in Zelle einfügen

[turtle47]

Hi,

Code: Alles auswählen

Sub Main
Dim myValue as Double
myDoc = thisComponent
mySheet = myDoc.Sheets().getByName("Tabelle1")
myValue = mysheet.getCellRangeByName("A20").value'Wert holen
mysheet.getCellRangeByName("A1").value = myValue'Wert schreiben
End Sub

Viel Erfolg.

Jürgen

[Stephan]

und mit makro aufzeichnen wird das ja nix

Dann wäre es prima wen Du mitteilst was dabei für Probleme auftreten und welche OOo-Version Du benutzt.

Ich konnte in OOo 2.4.0 keine SChwierigkeiten feststellen:

Code: Alles auswählen

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 = "A20"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:Copy", "", 0, Array())

rem ----------------------------------------------------------------------
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = "ToPoint"
args3(0).Value = "A1"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args3())

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:Paste", "", 0, Array())


end sub

Gruß
Stephan