Macros/Basic/Calc/Data

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Macros
• General Macros
• Macros for Writer
• Macros for Calc
• Macros for Impress
• Macros for Draw
• Macros for Base
• Macros for Math
• Basic/Python

Return to Index

Data

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