1 files changed, 53 insertions, 0 deletions
diff --git a/scripting/examples/python/SetCellColor.py b/scripting/examples/python/SetCellColor.py
new file mode 100644
index 000000000..7319d621d
--- /dev/null
+++ b/scripting/examples/python/SetCellColor.py
@@ -0,0 +1,53 @@
+#
+# This file is part of the LibreOffice project.
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0. If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+# This file incorporates work covered by the following license notice:
+#
+#   Licensed to the Apache Software Foundation (ASF) under one or more
+#   contributor license agreements. See the NOTICE file distributed
+#   with this work for additional information regarding copyright
+#   ownership. The ASF licenses this file to you under the Apache
+#   License, Version 2.0 (the "License"); you may not use this file
+#   except in compliance with the License. You may obtain a copy of
+#   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+#
+import uno
+
+def _SetCellColor(sheet, cellRange, color):
+    """Sets the background of 'cellRange' in 'sheet', to 'color'."""
+    # https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html#a92c77dc3025ac50d55bf31bc80ab118f
+    cells = sheet.getCellRangeByName(cellRange)
+
+    # https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1table_1_1CellProperties.html
+    cells.CellBackColor = color
+
+def SetCellColor():
+    ctx = uno.getComponentContext()
+    smgr = ctx.ServiceManager
+    desktop = smgr.createInstanceWithContext("com.sun.star.frame.Desktop", ctx)
+
+    # Create a blank spreadsheet document, instead of operating on the existing one
+    doc = desktop.loadComponentFromURL("private:factory/scalc", "_blank", 0, ())
+
+    # Select the first sheet in the spreadsheet (0-index based).
+    sheet = doc.Sheets[0]
+
+    # Call the above helper function to set color (in hex number).
+    # To get the hex number:
+    #    1. go to Calc, click toolbar dropdown "Background Color" > Custom Color;
+    #    2. Pick a color, copy the hex number and prefix it with "0x".
+    _SetCellColor(sheet, "C3:C21",    0x4021c9)
+    _SetCellColor(sheet, "D18:E21",   0x4021c9)
+    _SetCellColor(sheet, "G3:G21",    0x4021c9)
+    _SetCellColor(sheet, "H3:I5",     0x4021c9)
+    _SetCellColor(sheet, "I6:I21",    0x4021c9)
+    _SetCellColor(sheet, "H19:H21",   0x4021c9)
+
+    # You should get a nice "LO" in the spreadsheet!
+
+# Only the specified function will show in the Tools > Macro > Organize Macro dialog:
+g_exportedScripts = (SetCellColor,)