Macro/Basic/Calc/Dati

TDF LibreOffice Document Liberation Project Blog comunitari Weblate Nextcloud Redmine Ask LibreOffice Donazione

• Pagina principale
• Sviluppo
• Design
• Controllo qualità
• Eventi
• Documentazione
• Sito web
• Traduzione
• Accessibilità
• Commerciale
• Inclusione
• Aiuto

• Macro
• Macro generiche
• Macro per Writer
• Macro per Calc
• Macro per Impress
• Macro per Draw
• Macro per Base
• Macro per Math
• Basic/Python

Return to Index

Dati

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