Macros/Calc/py018

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

Description

Insert a formula into a certain cell

Python code

def main(args=None):
    # ~ NAME_SHEET = 'Sheet1'
    document = XSCRIPTCONTEXT.getDocument()
    sheet = document.CurrentController.ActiveSheet

    # ~ If you want any other sheet
    # ~ sheet = document.Sheets[NAME_SHEET]

    cell = sheet['B11']
    cell.Formula = '=SUM(B2:B10)'

    sheet['B11:D11'].fillAuto(1, 1)

    return