Macros/Python Guide/Calc/Calc ranges

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 Python Guide, Calc

Ranges

CAUTION: Copy or import function msgbox from Useful functions

Get cell by name

doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.CurrentController.ActiveSheet
    cell = sheet['A1']
    msgbox(cell.AbsoluteName)

Get cell by position

doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.CurrentController.ActiveSheet
    # Cell C6
    row = 5
    column = 2
    cell = sheet[row,column]
    msgbox(cell.AbsoluteName)

⇐ Return to Python Guide, Calc