File: SetCellColor.py

package info (click to toggle)
libreoffice 1%3A7.0.4-4%2Bdeb11u10
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 3,255,188 kB
  • sloc: cpp: 4,130,031; xml: 364,887; java: 276,583; python: 65,680; ansic: 36,276; perl: 32,034; javascript: 16,964; yacc: 10,836; sh: 10,721; makefile: 9,112; cs: 6,600; objc: 1,972; lex: 1,887; awk: 1,002; pascal: 940; asm: 928; php: 79; csh: 20; sed: 5
file content (15 lines) | stat: -rw-r--r-- 634 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
def SetCellColor(x, y, color):
    """Sets the background of the cell at (x,y) (zero-based column and row
       indices, for example (2,3) == C4) on the first sheet and
       returns the contents of the cell as a string.
    """
    #get the doc from the scripting context which is made available to all scripts
    desktop = XSCRIPTCONTEXT.getDesktop()
    model = desktop.getCurrentComponent()
    #check whether there's already an opened document
    if not hasattr(model, "Sheets"):
        return ""
    sheet = model.Sheets.Sheet1
    cell = sheet.getCellByPosition(x, y)
    cell.CellBackColor = color
    return cell.String