LibreOffice-Forum

Code: Alles auswählen

def sync_A1_B1(*_):
    doc = XSCRIPTCONTEXT.getDocument()
    table = doc.TextTables.Tabelle1
    input = table.getCellByName("A1").Text.String
    output = table.getCellByName("B1").Text
    output.String = input.replace('\n','\r').strip()
    for para in output.Text:
        para.ParaStyleName = "schreibschrift"

Code: Alles auswählen

# coding: utf-8
from __future__ import unicode_literals
# 1) Werte aus dem Arbeitsblatt holen.
desktop = XSCRIPTCONTEXT.getDesktop()
model = desktop.getCurrentComponent()
sheet = model.CurrentController.ActiveSheet
range = sheet.getCellRangeByName("A1:A3")
# 2) Einige Werte.
sum = 0
for row in range.Rows:
    sum += row.getCellByPosition(0,0).Value
# 3) Das Ergebnis an das Arbeisblatt übergeben.
sheet.getCellRangeByName("B3").Value = sum
# useful for debug
from apso_utils import msgbox
msgbox('done')

Code: Alles auswählen

doc = XSCRIPTCONTEXT.getDocument()
sheet = doc.CurrentController.ActiveSheet
sheet["B6"].Value = sum( sum(x for x in row if isinstance(x, float)) 
                        for row in sheet["A1:D3"].DataArray ))