Makros/Basis/Calc/Daten
< Macros | Basic/Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Spende
Daten
In this topic, many examples using current selection, caution, you sure the current select object is correct.
Read
Read like string for one cell (ScCellObj)
selection = ThisComponent.getCurrentSelection()
MsgBox selection.getString()
Read like value for one cell (ScCellObj)
selection = ThisComponent.getCurrentSelection()
MsgBox selection.getValue()
Write
Write string for one cell (ScCellObj)
selection = ThisComponent.getCurrentSelection()
selection.String = "Ingrid Bergman"
Write value for one cell (ScCellObj)
selection = ThisComponent.getCurrentSelection()
selection.Value = 100