[SOLVED] Export from text field from dialog to cell

[sevalav]

Hello,
I have dialog ("dialog1") with text field; how to put some text from this field to cell A1 in sheet1?

Thanks in advance

[sevalav]

I find solution:

sub FromFieldToCell
Dim oSheet,Cell, oField
oField = oDlg.getControl("TextField1")
oSheet = ThisComponent.Sheets.getByName("Sheet1")
cell = oSheet.getCellByPosition(0, 0)
cell.String = oField.Text
end sub